Oracle Oracle Database 1Z0-160 Questions & Answers

• Question 21:

  You want to use traditional GUI tools on a Database as a Service (DBaaS) instance. You have configured PuTTY and SSH sessions.

  What two things would you need to configure?

  A. X server program

  B. VPN connection

  C. X11 forwarding

  D. Remote Desktop Connection

  Correct Answer: CD

  Explanation:

  The key benefits of using X11 over SSH is:

  Server can have less packages installed.

  None of the desktop packages and services need to be installed (such as CUPS, Bluetooth, and Network

  Manager). Freeing CPU and Memory on the server.

  User accesses server over a secure connection. Graphics are tunneled over SSH.

  Incorrect Answers:

  A: With X11 forwarding over SSH you don't even need the xhost command installed on the system. It is not needed.

  References: https://access.redhat.com/discussions/682743

• Question 22:

  You did not configure Backup and Recovery during instance creation. You therefore need to schedule your backup strategy with RMAN.

  Which two tasks would you need to perform to customize the backup configuration?

  A. Use the bkup_apiutility logged in as the oracleuser to reconfigure the retention period and cycle period of the backups.

  B. Edit the /home/oracle/bkup/oscfg.specspecification file that is used by the DBaaS backup feature to maintain the list of system files and folders that are to be backed up.

  C. Edit the /home/oracle/bkup/dbcfg.specspecification file that is used by the DBaaS backup feature to maintain the list of database configuration files that are to be backed up.

  D. Use dbms_schedulerto perform automatic backups.

  Correct Answer: AC

  Explanation:

  A: 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.

  By default, the backup is given a timestamp-based tag. To specify a custom backup tag, add the --tag option to the bkup_api command; for example, to create a longterm backup with the tag "monthly", enter the following command: # /var/opt/oracle/bkup_api/bkup_api bkup_start --keep --tag=monthly C. Customizing Which Database Configuration Files Are Backed Up To change which database configuration files are backed up:

  1.

  Connect as the oracle user to the compute node. For detailed instructions, see Connecting to a Compute Node Through Secure Shell (SSH).

  2.

  Edit the contents of the /home/oracle/bkup/dbcfg.spec file: The backup feature provided by Oracle Database Cloud Service backs up the files and folders listed in this specification file.

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

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

• Question 23:

  Which two statements are true about Database as a Service (DBaaS) Oracle Database Cloud Service or about Oracle Database Schema Service in Oracle Public Cloud?

  A. With Oracle Database Schema Service, there is a separate database for each schema.

  B. With Oracle Database Cloud Service, you get a dedicated database instance or instances.

  C. With Oracle Database Schema Service, the schema or schemas may be in the same database as other schemas that belong to other subscribers.

  D. With Oracle Database Cloud Service, you cannot decide when to patch the database home.

  E. With Oracle Database Schema Service, the schema may be in an Oracle Database 12c pluggable.

  Correct Answer: BC

  Explanation:

  Database Schema Service uses schema isolation to implement multi-tenancy, which allows full

  transparency while still providing efficient use of database resources. The Oracle Database is, at its core,

  a multiuser system for sharing data, so Database Schema Service simply uses the capabilities built up for

  the Oracle Database to share resources among multiple Database Schema Service customers.

  Incorrect Answers:

  E: Oracle Database Cloud - Database Schema Service has four main components:

  1.

  Oracle Database 11gR2 Enterprise Edition.

  2.

  Oracle Application Express 5. Used to create and deploy all varieties of applications in a browser-based environment.

  3.

  RESTful Web Services. Allows access to the data in your Database Schema Service through simple URIs.

  4.

  Packaged Applications and Sample Code.

  References: https://docs.oracle.com/cloud/latest/dbcs_schema/CSDBU/GUID-B1C86AD3-D36D-461FB7B1-37C8EB05DBE8.htm

