Online Access Free 1z0-497 Practice Test

Examine the command:
sqlplus /nolog
In which scenario would this command execute successfully?

• A.from either a client or server, only if the database instance is up, and the command connects the session to the instance
• B.from either a client or server, only if the database instance is up, but the command does not connect the session to the instance
• C.from either a client or server, even if the database instance is not up
• D.only from the server, if the database instance is not up

You want to clone PDB1 and PDB2 into the same CDB. Which statement is correct?

• A.You cannot do this, because you can only clone PDBs into another CDB.
• B.Cloning a PDB can use the source files copy method to the target PDB files.
• C.Cloning a PDB can use the NOCOPY clause if the target PDB files use the source files.
• D.You can clone only one PDB (either PDB1 or PDB2) into the same CD

Which three statements are true about a database instance that has mounted a database but has not opened it?

• A.Data files are open in read-only mode.
• B.System administrators and users with the CREATE SESSION system privilege may connect to the instance.
• C.A control file is open.
• D.An alert log and trace files are open.
• E.System Global Area (SGA) is allocated and background processes are started.
• F.Instance recovery is performed for the database.

Which two statements describe data dictionary views?

• A.They are stored in the SYSTEM tablespace.
• B.The VSFIXED_TABLEview can be queried to list the names of these views.
• C.They speed up query and data manipulation language (DML) operations.
• D.They are owned by the SYS user.
• E.They are based on virtual tables.

Which two statements are true about transactions in Oracle Database 12c?

• A.Multiple transactions can use the same undo segment.
• B.Multiple transactions cannot share the same extent in an undo tablespace.
• C.If all the segments in an undo tablespace are used, transactions use system undo segments to store undo data.
• D.A transaction is assigned an undo segment when it is started.