Oracle Oracle Database 1Z0-160 Questions & Answers

• Question 41:

  Identify the access that is initially available to connect to your Oracle Database Cloud Service environment?

  A. telnet on port 23

  B. SSH on port 22

  C. SSL/TLS on port 443

  D. Cloud Control on port 7799

  E. Enterprise Manager on port 1158

  Correct Answer: B

  Explanation:

  By default, network access to the deployment is restricted to SSH connections on port 22.

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

• Question 42:

  Which two steps are true about performing an on-demand backup of database instance?

  A. You must first connect to the compute node as the ROOT user.

  B. You must disable the scheduled backup configuration.

  C. You must first connect to the compute node as the oracle user.

  D. You must execute bkup_apiwith the bkup_start option.

  E. You must execute bkup_apiwith the bkup_createoption.

  Correct Answer: AD

  Explanation:

  You can use the bkup_api utility to create an on-demand backup of a database deployment hosting a

  single-instance database or an Oracle Data Guard configuration.

  1.

  Connect as the opc user to the compute node. In a Data Guard configuration, connect to the compute node hosting the primary database.

  2.

  Start a root-user command shell: $ sudo -s #

  3.

  You can choose to have the backup follow the current retention policy, or you can choose to create a

  long-term backup that persists until you delete it:

  To create a backup that follows the current retention policy, enter the following bkup_api command:

  # /var/opt/oracle/bkup_api/bkup_api bkup_start To create a long-term backup, enter the following bkup_api command: # /var/opt/oracle/bkup_api/bkup_api bkup_start --keep

  1. Exit the root-user command shell and disconnect from the compute node: # exit $ exit

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

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

• Question 43:

  Which two statements are true about the SSH tunnels within a Database as a Service (DBaaS) Cloud environment?

  A. The SSH tunnel must be selected by an access rule to enable remote access.

  B. The server must hold the SSH public and private keys in the SSH authorized_keysfile.

  C. DBaaS provides a centralized key server for all SSH connections.

  D. The client must provide the server with the SSH private key.

  Correct Answer: AD

  Explanation:

  A: Oracle Database Cloud Service relies on Oracle Compute Cloud Service to provide secure network access to database deployments. You can use the Oracle Database Cloud Service console to perform network access operations such as enabling access to a port on a compute node, or creating new security rules.

  D: Creating an SSH tunnel enables you to access a specific compute node port by using an SSH connection as the transport mechanism. To create the tunnel, you must have the SSH private key file that matches the public key specified during the database deployment creation process.

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

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

• Question 44:

  How would you stop Oracle REST Data Services (ORDS)?

  A. Disable the APEX application in the Oracle GlassFish Server Administration Console.

  B. Use the listener control tool (lsnrctl).

  C. Stop the APEX resource in Enterprise Manager.

  D. Use the ords_stopcommand.

  Correct Answer: D

  Explanation:

  Stopping Oracle REST Data Services

  1.

  Connect as the opc user to the compute node.

  2.

  Start a root-user command shell: $ sudo -s #

  3.

  Stop ORDS: # /u01/app/oracle/product/ords/ords stop INFO: Stopping Oracle REST Data Services… INFO: Oracle REST Data Services stopped

  4.

  Exit the root-user command shell and close your connection to the compute node: # exit $ exit

  Reference: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/administer-ords.html

• Question 45:

  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 TDB

  B. Data Pump TTS

  C. SQL*Loader Direct Path

  D. conventional export/import

  E. Remote Cloning

  Correct Answer: B

  Explanation:

  The Data Pump Transportable Tablespace can be used only if the on-premises platform is little endian,

  and the database character sets of your on-premises database and Oracle Database Cloud Service

  database are compatible.

  The Transportable Tablespace method is generally much faster than a conventional export/import of the same data because the data files containing all of the actual data are simply copied to the destination location.

  Incorrect Answers:

  C: Data Pump TDB is not supported in this scenario.

  D: The data pump conventional export/import method is simple to implement, provides the broadest cross-platform support and enables you to physically re-organize your target database; however, the time and resources required for export and import may rule out this approach for situations with large databases or limited timeframes.

  E: Remote cloning is not supported in this scenario.

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

• Question 46:

  Which three statements are true about the service levels provided by Database Cloud Service (DBCS)?

  A. The Virtual Image service level provides a pre-created database.

  B. The Virtual Image service level provides tools for backups and patching.

  C. The automated service provides a pre-installed virtual machine image.

  D. The automated service provides a pre-created database.

  E. The cloud tooling within the automated service level provides a tool for point-in-time database recovery.

  Correct Answer: BDE

  Explanation: Incorrect Answers:

  A: When you create a database deployment on Oracle Database Cloud Service using the Virtual Image service level, Oracle Database is not automatically installed, nor is a database created.

  References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/create-db-virtual-imagedeployment.html

• Question 47:

  You created a Database Deployment. This action also created a virtual machine and configured it for the Database Deployment. It also created two user accounts. One of the users is opc.

  Which three functions can the opc user perform?

  A. dropping the database instance

  B. any operation that can be performed by a root user

  C. database tuning

  D. database backup and recovery by using the cloud tool

  E. administrative operations on the virtual machine

  F. operations any user with root access can perform

  Correct Answer: DEF

  Explanation:

  Opc is the system administrator account you use to connect to the compute node using SSH. This user

  can use the sudo command to perform operations that require root-user access.

  Connect as the user opc to perform operations that require root access to the compute node, such as

  backing up or patching; this user can use the sudo command to gain root access to the compute node.

  Incorrect Answers:

  B: The root user 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 user.

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

  Using Oracle Database Cloud Service (February 2017), page 5-3

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

• Question 48:

  Which three will be supported after migrating an on-premises database to a Database as a Service (DBaaS) instance on Oracle Cloud?

  A. increased security of application roles

  B. reduction in operational costs

  C. ability to increase capacity on demand

  D. provisioning of application testing

  E. centralization of database management

  Correct Answer: CDE

  References: https://www.oracle.com/database/solutions/private-dbaas.html

• Question 49:

  Which three statements are true about SSH tunnels in an Oracle Database Cloud Service configuration?

  A. A separate SSH tunnel is required for each port that is required for the environment.

  B. The SSH tunnel should include all required ports for the environment.

  C. The available protocols include ssh-2 DSA.

  D. The default protocol is ssh-1 RSA.

  E. The SSH tunnel is opened automatically by the Cloud Services VPN and remains open.

  F. The SSH tunnel must be opened manually and must remain open.

  Correct Answer: ACF

  Explanation:

  C: Incorrect Asnwes:

  

  B: You can only specify the source port, and the destination port.

  D: The default protocol is ssh-2 RSA-

  References: http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/javaservice/JCS/JCS_SSH/ create_sshkey.html https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/create-ssh-tunnel.html

• Question 50:

  What are two things can you do on the My Services Dashboard page?

  A. You can customize the metric icon for each valid service.

  B. You can add a data center and identity domain to your Cloud account.

  C. You can activate services for the current data center and identity domain.

  D. You can check the overall status of your active services for the current data center and identity domain.

  Correct Answer: CD

  Explanation:

  The My Services Dashboard shows information limited to one identity domain in your account.

  References: Using Oracle Database Cloud Service (February 2017), page 8-26

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