ITPub博客

（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...

--%s: Specifies the backup set number. This number is a counter in the control file that is incremented for each backup set. --    If you restore a backup control file, then duplicate values can result. --%p: Specifies the piec...

（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...

（156）What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?A. The number of DBWR processes increasesB. The number of ASMB processes increasesC. The number of DBWR_TO_SLAVES increasesD. The rebalancing operation in an ASM instance completes more quickly,but can ...

（155）Observe the structure of the table employees:The table contains 8475 records.One of the employees wants to know the names of all employees of the company.For this,he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executin...

（154）A database is running in ARCHIVELOG mode and regular backups are performed.A user receives the following error message:Which is the recommended sequence of operations you need to perform for the query successfully?A. Drop the affected tablespace,re-create the tablespace,restore the...

（153）You are managing an ASM instance.You previously issued the following statements:ALTER DISKGROUP dg1 DROP DISK disk2;ALTER DISKGROUP dg1 DROP DISK disk3;ALTER DISKGROUP dg1 DROP DISK disk5;You want to cancel the disk drops ...

(152)You are performing incomplete recovery using RMAN.You execute the following RUN block:RUN{  SET UNTIL SCN 1107600;  RESTORE DATABASE;  RECOVER DATABASE;}Which sta...

（151）Which statements about the MEMORY_TARGET initialization parameter are true?(Choose all that apply.)A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET,if MEMORY_MAX_TARGET is set to a value greater than zeroB. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_T...