问题：On Monday， you dropped the DEPT table from your schema and t...

Thursday, September 22, 2022

问题：You used the following command in Recovery Manager （RMAN） as...

Thursday, September 22, 2022

问题：You are using Oracle Enterprise Manager to estimate the size...

Tuesday, September 20, 2022

问题：The EMPLOYEES table is stored in the USERS tablespace. You n...

Thursday, September 15, 2022

问题：单选题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...

Sunday, July 16, 2023

问题：You decided to change the location of the flash recovery are...

Thursday, September 15, 2022

问题：You have specified the warning and critical threshold values...

Thursday, September 22, 2022

问题：Using the LIST command in Recovery Manager （RMAN）， which two...

Sunday, September 18, 2022

问题：Your system performs heavy transaction processing between 8：...

Saturday, September 17, 2022

问题：多选题You have the following online redo log configuration：    Group       Member   1     ’/disk1/oradata/redo01a.log’   2     ’/disk2/oradata/redo02a.log’   3     ’/disk3/oradata/redo03a.log’   You decide to multiplex the online redo log groups for recovery...

Friday, March 31, 2023

问题：You are employed as a DBA in an organization. You are inform...

Friday, September 16, 2022

问题：You are maintaining the SALES database of a company. You hav...

Tuesday, August 9, 2022

问题：You enabled the flashback logging feature， but you have not ...

Thursday, September 22, 2022

问题：You have configured Automatic Shared Memory Management. Whic...

Thursday, September 22, 2022

问题：单选题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...

Friday, March 31, 2023

问题：单选题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， ...

Sunday, July 16, 2023

问题：A redo log file is corrupted while the database is open； as ...

Wednesday, September 21, 2022

问题：单选题You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the co...

Monday, March 6, 2023

问题：You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parame...

Thursday, September 22, 2022

问题：单选题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...

Friday, March 31, 2023