问题:单选题Which statement correctly describes the change tracking writer (CTWR) background process?()A It keeps track of changes in the background processes.B It records the system change number (SCN) in the control file.C It writes audit records for user cha...
查看答案
问题:You want to create a consumer group, GROUP1, and you execute...
问题:单选题You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility?()A UNTIL CANCELB UNTIL SCNC UNTIL S...
问题:单选题A redo log file is corrupted while the database is open; as a consequence, database operations are stopped because archiving cannot continue. What would you do to solve the problem?()A clear the redo log groupB perform redo log file importC perform ...
问题:单选题Consider the following command to add a new disk group called "tdgroupA" with two failover groups: CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY FAILOVERGROUP control01 DISK ’/devices/A1’, ’/devices/A2’, ’/devices/A3’ FAILOVERGROUP control02 DISK ’/de...
问题:You have configured Automatic Shared Memory Management. Whic...
问题:You enabled the flashback logging feature, but you have not ...
问题:You issued the following command: ALTER TABLE SCOTT.EMP SH...
问题:You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parame...
问题:单选题You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, ...
问题:单选题You want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based?()A column sizesB column data typesC PCTFREED projected number of rowE PCTUSED...
问题:You executed the following query in your database: SELECT ol...
问题:单选题You executed the following command in Recovery Manager (RMAN): RMAN RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()A back up the control file to traceB bring database to the MOUNT stateC open a connection to the...
问题:In which scenario will you perform an incomplete recovery?()...
问题:多选题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? ()ARestore t...
问题:For the V$SESSION_LONGOPS view, you find that some of the da...
问题:You have specified the warning and critical threshold values...
问题:On Monday, you dropped the DEPT table from your schema and t...
问题:You used the following command in Recovery Manager (RMAN) as...
问题:多选题You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area?()Abackup piecesBcopies of all the parameter filesCtrace file generated using BACKUP CONTROLFILE TO TRACEDcontrol file autobacku...