1z0-160 | All About Downloadable 1z0-160 practice test


Q11. You want to perform database recovery with the most recent backup. Which command would you execute?

A. dbaascli rec –args –latest

B. dbaascli orec –args-latest

C. dbaascli rec –args -last

D. dbaascli orec –args -last

Answer: B

Explanation:

dbaascliorec 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

Q12. Which statement is true about the Oracle software releases that are currently supported in a Database as a Service (DBaaS) instance 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 containerdatabases.

Answer: C

Explanation:

11g 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

Q13. 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 theora_p2_dblistenersecurity rule.

B. Run thelsnrctl reload listenercommand.

C. Use the Oracle GlassFish Server Administration Console to start the listener application.

D. Change the firewall rules.

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" asthe "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

Q14. You want to perform an on-demand backup. Which two statements are true?

A. Connect to the instance’s VM as theopcuser.

B. Connect to the instance’s VM as theoracleuser.

C. Disable the backup configuration (crontab).

D. Enable the backup configuration (crontab).

Answer: A,D

Explanation:

A:Creating an On-Demand Backup by Using the bkup_api Utility

You can use the bkup_api utility to create an on-demand backup of a databasedeployment hosting a single-instance database or an Oracle Data Guard configuration.

D: If some activity you want to perform requires you to temporarily disable regularly scheduledbackups, you can do so by removing the scheduling information from the system-wide /etc/crontab file.

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

Q15. Which two statements are true about the SSH tunnels within a Database as a Service (DBaaS) Cloud environment?

A. The SSH tunnel must be selected by an access rule to enable remote access.

B. The server must hold the SSH public and private keys in the SSHauthorized_keysfile.

C. DBaaS provides a centralized key server for all SSH connections.

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

Answer: A,D

Explanation:

A: Oracle Database Cloud Service relies on Oracle Compute Cloud Service to provide secure network accessto database deployments. You can use the Oracle Database Cloud Service console to perform network access operations such as enabling access to a port on a compute node, or creating new security rules.

D: Creating an SSH tunnel enables you to access a specific compute node port by using an SSH connection as the transport mechanism. To create the tunnel, you must have the SSH private key file that matches the public key specified during the database deployment creation process.

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

Q16. You want to migrate an Oracle Database 11.2.0.2 on-premises database to the Oracle Database 11g database of the Database as a Service (DBaaS) instance on Oracle Cloud. A subset of the data that you want to transfer includes data stored in LONG data type columns.

All required data is contained in a dedicated tablespace. The tablespace is 100 GB in size and has 20% free space.

The client wants the data migrated in the shortest possible time to minimize impact on end users.

Select the most appropriate migration method to meet this requirement.

A. Data Pump TDB

B. Data Pump TTS

C. SQL*Loader Direct Path

D. conventional export/import

E. Remote Cloning

Answer: B

Explanation:

TheData Pump Transportable Tablespacecan 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.

The Transportable Tablespace method is generally much faster than a conventional export/import of the same data because the data files containing all of the actual data are simply copied to the destination location.

Q17. You are using access rules to control network traffic among your DBaaS instances. Which statement is true about access rules?

A. They are used only for configuring external server access to DBaaS and do not impact how network groups communicate.

B. They define a specific communication path, which consists of a source, destination, and protocol-port combination overwhich communication is allowed.

C. They are used to map an external user to a database user to allow the user to communicate with and access the database.

D. They are used to encrypt communication between DBaaS instances.

Answer: B

Explanation:

On the Access Rule youcan define the following:

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

Q18. You want all your colleagues to be able to access the compute node associated with an

Oracle Database Cloud – Database as a Service (DBaaS) instance. You want them to do so by using a custom host name rather than an IP address regardless of the client machine (personal or provided by the company) that they use for the access.

How would you enable this access?

A. Configure the Advanced Security Option (ASO).

B. Enable secure access to the DBaaS instance VM and database instance from remote hosts by using SSH.

C. Contact the administrator of your company’s intranet DNS and request a custom DNS record for the compute node’s public IP address.

D. Edit the machine’s/etc/hostsfile.

E. Resolve your domain name to the IP address of the DBaaS compute node by using the third-party domain registration vendor console.

Answer: C

Explanation:

You can associate a custom host name or domain name to the public IP address of a compute node associated with your Oracle Database Cloud Service environment.

To associate a custom host name to the public IP address of a compute node, contact the administrator of your DNS (Domain Name Service) and request a custom DNS record for the compute node’s public IP address. For example, if your domain is example.com and you wanted to use clouddb1 as the custom host name for a compute node, you would request a DNS record that associates clouddb1.example.com to your compute node's public IP address.

References:https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/define-custom-host-or-domain-name.html

Q19. You are monitoring resource usage on your Database Cloud Service.

What two resource usage metrics can you find on the Instance Overview page?

A. number of days left on your subscription

B. number of processes allocated

C. I/O from reads and writes

D. memory

E. storage

F. number of current users

Answer: D,E

Explanation:

The Overview page includes graphs that plot the data values for the top metrics for the past 7 days. The type of data collected and shown depends on the type of service. For example, for Oracle Database Cloud Service, the graphs show Storage Used and Maximum Storage Used.

Q20. 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 thebkup_apiutility logged in as theoracleuser 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 DBaaSbackup feature to maintain the list of database configuration files that are to be backed up.

D. Usedbms_schedulerto perform automatic backups.

Answer: A,C

Explanation:

A:You can use the bkup_api utility to create an on-demand backup of a database deployment hostinga 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:

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