1Z0-160 Online Practice Questions and Answers

Questions 4

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.

Buy Now

Questions 5

You are creating a new Database Deployment.

Which statement is true about connections that are created by default?

A. A default network connection is created to your application server.

B. A default network connection is created to the other Database Deployments that you have created.

C. No default connections are created to other Database Deployment or to any external servers.

D. All network connections are pre-created within Database Deployment.

Buy Now

Questions 6

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

These applications run in this configuration:

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

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

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

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

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.

Buy Now

Questions 7

Which two steps would you perform to restore and recover a database from the most recent backup?

A. Disable the scheduled backup configuration.

B. Disable the scheduled recovery configuration.

C. Perform the restore with the dbaascli orec --args -latestcommand.

D. Perform the restore with the dbaascli orec --args -lastcommand.

E. Perform the restore with the dbaascli orec --args -stop -lastcommand.

F. Perform the restore with the dbaascli orec --args -close -lastcommand.

Buy Now

Questions 8

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 -config

B. dbaascli dbpatchm --run -setup

C. dbaascli dbpatchm --run -apply

D. dbaascli dbpatchm --run -patch

Buy Now

Questions 9

You want to control network traffic among your DBaaS instances.

Which two statements are true about network groups?

A. By default, the DBaaS instances in a network group are accessible from hosts outside the network group.

B. You can add a DBaaS instance to a network group, but this enables communication only within this network group.

C. You can add a DBaaS instance to a network group, thus enabling communication with all other DBaaS instances both inside and outside the network group.

D. You can create a network group to enable unrestricted communication among your DBaaS instances.

E. DBaaS prevents network groups from having unrestricted communication among DBaaS instances.

Buy Now

Questions 10

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.

Buy Now

Questions 11

Which two must be true when you migrate an Oracle Database 12.1.0.2 non-CDB to a database that is running in a Database as a Service (DBaaS) instance on Oracle Cloud by using the Remote Cloning method?

A. The non-CDB may be opened in READ WRITE mode as long as ARCHIVELOG is enabled.

B. The database link owner must have the CREATE PDB system privilege.

C. The source platform must have the same endian format.

D. The non-CDB must be in archivelog mode.

E. The non-CDB must be opened in READ ONLY mode.

F. The database link owner must have the CREATE PLUGGABLE DBsystem privilege.

Buy Now

Questions 12

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)

Buy Now

Questions 13

Which two statements are true about a Database Deployment in Oracle Public Cloud?

A. A Secure Shell (SSH) key is provided by Oracle for accessing the compute nodes as the first step in creating a Database Deployment.

B. The billing frequency depends on the Oracle database software edition that is selected for the Database Deployment.

C. The public SSH key is provided when configuring the database in the Database Deployment.

D. Storage configuration must be selected for the Database Deployment.