Oracle 1Z0-160 Online Practice Questions and Exam Preparation

Oracle 1Z0-160 Online Questions & Answers

• Question 1:

  How do you enable a default connection between Database Deployment?

  A. by creating security lists and adding the instances that you want to communicate to these lists
  B. by creating dedicated communication keys and setting them to be used only for your Database Deployment-to-Deployment communication
  C. by creating nothing for communication between the Database Deployment because all instances are interconnected by default
  D. by installing and configuring the NETMGR utility for your database cloud, and then using it to set up the required communication channels
  A. by creating security lists and adding the instances that you want to communicate to these lists

  ---

  Before your DBaaS database was created, you or a coworker generated a private and public SSH key pair, perhaps using PuTTY Key Generator.

  The public key was specified when your database instance was created; a copy of that public key was stored in the VM hosting your database.

  When you define in PuTTY an SSH connection to the VM hosting your database, you will specify a copy of the private key stored on your local PC. When you initiate a PuTTY connection, the VM compares the private key to the matching

  public key stored in the VM. The VM permits the connection when the private and public key match as a valid key pair.

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

• Question 2:

  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
  B. dbaascli orec -args -latest

  ---

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

  You use GUI tools on the Virtual Machine to create and administer the Database as a Service (DBaaS) databases.

  You wish to use the Oracle Database Configuration Assistant (DBCA) to create a database instance. To run DBCA, you will need to use an SSH connection.

  You need to perform several steps to establish this connection in DBCA and to create the database.

  What are two of these steps?

  A. Connect to the DBaaS instance with the SSH terminal session as the oracle user.
  B. Configure a PuTTY or SSH session to perform X11 forwarding.
  C. Install an Xterminal program if required.
  D. Update the tnsnames.ora file with the name of the service to which you want to connect.
  A. Connect to the DBaaS instance with the SSH terminal session as the oracle user.
  B. Configure a PuTTY or SSH session to perform X11 forwarding.

  ---

  Example: To create a database into your Oracle Database Cloud Service

  1.

  You have created a PuTTY definition for connecting through an SSH tunnel to your Database Cloud Service (DBaaS) instance. Now open this definition to connect to the VM.

  2.

  Because this is not the first time you are connecting to the VM, the SSH utility does not prompt you to confirm the public key. If it were the first time, the SSH utility would have prompted you to confirm the public key. You would have confirmed by clicking Yes.

  3.

  You can now launch DBCA either in silent mode or in graphical mode.

  

  

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

• Question 4:

  How would you connect from your local machine to the database instance on a Database Deployment by using SQL*Net?

  A. You start an SSH process on your local machine to communicate to a tunnel created on the Database Deployment compute node.
  B. You must use port 1521 and the TCP/IP SSL communication protocol.
  C. You can use only the SSH connection that is defined on port 22 that is configured by default during Database Deployment installation.
  D. You use Transparent Data Encryption (TDE) to secure connections to the database instance on the Database Deployment.
  B. You must use port 1521 and the TCP/IP SSL communication protocol.

  ---

  To confirm remote access to the database through the SQL*Net security rule, create a connection to the database in Oracle SQL Developer. When creating the connection, fill out the fields as follows:

  1.

  Username: enter SYSTEM.

  2.

  Password: enter Pa55_WoRd.

  3.

  Hostname: enter the Public IP address of the compute node associated with the database deployment. To find out this address, display details of the service as described in Viewing Detailed Information for a Database Deployment

  4.

  Port: enter 1521.

  5.

  SID: enter ORCL.

  After entering values, click Test to test the connection.

  Note: TCPS is TCP/IP with SSL.

  References: Using Oracle Database Cloud Service (February 2017), 4-24 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud- service.pdf

• Question 5:

  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
  B. SSH on port 22

  ---

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

  You are migrating an Oracle Database 11.2.0.2 on-premise database to an Oracle Database Cloud Service (Database as a Service) that provides a pre-created Oracle Database 11.2.0.4 database.

  Which two migration methods are possible?

  A. Data Pump Transportable Database (TDB) export/import
  B. Remote Cloning
  C. Data Pump Transportable Tablespace (TTS) export/import
  D. RMAN Transportable Tablespace (TTS)
  C. Data Pump Transportable Tablespace (TTS) export/import
  D. RMAN Transportable Tablespace (TTS)

  ---

  You can migrate an on-premises source database to the database deployment on Oracle Database Cloud Service using the Data Pump Transportable Tablespace (TTS) method. You can migrate an on-premises source database to a database deployment on Oracle Database Cloud Service using the RMAN Transportable Tablespace (TTS) with Data Pump method.

  Incorrect Answers:

  A: Data Pump Transportable Database is not possible.

  B: Remote cloning is not possible.

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

• Question 7:

  You want to access your database over SQL*Net with a client application that is running locally on your machine.

  How would you enable access to port 1521 of the Compute Node (VM)?

  A. Use Oracle Compute Cloud Service to enable the ora_p2_dblistener security rule.
  B. Run the lsnrctl reload listener command.
  C. Use the Application Express Console to start the listener application.
  D. Change the firewall rules.
  D. Change the firewall rules.

  ---

  The DBaaS services are run under the Oracle Compute Cloud (IaaS). This has it's own firewall configuration, allowing you to limit access to your services. By default, all endpoints except SSH are disabled. There are a number of predefined

  "Security Rules" to open up the assorted endpoints, but they typically open the endpoints to public, which is rather risky. Instead, you should define custom rules, opening access to ports from specific machines.

  Navigate to the main "Oracle Database Cloud Service".

  Click on the hamburger next to the service of interest.

  Click the "Access Rules" option on the popup menu.

  Click the "Create Rule" button.

  Enter a "Rule Name".

  Select "" as the "Source" and enter your IP address in resulting box.

  Select "DB" as the "Destination".

  Enter "1521" as the "Destination Port(s)".

  Leave "TCP" as the "Protocol".

  Click the "Create" button.

  You should now be able to connect to the database from the specified IP address.

  References: https://oracle-base.com/articles/vm/oracle-cloud-database-as-a-service-dbaas-create-service

• Question 8:

  Which two problems indicate that you should consider scaling up your Database Deployment that hosts an Oracle Database 12c multitenant container database (CDB) with four pluggable databases (PDBs)?

  A. shortage of CPU for two PDBs in the CDB
  B. shortage of I/O bandwidth for the parallel queries that are issued by the CDB instance
  C. shortage of memory for the Database Deployment
  D. shortage of memory in the Shared Pool of the CDB
  E. shortage of CPU for the Database Deployment
  C. shortage of memory for the Database Deployment
  E. shortage of CPU for the Database Deployment

  ---

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

• Question 9:

  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.
  C. No default connections are created to other Database Deployment or to any external servers.

• Question 10:

  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.
  D. Increase the number of CPUs allocated to the Database Deployment.
  E. Add storage to the Database Deployment.
  G. Increase the memory allocated to the Database Deployment.