Free Oracle 1z0-074 Exam Dumps Questions & Answers

In which three situations would you recommend DB Replay to be used? (Choose three.)

• A.  to check the impact of schema changes such as adding new indexes or materialized views
• B.  to check the impact of changing the storage system or the network
• C.  to check the impact of database migration to the cloud
• D.  to check the impact of new optimizer statistics
• E.  to check the impact of upgrading and patching databases
• F.  to check the impact of partitioning a table

Which two statements are true about application containers? (Choose two.)

• A.  Multiple application roots can be created in one container database.
• B.  User-created common objects are accessible from the CDB root.
• C.  An application root can be unplugged from a CDB and plugged in to another CD
• D.  An application PDB can belong to multiple application containers.
• E.  A regular PDB can be plugged in to an application container provided it is an Oracle Database 12c Release 2 (12.2) PDB.
• F.  The application root stores user-created common objects and Oracle-supplied common objects.

Which method can be used to migrate from an on-premises Oracle Database 11g to Oracle Database 12c in the cloud if the on-premises platform is big-endian?

• A.  Data Pump Transportable Tablespace for all tablespaces
• B.  Oracle Loader-type external tables
• C.  remote cloning
• D.  Data Pump Conventional Export/Import
• E.  RMAN Transportable Tablespace with Data Pump for all tablespaces

To which two components does the term "shape" refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)

• A.  amount of RAM
• B.  number of database instances
• C.  number of network interface cards (NICs)
• D.  number of storage LUNs
• E.  number of CPUs

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