which three are true about the tools

多选题 which three are true about the tools for diagnosing Oracle Database failure situations?

A、 The Automatic Diagnostic Repository(ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it

B、 .The ADR command-line utility(ADRCI)can package incident information to send to Oracle Support.

C、 . The ADR can store metadata in an Oracle Database repository.

D、 . Flashback commands help with repairing physical errors.

E、 The Data Recovery Advisor uses the ADR F RMAN can always repair comupt blocks

查看答案

下载APP答题

由4l***dd提供分享举报纠错

相关试题

单选题 . A schema owner truncated a table in error and must recover the data
W.hich Oracle Flashback feature could be used to recover the data?

A、 FLASHBACK VERSION QUERY

B、 FLASHBACK TABLE

C、FLASHBACK TRANSACTION

D、 FLASHBACK DATABASE

E、 FLASHBACK DATAARCHIVE

查看答案

单选题 Examine this configuration:
2 COMHON USER PREFIx Is set to an empty string.
3 PDBI is a pluogable database in CDB1 .
4 APP1 ROO T Is an application cont a i ner in CDB1 .
5 APP1 PDB1 is an application PDBIn APP1 ROOT.Y.ou execute these commands:S. sqlplus sys/oracleelocalhost:1521/cdb1 as sysdbaS.QL> CREATE ROLE role1 CONTAINER=CURRENT;W.hich is true?

A、 It will return an error because creation of a local role is not allowed in CDB$ROOT

B、 ROLE1 will be created only in CDBSROOR and Appl ROOT.

C、 ROLE1 will be created only in CDBSROOR

D、It will return an error because common roles must start with c##

E、 ROLE1 will be created in CDBSROOR,PDB1,Appl Root,and APP1 PDB1

查看答案

单选题 Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

A、 It is a set of recommendations by the optimizer to create new indexes

B、 It is a set of recommendations by the optimizer to change the access methods used

C、It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders

D、It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans

E、It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation eror

查看答案

单选题 Auser complains about poor database performance
Y.ou want to verify if the user's session has waited for certain types of I/O activity
W.hich view displays all waits waited on by a session at least once?

A、VSSESSTAT

B、V$SESSION WAIT

C、VSSESSION EVENT

D、V$SESSION

E、VSSESSION WAIT CLASS

查看答案

单选题 You want to transport the UNIVERSIRY tablespace from one database to another. The universiry tablespace is currently open read/write
T.he source and destination platforms have the same endian format.

A、3,4.6

B、1,3,4,6,8

C、1,2,3,4,5,6,7,8

D、2,3,4,5,6,7

E、xamine this list of steps:
1Make the UNIVERSIRY tablespace read-only on the source system
2 Export the UNIVERSIRY tablespace metadata using EXPDP
3 Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an
R.MAN command that includes the DAMAPUMP clause
4 Copy the cross-platform backup sets to the destination system
5 Copy the Data Pump dump set from the source to the destination system
6 Restore the cross-platform backup set on the destination system using an RMANc.ommand that includes the pamapump clause
7 Import the UNIVERSIRY tablespace metadata using IMPDP
8 Make the UNIVERSIRY tablespace read/write on the destination system
W.hich are the minimum number of steps required, in the correct order,tot.ransport the UNIVERSIRY tablespace?

查看答案

单选题 Which should be tuned first when doing a performance tuning exercise for an Oracle Database

A、 log writer performance

B、SQL statements

C、 database instance memory management and sizes

D、general operating system health E)database writer performance

E、nvironment?

查看答案

单选题 How do you configure a CDB for local undo mode?

A、Open the CDB instance in restricted mode. In CDBSROOT,drop the UNDO tablespace Execute AITER DAMBASE LOCAL UNDO ON in each PDB.and then restart the CDB instance

B、Open the CDB instance in restricted mode.In CDB$ROOT,execute ALTER DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB,and then restart the CDB instance.

C、Open the CDB instance in upgrade mode. In CDB&ROOT,execute ALTER DATABASE
L.OCAL UNDO ON, and then restart the CDB instance

D、Open the CDB in read-only mode.In CDBSROOT, execute ALTER DATABASE LOCAL UNDO ON and then change the CDB to read/write mode

E、Open the CDB instance in upgrade mode.In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.

查看答案

单选题 .Examine this configuration
1）CDBl is a container database running in ARCHIVELOG mode.
2)Multiple uncommitted transactions are running in CDB1
3)Redo log groups l and 2 are INACTIVE
4)Redo log group 3 is the CURRENT group
A ll members of redo log group 3 are lost before it is archived
E xamine these possible steps
1)SHUTDOWN ABORT
2).STARTUP NOMOUNT
3)STARUP MOUNT
4)ALTER DATABASE MOUNT
5)RESTORE DATABASE
6) RECOVER DATABASE NOREDO
7) RECOVER DATABASE UNTIL AVAILABLE
8)RESTORE ARCHIVELOG ALL
9)ALTER DATABASE OPEN
10)ALTER DATABASE OPEN RESETLOGS
Choose the minimum required steps in the correct order to recover the database

A、1,3,5,6,9

B、1,3,5,8,6,10

C、1,2,5,7,4,10

D、1,3,5,7,10

E、1,3,5,6,10

F、1,3,5,6,10

查看答案