1z0-160: Oracle Database Cloud Service - Free download from Exam Hub

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?

Configure the Advanced Security Option (ASO).
Enable secure access to the DBaaS instance VM and database instance from remote hosts by using SSH.
Contact the administrator of your company’s intranet DNS and request a custom DNS record for the compute node’s public IP address.
Edit the machine’s /etc/hosts file.
Resolve your domain name to the IP address of the DBaaS compute node by using the third-party domain registration vendor console.

Correct 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

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

With Oracle Database Cloud Service as the subscription type, you must configure a database for Backup and Recovery.

Which two options do you have to back up your database instance?

No backups required. You are responsible for configuring the database backups.
Backup to cloud storage and VM block storage. Ten days worth of backups are kept, with five most recent days worth of backups available directly on VM block storage.
Backup to Oracle Cloud Service storage volumes that is equal to five times the value that was provided in Usable Data Storage when the instance was created.
Backup to cloud storage and VM block storage. Fourteen days worth of backups are kept, with seven most recent days worth of backups available directly on VM block storage.

Correct answer: AC

Explanation:

When creating a new database deployment on Oracle Database Cloud Service, you choose whether you want automatic backups to be configured for the database. Your choices are:Both Cloud Storage and Local Storage—30 days' worth of backups are kept, with the 7 most recent days' worth available directly on the compute node’s local storage. Cloud Storage Only—30 days' worth of backups are kept, with all backups on cloud storage. None—automatic backups are not configured. References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/db-deployments.html

When creating a new database deployment on Oracle Database Cloud Service, you choose whether you want automatic backups to be configured for the database. Your choices are:

Both Cloud Storage and Local Storage—30 days' worth of backups are kept, with the 7 most recent days' worth available directly on the compute node’s local storage.

Cloud Storage Only—30 days' worth of backups are kept, with all backups on cloud storage.

None—automatic backups are not configured.

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

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)?

Service administrators can assign and remove roles only for users of the services that they manage.
The DBaaS Database Administrator role permits granting the DBaaS Database Administrator or DBaaS Database Operator role to existing users.
Identity domain administrators can assign and remove roles for users in any identity domains.
The DBaaS Database Operator role permits the ability to scale, patch, and backup or restore service instances.
DBaaS network administrators can grant access privileges to designated users.

Correct answer: ADE

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:Can create and delete database deployments Can scale, patch, and back up or restore database deployments 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

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:

Can create and delete database deployments
Can scale, patch, and back up or restore database deployments
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

Which users are created and can be used for database and host management of your DBaaS database servers?

root, opc and oracle users
root, oracle and cloud users
root and oracle users
opc and oracle users
cloud and oracle users

Correct answer: D

Explanation:

Linux user accounts that are provisioned on an Oracle Database Cloud Service deployment that hosts an Oracle Real Application Clusters (Oracle RAC) database:* opc 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. * oracle The Oracle Database administrator account you use to access the system and perform non-root database administration tasks. * grid The Oracle Grid Infrastructure administrator account you use to perform ASM, ACFS, and clusterware administration tasks. * root The root administrator for the system. You do not have direct access to this account. To perform operations that require root-user access, use the sudo command as the opc user. References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/linux-user-accounts-rac.html

Linux user accounts that are provisioned on an Oracle Database Cloud Service deployment that hosts an Oracle Real Application Clusters (Oracle RAC) database:

* opc

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.

* oracle

The Oracle Database administrator account you use to access the system and perform non-root database administration tasks.

* grid

The Oracle Grid Infrastructure administrator account you use to perform ASM, ACFS, and clusterware administration tasks.

* root

The root administrator for the system. You do not have direct access to this account. To perform operations that require root-user access, use the sudo command as the opc user.

References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/linux-user-accounts-rac.html

Which two situations require that your Database as a Service (DBaaS) instance be scaled up?

The DBaaS instance is maxed out on semaphore sets.
The database instance has reached the limit in the license_max_sessions database parameter.
The DBaaS instance is maxed out on CPU.
The database instance is out of space in the sysaux and system tablespaces.
The DBaaS instance is maxed out on storage.
The DBaaS instance is maxed out on semaphores.

Correct answer: CE

Explanation:

Existing DBCS instances may scale up to bigger shapes in OCPU, Memory and Storage for vertical scaling. For horizontal scaling, DBCS provides RAC with the Extreme Performance option currently allowing applications to scale up to 2 nodes, each with a max of 16 OCPU shapes. Note: An Oracle CPU (OCPU) provides CPU capacity equivalent of one physical core of an Intel Xeon processor with hyper threading enabled. Each OCPU corresponds to two hardware execution threads, known as vCPUs.References: https://cloud.oracle.com/opc/database/faq

Existing DBCS instances may scale up to bigger shapes in OCPU, Memory and Storage for vertical scaling. For horizontal scaling, DBCS provides RAC with the Extreme Performance option currently allowing applications to scale up to 2 nodes, each with a max of 16 OCPU shapes.

Note: An Oracle CPU (OCPU) provides CPU capacity equivalent of one physical core of an Intel Xeon processor with hyper threading enabled. Each OCPU corresponds to two hardware execution threads, known as vCPUs.

References: https://cloud.oracle.com/opc/database/faq

How would you enable a port persistently to keep communication open through that port always?

To enable a port persistently, you must contact your DBaaS support team to update the port specifications for use.
You can use server certificates to map a server’s identity to enable persistent connection through a port to DBaaS instances.
All ports that are available in DBaaS servers must use an SSH tunnel and cannot be enabled persistently.
To enable a port persistently, you would require access to the Compute Cloud Service Console to open the ports to a set of IP addresses.

Correct answer: A

dbaascli is a command-line interface for managing a database instance on cloud.

Which two functions can you manage with dbaascli?

running health checks on your database
creating users in the database instance
restoring from the most recent backup
creating a database instance
applying a patch

Correct answer: CE

Explanation:

The dbaascli utility is provided on Oracle Database Cloud Service deployments to perform a variety of life-cycle and administration operations. Using the dbaascli utility, you can perform operations like:* Database recovery The orec latest subcommand restores the most recent backup and performs complete recovery. * Patching the database deployment The dbpatchm apply subcommand applies the patch. * Changing the password of the SYS user * Checking the status of the Oracle Data Guard configuration * Switchover and failover in an Oracle Data Guard configuration * Rotating the master encryption key References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/dbaascli.html

The dbaascli utility is provided on Oracle Database Cloud Service deployments to perform a variety of life-cycle and administration operations.

Using the dbaascli utility, you can perform operations like:

* Database recovery

The orec latest subcommand restores the most recent backup and performs complete recovery.

* Patching the database deployment

The dbpatchm apply subcommand applies the patch.

* Changing the password of the SYS user

* Checking the status of the Oracle Data Guard configuration

* Switchover and failover in an Oracle Data Guard configuration

* Rotating the master encryption key

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

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

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

Correct answer: E

Explanation:

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

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

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

Correct answer: CE

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:Viewing All Database Deployments Creating a Database Deployment 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.htmlhttps://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-services-page.html

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:

Viewing All Database Deployments
Creating a Database Deployment
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

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?

All versions and releases of Oracle Database 12c are supported.
All versions and releases of Oracle Database 11g are supported.
Oracle Database 11g Release 2 is supported.
Oracle Database 12c is supported but only for single container databases.

Correct 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

11g Release 2 and 12c Release 1 (and 2) are supported.