NEW QUESTION 1
Which two can be increased to scale up the compute shape of a Database Deployment in Oracle Database Cloud Service?

• A. Add more memory to the Database Deployment by using the Scale up button on the Oracle Database Cloud Service Overview page.
• B. Add more storage to the Database Deployment by using the Scale up button on the Oracle Database Cloud Service Overview page.
• C. Add more network adaptors (NICs) to the storage network used by the Database Deployment by using the Scale Up button on the Oracle Database Cloud Service Overview page.
• D. Add more network adaptors (NICs) to the public access network used by the Database Deployment by using the Scale Up button on the Oracle Database Cloud Service Overview page.
• E. Add more CPUs to the Database Deployment by using the Scale Up button on the Oracle Database Cloud Service Overview page.

Answer: AE

Explanation:
Occasionally, the need to scale arises from some change made to the database or backup configuration after it was created. For example, if the decision to use the In-Memory Database option was made after database creation, you might need to scale up the compute shape to one of the high-memory options, such as scaling from "OC4 - 2 OCPU, 15 GB RAM" to "OC2M - 2 OCPU, 30 GB RAM".
Note: To scale the compute shape for a database deployment:
View the overview page for the database deployment:
Open the Oracle Database Cloud Service console.
Click the name of the deployment you want to scale.The Oracle Database Cloud Service Overview page is displayed.
2. Choose the scaling command.The Scale Up/Down Service overlay is displayed. Note that the overlay includes information about the current compute shape.
Select a new compute shape.
Click Yes, Scale Up/Down Service to scale the database deployment.
The scaling operation begins. The database deployment is in Maintenance status and unavailable while the scaling operation is in progress.
References:
https://docs.oracle.com/cloud-machine/latest/dbcs_dbaas/CSDBI/GUID-457D283C-D890-4B4F-B65C-26D05B

NEW QUESTION 2
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 SSH authorized_keys file.
• C. DBaaS provides a centralized key server for all SSH connections.
• D. The client must provide the server with the SSH private key.

Answer: AD

Explanation:
A: Oracle Database Cloud Service relies on Oracle Compute Cloud Service to provide secure network access to 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

NEW QUESTION 3
What is the location of the associated database files of a Database Deployment?

• A. The installer sets the database file locations during installation by configuring the data file storage options.
• B. The Database Deployment data files are stored at:/u01: Oracle product software; the entire bits Compute Cloud storage volume/u02: Oracle Database data storage; the entire data Compute Cloud storage volume/u03: Database backup storage; the entire fra Compute Cloud storage volume/u04: Database redo logs; the entire redo Compute Cloud storage volume
• C. All database instance files on the Database Deployment are stored at /u01/app/oracle/oradata.
• D. The database file locations are read from utldbfiles.ora and users can update this file to set their own locations.

Answer: B

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

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

NEW QUESTION 4
Your Database Deployment hosts a multitenant container database (CDB) with four pluggable database (PDB) tenants.
Users of an application in one PDB and users of another application in another PDB complain of poor performance.
Investigation shows that the application sessions are not using excessive CPU nor are they requesting an unusual amount of I/O.
Which two steps should you perform to resolve this problem?

• A. Add storage to the Database Deployment.
• B. Add CPU to the Database Deployment.
• C. Examine the shares of resources allocated to each PDB within the CDB.
• D. Examine the shares of resources allocated to each consumer group within all four PDBs.
• E. Examine the shares of resources allocated to each consumer group within the PDBs that contain the two applications.
• F. Add memory to the Database Deployment.

Answer: EF

NEW QUESTION 5
Which three statements are true about the service levels provided by Database Cloud Service (DBCS)?

• A. The Virtual Image service level provides a pre-created database.
• B. The Virtual Image service level provides tools for backups and patching.
• C. The automated service provides a pre-installed virtual machine image.
• D. The automated service provides a pre-created database.
• E. The cloud tooling within the automated service level provides a tool for point-in-time database recovery.

Answer: BDE

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

Answer: C

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.
ora_p2_dbconsole, which controls access to port 1158, the port used by Enterprise Manager 11g Database Control.
ora_p2_dbexpress, which controls access to port 5500, the port used by Enterprise Manager Database Express 12c.
ora_p2_dblistener, which controls access to the port used by SQL*Net.
ora_p2_http, which controls access to port 80, the port used for HTTP connections.
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 2021), page 3-7 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf

NEW QUESTION 9
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 10
Which users are created and can be used for database and host management of your DBaaS database servers?

• A. root, opc and oracle users
• B. root, oracle and cloud users
• C. root and oracle users
• D. opc and oracle users
• E. cloud and oracle users

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

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

Answer: A

NEW QUESTION 12
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 13
Which users can remotely log in and administer a compute node of a Database Deployment?

• A. root and oracle users
• B. opc and oracle users
• C. sysman and oracle users
• D. root, opc, and oracle users
• E. root, oracle, and sysman users

Answer: B

NEW QUESTION 14
You have an Oracle Database 11g on-premises database with encrypted tablespaces.
You want to migrate this database to the pre-created database of the Database as a Service (DBaaS) instance on Oracle Cloud.
Which two statements are true about this migration?

