1Z1-160 by Oracle Valid Free Exam Practice Test

Question 1

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

Correct Answer: E,F

Question 2

You are configuring network connections for your database instance.
What does each network group represent?

A. allows unrestricted communication among some of your Oracle Database Cloud service instances by using a set of defined policies and access rules. B. manages the connections between your external application servers (application servers that you currently use in your business environment) and your Oracle Database Cloud service instances. C. defines load balancing and failover configurations between RAC database instances. D. defines network connections to the Pluggable Databases (PDBs) within a Container Database.

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

Which users can remotely log in and administer a compute node of a Database Deployment?

A. sysman and oracle users B. opc and oracle users C. root and oracle users D. root, oracle, and sysman users E. root, opc, and oracle users

Correct Answer: B

Question 4

Which statement is true about the Database Deployment and Database instances in Oracle Public Cloud?

A. A Database Deployment runs in a pluggable database (PDB), which is contained in a multi-tenant container database (CDB). B. A Database Deployment can support only one Oracle database instance. C. A Database Deployment can support multiple Oracle database instances. D. An Oracle database instance can support only one Database Deployment. E. An Oracle database instance can support multiple Database Deployment.

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 5

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

A. The location is based on Oracle Flex Architecture, which is similar to non-DBaaS systems. B. The Oracle Database Cloud software is located in the Database Automatic Diagnostic Repository (ADR). C. The location must be set during installation as user-defined locations for the installation to start. D. The installation is done at /var/opt/oracle/dbaascli and /var/opt/oracle/bkup_api.

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

You have an Oracle Database 12c on-premise non-CDB database that is running on the AIX platform.
Which two methods can be used to migrate the on-premise database to a database that is running in a Database as a Service (DBaaS) instance on Oracle Cloud?

A. scp file copy B. Transporting Tablespaces by using RMAN "backup from platform" C. Data Pump D. Remote Cloning E. Transporting Tablespaces by using RMAN convert

Correct Answer: C,D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 7

How do you enable a default connection between Database Deployment?

A. by installing and configuring the NETMGR utility for your database cloud, and then using it to set up the required communication channels B. by creating security lists and adding the instances that you want to communicate to these lists C. by creating nothing for communication between the Database Deployment because all instances are interconnected by default D. by creating dedicated communication keys and setting them to be used only for your Database Deployment-to-Deployment communication

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 8

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

A. Disable the scheduled recovery configuration. B. Perform the restore with the dbaascli orec --args -last command. C. Disable the scheduled backup configuration. D. Perform the restore with the dbaascli orec --args -close -last command. E. Perform the restore with the dbaascli orec --args -stop -last command. F. Perform the restore with the dbaascli orec --args -latest command.

Correct Answer: C,F

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 9

You want to migrate an Oracle Database 11.2.0.2 on-premises database to the Oracle Database 11g database of the Database as a Service (DBaaS) instance on Oracle Cloud. A subset of the data that you want to transfer includes data stored in LONG data type columns.
All required data is contained in a dedicated tablespace. The tablespace is 100 GB in size and has 20% free space.
The client wants the data migrated in the shortest possible time to minimize impact on end users.
Select the most appropriate migration method to meet this requirement.

A. Data Pump TTS B. conventional export/import C. SQL*Loader Direct Path D. Data Pump TDB E. Remote Cloning

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Oracle Database Cloud Service - 1Z1-160 Exam Practice Test