ITPub博客

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

107.Which components are needed for successful and most efficient recovery. A. The backup RB3 and the current online redo log filesB. the backup RB2 and the archived redo log files after the log sequence number 15622C. Backup R81 and the archived redo log hies after the log sequence numbe...

82.Identify the three predefined server-generated alerts. (Choose three.)A. Drop UserB. Tablespace Space UsageC. Resumable Session SuspendedD. Recovery Area Low On Free SpaceE. SYSTEM Tablespace Size IncrementAnswer: BCD参考：http://docs.oracle.com/cd/E11882_01/server.112/e25494/monitoring.h...

81.Evaluate the following command and its output:SQL>SELECT * FROM dba_temp_free_space;TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACELMTEMP                  250609664     &nbs...

80.Which two statements regarding a SQL profile are true? (Choose two.)A. It is built by Automatic Tuning Optimizer.B. It cannot be stored persistently in the data dictionary.C. It can be used by the query optimizer automatically.D. It can be created manually by using the CREATE PROFILE command....

79.You executed the following command:RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf';Which statement regarding the above command is correct?A. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy.B. The '/u01/app/oracle/oradata/orcl...

74.Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.Which two activities would you perform to mai...

73.You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)A. You are backing up to tape and your tape device performs its own compression.B. You are making image copies, and you have not enabled tablespace compressi...

55.Following is the list of locations in random order where oranfstab can be placed.1./etc/mtab2.$ORACLE_HOME/dbs/oranfstab3./etc/oranfstabWhat is the sequence in which Direct NFS will search the locations?A. 1, 2, 3B. 3, 2, 1C. 2, 3, 1D. 1, 3, 2Answer: C参考：http://docs.oracle.com/cd/E1...

54.Evaluate the following function code:CREATE FUNCTION get_dept_avg(dept_id NUMBER)RETURN NUMBERRESULT_CACHE RELIES_ON(EMPLOYEES)IS    avgsal NUMBER(6);BEGIN    SELECT AVG(SALARY)INTO avgsal      FROM EMPLOYEES     ...

48.View the Exhibit to examine the error obtained during the I/O calibration process. There are no data files on raw devices. What is the reason for this error?A. The DISK_ASYNCH_IO parameter is set to TRUE.B. The FILESYSTEMIO_OPTIONS parameter is set to NONE.C. Another session runs the I/O cali...