Online Access Free 1z1-497 Practice Test

Which type of information is included in dynamic performance views?
1 - System and session parameters
2 - Memory usage and allocation
3 - File states (including RMAN backup files)
4 - Progress of jobs and tasks
5 - SQL execution
6 - Statistics and metrics

• A.2, 3, 5, and 6
• B.1, 2, 3, 4, 5, and 6
• C.3, 4, and 5
• D.1, 2, 5, and 6
• E.2, 3, 4, 5, and 6
• F.1, 2, 3, and 4

Which two statements are true when you execute an invoker's rights procedure?

• A.The owner must have the INHERIT PRIVILEGES object privilege on the invoking user, or the INHERIT ANY PRIVILEGES privilege.
• B.Invoking users can control who can access their privileges when they run an invoker's rights procedure.
• C.The calling user must grant the INHERIT PRIVILEGES object privilege on the user owner of the procedure.
• D.The calling user must be granted the INHERIT PRIVILEGES object privilege on the user owner of the procedure.

Which statement regarding Oracle Active Data Guard 12c is false?

• A.It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized.
• B.It provides new support for DML to global temporary tables and the use of sequences in the standby database.
• C.It supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.
• D.Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.
• E.It repairs block corruptions detected in the primary or standby database.

The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table:
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
You find out that a session opened by user JIM has a transaction that caused the deadlock. Which two statements are true about SCOTT's session in this scenario?

• A.The session is terminated after receiving the error and JIM can continue with his transaction.
• B.SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
• C.The session is rolled back after receiving the error and JIM can continue with his transaction.
• D.SCOTT has to re-execute the last command in the transaction after he commits the transaction.

You want to drop a pluggable database from a multitenant container database that is used for development, which two statements are true?

• A.When you drop the PDB, the data files and redo log files are automatically removed from the storage file system.
• B.You can drop the PDB only if it is closed.
• C.You can drop the PDB and keep the data files to be reused by another PDB.
• D.You can drop the seed PDB, but you cannot create any other PDB within the CD