• A. The on-premises database platform must be of the same endianness as the DBaaS platform.
• B. You can use Full Transportable (TDB).
• C. You can use Data Pump TTS with the ENCRYPTION_PASSWORD parameter.
• D. You can use Data Pump TTS with the ENCRYPTED_PASSWORD parameter.
• E. Data is sent in clear when the NETWORK_LINK option is used.

Answer: AC

Explanation:
The Data Pump Transportable Tablespace method can 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.
Note: If the job you are attaching to was initially started using an encryption password, then when you attach to the job you must again enter the ENCRYPTION_PASSWORD parameter on the command line to re-specify that password. The only exception to this is if the job was initially started with the
ENCRYPTION=ENCRYPTED_COLUMNS_ONLY parameter. In that case, the encryption password is not needed when attaching to the job.
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-11g-11g.html

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

Answer: BE

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/ConfiguringNetworkS

NEW QUESTION 16
What would be the number of bits in the SSH key generated by using the ssh-keygen tool, which is used to connect to Oracle Cloud?

• A. 4096
• B. 1024
• C. 2048
• D. 512

Answer: C

NEW QUESTION 17
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 18
You want to make sure that your database administrators have a convenient way to monitor your DBaaS instance. To do so, you need to enable the Oracle DBaaS Monitor. How would you enable the Oracle DBaaS Monitor?

• A. Use the enable_dbaas_monitor command.
• B. Create an SSH tunnel to port 443.
• C. Disable the ora_p2_httpssl security rule in Oracle Compute Cloud Service Console.
• D. Use the Oracle GlassFish Server Administration Console.
• E. Add ODBM access to each DBA’s user profile.

Answer: B

Explanation:
To access Oracle DBaaS Monitor when the HTTPS port is blocked, you must create an SSH tunnel to port 443 on the compute node hosting the DBaaS Monitor.
Note: How you access Oracle DBaaS Monitor depends on whether the HTTPS port (443) has been unblocked. When a Database Cloud Service deployment is first created, the HTTPS port is blocked to ensure network security

NEW QUESTION 19
When you are using Oracle Compute Service Console and reviewing the network configuration of your database instance, what do the arrows that are shown within the security rules define?

• A. whether the connection was completely secured.
• B. the availability of network access to the database instance.
• C. the direction of network access to the database instance.
• D. the status of the database instance.

Answer: B

Explanation:
The arrows indicate if the access rule is enabled or not. Example:

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

NEW QUESTION 20
Oracle provides additional web-based tools for monitoring Database as a Service (DBaaS) instances. One of the tools is DBaaS Monitor Console.
Which user would you have to log in as to use this tool?

• A. dbsnmp
• B. sys
• C. dbaas_monitor
• D. sysman

Answer: C

Explanation:
To access Oracle DBaaS Monitor when the HTTPS port is unblocked:
Open the Oracle Database Cloud Service console.
From the menu for the deployment, select Open DBaaS Monitor Console.A window prompting you for your user name and password is displayed.
Enter dbaas_monitor as the user name and the password specified during the database deployment creation process, and then click OK.
References: Using Oracle Database Cloud Service (February 2021), 10-2 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf

NEW QUESTION 21
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 22
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 23
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?

• A. Non
• B. No backups require
• C. You are responsible for configuring the database backups.
• D. Backing up to cloud storage and local compute storag
• E. 10 (ten) days worth of backups are kept, with five most recent days worth of backups available directly on the local compute node storage.
• F. Backing up to Oracle Cloud Service storage volumes which is equal to five times the value that was provided in Usable Data Storage when the instance was created.
• G. Backing up to cloud storage and local compute storag
• H. 30 (thirty) days worth of backups are kept, with seven most recent days worth of backups available directly on local compute node storage.

Answer: AC

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

• A. A Database Deployment requires customers to install any additional management tools for their environment.
• B. A Database Deployment never provides a pre-created Oracle database software.
• C. An Oracle database instance that is provided as part of Oracle Database Cloud Service runs the same executable that would be run with the same version and release of Oracle Database on private premises.
• D. A Database Deployment always provides a customer-selected version of the Oracle database software.
• E. Only one Oracle database instance can run in a Database Deployment on Oracle Public Cloud.

Answer: CD

Explanation:
D: The wizard's Software Release page is used to select the Oracle Database software release that you want to run on your instance.

On the Software Edition page select the Oracle Database software edition that you want to run on your instance.

References:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_creating_an_instance/obe_

NEW QUESTION 25
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 oracle.
What three functions can be used by Oracle users in a Database Deployment?

• A. Grant privileges and roles to database users.
• B. Create database users.
• C. Back up and recover databases.
• D. Create tablespaces.
• E. Reboot a VM.
• F. Use the sudo command to perform root user access operations.

Answer: ABC

Explanation:
Oracle is the Oracle Database administrator account you use to access the system and perform non-root database administration tasks. A home directory, /home/oracle, is created for this user. This user cannot use the sudo command to perform operations that require root-user access. Additionally, by default you cannot connect as this user to the compute node using SSH. You can add the public key to the user’s
$HOME/.ssh/authorized_keys file to grant persistent SSH access, or you can connect as the opc user and then use the sudo -s command to start a root-user command shell, followed by an su - oracle command to switch to the oracle user.

NEW QUESTION 26
......