Free Oracle 1Z0-160 Exam Dumps Questions & Answers

You want to use traditional GUI tools on a Database as a Service (DBaaS) instance. You have configured PuTTY and SSH sessions.
What two things would you need to configure?

• A.  VPN connection
• B.  X11 forwarding
• C.  X server program
• D.  Remote Desktop Connection

Your Database Deployment hosts a multitenant container database (CDB) with four pluggable database (PDB) tenants.
Users of an application in one PDB and users of another application in another PDB complain of poor performance.
Investigation shows that the application sessions are not using excessive CPU nor are they requesting an unusual amount of I/O.
Which two steps should you perform to resolve this problem?

• A.  Examine the shares of resources allocated to each consumer group within all four PDBs.
• B.  Add memory to the Database Deployment.
• C.  Add storage to the Database Deployment.
• D.  Examine the shares of resources allocated to each PDB within the CDB.
• E.  Examine the shares of resources allocated to each consumer group within the PDBs that contain the two applications.
• F.  Add CPU to the Database Deployment.

Which user is used to log in to DBaaS Monitor Console to monitor the necessity of scaling a Database Deployment?

• A.  dbaas_monitor
• B.  sysman
• C.  sys
• D.  dbsnmp

You are preparing the storage volume for use in an instance.
Which two tasks must you perform?

• A.  Point to a mount point that has existing files and directories.
• B.  Connect to the Database Deployment to which you attached the storage volume by using ssh or PuTTY as the opc user.
• C.  Connect to the Database Deployment to which you attached the storage volume by using ssh or PuTTY as the oracle user.
• D.  Create a mount point on your instance.

You want to migrate an Oracle Database 11.2.0.2 on-premises database to the Oracle Database 11g database of the Database as a Service (DBaaS) instance on Oracle Cloud. A subset of the data that you want to transfer includes data stored in LONG data type columns.
All required data is contained in a dedicated tablespace. The tablespace is 100 GB in size and has 20% free space.
The client wants the data migrated in the shortest possible time to minimize impact on end users.
Select the most appropriate migration method to meet this requirement.

• A.  Remote Cloning
• B.  SQL*Loader Direct Path
• C.  Data Pump TTS
• D.  Data Pump TDB
• E.  conventional export/import