问题:You are performing a block media recovery on the tools01.dbf...
查看答案
问题:On Monday, you dropped the DEPT table from your schema and t...
问题:You have specified the warning and critical threshold values...
问题:单选题Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement: SQL DROP TABLE SCOTT.EMP PURGE; After one hour, you are performing the...
问题:单选题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 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 are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()A The instance starts,...
问题:单选题In which scenario will you use the Flashback Version Query feature?()A when you want to restore a table that has been dropped from the Recycle BinB when you want to identify the transaction ID of the transaction that deleted some important records fr...
问题:多选题Which two statements regarding compressed backups in Recovery Manager (RMAN) are true?()ABackup compression is disabled by default.BBackup compression can be used with both backup sets and image copies.CBackup compression cannot be enabled using the CO...
问题:Your database is in NOARCHIVELOG mode. The database has thre...
问题:You used the following command in Recovery Manager (RMAN) as...
问题:You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parame...
问题:You have configured Automatic Shared Memory Management. Whic...
问题:You enabled the flashback logging feature, but you have not ...
问题:单选题Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10:00 P.M. and 10:30 P.M. The next day, you decide to flash back t...
问题:The Database Resource Manager is not currently active in you...
问题:单选题In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups,DGROUP1, is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective: DROP DISKGROUP dgroup1 EXCLUDI...
问题:You have performed an incomplete recovery because some impor...
问题:A redo log file is corrupted while the database is open; as ...
问题:单选题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...