Online Access Free 1Z0-160 Practice Test

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.Add storage to the Database Deployment.
• B.Add CPU to the Database Deployment.
• C.Examine the shares of resources allocated to each consumer group within the PDBs that contain the two applications.
• D.Add memory to the Database Deployment.
• E.Examine the shares of resources allocated to each consumer group within all four PDBs.
• F.Examine the shares of resources allocated to each PDB within the CDB.

Which two problems indicate that you should consider scaling up your Database Deployment that hosts an Oracle Database 12c multitenant container database (CDB) with four pluggable databases (PDBs)?

• A.shortage of CPU for two PDBs in the CDB
• B.shortage of CPU for the Database Deployment
• C.shortage of memory for the Database Deployment
• D.shortage of I/O bandwidth for the parallel queries that are issued by the CDB instance
• E.shortage of memory in the Shared Pool of the CDB

Which two statements are true about the SSH tunnels within an Oracle Database Cloud Service environment?

• A.The server must hold the SSH public and private keys in the SSH authorized_keys file.
• B.An individual SSH tunnel is required for each port in the environment.
• C.The SSH tunnel must be selected by a security rule to enable remote access.
• D.The client must provide the server with the SSH private key.
• E.Oracle Database Cloud Service provides a centralized key server for all SSH connections.

You want to apply a patch to your Oracle Database Cloud - Database as a Service.
What command will you execute to patch your database instance?

• A.dbaascli dbpatchm --run -setup
• B.dbaascli dbpatchm --run -apply
• C.dbaascli dbpatchm --run -config
• D.dbaascli dbpatchm --run -patch

Which three are ways to scale a Database Deployment that is hosting three Oracle 12c databases?

• A.Increase the number of CPUs allocated to the DBaaS instance.
• B.Increase the CPU_COUNT parameter value in each database instance that is running on the DBaaS instance.
• C.Increase the memory allocated to the DBaaS instance.
• D.Use the Oracle Database 12c In-Memory database option in each database instance that is running on the DBaaS instance.
• E.Add storage to the DBaaS instance.
• F.Add additional virtual network interfaces (VNICs) to the DBaaS instance.
• G.Increase the MEMORY_TARGET parameter value in each database instance that is running on the DBaaS instance.