In which two conditions are resumable statements suspended?()
时间:2022-11-05
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? ()
You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use?()
Which statement must you issue to an already-running Automatic Storage Management (ASM) instance to prevent database instances from connecting to the ASM instance?()
You have a disk group, DGROUP1, with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group: ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES (MIRROR FINE);Which statement is true?()
时间:2022-11-04
You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query; Which statement is correct regarding the query output?()
You issue the following command on the RMAN prompt. RMAN> REPORT NEED BACKUP DAYS = 5 DATABASE; Which statement is true about executing this command?()
You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()
时间:2022-11-03
The online redo log group configuration for your database is as follows: What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database?()
You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup?()
Identify four uses of the Oracle Scheduler.()
时间:2022-11-02
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below: SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario? ()
You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting?()
You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem? ()
时间:2022-11-01