Oracle 1Z0-160 Exam Questions & Answers

You get complaints from users of several applications that performance has degraded over time.

These applications run in this configuration:

1.

There is one database and database instance, which is an Oracle 12c multitenant Container Database (CDB) with five Pluggable Databases (PDBs).

2.

One of the poorly performing applications run in one of the PDBs.

3.

One of the poorly performing applications runs in a different PDB in the same CDB.

4.

You have the Oracle Resource Manager configured for the CDB only.

5.

Each PDB has all sessions in one consumer group.

A check of wait events for the sessions belonging to these applications shows that the sessions are waiting longer and that there are more sessions from other applications in the same database instance.

You wish to avoid scaling up your Database Deployment in Oracle Cloud.

Which four should you check and possibly reconfigure to avoid the need to scale up the Database Deployment?

A. Modify the users that are using each application so that their sessions are associated with the correct consumer group in the PDB that is hosting their application.

B. Check the CDB plan to configure the shares allocated to all PDBs, including the PDBs that contain the two poorly performing applications.

C. Check the CDB plan only to configure the shares allocated to the PDBs that contain the two poorly performing applications.

D. Create separate consumer groups for the sessions for all applications in the PDB plans for the PDBs that are hosting the two poorly performing applications.

E. Check the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly performing applications.

F. Create a PDB plan for each PDB in the CDB that has poorly performing applications.

G. Create a separate CDB plan for each PDB that has poorly performing applications.

You use GUI tools on the Virtual Machine to create and administer the Database as a Service (DBaaS) databases.

You wish to use the Oracle Database Configuration Assistant (DBCA) to create a database instance. To run DBCA, you will need to use an SSH connection.

You need to perform several steps to establish this connection in DBCA and to create the database.

What are two of these steps?

A. Connect to the DBaaS instance with the SSH terminal session as the oracle user.

B. Configure a PuTTY or SSH session to perform X11 forwarding.

C. Install an Xterminal program if required.

D. Update the tnsnames.ora file with the name of the service to which you want to connect.

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. X server program

B. VPN connection

C. X11 forwarding

D. Remote Desktop Connection