1Z0-160 Online Practice Questions and Answers

Oracle provides additional web-based tools for monitoring Database as a Service (DBaaS) instances. One of the tools is DBaaS Monitor Console.

Which user would you have to log in as to use this tool?

A. dbsnmp

B. sys

C. dbaas_monitor

D. sysman

Which statement is true about Oracle Database Schema Service or Oracle Database Cloud Service in Oracle Public Cloud?

A. Database Schema Service requires no database administrators to administer the database.

B. Database as a Service (DBaaS) requires no database administrators to administer the database.

C. Database as a Service (DBaaS) provides complete database instances with shared control between the subscriber DBA and Oracle Support.

D. Database Schema Service provides database schemas with shared control between the subscriber DBA and Oracle Support.

You want to make sure that your database administrators have a convenient way to monitor your DBaaS instance. To do so, you need to enable the Oracle DBaaS Monitor.

How would you enable the Oracle DBaaS Monitor?

A. Use the enable_dbaas_monitorcommand.

B. Create an SSH tunnel to port 443.

C. Disable the ora_p2_httpsslsecurity rule in Oracle Compute Cloud Service Console.

D. Use the Oracle GlassFish Server Administration Console.

E. Add ODBM access to each DBA's user profile.

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

These applications run in this configuration:

1.

There are three different databases and database instances.

2.

Two of the poorly performing applications run in the same Pluggable Database (PDB) in an Oracle 12c multitenant Container Database (CDB) with four PDBs.

3.

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

4.

One of the poorly performing applications runs in an Oracle 12c non-CDB, which also hosts other applications.

5.

You have the Oracle Resource Manager configured for the CDB, all PDBs, and the non-CDB.

6.

Each application has a separate consumer group associated with the sessions that are running that application.

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 want to avoid scaling up your Database Deployment in Oracle Cloud.

Which three should you check and possibly reconfigure to avoid scaling up the Database Deployment?

A. Check the shares allocated only to the consumer group in the non-CDB that is used by the poorly performing application.

B. Check the shares allocated to all consumer groups in the non-CDB.

C. Check the CDB plan to configure the shares allocated to all PDBs, including the PDB that contains the two poorly performing applications.

D. Check the PDB plan for the PDB that is hosting the two poorly performing applications.

E. Check the CDB plan only to configure the shares allocated to the PDB that contains the two poorly performing applications.

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

How do you access “none default ports” on a Database Deployment's compute node?

A. Review a file called portlist.ini in your installation directory to acquire the list of “none default ports” that are assigned to your compute node.

B. File a service request with your Oracle Database Cloud Service support team to have the “none default ports” opened for use.

C. Create an SSH tunnel to the “none default port”.

D. All communication to Oracle Database Cloud Service must be configured only by using the default ports that are assigned to your compute node during the installation of your Database Deployments.

You are migrating an Oracle Database 11.2.0.2 on-premise database to an Oracle Database Cloud Service (Database as a Service) that provides a pre-created Oracle Database 11.2.0.4 database.

Which two migration methods are possible?

A. Data Pump Transportable Database (TDB) export/import

B. Remote Cloning

C. Data Pump Transportable Tablespace (TTS) export/import

D. RMAN Transportable Tablespace (TTS)

There are two ways to enable a port to a Database Deployment. The first requires access to the Oracle Compute Cloud Service Console to open the ports to a set of IP addresses. The second is to create a tunnel for port forwarding by using SSH.

Which statement is true about port forwarding by using SSH?

A. The SSH tunneling the configured SSH process must be running on the consumer side of the tunnel.

B. The SSH tunneling the configured SSH process must be running on the instance side of the tunnel.

C. The SSH tunneling to access the Database Deployment database via SQL Developer or SQL*Plus must be configured to port 1522.

D. The SSH tunneling to access the Database Deployment database via APEX must be configured to port 8080.

Which three are ways to scale a Database Deployment to solve performance degradation by resource shortage?

A. Add additional virtual network interfaces (VNICs) to the Database Deployment.

B. Increase the MEMORY_TARGET parameter value in each database instance that is running on the Database Deployment.

C. Increase the CPU_COUNT parameter value in each database instance that is running on the Database Deployment.

D. Increase the number of CPUs allocated to the Database Deployment.

E. Add storage to the Database Deployment.

F. Use the Oracle Database 12c In-Memory database option in each database instance that is running on the Database Deployment.

G. Increase the memory allocated 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. sys

B. sysman

C. dbsnmp

D. dbaas_monitor

Which three consoles can be accessed from the Oracle Database Deployment page?

A. Database Express Manager Console

B. OPC Console

C. Application Express Console

D. User Console

E. Storage Container Console

F. DBaaS Monitor Console