ITPub博客

177-Q99: Which of the following statements about Automatic Storage Management are true? Each correct answer represents a complete solution.(Choose all that apply)A. It is designed to release the burden of disk and storage management.B. It is a simple storage management interface available...

177-Q84: Your RMAN configuration has the backup optimization set to ON. Which of the following commands will this setting affect? Each correct answer represents a complete solution.(Choose all thar apply)A. BACKUP ARCHIVELOG with ALL or LIKE options.B. BACKUP BACKUPSET ALLC. BACKUP TA...

177-Q67: You need to perform user-managed complete database recovery. What information do you need to retrieve from V$RECOVERY_LOG? (Choose the best answer)A. The history of the datafiles recovered so far.B. The archived redo log files required for recovery.C. The datafiles and archiv...

177-Q48: You lose all control file copies and your datafiles are intact, but your online log files are unavailable. How do you recover the database in this situation?A. Re-create the control file and open the database with RESETLOGS.B. Restore a backup copy of the control file, perform in...

177-Q44: which of the following can be a performance bottlenect in RMAN? (Choose all that apply)A. Reading dataB. Writing dataC. Allocating channelsD. Copying blocksE. Multiplexing BackupsAnswer: A B D在RMAN中，下列哪个可以成为性能瓶颈？...

177-Q40: Which of the following statements is true regarding lightweight jobs? (Choose all that apply)A. You can use EM to create lightweight job.B. A lightweight job generates minimun redo when it run.C. A lightweight job is stored in the same table as other jobs.D. You use the C...

177-Q29: You are using a recovery catalog and you lose all copies of your control file. Which of the following sets commands will you use to restore the control file before you recover the database?A. SET DBID 188390190; RESTORE CONTROLFILE;B. SET DBID 188390190; RESTORE CONTROLFILE FROM ...

177-Q12: Which of the following tablespaces can be recovered while the database is online?(Choose all thar apply.)A. USERSB. UNDOC. SYSAUXD. SYSTEME. EXAMPLEAnswer: A C E

177-Q11: Which of the following methods can you use to enable duplexed RMAN backups?(Choose two answers.)A. Use the initialization parameter RMAN_BACKUP_COPIES.B. Use the BACKUP COPIES option in the RMAN CONFIGURE command.C. Use the BACKUP COPIES option in the ALLOCATE CHANNEL command...

177-Q9 You want to leverage resource consumer groups when using the Scheduler. Which Scheduler object uses resource plans directly?A. A lightweight jobB. A job classC. A job chainD. A programAnswer: B题意是：当使用调度程序时，您想利用资源消耗组。哪个调度对象直接使用资源计...

177-Q8For which of the following scenarios would you use user-managed incomplete recovery?(Choose all that apply) A. You have lost a datafile and one or more of the archived redo log files are missing.B. Serveral widespread logical errors have occurred in the database in the last day.C. ...

691. You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache contains the ideal workload for analysis. You want to analyze only a few most resource-intensive statements.What must you do to receive recommendations on efficient use...

509.Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)A. A single SQL statement provided by a userB. An existing SQL Tuning Set (STS)C. A preprocessed Database Replay workloadD. A schema nameE. SQL statement identified in EM as using excessive res...

255.Which two statements about the SQL Management Base (SMB) are true? (Choose two.)A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It stores plans generated by the optimizer using a stored outline.C. It is part of the data dictionary and stored in the SYSAUX tablespace.D. It...

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

487.When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics.Which two statements describe the implications of this? (Choose two.)A. It produces less accurate results of the comparison analysis.B. It automatically calls the SQL Tuning Adv...

403.To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?A. EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning AdvisorB. EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuni...

369.Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?A. The SGA Tuning AdvisorB. The SQL Access AdvisorC. The SQL Tuning AdvisorD. The Memory AdvisorAnswer: C 下列哪一个可以为一个特定的SQL语句减少数据库时间而标识和创建索引？...

123.What two statements are true regarding the recommendations received from the SQL Access Advisor?(Choose two.)A. It cannot generate recommendations that support multiple workload queries.B. It can recommend partitioning on tables provided that the workloads have some predicates and joins on the...

573.Upon starting your database, you receive the following error:SQL> startupORACLE instance started.Total System Global Area 171581440 bytesFixed Size 1298640 bytesVariable Size 146804528 bytes Database Buffers 20971520 bytes Redo Buffers 2506752 bytes Database mounted.ORA-00313: open failed ...