NEW QUESTION 1
Which two are prerequisites for performing Flashback Transaction? (Choose two.)

• A. A supplemental log must be enabled for the primary key.
• B. Undo retention guarantee must be configured for the database.
• C. Fast Recovery Area must be enabled for the database.
• D. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
• E. Row movement must be enabled.

Answer: AD

NEW QUESTION 2
Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

• A. The PDB is closed and the temp file is re-created automatically when the PDB is opened.
• B. The PDB is closed and requires media recovery at the PDB level.
• C. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.
• D. The PDB does not close and starts by using the default temporary tablespace defined for the CDB.

Answer: C

NEW QUESTION 3
Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)? (Choose three.)

• A. A PDB opened in restricted mode allows only local users to connect.
• B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
• C. When a CDB is in MOUNT state, PDBs are automatically placed in MOUNT state.
• D. All PDBs must be shut down before shutting down a CDB instance.
• E. When a CDB instance is started, PDBs can be placed in OPEN state by using database triggers or by executing the ALTER PLUGGABLE DATABASE command.

Answer: BCE

NEW QUESTION 4
Which two statements are true about a multitenant architecture? (Choose two.)

• A. Each pluggable database (PDB) has its own initialization parameter file.
• B. A PDB can have a private undo tablespace.
• C. Log switches occur only at the container database level.
• D. A PDB can have a private temporary tablespace.
• E. Each PDB has a private control file.

Answer: CD

NEW QUESTION 5
Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode? (Choose two.)

• A. online redo log files while the database is open
• B. data files while the database is open
• C. PFILE and password file in MOUNT state
• D. data blocks in data files that have changed since the previous backup
• E. data files while the database is in NOMOUNT state

Answer: BD

NEW QUESTION 6
Your database is running in ARCHIVELOG mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.
Examine the steps to recover the online redo log group and move it to a new location.
1. Restore the corrupted redo log group.
2. Restore the database from the most recent database backup.
3. Perform an incomplete recovery.
4. Relocate the member of the damaged online redo log group to a new location.
5. Open the database with the RESETLOGS option.
6. Issue a checkpoint and clear the log. Identify the required steps in the correct order.

• A. 1, 3, 4, 5
• B. 6, 3, 4, 5
• C. 2, 3, 4, 5
• D. 6, 4, 3, 5

Answer: C

NEW QUESTION 7
A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.
Which table organization allows for generating the bills with minimum degree of row sorting?

• A. a hash cluster
• B. an index cluster
• C. a partitioned table
• D. a sorted hash cluster
• E. a heap table with a rowid column

Answer: D

NEW QUESTION 8
Which two statements are true about unified auditing? (Choose two.)

• A. A unified audit trail captures audit information from unified audit policies and audit settings.
• B. Unified auditing is enabled by executing make –f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME.
• C. Audit records are created for all users except sys.
• D. Audit records are created only for the DML and DDL operations performed on database objects.
• E. Unified auditing is enabled by setting the audit_trail parameter to db, extended.
• F. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.

Answer: AB

NEW QUESTION 9
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time FROM v$rsrc_consumer_group;

Which two statements are true? (Choose two.)

• A. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
• B. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
• C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
• D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
• E. A user belonging to the DSS_QUERIES resource consumer group can create a new session but the session will be queued.

Answer: CE

NEW QUESTION 10
You execute the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT ‘/disk1/%U; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT ‘/disk2/%U; RMAN> BACKUP DATABASE;
Which statement is true about the backup set created by the BACKUP command?

• A. The default channel is allocated and the backup set is created in only one destination.
• B. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations.
• C. Two channels are allocated and two copies of the backup set are taken in parallel in both locations.
• D. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2.

Answer: B

