Online Access Free 1z0-497 Practice Test

Which two statements about Data Recovery Advisor are true?

• A.Data Recovery Advisor can be used to diagnose and repair data corruptions in PDBs.
• B.You can use the ADVISE FAILURE command to display repair options after running LIST FAILURE in an RMAN session.
• C.Data Recovery Advisor can be used to diagnose and repair data corruptions in non-CDBs.
• D.Data Recovery Advisor cannot be used to diagnose and repair data corruptions in the root of a CD

In which situation would you use static database registration for a listener?

• A.when DBAs need to connect remotely to start up the database instance
• B.when multiple databases are to be registered with the listener
• C.when users need to connect the database instance by using the host naming method
• D.when the database instance to be registered with the listener is configured in shared server mode

Which two statements about Database Express are true?

• A.It is not supported on Standard Edition (SE) and Express Edition (XE).
• B.It can perform actions outside the database.
• C.It uses internal infrastructure components, such as XDB and SQL*Net.
• D.It has background tasks and processes that periodically collect information via FTP.
• E.It has two new features: Performance Hub and Composite Active Reports.

When you start up a CDB, which operations are performed automatically and in what order?
a - The instance is started.
b - Control files are opened.
c - The root container is opened (redo logs and root data files).
d - Seed pluggable database is in READ ONLY mode.
e - Other PDBs are still in MOUNTED mode.
f - Triggers may fire if they exist to open other PDBs.

• A.a, b, c, d
• B.a, b, c, d, e, f
• C.b, c, a, d
• D.c, b, a, d, f, e
• E.b, c, a, d, e, f

Which three tasks can you perform in Database Express?

• A.View performance and status information about the database instance.
• B.Start up the database.
• C.Manage users and security.
• D.Create database structures.
• E.Shut down the database.