Oracle Oracle Database 1Z0-160 Questions & Answers

• Question 11:

  Which three consoles can be accessed from the Oracle Database Deployment page?

  A. Database Express Manager Console

  B. OPC Console

  C. Application Express Console

  D. User Console

  E. Storage Container Console

  F. DBaaS Monitor Console

  Correct Answer: ACD

• Question 12:

  Which two statements are true about the SSH tunnels within an Oracle Database Cloud Service environment?

  A. An individual SSH tunnel is required for each port in the environment.

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

  C. The SSH tunnel must be selected by a security rule to enable remote access.

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

  E. Oracle Database Cloud Service provides a centralized key server for all SSH connections.

  Correct Answer: BC

• Question 13:

  Which three are ways to scale a Database Deployment to solve performance degradation by resource shortage?

  A. Add additional virtual network interfaces (VNICs) to the Database Deployment.

  B. Increase the MEMORY_TARGET parameter value in each database instance that is running on the Database Deployment.

  C. Increase the CPU_COUNT parameter value in each database instance that is running on the Database Deployment.

  D. Increase the number of CPUs allocated to the Database Deployment.

  E. Add storage to the Database Deployment.

  F. Use the Oracle Database 12c In-Memory database option in each database instance that is running on the Database Deployment.

  G. Increase the memory allocated to the Database Deployment.

  Correct Answer: DEG

• Question 14:

  Which two tasks can be performed to customize a backup configuration?

  A. Edit the /home/oracle/bkup/dbcfg.specfile to maintain the list of database configuration files to be backed up.

  B. Use dbms_schedulerto schedule automatic backups.

  C. Edit the /home/oracle/bkup/dbcfg.specfile to maintain the list of system files and folders to be backed up.

  D. Use the bkup_apiutility as the oracleuser to configure a retention period.

  Correct Answer: AD

• Question 15:

  When you are using Oracle Compute Service Console and reviewing the network configuration of your

  database instance, what do the arrows that are shown within the security rules define?

  A. whether the connection was completely secured.

  B. the availability of network access to the database instance.

  C. the direction of network access to the database instance.

  D. the status of the database instance.

  Correct Answer: B

  Explanation:

  The arrows indicate if the access rule is enabled or not.

  Example:

  

  References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-accessrules-page.html

• Question 16:

  How would you enable Oracle DBaaS Monitor?

  A. Create an SSH tunnel to port 443.

  B. Add Oracle DBaaS Monitor access to SYS, SYSTEMusers profile.

  C. Disable the ora_p2_httpslsecurity rule in the Oracle Compute Cloud Service console.

  D. Use the enable_dbaas_monitorcommand.

  E. Use the Oracle Application Express Administration Console.

  Correct Answer: A

• Question 17:

  With Oracle Database Cloud Service as the subscription type, you must configure a database for Backup and Recovery.

  Which two options do you have to back up your database instance?

  A. None. No backups required. You are responsible for configuring the database backups.

  B. Backing up to cloud storage and local compute storage. 10 (ten) days worth of backups are kept, with five most recent days worth of backups available directly on the local compute node storage.

  C. Backing up to Oracle Cloud Service storage volumes which is equal to five times the value that was provided in Usable Data Storage when the instance was created.

  D. Backing up to cloud storage and local compute storage. 30 (thirty) days worth of backups are kept, with seven most recent days worth of backups available directly on local compute node storage.

  Correct Answer: AC

• Question 18:

  You want to make sure that Oracle Application Express (APEX) is enabled and accessible.

  Which two steps must you perform?

  A. Unblock the APEX instance's VM and follow the URL to instance-ip-address: 4848.

  B. Enable the ora_p2_httpsslsecurity rule in the Oracle Compute Cloud Service console.

  C. Create an SSH tunnel to port 443 on a Database Deployment's compute node.

  D. Select deploy_enablefrom the DBaaS monitor.

  E. Select apex_launchfrom the GlassFish Server Administration Console monitor.

  Correct Answer: AC

  Explanation:

  To access the administration console when the HTTPS port is unblocked:

  1.

  Direct your browser to the appropriate URL, based on which release of Oracle Database is in use:

  For the CDB in an Oracle Database 12c Release 1 database: https://node-ip-address/apex/

  For a PDB in an Oracle Database 12c Release 1 database: https://node-ip-address/apex/lowercase-pdbname/

  For an Oracle Database 11g Release 2 database: https://node-ip-address/apex/

  where node-ip-address is the public IP address of the compute node hosting the administration console

  and lowercase-pdb-name is the name of the PDB, with all letters in lowercase. Obtain these values by

  viewing details as described in Viewing Detailed Information for a Database Deployment.

  After directing your browser to the appropriate URL, the Oracle Application Express Login page is displayed.

  2.

  Enter the following information to log in as the administrator. Then, click Login to Application Express.

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

• Question 19:

  Which two statements are true about the Database Deployments and Oracle database instances that are provided by Oracle Public Cloud?

  A. A Database Deployment requires customers to install any additional management tools for their environment.

  B. A Database Deployment never provides a pre-created Oracle database software.

  C. An Oracle database instance that is provided as part of Oracle Database Cloud Service runs the same executable that would be run with the same version and release of Oracle Database on private premises.

  D. A Database Deployment always provides a customer-selected version of the Oracle database software.

  E. Only one Oracle database instance can run in a Database Deployment on Oracle Public Cloud.

  Correct Answer: CD

  Explanation:

  D: The wizard's Software Release page is used to select the Oracle Database software release that you want to run on your instance.

  

  On the Software Edition page select the Oracle Database software edition that you want to run on your instance.

  

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

• Question 20:

  Which three statements are true about the Oracle Cloud Service storage volumes that are created as part of a Database Deployment in Oracle Public Cloud?

  A. The database data file storage and the tempfile storage are placed on the same storage volume.

  B. The database backup storage and the redo log storage are placed on the same storage volume.

  C. The Oracle database product software storage and the database data file storage are placed on the same storage volume.

  D. The database backup storage and the database product software storage are placed on different storage volumes.

  E. The database data file storage and the redo log storage are placed on different storage volumes.

  Correct Answer: ADE

  Explanation:

  Compute Cloud Service Storage Volumes

  When a Database Cloud Service deployment is created using the Oracle Database Cloud Service service

  level, the following storage volumes are created.

  

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

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