• Question 24:

  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_dblistenersecurity rule.

  B. Run the lsnrctl reload listenercommand.

  C. Use the Application Express Console to start the listener application.

  D. Change the firewall rules.

  Correct Answer: D

  Explanation:

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

  There are two ways to enable a port to a Database Deployment. The first requires access to the Oracle Compute Cloud Service Console to open the ports to a set of IP addresses. The second is to create a tunnel for port forwarding by using SSH.

  Which statement is true about port forwarding by using SSH?

  A. The SSH tunneling the configured SSH process must be running on the consumer side of the tunnel.

  B. The SSH tunneling the configured SSH process must be running on the instance side of the tunnel.

  C. The SSH tunneling to access the Database Deployment database via SQL Developer or SQL*Plus must be configured to port 1522.

  D. The SSH tunneling to access the Database Deployment database via APEX must be configured to port 8080.

  Correct Answer: A

  Explanation: Incorrect Answers:

  C: SQL Developer or SQL*Plus must be configured to port 1521, not port 1522.

  D: APEX use port 443.

• Question 26:

  You have an Oracle Database 11g on-premises database with encrypted tablespaces.

  You want to migrate this database to the pre-created database of the Database as a Service (DBaaS) instance on Oracle Cloud.

  Which two statements are true about this migration?

  A. The on-premises database platform must be of the same endianness as the DBaaS platform.

  B. You can use Full Transportable (TDB).

  C. You can use Data Pump TTS with the ENCRYPTION_PASSWORDparameter.

  D. You can use Data Pump TTS with the ENCRYPTED_PASSWORDparameter.

  E. Data is sent in clear when the NETWORK_LINKoption is used.

  Correct Answer: AC

  Explanation:

  The Data Pump Transportable Tablespace method 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.

  Note: If the job you are attaching to was initially started using an encryption password, then when you

  attach to the job you must again enter the ENCRYPTION_PASSWORD parameter on the command line to

  re-specify that password. The only exception to this is if the job was initially started with the

  ENCRYPTION=ENCRYPTED_COLUMNS_ONLY parameter. In that case, the encryption password is not

  needed when attaching to the job.

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

• Question 27:

  Which two statements are true about a Database Deployment in Oracle Public Cloud?

  A. A Secure Shell (SSH) key is provided by Oracle for accessing the compute nodes as the first step in creating a Database Deployment.

  B. The billing frequency depends on the Oracle database software edition that is selected for the Database Deployment.

  C. The public SSH key is provided when configuring the database in the Database Deployment.

  D. Storage configuration must be selected for the Database Deployment.

  E. The database that is configured may be an Oracle 11gR2 database.

  Correct Answer: AE

  Explanation:

  E: Onwizard Software Release page page to select the Oracle Database software release that you want to run on your instance.

  

  Note: When you create a database instance, you use the Create Database Cloud Service wizard, which steps you through the process of making the choices that produce a service instance tailored to your needs. These choices include:

  1.

  Service Level

  2.

  Billing Frequency

  3.

  Oracle Database Release Version

  4.

  Oracle Database Edition

  5.

  Computing Power

  6.

  Database Storage

  7.

  Backup and Recovery Configuration

  Incorrect Answers:

  B: Use the Subscription Type page, of the Create Database Cloud Service wizard, to select the service

  level and billing frequency.

  

  D: Storage is not configured. You configure the Instance, the Database, and Backup and recovery.

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

• Question 28:

  Which two tasks can you perform on the Database Cloud Service Instance View page?

  A. You can add pluggable databases (PDBs) to the database.

  B. You can decrease the storage of an instance.

  C. You can see patching information.

  D. You can create new users to access an instance.

  E. You can scale up to increase the shape of the current instance.

  Correct Answer: CD

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

• Question 29:

  Which three are ways to scale a Database as a Service (DBaaS) instance that is hosting three Oracle 12c databases?

  A. Add additional virtual network interfaces (VNICs) to the DBaaS instance.

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

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

  D. Increase the number of CPUs allocated to the DBaaS instance.

  E. Add storage to the DBaaS instance.

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

  G. Increase the memory allocated to the DBaaS instance.

  Correct Answer: DEG

• Question 30:

  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)

  Correct Answer: CD

  Explanation:

  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