You use a recovery catalog for maintaining your database backups. You execute the following command: $rman TARGET / CATALOG rman / cat@catdb RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL; Which two statements are true? (Choose two.)

Your database is in ARCHIVELOG mode. You want to disable archiving for the database. Examine these steps: 1. Execute the ALTER DATABASE NOARCHIVELOG command 2. Execute SHUTDOWN IMMEDIATE 3. Execute STARTUP MOUNT 4. Set the DB_RECOVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/ 5. Execute STARTUP NOMOUNT 6. Open the database 7. Execute SHUTDOWN TRANSACTIONAL Identify the required steps in the correct sequence.

A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the following: 1. The user account must be locked after five unsuccessful login attempts. 2. Data read per session must be limited for the user. 3. The user cannot have more than three simultaneous sessions. 4. The user must have a maximum minutes session idle time before being logged off automatically. How would you accomplish this?

An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?

Which three statements are true about adaptive SQL plan management? (Choose three.)

Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. Which two statements are true? (Choose two.)

You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause. What are two effects of not using the "ENABLE PLUGGABLE database" clause?

Identify two correct statements about multitenant architectures.

In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?

Which statement is true regarding the startup of a database instance?

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source): Which three are prerequisites for successful execution of the command? (Choose three.)

The HR user receives the following error while inserting data into the sales table: On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it. Which two methods would you use to resolve this error? (Choose two.)

The ORCL database is configured to support shared server mode. You want to ensure that a user connecting remotely to the database instance has a one-to-one ratio between client and server processes. Which connection method guarantees that this requirement is met?

You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB). The following are the possible steps to accomplish this task: 1. Place all the user-defined tablespace in read-only mode on the source database. 2. Upgrade the source database to a 12c version. 3. Create a new PDB in the target container database. 4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility. 5. Copy the asso

Which two are true concerning a multitenant container database with three pluggable database? (Choose two.)

Which Oracle Database component is audited by default if the unified Auditing option is enabled?