1Z0-160 Online Practice Questions and Answers

Which two statements are true about the information that you see on the Database Cloud Service page?

A. It shows the date the instance was last accessed.

B. It shows the number of active sessions for each instance in your domain.

C. It shows the total memory for all instances in your domain.

D. It lists the memory for each instance in your domain.

E. It shows the name of each database instance.

Where is the Oracle Database Cloud software for monitoring and backup installed?

A. The Oracle Database Cloud software is located in the Database Automatic Diagnostic Repository (ADR).

B. The installation is done at /var/opt/oracle/dbaascliand /var/opt/oracle/bkup_api.

C. The location must be set during installation as user-defined locations for the installation to start.

D. The location is based on Oracle Flex Architecture, which is similar to non-DBaaS systems.

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

How do you enable a default connection between Database Deployment?

A. by creating security lists and adding the instances that you want to communicate to these lists

B. by creating dedicated communication keys and setting them to be used only for your Database Deployment-to-Deployment communication

C. by creating nothing for communication between the Database Deployment because all instances are interconnected by default

D. by installing and configuring the NETMGR utility for your database cloud, and then using it to set up the required communication channels

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.

Which two statements are true about the Database Deployments and Oracle database instances that are provided by Oracle Public Cloud?

A. A Database Deployment Virtual Image always provides a pre-created Oracle database.

B. An Oracle database instance that is provided as part of Oracle Database Cloud Service runs a different executable than would be run with the same version and release of Oracle Database on private premises.

C. A Database Deployment Virtual Image always provides a Linux virtual machine.

D. A Database Deployment Virtual Image requires customers to install their preferred version on the Oracle database software.

E. Multiple Oracle database instances can run in a Database Deployment on Oracle Public Cloud.

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 statements are true about the Oracle Cloud Service storage volumes that are created as part of a Database Deployment in Oracle Public Cloud?

A. The database data file storage and the tempfile storage are placed on the same storage volume.

B. The database backup storage and the redo log storage are placed on the same storage volume.

C. The Oracle database product software storage and the database data file storage are placed on the same storage volume.

D. The database backup storage and the database product software storage are placed on different storage volumes.

E. The database data file storage and the redo log storage are placed on different storage volumes.

Which two tasks can be performed to customize a backup configuration?

A. Edit the /home/oracle/bkup/dbcfg.specfile to maintain the list of database configuration files to be backed up.

B. Use dbms_schedulerto schedule automatic backups.

C. Edit the /home/oracle/bkup/dbcfg.specfile to maintain the list of system files and folders to be backed up.

D. Use the bkup_apiutility as the oracleuser to configure a retention period.

Which two statements are true about the Oracle software releases that are currently supported in a Database Deployment in Oracle Public Cloud?

A. All versions and releases of Oracle Database 12c are supported.

B. All versions and releases of Oracle Database 11g are supported.

C. Oracle Database 11g Release 2 is supported.

D. Oracle Database 12c is supported but only for single container databases.

E. Oracle Database 12c Release 2 is supported.