QUESTION 41
The warning and critical threshold values have been set to 85% and 97%, respectively, for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50% and critical threshold to be 53% in Database Control. Which statement is true?

A.    The new setting would be applied but no alerts would be raised immediately.
B.    The new setting would be applied and an alert would be raised immediately.
C.    The new setting would be ignored because the tablespace space usage is more than the specified threshold value.
D.    The new setting would cause an error because the tablespace space usage is more than the specified threshold value.

Answer: A

QUESTION 42
You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command:
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
When a backup is performed, what would be the status of this backup after seven days?

A.    The backup would be marked as invalid.
B.    The backup would be marked as obsolete.
C.    The backup would be removed from the media.
D.    The backup would be removed from the RMAN repository.

Answer: B

QUESTION 43
You work as a database administrator at certkiller.com. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEES table. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?

A.    perform point-in-time recovery
B.    perform a Flashback Table operation to restore the table to the state it was in two days ago
C.    perform a Flashback Database operation to restore the database to the state it was in two days ago
D.    perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery

Answer: D

QUESTION 44
When performing a backup using Recovery Manager (RMAN), which four types of files can be backed up with the RMAN BACKUP command? (Choose four.)

A.    data file
B.    password file
C.    archivelog file
D.    temporary file
E.    online redo log file
F.    the current control file
G.    the tnsnames.ora file
H.    current server parameter file

Answer: ACFH

QUESTION 45
You were recently hired by certkiller.com as a database administrator. You are asked to find out whether the currently functional listener process, named L1, has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task?

A.    by using the STATUS command of the Listener control utility
B.    by using the STATUS L1 command of the Listener control utility
C.    by using the SHOW RULES command of the Listener control utility
D.    by using the SET PASSWORD command of the Listener control utility
E.    by searching for the PASSWORD_LISTENER entry in the listener.ora file

Answer: B

QUESTION 46
These are the details about V$FLASHBACK_DATABASE_STAT:
SQL> DESC v$FLASHBACK_DATABASE_STAT
Name Null? Type
————- ——– ————–
BEGIN_TIME DATE
END_TIME DATE
FLASHBACK_DATA NUMBER
DB_DATA NUMBER
REDO_DATA NUMBER
ESTIMATED_FLASHBACK_SIZE NUMBER
Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true? (Choose two.)

A.    BEGIN_TIME is the time at which Flashback logging is enabled.
B.    END_TIME is the time at which the query is executed on the view.
C.    REDO_DATA is the number of bytes of redo data written during the interval.
D.    This view contains information about flashback data pertaining to the last 24 hours.
E.    FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

Answer: CD

QUESTION 47
You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided, which approach would you take to solve the problem?

A.    flash back the database
B.    import the temporary tablespace from the last export
C.    restore all the data files and temporary files from the last full database backup and perform a recovery
D.    Do not perform a recovery, but create a new temporary tablespace, make it the default temporary tablespace and then drop the old tablespace

Answer: D

QUESTION 48
Which two statements are correct regarding the Oracle Flashback Drop feature? (Choose two.)

A.    Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.
B.    You can flash back a dropped table provided row movement has been enabled on the table.
C.    If you drop an index before dropping its associated table, then the recovery of the index is not supported when you flash back the dropped table.
D.    When you execute the DROP TABLESPACE ? INCLUDING CONTENTS command, the objects in the tablespace are places in the recycle bin.
E.    When a dropped table is moved to the recycle bin, only the table is renamed to a system-generated name; its associated objects and constraints are not renamed.
F.    If you drop a table that is protected by the recycle bin, then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.

Answer: AC

QUESTION 49
You want to create a consumer group,GROUP1, and you execute the following command in the command-line interface:
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP
(CONSUMER_GROUP =>’group1′, COMMENT => ‘New Group’);
This command errors out displaying the following message:
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at .SYS.DBMS_RMIN., line 115
ORA-06512: at SYS.DBMS_RESOURCE_MANAGER., line 108
ORA-06512: at line 1
What action would you take to overcome this error?

A.    grant SYSDBA to the user
B.    grant SYSOPER to the user
C.    grant the RESOURCE role to the user
D.    use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use
E.    grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package

Answer: E

QUESTION 50
You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes? (Choose two.)

A.    ONLINE
B.    REVERSE
C.    PARALLEL
D.    COMPRESS
E.    NOLOGGING
F.    COMPUTE STATISTICS

Answer: CE

Get Passleader New Update Oracle 1Z0-043 Test Questions With Low Cost