ITPub博客

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

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_TIMEAnswer: E 对于一个单独的磁盘组，下列哪一个不是一个可配置的属性？DG_DROP_TIME...

494.Which statement about Automatic Memory Management with Oracle 11g is true?A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.B. Oracle can reallocate memory between the SGA and PGA automatic...

49.Which statement about recovering from the loss of a redo log group is true?A. If the lost redo log group is ACTIVE, you should first attempt to clear the log file.B. If the lost redo log group is CURRENT, you must clear the log file.C. If the lost redo log group is ACTIVE, you must restore, pe...

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

268.You are using Recovery Manager (RMAN) for backup and recovery operations with a recoverycatalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM,you were informed that the USER_DATA tablespace was accidentally dropped.On investigation, you found that the ...

648.Note the following statements that use flashback technology:1. FLASHBACK TABLE <table> TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLASHBACK TABLE <table> TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 12399...

633.Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform? (Choose three.)A. Both source and target database must be the same character setB. Both source and target database must have the same endian formatC. The COM...

592.Which backup option defines a user-defined name for a backup?A. FORMATB. NAMEC. TAGD. FORMAT U%Answer: C哪种备份选项定义了一个用于备份的用户定义名称？

586.Consider the following command:Backup database plus archivelog delete input;How many backup sets would be created by this command if the following were true:Control-file auto backups were enabled.The size of backup sets was not restricted.One channel was allocated.A. 1B. 2C. 3D. 4E. 5...

585.What type of backup is stored in a proprietary RMAN format?A. Backup setB. Image copyC. Backup sectionD. Backup groupAnswer: A什么类型的备份存储在一个专有的RMAN格式中？