Free 1Z0-160 Exam Dumps PDF Preview

Question 1

Single choice

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.

Reveal answer details Close answer details

Correct answerC

Question 2

Single choice

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 container databases.

Reveal answer details Close answer details

Correct answerC

Explanation

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

Question 3

Multiple choice

You are on the Database Cloud Service Instance View page.

Which three consoles can you open?

A
OPC Console
B
GlassFish Administration Console
C
Storage Container Console
D
Application Express Console
E
User Console
F
Database Express Manager Console

Reveal answer details Close answer details

Correct answersD, E, F

Explanation

Explanation:
The menu for each deployment that provides the following options:
1. Open DBaaS Monitor Console - Open the Oracle Cloud Database Monitor for the deployment.
2. Open Application Express Console - Open the Oracle Application Express home page for the deployment.
3. Open EM Console - Open the database console, either Enterprise Manager Database Express 12c or Enterprise Manager 11g Database Control.

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

Question 4

Single choice

How would you enable Oracle DBaaS Monitor?

A
Create an SSH tunnel to port 443.
B
Add Oracle DBaaS Monitor access to SYS, SYSTEM users profile.
C
Disable the ora_p2_httpsl security rule in the Oracle Compute Cloud Service console.
D
Use the enable_dbaas_monitor command.
E
Use the Oracle Application Express Administration Console.

Reveal answer details Close answer details

Correct answerA

Question 5

Multiple choice

Users must be granted roles to manage Cloud services.

Which three statements are true about roles and role assignment in Database as a Service (DBaaS)?

A
Service administrators can assign and remove roles only for users of the services that they manage.
B
The DBaaS Database Administrator role permits granting the DBaaS Database Administrator role to existing users.
C
Identity domain administrators can assign and remove roles for users in any identity domains.
D
The DBaaS Database Operator role permits scaling, patching, and backing up or restoring service instances.
E
DBaaS network administrators can grant access privileges to designated users.

Reveal answer details Close answer details

Correct answersA, D, E

Explanation

Explanation:
A: A Service administrator manages administrative functions related to Oracle Cloud services within an identity domain.

D: The privileges given to the DBaaS Database Administrator role include: Can scale, patch, and back up or restore database deployments

Incorrect Answers:
B: The privileges given to the DBaaS Database Administrator role are:
1. Can create and delete database deployments 2. Can scale, patch, and back up or restore database deployments
3. Can monitor and manage service usage in Oracle Cloud
C: Only identity domain administrators can manage user accounts, and they are allowed to add, modify, and remove user accounts only in the identity domains that they have been designated to administer.

References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-roles-and-users.html

Question 6

Single choice

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

Reveal answer details Close answer details

Correct answerA

Explanation

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

Multiple choice

Which two statements are true about the information that you see on the Database Cloud Service page?

A
It shows the date the instance was last accessed.
B
It shows the number of active sessions for each instance in your domain.
C
It shows the total memory for all instances in your domain.
D
It lists the memory for each instance in your domain.
E
It shows the name of each database instance.

Reveal answer details Close answer details

Correct answersC, E

Explanation

Explanation:

The Oracle Database Cloud Service Services page displays all deployments on Oracle Database Cloud Service.
Use the Oracle Database Cloud Service Services page to perform the following tasks:
1. Viewing All Database Deployments
2. Creating a Database Deployment
3. Viewing Detailed Information for a Database Deployment

Deleting a Database Deployment
The Activity page displays activities for all Oracle Database Cloud Service deployments in your identity domain.

Example:

References:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/sscs/ProvisionDB/SOACS_prereq%20_DBCS.html
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-services-page.html

Question 8

Multiple choice

You want to perform an on-demand backup.

Which two statements are true?

A
Connect to the instance's VM as the opc user.
B
Connect to the instance's VM as the oracle user.
C
Disable the backup configuration (crontab).
D
Enable the backup configuration (crontab).

Reveal answer details Close answer details

