databases Online Quiz - 167
|Description: databases Online Quiz - 167|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist. Which command should you now use to check if any of the files were missing?
When performing recovery of a database in NOARCHIVELOG mode with RMAN, the target database must be in the ______ state to restore the control file.
Which modifier is used to change listener parameters in the Listener Control utility environment?
The ORDERS table has a constant transaction load 24 hours a day, so down time is not allowed. The index become fragmented. Whic statment is true ?
You omit the UNDO tablespace clause in your CREATE DATABASE statment. The UNDO_MANAGEMENT parameter is set to AUTO. What is the result of your CREATE DATABASE statement ?
John has created a procedure named SALARY_CALC. Which SQL query allow him to view text of procedure?
The employees table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table's primary key is stored in INDX tablespace. Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will be exported by this command ? exp system/manager tablespace=SAMPLE
Consider this syntax MERGE INTO t1 USING t2 ON (join predicate) .... What does the MERGE syntax do ?
Examine the statement : DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES; What is the result of the statement?
When performing an incomplete recovery of the whole database, what must be true about the data files that are restored ?
You issue this statement ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statment generate ?
Which three features are provided by Oracle Net Services? (Choose three)
You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup? (Choose three)
Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined? (Choose three)