You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name. What must this name be made up of?

You create a table with the PERIODFOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceeded during execution of a data manipulation language (DML) statement, the operation should abort and return an error. However, queries should still be allowed, even if users have exceeded the undo space limitation. How would you achieve this?

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: – Version: Oracle Database 12c Releases 1 64-bit – Character set: WE8ISO8859P15 – National character set: AL16UTF16 – O/S: Oracle Linux6 64-bit The characteristics of the CDB are as follows: – Version: Oracle Database 12c Release 1 64-bit – Character set: AL32UTF8 – O/S: Oracle Linux 6 64-bit Which technique should you use to m

In your production database, data manipulation language (DML) operations are executed on the SALES table. You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information. What action would you take to achieve this task?

You want to create a database and you have the following: - Oracle Grid Infrastructure is installed and configured. - Oracle Database Vault is installed in ORACLE_HOME to be used for this database. - Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server. Examine the requirements: 1. configuring the database instance to support shared server mode 2. using Automatic Storage Management (ASM) for storing database files. 3. configuring a naming method to help a remo

Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity. Which action generates recommendations to overcome the performance issues?

Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)? (Choose three.)

Which three statements are true about Enterprise Manager Database Express? (Choose three.)

Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback? (Choose three.)

You have the following entry in the tnsnames.ors of your hq.us.example.com host machine: You issue the following command at the command prompt: Sqlplus HR/HR@ORCL Which statement is true about the connection to the ORCL database instance?

Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)

Identify three benefits of Unified Auditing.

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose three.)

Which two statements are true when row archival management is enabled? (Choose two.)