ITPub博客

（177）When you create a backup control file, where is the resulting file written to?A. The database user dump destination directoryB. The database diagnostic destination directoryC. To $ORACLE_HOME/rdbmsD. To $ORACLE_HOME/adminE. To the directory and filename you specify in the c...

（176）Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?A. Archive log generation is suspended until the tablespaces are taken out of hot backup mode.B. Datafiles are not written to during hot backups.C. Changes to th...

（175）You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database,as shown here:1. Put the tablespaces in backup mode.2. Back up the datafiles for all tablespaces.3. Take the tablespaces out of backup mode.4. Back up all archived redo logs.Your colleague a...

（174）What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?A. MMONB. LGWRC. ARCnD. ARWRE. COPY答案：（C）解析：肯定是归档模式特有的归档进程，ARCn

（173）Which of the following is not a configurable attribute for an individual disk group?A. AU_SIZEB. COMPATIBLE.RDBMSC. COMPATIBLE.ASMD. DISK_REPAIR_TIMEE. DG_DROP_TIME答案：（E）解析：《Automatic Storage Management Administrator's Guide》 4.1磁盘组属性是绑...

（172）What is the net effect of the following command?alter diskgroup dgroup1 drop disk abc;A. The disk ABC will be dropped from the disk group.Since you did not issue a rebalance command,the data on that disk will be lost.B. The command will raise an error indicating that you need to re...

（171）After executing the command：alter diskgroup disk group2 drop disk dg2a;you issue the following command from the ASM instance: Select group_number, count(*) from v$asm_operation;What is the implication if the query against V$ASM_OPERATION returns zero rows?A. The drop disk operatio...

（170）ASM supports all but which of the following file types?(Choose all that apply.)A. Database filesB. SpfilesC. Redo-log filesD. Archived log filesE. RMAN backup setsF. Password filesG. init.ora files答案：（F、G）解析：《Automatic Storage Management Admi...

（169）Exhibit#1:Exhibit#2:View the Exhibit exhibit1 to observe the maintenance window property.View the Exhibit exhibit2 to examine the output of the query.Which two statements describe the conclusions?(Choose two.)A. RESOURCE_PERCENTAGE should be increased.B. The repeat time f...

（167）View the Exhibits exhibit1 and exhibit2.DECLARE  newjob sys.job;  newjobarr sys.job_array;  newjobname VARCHAR2(30);BEGIN  newjobarr := sys.job_array();...

（166）Exhibit:SQL>select flashback_archive_name, status from dba_flashback_archiveFLASHBACK_ARCHIVE NA STATUS-----------------------------------FLA1View the Exhibit and examine the output.You executed the fol...

（165）View the Exhibit exhibit1.In the CUSTOMERS_OBE table,when the value of CUST_STATE_PROVINCE is "CA", the value of COUNTRY_ID is "US."View the Exhibit exhibit2 to examine the commands and query plans.The optimizer can sense 8 rows instead of 29 rows,which is the actual number of rows...

（164）View the Exhibit to examine the details for an incident.Which statement is true regarding the status of the incident?A. The incident has been newly created and is in the process of collecting diagnostic information.B. The incident is now in the Done state and the ADR can select the incid...

（163）View the Exhibit to observe the error.You receive this error regularly and have to shut down the database instance to overcome the error.What can the solution be to reduce the chance of this error in future,when implemented?A. setting the PRE_PAGE_SGA parameter to TRUEB. locking...

（162）View the Exhibit to examine the output produced by the following query at three different times since the database instance startedand has undergone workloads of different capacities:SQL>SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic...

（161）You are using a recovery catalog to maintain Recovery Manager(RMAN)backup information for your production database.You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production databa...

（160）Which two statements are true about the duplexing of the backups taken by RMAN?(Choose two.)A. It's only supported for the backups performed on the tapeB. It is not supported for backup operations that produce image copiesC. Duplex backups need a parallelism for the device to be eq...

（159）Which package provides API's for the SQL Tuning Advisor?A. DBMS_MONITORB. DBMS_STATSC. DBMS_SQLTUNED. DBMS_ADVISOR答案：（C）解析：DBMS_SQLTUNE

（158）You create two resource plans,one for data warehouse loading jobs at night and the other for application jobs at day time.You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this?A. Implem...

（157）The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?A. The Oracle database will perform block checking for the index blocks onlyB. The Oracle database will not perform block checking for any of the data blocksC. The Oracle databa...