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

Thursday, September 22, 2022

问题：单选题You decided to change the location of the flash recovery area. You executed the following command：   ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’；   Which statement is true？（）A  The location can be changed only if the flash recove...

Saturday, October 26, 2024

问题：单选题The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters wh...

Wednesday, April 3, 2024

问题：Users in your production database complain that they are get...

Tuesday, September 20, 2022

问题：In which scenario will you perform a cancel-based recovery？（...

Friday, September 16, 2022

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

Thursday, September 22, 2022

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

Thursday, September 22, 2022

问题：单选题You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine...

Saturday, December 7, 2024

问题：单选题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, November 8, 2024

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

Friday, May 3, 2024

问题：You are connected to Recovery Manager （RMAN） without a recov...

Friday, September 16, 2022

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

Thursday, September 22, 2022

问题：多选题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？（）ABy using the trace file.BBy using the alert log file.CBy using the datab...

Saturday, December 7, 2024

问题：单选题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 are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national cha...

Saturday, March 1, 2025

问题：单选题You enabled the flashback logging feature， but you have not specified the location of the flash recovery area.  Which location would be used as the default location for the flash recovery area？（）A the location used for control filesB the location used ...

Saturday, April 19, 2025

问题：Your database operates in ARCHIVELOG mode. User/x7fmanaged c...

Thursday, September 15, 2022

问题：单选题Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this...

Sunday, November 17, 2024

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

问题：单选题You lost the index tablespace in your database. You are not able to use tablespace point/x7fin/x7ftime recovery on the index tablespace. What could be the reason for this？（）A The index tablespace contains bitmap indexes.B The index tablespace contains ...

Saturday, October 26, 2024