Oracle Oracle Certifications 1Z0-160 Questions & Answers

• Question 51:

  The first step to connecting to Oracle Cloud is generating an SSH key pair.

  To generate a key pair on a Unix or Linux machine, you would run the ssh-keygenutility.

  What should be the number of bits in the key that must be created?

  A. 1014

  B. 2024

  C. 2048

  D. 1234

  Correct Answer: C

  Explanation:

  To generate an SSH key pair on UNIX and UNIX-like platforms using the ssh-keygen utility:

  1.

  Navigate to your home directory:

  $ cd $HOME

  2.

  Run the ssh-keygen utility, providing as filename your choice of file name for the private key:

  $ ssh-keygen -b 2048 -t rsa -f filename

  The ssh-keygen utility prompts you for a passphrase for the private key.

  3.

  Enter a passphrase for the private key, or press Enter to create a private key without a passphrase Etc.

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

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

• Question 52:

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

  A. A Database Deployment Virtual Image always provides a pre-created Oracle database.

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

  C. A Database Deployment Virtual Image always provides a Linux virtual machine.

  D. A Database Deployment Virtual Image requires customers to install their preferred version on the Oracle database software.

  E. Multiple Oracle database instances can run in a Database Deployment on Oracle Public Cloud.

  Correct Answer: CD

• Question 53:

  You are creating a new Database Deployment.

  Which statement is true about connections that are created by default?

  A. A default network connection is created to your application server.

  B. A default network connection is created to the other Database Deployments that you have created.

  C. No default connections are created to other Database Deployment or to any external servers.

  D. All network connections are pre-created within Database Deployment.

  Correct Answer: C

• Question 54:

  You get complaints from users of several applications that performance has degraded over time.

  These applications run in this configuration:

  1.

  There is one database and database instance, which is an Oracle 12c multitenant Container Database (CDB) with five Pluggable Databases (PDBs).

  2.

  One of the poorly performing applications run in one of the PDBs.

  3.

  One of the poorly performing applications runs in a different PDB in the same CDB.

  4.

  You have the Oracle Resource Manager configured for the CDB only.

  5.

  Each PDB has all sessions in one consumer group.

  A check of wait events for the sessions belonging to these applications shows that the sessions are waiting longer and that there are more sessions from other applications in the same database instance.

  You wish to avoid scaling up your Database Deployment in Oracle Cloud.

  Which four should you check and possibly reconfigure to avoid the need to scale up the Database Deployment?

  A. Modify the users that are using each application so that their sessions are associated with the correct consumer group in the PDB that is hosting their application.

  B. Check the CDB plan to configure the shares allocated to all PDBs, including the PDBs that contain the two poorly performing applications.

  C. Check the CDB plan only to configure the shares allocated to the PDBs that contain the two poorly performing applications.

  D. Create separate consumer groups for the sessions for all applications in the PDB plans for the PDBs that are hosting the two poorly performing applications.

  E. Check the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly performing applications.

  F. Create a PDB plan for each PDB in the CDB that has poorly performing applications.

  G. Create a separate CDB plan for each PDB that has poorly performing applications.

  Correct Answer: ABDF

• Question 55:

  You are configuring network connections for your database instance.

  What does each network group represent?

  A. allows unrestricted communication among some of your Oracle Database Cloud service instances by using a set of defined policies and access rules.

  B. defines load balancing and failover configurations between RAC database instances.

  C. defines network connections to the Pluggable Databases (PDBs) within a Container Database.

  D. manages the connections between your external application servers (application servers that you currently use in your business environment) and your Oracle Database Cloud service instances.

  Correct Answer: A

  Explanation:

  Network groups provide a method for VMs to be grouped together for communications and firewall rules.

  You can define network groups to allow VMs within a group to communicate with each other, while also

  preventing those VMs from communicating outside the group.

  Note:

  Access rule. Access rules define the permitted paths of communication for VMs that are within a network

  group. You can define an access rule to enable a specific path of communication between two network

  groups, or between a network group and a specified list of IP addresses.

  References: http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/OU/IntroDBaaS/

  ConfiguringNetworkSettings/ConfiguringNetworkSettings.html#section2s2

• Question 56:

  Which two can be increased to scale up the compute shape of a Database Deployment in Oracle Database Cloud Service?

  A. Add more memory to the Database Deployment by using the Scale up button on the Oracle Database Cloud Service Overview page.

  B. Add more storage to the Database Deployment by using the Scale up button on the Oracle Database Cloud Service Overview page.

  C. Add more network adaptors (NICs) to the storage network used by the Database Deployment by using the Scale Up button on the Oracle Database Cloud Service Overview page.

  D. Add more network adaptors (NICs) to the public access network used by the Database Deployment by using the Scale Up button on the Oracle Database Cloud Service Overview page.

  E. Add more CPUs to the Database Deployment by using the Scale Up button on the Oracle Database Cloud Service Overview page.

  Correct Answer: AE

  Explanation:

  Occasionally, the need to scale arises from some change made to the database or backup configuration

  after it was created. For example, if the decision to use the In-Memory Database option was made after

  database creation, you might need to scale up the compute shape to one of the high-memory options,

  such as scaling from "OC4 - 2 OCPU, 15 GB RAM" to "OC2M - 2 OCPU, 30 GB RAM".

  Note: To scale the compute shape for a database deployment:

  1) View the overview page for the database deployment:

  a) Open the Oracle Database Cloud Service console.

  b) Click the name of the deployment you want to scale.

  The Oracle Database Cloud Service Overview page is displayed.

  1.

  2. Choose the scaling command.

  The Scale Up/Down Service overlay is displayed. Note that the overlay includes information about the

  current compute shape.

  2.

  Select a new compute shape.

  3.

  Click Yes, Scale Up/Down Service to scale the database deployment.

  The scaling operation begins. The database deployment is in Maintenance status and unavailable while

  the scaling operation is in progress.

  References: https://docs.oracle.com/cloud-machine/latest/dbcs_dbaas/CSDBI/GUID-457D283C-D8904B4F-B65C-26D05B4C80CC.htm#CSDBI3339

