Description : What is Rollback Segment?
Last Answer : A Database contains one or more Rollback Segments to temporarily store “undo” information.
Description : What are the various types of RollBack Segments ?
Last Answer : Public Available to all instances Private Available to specific instance
Description : Can you Rollback to any savepoint ?
Last Answer : Yes.
Description : An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?
Last Answer : No.
Description : What are the min. extents allocated to a rollback extent ?
Last Answer : Two
Description : What are the steps involved in Instance Recovery?
Last Answer : Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo log, including the contents of rollback segments. Rolling back ... held by transactions in process at the time of the failure. Resolving any pending distributed transact
Description : What is a Segment?
Last Answer : A segment is a set of extents allocated for a certain logical structure.
Description : What is an Index Segment?
Last Answer : Each Index has an Index segment that stores all of its data.
Description : How many different triggers are available in Report?
Last Answer : There are five types of triggers in report 6i 1) Before report trigger 2) After report trigger 3) Before Parameter trigger 4) After parameter trigger 5) Between pages trigger
Description : What are the uses of rollback segment?
Last Answer : A database contains one or more rollback segments to temporarily store "undo" information.
Description : What is rollback segment?
Description : What is a Rollback segment entry ?
Last Answer : It is the set of before image data blocks that contain rows that are modified by a transaction. Each Rollback Segment entry must be completed within one rollback segment. A single rollback segment can have multiple rollback segment entries.
Description : How will you monitor rollback segment status ?
Last Answer : Querying the DBA_ROLLBACK_SEGS view IN USE - Rollback Segment is on-line. AVAILABLE - Rollback Segment available but not on-line. OFF-LINE - Rollback Segment off-line INVALID - Rollback ... corupted. PARTLY AVAILABLE - Contains data from an unresolved transaction involving a distributed database.
Description : How will you force database to use particular rollback segment ?
Last Answer : SET TRANSACTION USE ROLLBACK SEGMENT rbs_name.
Description : What is Rollback Segment ?
Last Answer : A Database contains one or more Rollback Segments to temporarily store "undo" information.
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 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 : What is the Difference between a post query and a pre query?
Last Answer : A post query will fire for every row that is fetched but the pre query will fire only once.
Description : What is the difference between deleting and truncating of tables?
Last Answer : Deleting a table will not remove the rows from the table but entry is there in the database dictionary and it can be retrieved But truncating a table deletes it completely and it cannot be retrieved.
Description : What is difference between UNIQUE constraint and PRIMARY KEY constraint?
Last Answer : A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can’t contain Nulls. 47.What is Index Cluster? – A Cluster with an index on the Cluster Key 48.When does a Transaction end? – When it is committed or Rollbacked.
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 : 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 define multiple savepoints ?
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 null keys be entered in cluster index, normal index ?
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 ?