Oracle Oracle Database 1Z0-160 Questions & Answers

• Question 71:

  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

  Correct Answer: C

  Explanation:

  To access Oracle DBaaS Monitor when the HTTPS port is unblocked:

  1.

  Open the Oracle Database Cloud Service console.

  2.

  From the menu for the deployment, select Open DBaaS Monitor Console.

  A window prompting you for your user name and password is displayed.

  3.

  Enter dbaas_monitor as the user name and the password specified during the database deployment creation process, and then click OK.

  References: Using Oracle Database Cloud Service (February 2017), 10-2

  https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloudservice.pdf

• Question 72:

  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.

  Correct Answer: B

  Explanation:

  When a database deployment is created using the Oracle Database Cloud Service service level, software

  is installed in the following locations.

  *

  bkup_api utility /var/opt/oracle/bkup_api

  *

  dbaascli utility /var/opt/oracle/dbaascli

  *

  Oracle REST Data Services /u01/app/oracle/product/apex_listener

  *

  Oracle Database $ORACLE_HOME:

  1.

  Oracle Database 12c: /u01/app/oracle/product/12.1.0/dbhome_1

  2.

  Oracle Database 11g: /u01/app/oracle/product/11.2.0/dbhome_1

  Note: Using the dbaascli utility, you can perform operations like:

  1.

  Changing the password of the SYS user

  2.

  Checking the status of the Oracle Data Guard configuration

  3.

  Switchover and failover in an Oracle Data Guard configuration

  4.

  Patching the database deployment

  5.

  Database recovery

  6.

  Rotating the master encryption key

  References: Using Oracle Database Cloud Service (February 2017), A-4

  https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloudservice.pdf

• Question 73:

  You created a Database as a Service (DBaaS) instance. This action also created a virtual machine and configured it for the DBaaS instance. It also created two user accounts. One of the users is oracle.

  What three functions can be used by Oracle users in a Database Deployment?

  A. Grant privileges and roles to database users.

  B. Create database users.

  C. Back up and recover databases.

  D. Create tablespaces.

  E. Reboot a VM.

  F. Use the sudo command to perform root user access operations.

  Correct Answer: ABC

  Explanation: Oracle is the Oracle Database administrator account you use to access the system and perform non-root database administration tasks. A home directory, /home/oracle, is created for this user. This user cannot use the sudo command to perform operations that require root-user access. Additionally, by default you cannot connect as this user to the compute node using SSH. You can add the public key to the user's $HOME/.ssh/authorized_keys file to grant persistent SSH access, or you can connect as the opc user and then use the sudo -s command to start a root-user command shell, followed by an su - oracle command to switch to the oracle user.

  Incorrect Answers:

  F: root is the root administrator for the system. You do not have direct access to this account. To perform operations that require root-user access, use the sudo command as the opc, not the oracle, user.

  References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/linux-user-accounts

  rac.html http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/ obe_dbaas_administering_your_database_cloud_service/ obe_dbaas_administering_your_database_cloud_service.html

• Question 74:

  Which command would you execute to perform DBaaS recovery with the latest backup?

  A. dbaascli rec -args -latest

  B. dbaascli orec -args -latest

  C. dbaascli rec -args -last

  D. dbaascli orec -args -last

  Correct Answer: B

  Explanation:

  dbaascli orec latest command restores the most recent backup and performs complete recovery.

  References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/dbaascli.html

• Question 75:

  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?

  A. conventional export/import

  B. Transportable Tablespace (TTS) with RMAN conversion

  C. Transportable Tablespace (TTS) by using Oracle Data Pump

  D. SQL *Loader

  E. RMAN image restore

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

  Correct Answer: BCDF

  Explanation:

  You load data into an Oracle database on Oracle Database Cloud Service using the same tools you would

  use for an Oracle database on another system.

  *

  (D) Using SQL*Loader to Load Data into the Database

  *

  Using Oracle Data Pump Import to Load Data into the Database

  *

  (BC) Using Transportable Tablespaces to Load Data into the Database

  There are two ways to transport a tablespace:

  Manually, involving issuing commands to SQL*Plus, RMAN, and Data Pump.

  Using the Transport Tablespaces Wizard in Enterprise Manager

  *

  Using Pluggable Databases (PDBs) to Load Data into the Database

  *

  Using Oracle Public Cloud Data Transfer Services to Move Large Data Sets

  *

  (F) Full transportable export/import, is available to make migration to Oracle Database 12c faster, easier,

  and more efficient than ever before. Full transportable export is available starting with Oracle Database

  11g Release 2 (11.2.0.3).

  References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/load-data-db.html https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces013.htm#ADMIN11395 http://www.oracle.com/technetwork/database/enterprise-edition/full-transportable-wp-12c-1973971.pdf

• Question 76:

  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?

  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.

  Correct Answer: C

  Explanation:

  Release 2 and 12c Release 1 (and 2) are supported.

  

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

• Question 77:

  What is the location of the associated database files of a Database Deployment?

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

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

  C. All database instance files on the Database Deployment are stored at /u01/app/oracle/oradata.

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

  Correct Answer: B

  Explanation:

  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.

  

  References: Using Oracle Database Cloud Service (February 2017), page A-9

  http://docs.oracle.com/cloud/latest/dbcs_dbaas/CSDBI/CSDBI.pdf

• Question 78:

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

  A. An Oracle database instance can support only one Database Deployment.

  B. A Database Deployment can support only one Oracle database instance.

  C. An Oracle database instance can support multiple Database Deployment.

  D. A Database Deployment runs in a pluggable database (PDB), which is contained in a multi-tenant container database (CDB).

  E. A Database Deployment can support multiple Oracle database instances.

  Correct Answer: E

  References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/dbdeployments.html#GUID-61C0A3F6-1760-47EC-8B3E-8B50AE1276D9

• Question 79:

  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.

  Correct Answer: CE

  Explanation:

  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:

  1.

  Viewing All Database Deployments

  2.

  Creating a Database Deployment

  3.

  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:

  

  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

• Question 80:

  How would you enable a port persistently to keep communication always open through that port?

  A. You would require access to the Oracle Compute Cloud Service console to open the ports to a set of IP addresses.

  B. You must contact your Oracle Database Cloud Service support team to update the port specifications for use.

  C. All ports that are available in Oracle Database Cloud Service servers must use an SSH tunnel and cannot be enabled persistently.

  D. You can use server certificates to map a server's identity to enable persistent connection through a port to a Database Deployment's compute nodes.

  Correct Answer: D