|
Question |
Rating |
View Answer |
|
What is row migration?
|
|
View Answer |
|
5. Which storage parameter is applicable only to rollback segments? A. PCTINCREASE B. MAXEXTENTS C. TRANASACTIONS D. None of the above.
|
|
View Answer |
|
What is the difference between a Function Key Trigger and Key Function Trigger ? |
|
View Answer |
|
Which two parameters cannot be used together to specify the archive destination?
|
|
View Answer |
|
Which clauses in the CREATE DATABASE command specify limits for the database? |
|
View Answer |
|
Describe Oracle architecture in brief. |
|
View Answer |
|
Which prefix for the data dictionary views indicate that the contents of the view belong to the current user? |
|
View Answer |
|
Which data dictionary view provides the names of the control files? |
|
View Answer |
|
How do you correct a procedure that has become invalid when one of the tables it is referring to was altered to drop a constraint? |
|
View Answer |
|
What is the use of Control File ? |
|
View Answer |
|
When you create a control file, the database has to be: |
|
View Answer |
|
How can we reduce the network traffic? |
|
View Answer |
|
Explain the difference between a data block, an extent and a segment? |
|
View Answer |
|
Which parameter value is use to set the directory path where the alert log file is written?
|
|
View Answer |
|
Which component in the SGA has the dictionary cache? |
|
View Answer |
|
What can cause the Snapshot too old error? |
|
View Answer |
|
Which two initialization parameters are used by ORACLE to determine the number of rollback segments required for an instance?
a. ROLLBACK_SEGMENTS b. TRANSACTIONS c. TRANSACTIONS_PER_ROLLBACK_SEGMENT d. PROCESSES
|
|
View Answer |
|
Which data dictionary view provides information on the version of the database and installed components? |
|
View Answer |
|
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ? |
|
View Answer |
|
Explaint the nvl2 function
|
|
View Answer |