ITPub博客

（223）You plan to set up the Automatic Workload Repository baseline metric thresholds for a moving window baseline.Which action would you take before performing this task?A. Compute the baseline statistics.B. Take an immediate AWR snapshot.C. Decrease the window size for the baseline...

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

(221)To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:BEGIN  dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor, 'TASK1');END;...

（220）Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)A. It can be used to allow the access privilege settings for users but not roles.B. It can be used to allow the access privilege settings for users as well as roles.C. It can b...

（219）You executed the following PL/SQL block successfully:VARIABLE tname VARCHAR2(20)BEGIN  dbms_addm.insert_finding_directive(NULL, DIR_NAME=>'Detail CPU Usage',         &nb...

（218）Your database is running in ARCHIVELOG mode.You are performing a user-managed backup of the DATA1 tablespace.You place the DATA1 tablespace in backup mode by issuing the following statement:ALTER TABLESPACE data1 BEGIN BACKUP;While you are performing the backup,an error occurs that...

（217）Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment.At the end of the upgrade,you observe that the DBA executes the following script: SQL>@utlrp.sqlWhat is the significance of executing this script?A. It perfo...

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