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

• A. You would require access to the Oracle Compute Cloud Service console to open the ports to a set of IP addresses.
• B. You must contact your Oracle Database Cloud Service support team to update the port specifications for use.
• C. All ports that are available in Oracle Database Cloud Service servers must use an SSH tunnel and cannot be enabled persistently.
• D. You can use server certificates to map a server’s identity to enable persistent connection through a port to a Database Deployment’s compute nodes.

Answer: D

NEW QUESTION 2
You use GUI tools on the Virtual Machine to create and administer the Database as a Service (DBaaS)
databases.
You wish to use the Oracle Database Configuration Assistant (DBCA) to create a database instance. To run DBCA, you will need to use an SSH connection.
You need to perform several steps to establish this connection in DBCA and to create the database. What are two of these steps?

• A. Connect to the DBaaS instance with the SSH terminal session as the oracle user.
• B. Configure a PuTTY or SSH session to perform X11 forwarding.
• C. Install an Xterminal program if required.
• D. Update the tnsnames.ora file with the name of the service to which you want to connect.

Answer: AB

Explanation:
Example: To create a database into your Oracle Database Cloud Service
You have created a PuTTY definition for connecting through an SSH tunnel to your Database Cloud Service (DBaaS) instance. Now open this definition to connect to the VM.t10101
Because this is not the first time you are connecting to the VM, the SSH utility does not prompt you to confirm the public key. If it were the first time, the SSH utility would have prompted you to confirm the public key. You would have confirmed by clicking Yes.t10102
You can now launch DBCA either in silent mode or in graphical mode.
References:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/OU/IntroDBaaS/UsingDBATools/Usin

NEW QUESTION 3
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.

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.

NEW QUESTION 4
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.

Answer: CD

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

NEW QUESTION 5
Which three are ways to scale a Database Deployment 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.

Answer: DEG

NEW QUESTION 6
Which three consoles can be accessed from the Oracle Database Deployment page?

• A. Database Express Manager Console
• B. OPC Console
• C. Application Express Console
• D. User Console
• E. Storage Container Console
• F. DBaaS Monitor Console

Answer: ACD

NEW QUESTION 7
Which two steps would you perform to restore and recover a database from the most recent backup?

• A. Disable the scheduled backup configuration.
• B. Disable the scheduled recovery configuration.
• C. Perform the restore with the dbaascli orec --args –latest command.
• D. Perform the restore with the dbaascli orec –-args –last command.
• E. Perform the restore with the dbaascli orec –-args –stop -last command.
• F. Perform the restore with the dbaascli orec –-args –close –last command.

Answer: AC

Explanation:
A: Note: 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.
C: You can use the dbaascli utility to restore from the most recent backup and perform complete recovery on a database deployment hosting a single-instance database:
Connect as the opc user to the compute node.
Start a root-user command shell:$ sudo -s#
Restore the most recent backup and perform complete recovery using the orec subcommand of the dbaascli utility:# dbaascli orec --args -latestThe restore and recover process performs these steps:
Shuts down the database
Extracts and restores configuration files
Prepares for recovery
Performs the recovery
Restarts the database instance after recovery
Exit the root-user command shell:# exit$
References: Using Oracle Database Cloud Service (February 2021), page 6-23 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf

NEW QUESTION 8
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

Answer: D

NEW QUESTION 9
Which two must be true when you migrate an Oracle Database 12.1.0.2 non-CDB to a database that is running in a Database as a Service (DBaaS) instance on Oracle Cloud by using the Remote Cloning method?

• A. The non-CDB may be opened in READ WRITE mode as long as ARCHIVELOG is enabled.
• B. The database link owner must have the CREATE PDB system privilege.
• C. The source platform must have the same endian format.
• D. The non-CDB must be in archivelog mode.
• E. The non-CDB must be opened in READ ONLY mode.
• F. The database link owner must have the CREATE PLUGGABLE DB system privilege.

Answer: EF

Explanation:
To migrate an Oracle Database 12c non-CDB database to a Database Cloud Service database deployment using the remote cloning method, you perform these tasks:
On the on-premises database host, invoke SQL*Plus and set the on-premises database to READ ONLY mode.
On the Database Cloud Service compute node, invoke SQL*Plus and create a database link that enable a connection to the on-premises database.
On the Database Cloud Service compute node, execute the CREATE PLUGGABLE DATABASEcommand to clone the on-premises non-CDB database.
On the Database Cloud Service compute node, execute
the $ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql script.
On the Database Cloud Service compute node, open the new PDB by executing the ALTER PLUGGABLE DATABASE OPEN command.
Optionally, on the on-premises database host invoke SQL*Plus and set the on-premises database back to READ WRITE mode.
You can use this method only if the on-premises platform is little endian, the on-premises database release is 12.1.1.2 or higher, and the on-premises database and Database Cloud Service database have compatible database character sets and national character sets.
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-remote-cloning-non-cdb.html

NEW QUESTION 10
Which two statements are true about the SSH tunnels within an Oracle Database Cloud Service environment?

• A. An individual SSH tunnel is required for each port in the environment.
• B. The client must provide the server with the SSH private key.
• C. The SSH tunnel must be selected by a security rule to enable remote access.
• D. The server must hold the SSH public and private keys in the SSH authorized_keys file.
• E. Oracle Database Cloud Service provides a centralized key server for all SSH connections.

