You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario? (Choose two.)

• A.The database must have multiplexed redo logs for the flashback to succeed.
• B.The database must be MOUNTED for the flashback to succeed.
• C.The database must use block change tracking for the flashback to succeed.
• D.The database must be opened in restricted mode for the flashback to succeed.
• E.The database must be opened with the RESETLOGS option after the flashback is complete.
• F.The database must be opened in read-only mode to check if the database has been flashed back to
  the correct SCN.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)?

• A.It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis.
• B.Its results are stored in AWR.
• C.It provides recommendations only for poorly performing SQL statements.
• D.It requires at least one Automatic Workload Repository (AWR) snapshot for analysis.
• E.It calls SQL advisors automatically if required.

Comment: *

Name: *

Email: *

Verification: *

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 isavailable 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 methodto help a remote user connect to a database instance
4 . configuring the Fast Recovery Area
5 . configuring Database Vault
6 . configuring Enterprise Manager (EM) Database Express
7 . registering with EM Cloud Control
8 . configuring remote log archive destinations
9 . enabling daily incremental backups
1 0. configuring a nondefault block size for nondefault block size tablespaces
Which of these requirements can be met while creating a database by using the Database
Configuration Assistant (DBCA)?

• A.1, 2, 3, 4, 6, 8, 9 and 10
• B.1, 2, 4, 5, 6 and 7
• C.1, 2, 4, 5, 6, 7 and 8
• D.1, 2, 4, 5,7, 8, 9 and 10
• E.1, 2, 3, 8, 9 and 10

Comment: *

Name: *

Email: *

Verification: *

Your database instance has started using an SPFILE.
Examine the RMAN configuration settings:

You execute the command:
RMAN> BACKUP AS COPY TABLESPACE TEST;
Which three types of files are backed up by using this command?

• A.online redo log files
• B.control file
• C.SPFILE
• D.archived redo log files
• E.data file(s)
• F.PFILE

Comment: *

Name: *

Email: *

Verification: *

In your Oracle 12c database, you plan to execute the command:
SQL> CREATE TABLESPACE tbs1 DATAFILE '/u02/oracle/data/tbs01.dbf' SIZE 50M;
The u02 file system has 1 GB of free space available.
What is the outcome?

• A.It creates a locally managed tablespace with manual segment space
  managementenabled.
• B.It raises an error because extent management is not specified.
• C.It creates a locally managed tablespace with automatic segment space management enabled.
• D.It creates a dictionary-managed tablespace with manual segment space management enabled.

Comment: *

Name: *

Email: *

Verification: *