Oracle 1z0-160 Exam Questions

Question 6 of 70

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

It shows the date the instance was last accessed.

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

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

It lists the memory for each instance in your domain.

It shows the name of each database instance.

Correct Answer: C, E

The Oracle Database Cloud Service Services page displays all deployments on Oracle Database Cloud Service.
Use the Oracle Database Cloud Service Services page to perform the following tasks:
✑ Viewing All Database Deployments
✑ Creating a Database Deployment
✑ Viewing Detailed Information for a Database Deployment

Deleting a Database Deployment -
The Activity page displays activities for all Oracle Database Cloud Service deployments in your identity domain.
Example:
Exam 1z0-160: Question 6 - Image 1

References:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/sscs/ProvisionDB/SOACS_prereq%20_DBCS.html https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-services-page.html CE

Question 7 of 70

Which statement is true about the Oracle software releases that are currently supported in a Database as a Service (DBaaS) instance in Oracle Public Cloud?

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

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

Oracle Database 11g Release 2 is supported.

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

Correct Answer: C

11g Release 2 and 12c Release 1 (and 2) are supported.
Exam 1z0-160: Question 7 - Image 1

References:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_creating_an_instance/obe_dbaas_creating_an_instance.html C

Question 8 of 70

You are working on a DBaaS database instance.
Identify the location for the associated database files for your instance.

The installer sets the database file locations during installation by configuring the data file storage options.

The DBaaS database instance data files are stored at: : Oracle product software; the entire bits Compute Cloud storage volume /u01 : Oracle Database data storage; the entire data Compute Cloud storage volume /u02 : Database backup storage; the entire fra Compute Cloud storage volume /u03 : Database redo logs; the entire redo Compute Cloud storage volume /u04

All DBaaS database files are stored at /u01/app/oracle/oradata.

The database file locations are read from utldbfiles.ora and users can update this file to set their own locations.

Correct Answer: B

Compute Cloud Service Storage Volumes
When a Database Cloud Service database deployment is created at the Oracle
Database Cloud Service service level, the following storage volumes are created.
Exam 1z0-160: Question 8 - Image 1

References: Using Oracle Database Cloud Service (February 2017), page A-9 http://docs.oracle.com/cloud/latest/dbcs_dbaas/CSDBI/CSDBI.pdf B

Question 9 of 70

You want to perform database recovery with the most recent backup.
Which command would you execute?

dbaascli rec –args –latest

dbaascli orec –args -latest

dbaascli rec –args -last

dbaascli orec –args -last

Correct Answer: B

Question 10 of 70

You are migrating an Oracle Database 11.2.0.4 on-premise database to an Oracle Database Cloud Service (Database as a Service) that provides a pre-created
Oracle Database 12.1.0.2 database.
What four migration methods can be used?

conventional export/import

Transportable Tablespace (TTS) with RMAN conversion

Transportable Tablespace (TTS) by using Oracle Data Pump

SQL *Loader

RMAN image restore

Data Pump Transportable Database (TDB) export/import

Correct Answer: B, C, D, F