Free Oracle 1z0-074 Exam Dumps Questions & Answers

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.  SQL Access Advisor
• B.  SQL Performance Analyzer
• C.  adaptive cursor sharing
• D.  using literals in SQL statements
• E.  adaptive execution plans

Which two statements are true about FLEX ASM? (Choose two.)

• A.  It is impossible to connect to a database instance on one node if the database password file for the same database is corrupt on another node in the cluster.
• B.  Database instances that depend on an ASM instance that is terminated fail over to a node that has a surviving ASM instance.
• C.  A database instance on any node can connect to an ASM instance on any node.
• D.  A separate ASM network is required.
• E.  Database instances that depend on an ASM instance that is terminated connect to a surviving ASM instance.

Which two statements are true about a PDB lockdown profile? (Choose two.)

• A.  It is created by a common user with the SYSDBA privilege in each PDB where it needs to be applied.
• B.  It is enabled by default on creation.
• C.  It is enabled in PDBs only after the CDB to which the PDBs belong is restarted.
• D.  It is created by a common user with the SYSDBA privilege in CDB$ROOT.
• E.  It is created by a local user with the SYSDBA privilege in each PDB where it needs to be applied.
• F.  It is enabled by using the PDB_LOCKDOWN parameter in each PDBs where it needs to be applied.

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 automatically resets the COMPATIBLE parameter value to 12.0.0
• E.  It modifies or creates new tablespaces as required
• F.  It drops all the invalid objects

U1.T1 is in a tablespace TBS_UNCMP which has no default compression and U1.T2 is in a tablespace, TBS_CMP with default compression for query low.
You execute commands:

Which three statements are true? (Choose three.)

• A.  T1 is in the TBS_CMP tablespace
• B.  T1 is in uncompressed format
• C.  All indexes on T1 remain valid
• D.  The primary key constraints on T1 are dropped
• E.  T1 is in the TBS_UNCMP tablespace
• F.  T1 is in compressed format