Online Access Free 1z0-497 Exam Questions

Which two statements about Database Express are true?

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

Which statement about CDB architecture is true?

• A.You can create common users in PDBs.
• B.A seed PDB can sometimes be opened for particular operations.
• C.Multiple PDBs with the same name can reside in the same CDB.
• D.Oracle-supplied metadata resides only in the root container.
• E.A CDB can have an infinite number of PDBs.

Which two statements about multitenant architecture are true?

• A.It ensures full backward compatibility with non-CDBs.
• B.It fully operates with RAC.
• C.It allows central management and administration of single databases.
• D.It is integrated with Enterprise Manager, but not with the Resource Manager.

YOUR database crashes after a user accidentally kills a background process. What are three possible ways to restart your database?

• A.S sqlplus / as sysdba SQL> startup open recover;
• B.S sqlplus / as sysdba SQL> restart;
• C.S sqlplus / as sysdba SQL> startup immediate;
• D.S rman target / RMAN> Startup
• E.S srvctl start database -db SORACLE_SID

Which option represents the steps to add a multiplexed copy of the current control file or to rename a control file in Oracle Database 12c?
a - Shut down the database.
b - Restart the database.
c - Copy an existing control file to a new location by using operating system commands.
d - Edit the CONTROL_FILESparameter in the database initialization parameter file to add the new control file name, or to change the existingcontrol file name.

• A.a, c, d, b
• B.c, d, b
• C.a, d, b, c
• D.b, c, d