1z0-160 | Real Oracle 1z0-160 dumps

Q41. You created a Database as a Service (DBaaS) instance. This action also created a virtual machine and configured it for the DBaaS instance. It also created two user accounts. One of the users is opc.

Which three functions can the opc user perform?

A. dropping the database instance

B. any root-user operation

C. database tuning

D. database backup and recovery

E. administrative operations in the virtual machine

F. operations that requires root-user access

Answer: D,E,F

Explanation:

Opcis the system administrator account you use to connect to the compute node using SSH. This user can use the sudo command to perform operations that require root-user access.

Connect as the user opc to perform operations that require root access to thecompute node, such as backing up or patching; this user can use the sudocommand to gain root access to the compute node.

Q42. Where is the Oracle Database Cloud software for monitoring and backup installed?

A. The Oracle Database Cloud software is located in the Database Automatic Diagnostic Repository (ADR).

B. The installation is done at/var/opt/oracle/dbaascliand/var/opt/oracle/bkup_api.

C. The location must be set during installation as user-defined locations for the installation to start.

D. The location is based on Oracle Flex Architecture, which is similar to non-DBaaS systems.

Answer: B

Explanation:

When a database deployment is created using the Oracle Database Cloud Serviceservice level, software is installed in the following locations.

* bkup_api utility /var/opt/oracle/bkup_api

* dbaascli utility /var/opt/oracle/dbaascli

* Oracle RESTData Services /u01/app/oracle/product/apex_listener

* Oracle Database

$ORACLE_HOME:

Note: Using the dbaascli utility, you can performoperations like:

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

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

A. You can add pluggable databases (PDBs) to thedatabase.

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.

Answer: C,D

Explanation:

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

Q44. Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud?

A. An Oracle database instance can support only one DBaaS instance.

B. A DBaaS instance can support only one Oracle database instance.

C. An Oracle database instance can support multiple DBaaS instances.

D. A DBaaS instance runs in a pluggable database (PDB), which is contained in a multi- tenant container database (CDB).

E. A DBaaS instance can support multiple Oracle database instances.

Answer: E

Explanation:

References:http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/sscs/ProvisionDB/SOACS_prereq%20_DBCS.html

Q45. How do you access “none default ports” on your DBaaS VM server?

A. Review a file calledportlist.iniin your installation directory to acquire the list of “none default ports” that are assigned to your VM server.

B. You file a service request with your DBaaS support team to have the “none default ports” opened for use.

C. You create an SSH tunnel to the “none default port”.

D. All communication to DBaaS services must be configured only by using the default ports that are assigned to your VM server during the installation of yourDBaaS instances.

Answer: B

Explanation:

To enable access to a compute node port, you enable the appropriate security rule.When you enable one of the predefined security rules, the given port on the computenode is opened to the public internet. To enable access to a different port, or restrictaccess to a port, you must create a security rule.

Note:When a database deployment is created, the following Oracle Compute Cloud

Servicesecurity rules are created, but set to a disabled status.

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

Q46. 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

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

These applications run in this configuration:

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 as a Service (DBaaS) instance in Oracle Cloud.

Which three should you check and possibly reconfigure to avoid the need to scale up the DBaaS instance?

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 configurethe 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.

Answer: A,D,E

Explanation:

References:https://docs.oracle.com/database/121/ADMIN/cdb_dbrm_em.htm

Q48. 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

Q49. How do you access “none default ports” on your DBaaS VM server?

A. Review a file calledportlist.iniin your installation directory to acquire the list of “none default ports” that are assigned to your VM server.

B. You file a service request with your DBaaS support team to have the “none default ports” opened for use.

C. You create an SSH tunnel to the “none default port”.

D. All communication to DBaaS services must be configured only by using the default ports that are assigned to your VM server during the installation of yourDBaaS instances.

Answer: B

Explanation:

To enable access to a compute node port, you enable the appropriate security rule.When you enable one of the predefined security rules, the given port on the computenode is opened to the public internet. To enable access to a different port, or restrictaccess to a port, you must create a security rule.

Note:When a database deployment is created, the following Oracle Compute Cloud

Servicesecurity rules are created, but set to a disabled status.

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

Q50. 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.