ITPub博客

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

71.The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on yourdatabase. Your database is facing a series of interrelated problems over a period of two hours. You needto ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?A. C...

479.Which two statements about workload capture and replay operations are true? (Choose two.)A. The clients must be created manually on the test machines to perform more realistic testing.B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean statefor worklo...

351.What information does the report schema command not provide? (Choose all that apply.)A. Size of the datafilesB. Size of the tempfilesC. Date of last backup for datafiles and tempfilesD. Filenames for each datafileE. Checkpoint SCN associated with the last RMAN backupAnswer: CE从输出来看...

544.Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain thatthey dont want you to shut down the database to perform the backup. What options are available to you?A. Put the database in hot backup mode and perform an online backup, including backing up the archi...