QUESTION NO: 1
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:
Which statement is true about the outcome?
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:
Which statement is true about the outcome?
Correct Answer: B
Vote an answer
QUESTION NO: 2
You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the following statement to create a tablespace, mytbs: CREATE TABLESAPCE mythbs DATAFILE '/u1/data/mytbs.dbf' SIZE 100M; Which two statements are correct regarding the mytbs tablespace? (Choose two)
You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the following statement to create a tablespace, mytbs: CREATE TABLESAPCE mythbs DATAFILE '/u1/data/mytbs.dbf' SIZE 100M; Which two statements are correct regarding the mytbs tablespace? (Choose two)
Correct Answer: D,E
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 3
The EMP table exists in your schema. You want to execute the following query:
SELECT ename, sal
FROM emp
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)
WHERE ename = 'ALLEN';
What are the minimum requirements for the statement to execute successfully? (Choose all that apply)
The EMP table exists in your schema. You want to execute the following query:
SELECT ename, sal
FROM emp
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)
WHERE ename = 'ALLEN';
What are the minimum requirements for the statement to execute successfully? (Choose all that apply)
Correct Answer: A,B
Vote an answer
QUESTION NO: 4
You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation?
You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation?
Correct Answer: C
Vote an answer
QUESTION NO: 5
Which two statements are correct about database transportation? (Choose two.)
Which two statements are correct about database transportation? (Choose two.)
Correct Answer: C,E
Vote an answer
QUESTION NO: 6
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the tablespace in backup mode:
SQL> ALTER TABLESPACE users BEGIN BACKUP;
While copying the file to the backup destination a power outage caused the instance to terminate abnormally.
Which statement is true about the next database startup and the userstablespace?
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the tablespace in backup mode:
SQL> ALTER TABLESPACE users BEGIN BACKUP;
While copying the file to the backup destination a power outage caused the instance to terminate abnormally.
Which statement is true about the next database startup and the userstablespace?
Correct Answer: D
Vote an answer
QUESTION NO: 7
You notice that the performance of the database has degraded because of frequent
checkpoints.
Which two actions resolve the issue?
You notice that the performance of the database has degraded because of frequent
checkpoints.
Which two actions resolve the issue?
Correct Answer: A,D
Vote an answer
QUESTION NO: 8
You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database.
Which two statements are true?
You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database.
Which two statements are true?
Correct Answer: B,D
Vote an answer
QUESTION NO: 9
The DB_BLOCK_CHECKING parameter is set to FULL.
What checks occur each time the DBWnprocess(es) writes?
The DB_BLOCK_CHECKING parameter is set to FULL.
What checks occur each time the DBWnprocess(es) writes?
Correct Answer: A
Vote an answer
QUESTION NO: 10
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?
Correct Answer: B
Vote an answer