• Question 57:

  Your Database Deployment hosts a multitenant container database (CDB) with four pluggable database (PDB) tenants.

  Users of an application in one PDB and users of another application in another PDB complain of poor performance.

  Investigation shows that the application sessions are not using excessive CPU nor are they requesting an unusual amount of I/O.

  Which two steps should you perform to resolve this problem?

  A. Add storage to the Database Deployment.

  B. Add CPU to the Database Deployment.

  C. Examine the shares of resources allocated to each PDB within the CDB.

  D. Examine the shares of resources allocated to each consumer group within all four PDBs.

  E. Examine the shares of resources allocated to each consumer group within the PDBs that contain the two applications.

  F. Add memory to the Database Deployment.

  Correct Answer: EF

• Question 58:

  Which are two of the tasks that must be performed to enable SQL*NET access for your database instance on a Database Deployment over SSL?

  A. You must open a port on the virtual machine (compute node) that is hosting the instance.

  B. You use Net Manager (NETMGR) to configure a database alias and set the connect string.

  C. You use Oracle Connection Manager to configure the required network settings.

  D. You must configure SSL support on the instance.

  Correct Answer: AB

  Explanation:

  SQL*Net is Oracle's remote data access protocol that enables client-server and server-server

  communications across networks.

  An Oracle client connects to the server using the port address of the listener, which is normally defined as

  TCP port 1521 during Oracle installation.

  Oracle Net Manager is a utility used for configuring SQL*Net.

  

  References: http://www.orafaq.com/wiki/Net_Manager

• Question 59:

  You have an Oracle Database 12c on-premise non-CDB database that is running on the AIX platform.

  Which two methods can be used to migrate the on-premise database to a database that is running in a Database as a Service (DBaaS) instance on Oracle Cloud?

  A. Remote Cloning

  B. Transporting Tablespaces by using RMAN convert

  C. Data Pump

  D. Transporting Tablespaces by using RMAN “backup from platform”

  E. scp file copy

  Correct Answer: AC

  Explanation:

  You can migrate Oracle Database 12c non-CDB databases from on-premises to Oracle Database 12c

  databases in Oracle Database Cloud using several different methods including:

  *

  Data Pump Conventional Export/Import This method can be used regardless of the endian format and database character set of the on-premises database.

  *

  Remote Cloning (non-CDB)

  This method can be used only if the on-premises platform is little endian, the on-premises database release is 12.1.0.2 or higher, and the on-premises database and Database Cloud Service database have compatible database character sets and national character sets.

  You can use the remote cloning method to copy an Oracle Database 12c non-CDB on-premises database to your Oracle Database 12c database in the cloud.

  *

  RMAN CONVERT Transportable Tablespace with Data Pump This method can be used only if the database character sets of your on-premises database and Oracle Database Cloud Service database are compatible.

  *

  RMAN Cross-Platform Transportable Tablespace Backup Sets

  This method can be used only if the database character sets of your on-premises database and Oracle Database Cloud Service database are compatible.

  References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-12c-non-cdb-12c.html

• Question 60:

  You get complaints from users of several applications that performance has degraded over time.

  These applications run in this configuration:

  1.

  There are three different databases and database instances.

  2.

  Two of the poorly performing applications run in the same Pluggable Database (PDB) in an Oracle 12c multitenant Container Database (CDB) with four PDBs.

  3.

  One of the poorly performing applications runs in a different PDB in the same CDB.

  4.

  One of the poorly performing applications runs in an Oracle 12c non-CDB, which also hosts other applications.

  5.

  You have the Oracle Resource Manager configured for the CDB, all PDBs, and the non-CDB.

  6.

  Each application has a separate consumer group associated with the sessions that are running that application.

  A check of wait events for the sessions belonging to these applications shows that the sessions are waiting longer and that there are more sessions from other applications in the same database instance.

  You want to avoid scaling up your Database Deployment in Oracle Cloud.

  Which three should you check and possibly reconfigure to avoid scaling up the Database Deployment?

  A. Check the shares allocated only to the consumer group in the non-CDB that is used by the poorly performing application.

  B. Check the shares allocated to all consumer groups in the non-CDB.

  C. Check the CDB plan to configure the shares allocated to all PDBs, including the PDB that contains the two poorly performing applications.

  D. Check the PDB plan for the PDB that is hosting the two poorly performing applications.

  E. Check the CDB plan only to configure the shares allocated to the PDB that contains the two poorly performing applications.

  F. Check the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly performing applications.

  Correct Answer: BCF