ITPub博客

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

RMAN远程连接目标数据库遭遇RMAN-06429错误，原因是本机Oracle环境是11G，远程目标数据库版本是10G，RMAN版本不一致。C:\Users\dell>sqlplus "sys/XXXXXX@Server_IP/ORACLE_SID as sysdba"SQL*Plus: Release 11.2.0.3.0 Production on 星期五 8月 12 10:21:44 2016Copyright (c) 1982, 2011, Oracle.  All...

122.Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.) A. Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository (ADR).B. The problem key is the ...

121.Which three statements are true regarding the functioning of the Autotask Background Process(ABP)? (Choose three.) A. It creates jobs without considering the priorities associated with them.B. It translates tasks into jobs for execution by the scheduler.C. It determines the list of jo...

120.You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)A. The database-comp...

118.Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? A. SQL statements that are part of the AWR baseline onlyB. SQL statements based on the AWR top SQL identificationC. SQL statements that are part of the available SQL Tuning Set (STS) only...

116.Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.) A. It can be used to back up all data on ASM disks.B. It can be used to recover the damaged ASM disk group along with the data.C. It can be used to gather information about a preexisting ASM di...

113.Which statement is true regarding virtual private catalogs?A. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.B. The virtual private catalog owner cannot create and modify the stored scripts.C. The set of views and synonym...

112.Your database initialization parameter file has the following entry:SEC_MAX_FAILED_LOGIN_ATTEMPTS=3Which statement is true regarding this setting?A. It drops the connection after the specified number of login attempts fail for any user.B. It is enforced only if the password profile is enable...

109.Which statement describes the effect of table redefinition on the triggers attached to the table? A. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table.B. All triggers on the table are invalidated and must be manually recom...

108.You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore command. Which of these methods would you use to achieve th...