NEW QUESTION 11
You are administering a multitenant container database (CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode. (Choose two.)

• A. by using the CONNECT statement as a local user having only the SET CONTAINER privilege
• B. by using easy connect
• C. by using external authentication
• D. as a common user with the SET CONTAINER privilege
• E. by executing the ALTER SESSION SET CONTAINER command as a local user

Answer: BD

NEW QUESTION 12
While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.
Which two actions would you take for tape streaming to happen during the backup? (Choose two.)

• A. Configure backup optimization.
• B. Configure the channel to increase maxopenfiles.
• C. Configure a backup policy by using incremental backups.
• D. Configure the channel to increase capacity with the rate parameter.
• E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.
• F. Configure large_pool, if not done alread
• G. Alternatively, you can increase the size of large_pool.

Answer: BE

NEW QUESTION 13
Which three statements are true about persistent lightweight jobs? (Choose three.)

• A. A user cannot set privileges on them.
• B. They generate large amounts of metadata.
• C. They may be created as fully self-contained jobs.
• D. They must reference an existing Scheduler Program.
• E. They are useful when users need to create a large number of jobs quickly.

Answer: ADE

NEW QUESTION 14
You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:

What is a prerequisite for the successful execution of this command?

• A. The target database must be in MOUNT state.
• B. RMAN must be connected to the target database instance and the auxiliary instance.
• C. A most recent backup set of the PROD database must exist.
• D. Flashback must be enabled for the PROD database.

Answer: B

Explanation: Assume that the source database prod is on host1 and stores its data files in a non-ASM file system. The control files for prod are located in /oracle/oradata/prod/.
You want to duplicate the source database to database dupdb on remote host host2. You want to store the duplicate database files in ASM disk group +DISK1.
After connecting RMAN to the target, duplicate, and recovery catalog databases, run the following RMAN script to duplicate the database.
DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE
SPFILE
PARAMETER_VALUE_CONVERT '/oracle/oradata/prod/', '+DISK1' SET DB_CREATE_FILE_DEST +DISK1;
When the DUPLICATE command completes, the duplicate database is created, with data files, online redo log files, and control files in ASM disk group +DISK1.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2021), page 26-7

NEW QUESTION 15
You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this? (Choose two.)

• A. ALTER TABLESPACE adtbs RESI2E 20G;
• B. ALTER TABLESPACE adtbs ADD DATAFILE;
• C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
• D. ALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
• E. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

Answer: AC

Explanation: http://www.techonthenet.com/oracle/tablespaces/alter_tablespace.php

NEW QUESTION 16
You are administering a multitenant container database (CDB) that contains two pluggable databases (PDBs), PDB1 and PDB2. You are connected to PDB2 as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB modifiable. As the user SYS, execute the following command on PDB2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?

• A. The STATISTICS_LEVEL parameter is set to ALL when any of the PDBs is reopened.
• B. The STATISTICS_LEVEL parameter is set to ALL only for PDB2 when it is reopened.
• C. The STATISTICS_LEVEL parameter is set to ALL when the root database is restarted.
• D. The statement is ignored because there is no SPFILE for a PDB.

Answer: B

NEW QUESTION 17
Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);
5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;
6. ALTER TABLE customer FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?

• A. 1, 2, 5
• B. 1, 3, 6
• C. 2, 3, 5, 6
• D. 3, 4, 5

Answer: A

NEW QUESTION 18
You execute the command to recover your database:

Which statement is true?

• A. It restores all data files from the specified time, and then applies the redo logs.
• B. It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time.
• C. It restores all data files and control files from the most recent backup taken before the “until time”, and then recovers up to the “until time” using any restored archive logs that are needed to complete the task.
• D. It restores the control file and all data files from the most recent backups, and then applies the redo logs up to the “until time”.

Answer: C

Explanation: UNTIL TIME = 'date_string' specifies a time as an upper limit. RMAN selects only files that can be used to restore and recover up to but not including the specified time.
RMAN can perform recovery of the whole database to a specified past time, SCN, or log sequence number. This type of recovery is sometimes called incomplete recovery because it does not completely use all of the available redo. Incomplete recovery of the whole database is also called database point-in-time recovery (DBPITR).
DBPITR requires restoring your database from an older backup, then performing media recovery until your specified target time, SCN or log sequence number. Note that because you need your archived redo log files to perform this process, you cannot perform database point-in-time recovery if you have been running your database in NOARCHIVELOG mode.
References: https://docs.oracle.com/cd/B13789_01/server.101/b10734/rcmrecov.htm

NEW QUESTION 19
In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed? (Choose three.)

• A. Undo retention guarantee must be enabled.
• B. No other table with the same name should exist in the HR schema.
• C. SCOTT should have the FLASHBACK ANY TABLE privilege.
• D. SCOTT should have the SELECT privilege on the HR schema and its recyclebin.
• E. No duplicates of the HR.EMPLOYEES table should exist in the recyclebin of the HR schema.
• F. The recycle bin should be enabled.

Answer: BCF