Answer: BC

NEW QUESTION 11
How would you stop Oracle REST Data Services (ORDS)?

• A. Perform the /u01/app/oracle/product/ords/ords
• B. Use the listener control tool (lsnrctl).
• C. Stop the APEX resource in Enterprise Manager.
• D. Use the ords_stop command.

Answer: D

NEW QUESTION 12
Which two statements are true about the Oracle software releases that are currently supported in a Database Deployment 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.
• E. Oracle Database 12c Release 2 is supported.

Answer: CE

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_

NEW QUESTION 13
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: DE

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.

NEW QUESTION 14
You are preparing the storage volume for use in an instance. Which two tasks must you perform?

• A. Point to a mount point that has existing files and directories.
• B. Connect to the Database Deployment to which you attached the storage volume by using ssh or PuTTY as the opc user.
• C. Create a mount point on your instance.
• D. Connect to the Database Deployment to which you attached the storage volume by using ssh or PuTTY as the oracle user.

Answer: BC

Explanation:
To add temporary storage to a database deployment:
Use the Create Storage Volume wizard in the Compute Cloud Service console to create a storage volume.
Attach the storage volume to the Compute Cloud Service instance on which the compute node is running. When you attach the storage volume, it is assigned a disk number. Note down this disk number for later use.
Connect as the opc user to the compute node.
Start a root-user command shell$ sudo -s #
Confirm the addition of the storage volume by using the ls command:# ls /dev/xvd*
Create a file system on the partition by using the mkfs command.
Create a directory to use as the mount point for the partition by using the mkdir command.
Mount the partition on the directory you just created by using the mount command.
Set the ownership and permissions of the mount-point directory appropriately by using the chown and chmod commands.
Exit the root-user command shell.
References: Using Oracle Database Cloud Service (February 2021), 4-4 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf

NEW QUESTION 15
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.

Answer: C

NEW QUESTION 16
Which two statements are true about the Database Deployments and Oracle database instances that are provided by Oracle Public Cloud?

• A. A Database Deployment Virtual Image always provides a pre-created Oracle database.
• B. An Oracle database instance that is provided as part of Oracle Database Cloud Service runs a different executable than would be run with the same version and release of Oracle Database on private premises.
• C. A Database Deployment Virtual Image always provides a Linux virtual machine.
• D. A Database Deployment Virtual Image requires customers to install their preferred version on the Oracle database software.
• E. Multiple Oracle database instances can run in a Database Deployment on Oracle Public Cloud.

Answer: CD

NEW QUESTION 17
You want to apply a patch to your Oracle Database Cloud – Database as a Service. What command will you execute to patch your database instance?

• A. dbaascli dbpatchm --run -config
• B. dbaascli dbpatchm --run -setup
• C. dbaascli dbpatchm --run -apply
• D. dbaascli dbpatchm --run -patch

Answer: C

Explanation:
Options of the command: dbaascli dbpatchm apply – applies the patch.
clonedb – applies a patch to a test deployment. list_patches – displays a list of available patches.
list_tools – checks whether any cloud tooling updates are available. prereq – checks the prerequisites of a patch.
rollback – rolls back the last deployment patch. switchback – restores database software to a prior state. toolsinst – downloads
References: References: Using Oracle Database Cloud Service (February 2021), page D-1 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf

NEW QUESTION 18
Which three statements are true about the Oracle Cloud Service storage volumes that are created as part of a Database Deployment in Oracle Public Cloud?

• A. The database data file storage and the tempfile storage are placed on the same storage volume.
• B. The database backup storage and the redo log storage are placed on the same storage volume.
• C. The Oracle database product software storage and the database data file storage are placed on the same storage volume.
• D. The database backup storage and the database product software storage are placed on different storage volumes.
• E. The database data file storage and the redo log storage are placed on different storage volumes.

Answer: ADE

Explanation:
Compute Cloud Service Storage Volumes
When a Database Cloud Service deployment is created using the Oracle Database Cloud Service service level, the following storage volumes are created.

References: Using Oracle Database Cloud Service (February 2021), page A-3
http://docs.oracle.com/cloud/latest/dbcs_dbaas/CSDBI/CSDBI.pdf

NEW QUESTION 19
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.

Answer: E

Explanation:
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/db-deployments.html#GUID-61C0A3F6-1760

NEW QUESTION 20
Which two tasks can be performed to customize a backup configuration?

• A. Edit the /home/oracle/bkup/dbcfg.spec file to maintain the list of database configuration files to be backed up.
• B. Use dbms_scheduler to schedule automatic backups.
• C. Edit the /home/oracle/bkup/dbcfg.spec file to maintain the list of system files and folders to be backed up.
• D. Use the bkup_api utility as the oracle user to configure a retention period.

Answer: AD

NEW QUESTION 21
Which two steps are true about performing an on-demand backup?

• A. You need to connect to the compute node as the oracle user.
• B. You need to connect to the compute node as the opc user.
• C. You need to disable the backup configuration (crontab).
• D. You need to enable the backup configuration (crontab).

Answer: D

NEW QUESTION 22
Users must be granted roles to manage Cloud services.
Which three statements are true about roles and role assignment in Oracle Database Cloud Service?

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

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

NEW QUESTION 23
......