ITPub博客

129.You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group? (Choose all that apply.) A. The au_size disk group attribute de...

125.Which statement describes the significance of the CHANGE FAILURE command in RMAN?(Choose all that apply.)A. It is used to change failure priority only for HIGH or LOW priorities.B. It is used to execute the advised repair script.C. It is used to change failure priority only for the CRITICAL p...

104.You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario? (Cho...

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

70.You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:ALTER TABLE employees SHRINK SPACE CASCADE;Which statement is correct in this scenario?A. The EMPLOYEES table will be changed to read-only mode during the shrink operation.B. The in...

67.On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?(Choose two.)A. fixed tablesB. heap tablesC. external tablesD. temporary tablesE. Index-Organized Tables (IOTs)Answer: BE参考：http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_100...

66.Which two initialization parameters would you set to enable Automatic Shared Memory Management?(Choose two.)A. set SHARED_POOL_SIZE to zeroB. set STATISTICS_LEVEL to BASICC. set SGA_TARGET to a non-zero valueD. set DB_CACHE_SIZE to a non-zero valueE. set STATISTICS_LEVEL to TYPICAL or ALLAn...

65. An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files? A. TEST_TBS is a small file tablespace.B. TEST...

63.Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?A. point-in-time recoveryB. execute the ROLLBACK command with transaction numberC. flashback the database to before the transaction was committedD. determin...

58.Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?A. AWR baselines are always created as repeating baselines.B. AWR baselines can be created on the basis of two time values.C. AWR baselines are always created with infinite expiratio...

52.You have the following requirements in relation to the detection of block corruption for your database instance:Check for logical self-consistency of data blocks when modified in memory.Checksums are calculated before and after the block change.Checks are performed for the lost writes to the p...

51.To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows:SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10;What is the significance of this...

36.Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)A. It repairs blocks that have read disk I/O errors.B. It checks whether the alias metadata directory and the file directory are linked correctly.C. It repairs blocks by always reading them f...

31.Which two statements are correct about database transportation? (Choose two.)A. The source and target platforms must be the sameB. Redo logs, control files and temp files are also transportedC. The transported database must have the same database identifier (DBID) as the source database and ca...

30.Which two statements are true with respect to the maintenance window? (Choose two.)A. A DBA can enable or disable an individual task in all maintenance windows.B. A DBA cannot change the duration of the maintenance window after it is created.C. In case of a long maintenance window, all Automat...

21.You are managing an Oracle Database 11g instance. You want to create a duplicate database for testing purpose.What are the prerequisites for performing the active database duplication? (Choose all that apply.)A. The source database backup must be copied over the net for test database.B. The so...

17.The INV_HISTORY table is created using the command:SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2))partition by range (inv_date) interval (numtoyminterval(1,'month'))(partition p0 values less than (to_date('01-01-2005','dd-mm-yyyy')),partition p1 values les...

13.View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is the Significance Level threshold type not available in the threshold setting?A. because AWR baseline is not enabledB. because Current Open Cursors Count is not a basic metricC. because the STATISTICS_LE...

12.You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option.After some days, you want to change the status of the database backup and you issued the following command:RMAN>CHANGE BACKUPSET 231 NOKEEP;What is the implication of this command?A. The back...

1.While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)A. The plan baselines can be evolved over time to produce better p...