Online Access Free 1z0-074 Exam Questions

In which two situations does the INHERIT ANY PRIVILIGES privilege regulate the privileges used?

• A.when a user creates a new user
• B.when a user performs a GRANT or REVOKE operation
• C.when a user runs a procedure created with invoker's right
• D.when a user runs a procedure created with definer's right
• E.when a user queries a BEQUEATH CURRENT_USER view that references an invoker's right procedure

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

• A.It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).
• B.It recommends the use of SQL Tuning Advisor for regressed SQL statements.
• C.It generates execution plans for each SQL statement in an STS.
• D.It always executes triggers that are fired recursively in FULLDML mode.
• E.It recommends the creation of indexes for regressed SQL statements.

The TESTDB container database (CDB) running in ARCHIVELOG mode contains two pluggable databases (PDBs) PDB1 and PDB2.
A connect descriptor for TESTDB is mapped to the TNS alias testdb in tnsnames.ora.
The default RMAN configuration is used.
Examine these commands:

Which files are backed up?

• A.all root and PDB1 data files, and the CONTROLFILE, SPFILE, and ARCHIVELOGS
• B.all root and PDB1 data files, and the CONTROLFILE, SPFILE, ONLINE REDO LOG FILES, and ARCHIVELOGS
• C.all root and PDB1 data files, and the CONTROLFILE and SPFILE
• D.all root and PDB1 data files
• E.all root and PDB1 data files, and the CONTROLFILE, SPFILE, and FLASHBACKLOGS

One of your databases supports an OLTP workload.
If a better plan is discovered for a statement, then you want that plan to be used.
Which two can cause better plans to be used for a statement? (Choose two.)

• A.using literals in SQL statements
• B.adaptive cursor sharing
• C.SQL Access Advisor
• D.adaptive execution plans
• E.SQL Performance Analyzer

Which three tasks are performed automatically by Database Upgrade Assistant (DBUA) when the database to be upgraded is in archivelog mode and has the database flashback feature enabled? (Choose three.)

• A.It calls the catctl.pl script to perform the upgrade process in parallel
• B.It changes Oracle kernel parameters if required
• C.It creates a restore point to restore the database if the upgrade fails
• D.It drops all the invalid objects
• E.It automatically resets the COMPATIBLE parameter value to 12.0.0
• F.It modifies or creates new tablespaces as required