Online Access Free 1z1-074 Exam Questions

A multi-tenant container database (CDB) contains three PDBs.
Which three are prerequisites for performing a cross-platform transport of any of the PDBs? (Choose three.)

• A.Flashback database must be enabled for the CDB.
• B.The COMPATIBLE parameter must be set to 12.2 or greater in the CDB.
• C.The CDB must use Automatic Memory Management.
• D.The CDB should be in MOUNT state.
• E.The source PDBs must be closed for a cross-platform PDB backup.
• F.The source and target platforms must have the same endianness.

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 queries a BEQUEATH CURRENT_USER view that references an invoker's right procedure
• C.when a user runs a procedure created with definer's right
• D.when a user runs a procedure created with invoker's right
• E.when a user performs a GRANT or REVOKE operation

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

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

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 automatically resets the COMPATIBLE parameter value to 12.0.0
• C.It creates a restore point to restore the database if the upgrade fails
• D.It changes Oracle kernel parameters if required
• E.It modifies or creates new tablespaces as required
• F.It drops all the invalid objects

In your CDB1 container database, the DB_CREATE_FILE_DEST parameter is set to
'/u01/app/oracle/oradata'.
CDB1 has an application container called REGIONS_APP.
There are no seeds for REGIONS_APP and there are no other application containers.
You plan to execute this command.
CREATE PLUGGABLE DATABASE AS SEED ADMIN USER seed_adm IDENTIFIED BY admin_123; What must you do for the command to execute successfully?

• A.Add the CREATE_FILE_DEST clause to the command
• B.Set the PDB_FILE_NAME_CONVERT parameter to '/u01/app/oracle/oradata'
• C.Add the FILE_NAME_CONVERT clause to the command
• D.Set the current container to CDB1
• E.Set the current container to REGIONS_APP