NEW QUESTION 1
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 2
You want to migrate an Oracle Database 11.2.0.2 on-premises database to the Oracle Database 11g database of the Database as a Service (DBaaS) instance on Oracle Cloud. A subset of the data that you want to transfer includes data stored in LONG data type columns.
All required data is contained in a dedicated tablespace. The tablespace is 100 GB in size and has 20% free space.
The client wants the data migrated in the shortest possible time to minimize impact on end users. Select the most appropriate migration method to meet this requirement.

• A. Data Pump TDB
• B. Data Pump TTS
• C. SQL*Loader Direct Path
• D. conventional export/import
• E. Remote Cloning

Answer: B

Explanation:
The Data Pump Transportable Tablespace 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.
The Transportable Tablespace method is generally much faster than a conventional export/import of the same data because the data files containing all of the actual data are simply copied to the destination location.

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

Answer: DEF

Explanation:
DF: The menu for each deployment that provides the following options:
Open DBaaS Monitor Console — Open the Oracle Cloud Database Monitor for the deployment.
Open Application Express Console — Open the Oracle Application Express home page for the deployment.
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

NEW QUESTION 4
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 5
Which two statements are true about a Database Deployment in Oracle Public Cloud?

• A. A Secure Shell (SSH) key is provided by Oracle for accessing the compute nodes as the first step in creating a Database Deployment.
• B. The billing frequency depends on the Oracle database software edition that is selected for the Database Deployment.
• C. The public SSH key is provided when configuring the database in the Database Deployment.
• D. Storage configuration must be selected for the Database Deployment.
• E. The database that is configured may be an Oracle 11gR2 database.

Answer: AE

Explanation:
E: Onwizard Software Release page page to select the Oracle Database software release that you want to run on your instance.

Note: When you create a database instance, you use the Create Database Cloud Service wizard, which steps you through the process of making the choices that produce a service instance tailored to your needs. These choices include:
Service Level
Billing Frequency
Oracle Database Release Version
Oracle Database Edition
Computing Power
Database Storage
Backup and Recovery Configuration

NEW QUESTION 6
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 7
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 8
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 9
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 10
Which statement is true about Oracle Database Schema Service or Oracle Database Cloud Service in Oracle Public Cloud?

• A. Oracle Database Schema Service requires no database administrators to administer the database.
• B. Oracle Database Cloud Service requires no database administrators to administer the database.
• C. Oracle Database Cloud Service provides complete database instances with shared control between thesubscriber DBA and Oracle Support.
• D. Oracle Database Schema Service provides database schemas with shared control between the subscriber DBA and Oracle Support.

Answer: C

NEW QUESTION 11
You are migrating an Oracle Database 11.2.0.4 on-premise database to an Oracle Database Cloud Service (Database as a Service) that provides a pre-created Oracle Database 12.1.0.2 database.
What four migration methods can be used?

• A. conventional export/import
• B. Transportable Tablespace (TTS) with RMAN conversion
• C. Transportable Tablespace (TTS) by using Oracle Data Pump
• D. SQL *Loader
• E. RMAN image restore
• F. Data Pump Transportable Database (TDB) export/import

Answer: BCDF

Explanation:
You load data into an Oracle database on Oracle Database Cloud Service using the same tools you would use for an Oracle database on another system.
* (D) Using SQL*Loader to Load Data into the Database
* Using Oracle Data Pump Import to Load Data into the Database
* (BC) Using Transportable Tablespaces to Load Data into the Database There are two ways to transport a tablespace:
Manually, involving issuing commands to SQL*Plus, RMAN, and Data Pump. Using the Transport Tablespaces Wizard in Enterprise Manager
* Using Pluggable Databases (PDBs) to Load Data into the Database
* Using Oracle Public Cloud Data Transfer Services to Move Large Data Sets
* (F) Full transportable export/import, is available to make migration to Oracle Database 12c faster, easier, and more efficient than ever before. Full transportable export is available starting with Oracle Database 11g Release 2 (11.2.0.3).
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/load-data-db.html https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces013.htm#ADMIN11395 http://www.oracle.com/technetwork/database/enterprise-edition/full-transportable-wp-12c-1973971.pdf

NEW QUESTION 12
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 13
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 14
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.

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_DBC https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-services-page.html

NEW QUESTION 15
Which two situations require that your Database Deployment be scaled up?

• A. The Database Deployment instance is maxed out on semaphore sets.
• B. The database instance has reached the limit in the license_max_sessions database parameter.
• C. The Database Deployment is maxed out on CPU.
• D. The database instance is out of space in the sysaux and system tablespaces.
• E. The Database Deployment is maxed out on storage.
• F. The Database Deployment is maxed out on semaphores.

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

NEW QUESTION 16
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 17
You get complaints from users of several applications that performance has degraded over time. These applications run in this configuration:
There is one database and database instance, which is an Oracle 12c multitenant Container Database (CDB) with five Pluggable Databases (PDBs).
One of the poorly performing applications run in one of the PDBs.
You have the Oracle Resource Manager configured for the CDB only.
Each PDB has all sessions in one consumer group.
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 Deployment in Oracle Cloud.
Which four should you check and possibly reconfigure to avoid the need to scale up the Database Deployment?

• A. Modify the users that are using each application so that their sessions are associated with the correctconsumer group in the PDB that is hosting their application.
• B. Check the CDB plan to configure the shares allocated to all PDBs, including the PDBs that contain the two poorly performing applications.
• C. Check the CDB plan only to configure the shares allocated to the PDBs that contain the two poorly performing applications.
• D. Create separate consumer groups for the sessions for all applications in the PDB plans for the PDBs that are hosting the two poorly performing applications.
• E. Check the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly performing applications.
• F. Create a PDB plan for each PDB in the CDB that has poorly performing applications.
• G. Create a separate CDB plan for each PDB that has poorly performing applications.

Answer: ABDF

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
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 20
You are configuring network connections for your database instance. What does each network group represent?

• A. allows unrestricted communication among some of your Oracle Database Cloud service instances by using a set of defined policies and access rules.
• B. defines load balancing and failover configurations between RAC database instances.
• C. defines network connections to the Pluggable Databases (PDBs) within a Container Database.
• D. manages the connections between your external application servers (application servers that you currently use in your business environment) and your Oracle Database Cloud service instances.

Answer: A

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 21
There are two ways to enable a port to a Database Deployment. The first requires access to the Oracle Compute Cloud Service Console to open the ports to a set of IP addresses. The second is to create a tunnel for port forwarding by using SSH.
Which statement is true about port forwarding by using SSH?

• A. The SSH tunneling the configured SSH process must be running on the consumer side of the tunnel.
• B. The SSH tunneling the configured SSH process must be running on the instance side of the tunnel.
• C. The SSH tunneling to access the Database Deployment database via SQL Developer or SQL*Plus must be configured to port 1522.
• D. The SSH tunneling to access the Database Deployment database via APEX must be configured to port 8080.

Answer: A

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