ITPub博客

301.Which command is used to configure RMAN to perform a compressed backup for every backupexecuted?A. BACKUP AS COMPRESSED BACKUPSET DATABASEB. BACKUP AS COMPRESSED COPY OF DATABASEC. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSETD. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRE...

583.During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need toknow the names of the online redo logs so you can apply them during recovery.Which view or views would you use to determine this information? (Choose all that apply.)A. V$LOGFILEB. V$RECOVE...

521.You notice that a job in a chain has not completed on a nonconstrained RAC database. Which ofthese are valid reasons why that might occur?A. The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.B. The job affinity is to a service and one node in th...

17.The INV_HISTORY table is created using the command: SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2)) partition by range (inv_date) interval (numtoyminterval(1,'month')) (partition p0 values less than (to_date('01-01-2005','dd-mm-yyyy')),...

222.You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down.To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:ASMCMD> lsdsk -I -d DATAWhich statement is true regarding the outcome of this command?A. The command s...

690. The database users regularly complain about the difficulty in performing transactions. Oninvestigation, you find that some users perform long-running transactions that consume huge amounts ofspace in the undo tablespace, which caused the problem. You want to control the usage of the undotabl...

532.As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in yourdatabase. Using ASM, you want to create a disk group that will provide for the greatest amount ofredundancy for your ASM data (you do not have advanced SAN mirroring technology available to you,u...

178.If a log file becomes corrupted, it may cause the database to stall. How would you correct such asituation?A. Recover the online redo log from backup.B. Delete and re-create the log file.C. Use the alter database clear logfile command to clear the log file.D. Shut down the database and rest...

637.Which three statements are true about windows? (Choose three.)A. Only one window can be open at any given timeB. Consumer groups are associated with windowsC. Windows work with job classes to control resource allocationD. The database service name must be provided during windows creationE. ...

62.You want to convert your existing non-ASM files to ASM files for the database PROD. Which methodor command would you use to accomplish this task?A. Data Pump Export and ImportB. conventional export and importC. the CONVERT command of RMAND. the BACKUP AS COPY. command of RMANAnswer: D参考...

511.You have configured flash recovery area in your database and you set the following Initializationparameters for your database instance:LOG_ARCHIVE_DEST 1 = ,,LOCATION=/disk1/arch MANDATORY'LOG _ARCHIEVE_DEST 2 = ,,LOCATION=/disk2/arch'LOG_ARCHIVK_DEST_3 = ,,LOCATION=/diSk3/archLOG_ARCH1VK_D...

458.Globalization support is implemented through the text- and character-processing functions providedby which Oracle feature?A. RSTLNEB. NLSRTLC. LISTENERD. NLSSORTE. Linguistic sortsAnswer: BNLSRTL（National Language Support Runtime Library）这个库负责为globalization提供locale-indep...

110.You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for amonth. You want Oracle Database to automatically create a baseline every Monday and remove the oldbaseline. What is the correct action to achieve this?A. Create and populate a SQL Tuning Set from the AW...

493.Which three statements about performance analysis by SQL Performance Analyzer are true?(Choose three.)A. It detects changes in SQL execution plans.B. It produces results that can be used to create the SQL plan baseline.C. The importance of SQL statements is based on the size of the objects a...

688. Which two statements are true about the compressed backups in RMAN? (Choose two.)A.Compressed backups can only be taken on the tape drives.B.The binary compression creates some performance overhead during backup operation.C.The ZLIB compression algorithm can be used only if the COMPATIBLE in...

428.Which of the following are prerequisite steps to transport a database? (Choose all that apply.)A. Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if theintended destination is listed.B. Verify that there are no restrictions or limitations that the source or destin...

40.Evaluate the following code:SQL>VARIABLE task_name VARCHAR2(255); SQL>VARIABLE sql_stmt VARCHAR2(4000);SQL>BEGIN :sql_stmt := 'SELECT COUNT(*) FROM customersWHERE cust_state_province =''CA''';:task_name := 'MY_QUICKTUNE_TASK';DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR,:task_name...

488.You are managing an Oracle Database 11g database with the ASM storage. The database is havingbig file tablespaces. You want files to open faster and less memory to be used in the shared pool tomanage the extent maps.What configuration would you effect to achieve your objective? (Choose all th...

283.You set the following parameters in the parameter file and restarted the database:MEMORY_MAX_TARGET=0MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270MWhich two statements are true regarding these parameters after the database instance is restarted?(Choose two.)A. The MEMORY_MAX_TA...

456.Which of the following is true about job chains?A. They consist of one or more Scheduler programs.B. They are used to implement dependency scheduling.C. They are used to implement time-based scheduling.D. They are used to implement event-based scheduling.E. None of the above.Answer: B既...