GeekInterview.com
  I am new, Sign me up!
 

Oracle Basics Interview Questions


Oracle Basics Interview Questions

Questions: 49
Comments: 279
 Oracle Basics Tags
 Showing Questions 11-20 of 49 Questions
<< Previous 1 [2] 3 4 5 Next >>
 Sponsored Links

 
 Oracle Basics Interview Questions
Sorting Options :  

Latest Answer: 1. Procedure Overloading and Function Overloading Possible in Package. This  Overloading Concept Not Possible in Procedure.2. Variables in Package we Can use as a Global Variables. it's Not Possible in Procedure. ...

Latest Answer: Cold Backup is possible only when the database is down means it is not available to users to access. Disadvantage is we effort downtime. Here we need to take backup of datafiles, control files, redo files. Here we get consistent backup image.Hot backup ...
Read Answers (4) | Asked by : Sridhar
Tags : Backup

Latest Answer: Dear All,LIFE OF SQL STATEMENTStep 1: Oracle Create a CursorFor every SQL, first a cursor is created (cursor creation can occur implicitly, or explicitly by declaring a cursor). Step 2: Oracle Parse SQL StatementA SQL statement is parsed only if an identical ...
Read Answers (3) | Asked by : Ritesh Ratna

Latest Answer: Instance is the memory structures and background processes used to interact with Database.Instance = SGA + Background ProcessDatabase is the physical files used to store information. the 3 types of physical files are: Datafiles, Control File and ...
Read Answers (1) | Asked by : Mohammed Abdul Afroze

Latest Answer: Where current of is used for updating the data referenced by cursor which was created as "SELECT FOR UPDATE".DECLARECURSROR MY_CURR IS        SELECT COL1, COL2, COL3,...,COLN        ...
Read Answers (3) | Asked by : ramahesh

Latest Answer: To execute sqlplus via Unix shell scripts the following parameters need to be initialized.(1.) ORACLE_HOME export ORACLE_HOME=Path to (2.) ORACLE_SIDexport ORACLE_SID=Actual ORACLE_SIDAfter these initializations have been done use sqlplus ...
Read Answers (2) | Asked by : ddkdhar

Latest Answer: The only difference between rownum and level pseudocolumn  isRownum is used to order the datas according to their ranks and it is used in inline views..Level pseudocolumn is used in hierarchial retrival of database..... ...
Read Answers (1) | Asked by : ddkdhar

Latest Answer: The varchar2(30) will take 30 bites. Because the size is specified as 30. if you entered a data of only 20 chars the remaining 10 will be transformed to the other field or row. By this the wastage of the disk space can be minimised. ...
Read Answers (2) | Asked by : ferozbm

Latest Answer:  The way the data maintained in the collection of tables can be explained by the data structure. The structure of database will show on which conditions the database will be maintained with out inconsistancy. ...
Read Answers (1) | Asked by : rajender

Latest Answer: One time procedure, Its actually not a procedure but its called as one time procedure, Why because this used to initialize variable, calling function or procedure once the scope of package for user session.This can be defined like this..Package Body Aa ...
Read Answers (4) | Asked by : hasanvtu

View page << Previous 1 [2] 3 4 5 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape