Description : Can null keys be entered in cluster index, normal index ?
Last Answer : Yes.
Description : Can you index columns defined in views?
Last Answer : No, view columns themselves cannot be indexed.
Description : What is an Index Segment?
Last Answer : Each Index has an Index segment that stores all of its data.
Description : How many rows will the following SQL return
Last Answer : Select * from emp Where rownum < 10; 9 rows.
Description : Can you use %RowCount as a parameter to a cursor
Last Answer : Yes
Description : What are the various types of RollBack Segments ?
Last Answer : Public Available to all instances Private Available to specific instance
Description : Can you pass a parameter to a cursor ?
Last Answer : Explicit cursors can take parameters, as the example below shows. A cursor parameter can appear in a query wherever a constant can appear. CURSOR c1 (median IN NUMBER) IS SELECT job, ename FROM emp WHERE sal > median
Description : What is the significance of the & and && operators in PL SQL ?
Last Answer : The & operator means that the PL SQL block requires user input for a variable. The && operator means that the value of this variable should be the same as inputted by the user previously ... span across different rollback segments or will it terminate ? It will terminate (Please check ).
Description : What is the maximum no. of columns a table can have ?
Last Answer : 254.
Description : Can you Rollback to any savepoint ?
Description : Can you define multiple savepoints ?
Description : An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?
Last Answer : No.
Description : What is the difference between unique key and primary key ?
Last Answer : Unique key can be null; Primary key cannot be null.
Description : What are the states of a rollback segment ? What is the difference between partly available and needs recovery ?
Last Answer : The various states of a rollback segment are : ONLINE, OFFLINE, PARTLY AVAILABLE, NEEDS RECOVERY and INVALID.
Description : What are the min. extents allocated to a rollback extent ?
Last Answer : Two
Description : Can Check constraint be used for self referential integrity ? How ?
Last Answer : ? Yes. In the CHECK condition for a column of a table, we can reference some other column of the same table and thus enforce self referential integrity.
Description : Can Long/Long RAW be clustered ?
Description : What are the disadvantages of clusters ?
Last Answer : The time for Insert increases.
Description : What are the advantages of clusters ?
Last Answer : Access time reduced for joins.
Description : What is the use of Data Dictionary ?
Last Answer : Used by Oracle to store information about various physical and logical Oracle structures e.g. Tables, Tablespaces, datafiles, et
Description : What is the use of Control files ?
Last Answer : Contains pointers to locations of various data files, redo log files, etc.
Description : Can you increase the size of datafiles ? How ?
Last Answer : No (for Oracle 7.0)
Description : Can you increase the size of a tablespace ? How ?
Last Answer : Yes, by adding datafiles to it.
Description : Describe Oracle database's physical and logical structure
Last Answer : Physical : Data files, Redo Log files, Control file. Logical : Tables, Views, Tablespaces, etc.
Description : What are constraining triggers ?
Last Answer : A trigger giving an Insert/Updat e on a table having referential integrity constraint on the triggering table.
Description : What are mutating triggers ?
Last Answer : A trigger giving a SELECT on the table on which the trigger is written.
Description : What are cascading triggers? What is the maximum no of cascading triggers at a time?
Last Answer : When a statement in a trigger body causes another trigger to be fired, the triggers are said to be cascading. Max = 32.
Description : Can views be specified in a trigger statement ?
Last Answer : No
Description : What is the maximum no. of statements that can be specified in a trigger statement?
Last Answer : One.
Description : What is the advantage of a stored procedure over a database trigger ?
Last Answer : We have control over the firing of a stored procedure but we have no control over the firing of a trigger.
Description : What are the various types of database triggers ?
Last Answer : There are 12 types of triggers, they are combination of : Insert, Delete and Update Triggers. Before and After Triggers. Row and Statement Triggers. (3*2*2=12)
Description : What are the parts of a database trigger ?
Last Answer : The parts of a trigger are: A triggering event or statement A trigger restriction A trigger action
Description : Can you pass parameters in packages ? How ?
Last Answer : Yes. You can pass parameters to procedures or functions in a package.
Description : Why Create or Replace and not Drop and recreate procedures ?
Last Answer : So that Grants are not dropped.
Description : What are the constructs of a procedure, function or a package ?
Last Answer : The constructs of a procedure, function or a package are : variables and constants cursors exceptions
Description : Can 2 functions have same name & input parameters but differ only by return datatype
Description : Can functions be overloaded ?
Description : What is Over Loading and what are its restrictions ?
Last Answer : OverLoading means an object performing different functions depending upon the no. of parameters or the data type of the parameters passed to it.
Description : What are the various types of parameter modes in a procedure ?
Last Answer : IN, OUT AND INOUT.
Description : Can you call a stored function in the constraint of a table ?
Last Answer : no
Description : Can you have two stored functions with the same name ?
Description : Can you have two functions with the same name in a PL/SQL block
Description : What is the difference between a procedure and a function ?
Last Answer : Functions return a single variable by value whereas procedures do not return any variable by value. Rather they return multiple variables by passing variables by reference through their OUT parameter
Description : Can we define exceptions twice in same block ?
Description : What are the various types of Exceptions ?
Last Answer : User defined and Predefined Exceptions.
Description : Can you use select in FROM clause of SQL select ?
Description : What are attributes of cursor?
Last Answer : %FOUND , %NOTFOUND , %ISOPEN,%ROWCOUNT
Description : what are the datatypes supported By oracle (INTERNAL)
Last Answer : Varchar2, Number,Char , MLSLABEL.
Description : Is space acquired in blocks or extents ?
Last Answer : In extents .
Description : How many columns can table have?
Last Answer : The number of columns in a table can range from 1 to 254.