ITPub博客

（216）Which three elements can a job chain process involve?(Choose three)A. an eventB. a scheduleC. a programD. another chainE. a lightweight job答案：（B、D、E）解析：《Administrator's Guide》 29.6.3After creating a chain object,you define one or more chain ...

（215）Which two statements regarding the Flashback Table feature are correct?(Choose two.)A. Flashback Table can be performed on system tables.B. Flashback Table operation does not shrink the segments.C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.D. Fla...

（214）You issued the following command on the temporary tablespace LMTEMP in your database:SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;Which requirement must be fulfilled for this command to succeed?A.The tablespace must be locally managed.B.The tablespace must have only one te...

（213）View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance.To repair the failure,you executed the following as the first command in the RMAN session:RMAN>REPAIR FAILURE;Which statement describes the consequence of the ...

（212）Note the following parameters settings in your database:SGA_MAX_SIZE=1024MSGA_TARGET=700MDB_8K_CACHE_SIZE=124MLOG_BUFFER=200MYou issued the following command to increase the value of DB_8K_CACHE_SIZE:SQL>ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;What would happen?A...

（211）You want to disable resumable space allocation for all sessions.Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions?A.0B.10C.100D.NULL答案：（A）重复：208

（210）The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task.What is the reason for this?A. to prevent the creation of an excessive number of scheduler job classesB. to allow the Automated Maintenance Tasks to use system ...

（209）You executed the following commands:SQL>ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;SQL>EXECUTE DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');SQL>EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');Which statement is correct regarding the...

（208）You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?(Choose two.)A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB. issuing the ALTER SESSION ENABLE RESUMABLE; statementC. mod...

（207）You want to analyze a SQL Tuning Set(STS) using SQL Performance Analyzer in a test database.Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?(Choose two.)A. Every SQL statement in the STS is considered only once for ...

（206）Which statements are true regarding the Query Result Cache?(Choose all that apply.)A. It can be set at the system,session,or table level.B. It is used only across statements in the same session.C. It can store the results from normal as well as flashback queries.D. It can store...

（205）You specify a nonzero value for the MEMORY_TARGET initialization parameter,but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters.You restart your database instance.Which statement about the result is true?A.The database instance starts,and Oracle sets the default val...

（204）You are tuning RMAN to optimize performance.You want tape I/O to be asynchronous when you perform tape backups.Which action should you take?A. Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE.B. Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE.C. Use compression when performing ...

（203）Which statement about the enabling of table compression in Oracle Database 11g is true?A. Compression can be enabled at the table,tablespace,or partition level for direct loads only.B. Compression can be enabled only at the table level for both direct loadsand conventional DML.C. C...

（202）In which two aspects does hot patching differ from conventional patching?(Choose two.)A. It consumes more memory compared with conventional patching.B. It can be installed and uninstalled via OPatch unlike conventional patching.C. It takes more time to install or uninstall compared...

（201）Examine the following PL/SQL block:SET SERVEROUTPUT ONSET LONG 10000DECLARE  report clob;BEGIN  report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();  DB...

（200）Which operation requires that you create an auxiliary instance manually before executing the operation?(Choose all that apply.)A. Backup-based database duplication.B. Active database duplication.C. Tablespace point-in-time recovery.D. No operation requires the creation of an au...

（199）When you're performing a tablespace point-in-time recovery,which tablespaces will always be restored to the auxiliary instance?(Choose all that apply.)A. The SYSTEM tablespace.B. The UNDO tablespace.C. All tablespaces with tables.D. All tablespaces with indexes.E. No tables...

（198）What are the two different types of database duplication?(Choose two.)A. ActiveB. PassiveC. OnlineD. Backup-basedE. Failure driven答案：（A、D）

（197）Which of the following commands will fail?A. report schema;B. report need backup;C. report need backup days 3;D. report user;E. report obsolete;答案：（D）解析：RMAN>report user;RMAN-00571:==============================...