Correct answersA, D

Explanation

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 database deployment hosting a single-instance database or an Oracle Data Guard configuration.
1. Connect as the opc user to the compute node. In a Data Guard configuration, connect to the compute node hosting the primary database.
2. Start a root-user command shell:
$ sudo -s
# 3. You can choose to have the backup follow the current retention policy, or you can choose to create a long-term backup that persists until you delete it:
- To create a backup that follows the current retention policy, enter the following bkup_api command:
# /var/opt/oracle/bkup_api/bkup_api bkup_start
- To create a long-term backup, enter the following bkup_api command:
# /var/opt/oracle/bkup_api/bkup_api bkup_start --keep
1. Exit the root-user command shell and disconnect from the compute node:
# exit

$ exit

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

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

Question 9

Single choice

How do you access "none default ports" on a Database Deployment's compute node?

A
Review a file called portlist.ini in your installation directory to acquire the list of "none default ports" that are assigned to your compute node.
B
File a service request with your Oracle Database Cloud Service support team to have the "none default ports" opened for use.
C
Create an SSH tunnel to the "none default port".
D
All communication to Oracle Database Cloud Service must be configured only by using the default ports that are assigned to your compute node during the installation of your Database Deployments.

Reveal answer details Close answer details

Correct answerC

Explanation

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 compute node is opened to the public internet. To enable access to a different port, or restrict access to a port, you must create a security rule.

Note: When a database deployment is created, the following Oracle Compute Cloud Service security rules are created, but set to a disabled status.
1. ora_p2_dbconsole, which controls access to port 1158, the port used by Enterprise Manager 11g
Database Control.
2. ora_p2_dbexpress, which controls access to port 5500, the port used by Enterprise Manager Database
Express 12c.
3. ora_p2_dblistener, which controls access to the port used by SQL*Net.
4. ora_p2_http, which controls access to port 80, the port used for HTTP connections.
5. ora_p2_httpssl, which controls access to port 443, the port used for HTTPS connections, including
Oracle REST Data Services, Oracle Application Express, and Oracle DBaaS Monitor.

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

Question 10

Single choice

Which statement is true about the Database Deployment and Database instances in Oracle Public Cloud?

A
An Oracle database instance can support only one Database Deployment.
B
A Database Deployment can support only one Oracle database instance.
C
An Oracle database instance can support multiple Database Deployment.
D
A Database Deployment runs in a pluggable database (PDB), which is contained in a multi-tenant container database (CDB).
E
A Database Deployment can support multiple Oracle database instances.

Reveal answer details Close answer details

Correct answerE

Explanation

References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/db-deployments.html#GUID-61C0A3F6-1760-47EC-8B3E-8B50AE1276D9

Question 11

Multiple choice

You want to control network traffic among your DBaaS instances.

Which two statements are true about network groups?

A
By default, the DBaaS instances in a network group are accessible from hosts outside the network group.
B
You can add a DBaaS instance to a network group, but this enables communication only within this network group.
C
You can add a DBaaS instance to a network group, thus enabling communication with all other DBaaS instances both inside and outside the network group.
D
You can create a network group to enable unrestricted communication among your DBaaS instances.
E
DBaaS prevents network groups from having unrestricted communication among DBaaS instances.

Reveal answer details Close answer details

Correct answersB, E

Explanation

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 12

Single choice

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

Reveal answer details Close answer details

Correct answerB

Explanation

Explanation:
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 13

Single choice

Which user is used to log in to DBaaS Monitor Console to monitor the necessity of scaling a Database Deployment?

A
sys
B
sysman
C
dbsnmp
D
dbaas_monitor

Reveal answer details Close answer details

Correct answerD

Explanation

References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/access-dbaas-monitor.html

VOL	TYPE	QUESTIONS
1	Single choice	8
2	Multiple choice	5

Free 1Z0-160 Exam Dumps Preview

Oracle Database Cloud Service

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13