Oracle Oracle Database 1Z0-160 Questions & Answers

• Question 1:

  Which two tasks can be performed from the Database Deployment page?

  A. creating new users to access an instance

  B. adding pluggable databases (PDBs) to the database

  C. decreasing the storage of an instance

  D. viewing patching information

  E. scaling up to select the shape of the current instance

  Correct Answer: DE

• Question 2:

  Which two statements are true about controlling traffic among Database Deployments using a security list?

  A. By default, the Database Deployment in a security list are accessible from hosts outside the security list.

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

  C. You can add a Database Deployment to a security list, thus enabling communication with all other Database Deployments both inside and outside the security list.

  D. You can create a security list to enable unrestricted communication among your Database Deployments.

  E. Database Deployment prevents security lists from having unrestricted communication among Database Deployments.

  Correct Answer: BE

• Question 3:

  Which three actions can you perform from the Oracle Cloud My Services Dashboard page?

  A. Get Oracle Compute Cloud Service details.

  B. Add a data center and identity domain to your Cloud account.

  C. Activate services for the current data center and identity domain.

  D. Get Oracle GoldenGate Cloud Service details.

  E. Create a Database Deployment.

  F. View the date and time of the last access to each database instance.

  Correct Answer: ACD

• Question 4:

  Which two statements are true about the Oracle software releases that are currently supported in a Database Deployment 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.

  E. Oracle Database 12c Release 2 is supported.

  Correct Answer: CE

  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 5:

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

  A. You need to connect to the compute node as the oracle user.

  B. You need to connect to the compute node as the opc user.

  C. You need to disable the backup configuration (crontab).

  D. You need to enable the backup configuration (crontab).

  Correct Answer: D

• Question 6:

  Examine these commands:

  1.

  # dbaascli dbpatchm --run -prereq

  2.

  # dbpatchmdg -precheck_async patch_id

  3.

  $ raccli apply patch -db -tag tag-name -prechecks

  Which is true?

  A. Only 1 and 2 will execute successfully and check the prerequisites.

  B. All three commands will execute successfully and check the prerequisites.

  C. Only 1 and 3 will execute successfully and check the prerequisites.

  D. Only 2 and 3 will execute successfully and check the prerequisites.

  Correct Answer: B

• Question 7:

  Which user is used to log in to DBaaS Monitor Console to monitor the necessity of scaling a Database Deployment?

  A. sys

  B. sysman

  C. dbsnmp

  D. dbaas_monitor

  Correct Answer: D

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

• Question 8:

  What would be the number of bits in the SSH key generated by using the ssh-keygen tool, which is used to connect to Oracle Cloud?

  A. 4096

  B. 1024

  C. 2048

  D. 512

  Correct Answer: C

• Question 9:

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

  A. root and oracle users

  B. opc and oracle users

  C. sysmanand oracle users

  D. root, opc, and oracle users

  E. root, oracle, and sysman users

  Correct Answer: B

• Question 10:

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

  A. Perform the /u01/app/oracle/product/ords/ords

  B. Use the listener control tool (lsnrctl).

  C. Stop the APEX resource in Enterprise Manager.

  D. Use the ords_stopcommand.

  Correct Answer: D