QUESTION 21
You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace: RMAN> BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully? (Choose all that apply.)

A.    The database is in NOMOUNT state.
B.    The database is in NOARCHIVELOG mode and the tablespace is online.
C.    The database is in NOARCHIVELOG mode and the tablespace is offline.
D.    The database is in ARCHIVELOG mode and the tablespace is offline.
E.    The database is in ARCHIVELOG mode and the tablespace is online.

Answer: CDE

QUESTION 22
Identify four uses of the Oracle Scheduler. (Choose four.)

A.    enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment
B.    enables Oracle database to do patches according to a DBA-defined schedule
C.    enables you to schedule the execution of jobs based on time
D.    enables you to execute jobs in a clustered environment
E.    enables you to periodically execute operating systemscript files located on the same server as the database
F.    enables you to create a job that makes use of saved programs and schedules
G.    enables you to automate the management of the jobs that are created using the DBMS_JOB package

Answer: CDEF

QUESTION 23
In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure? How would you recover the lost redo log member?

A.    import the database from the last export
B.    restore all the members in the group from the last backup
C.    drop the lost member from the database and then add a new member to the group
D.    restore all the database files from the backup and then perform a complete recovery
E.    restore all the database files from the backup and then perform an incomplete recovery

Answer: C

QUESTION 24
Your business has departmental reports that are generated every day. Each department must use the same set of queries, but access a different subset of data in the tables, depending on which department generates the report. The format of the reports is being developed; currently, the format changes daily. How would you configure the database to ensure that each department generates its report (based on its target data) using the most recent report format every day?

A.    By having each user run the report generation procedure at the scheduled time, supplying the necessary input variables.
B.    By creating a program using DBMS_JOB that accepts one or more variables, and creating a job that calls this program using DBMS_JOB.
C.    By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.
D.    By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.
E.    By creating a program using DBMS_SCHEDULER that accepts one or more variables, and creating a job that calls this program using DBMS_SCHEDULER.

Answer: E

QUESTION 25
You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider?

A.    take data files from the read-only tablespace offline before performing a recovery
B.    recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the database
C.    drop the read-only tablespace and re-create the tablespace after recovery
D.    perform a recovery; status of the tablespace in control file will be changed automatically

Answer: A

QUESTION 26
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? (Choose three.)

A.    log writer
B.    archival
C.    process monitor
D.    system monitor
E.    change tracking writer
F.    database writer

Answer: ABF

QUESTION 27
You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?

A.    loss of one of the tablespaces
B.    loss of a system data file
C.    loss of one of the control files
D.    loss of a tempfile
E.    loss of the only member of an unarchived redo log group
F.    loss of a member from each redo log group

Answer: E

QUESTION 28
A redo log file is corrupted while the database is open; as a consequence, database operations are stopped because archiving cannot continue. What would you do to solve the problem?

A.    clear the redo log group
B.    perform redo log file import
C.    perform an incomplete recovery
D.    perform a redo log recovery using Recovery Manager (RMAN)
E.    shut down the database and open the database in the NOARCHIVELOG mode

Answer: A

QUESTION 29
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command:
SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE – 5/24);
Which two statements are true? (Choose two.)

A.    SYSDATE should not be used with TIMESTAMP.
B.    The database must have multiplexed redo log files.
C.    The database must be in the MOUNT state to execute the command.
D.    The database must be opened with the RESETLOGS option after the flashback operation.
E.    The entire database needs to be restored from the most recent backup before the flashback operation.

Answer: CD

QUESTION 30
You work as a database administrator at certkiller.com. In your test database, you find that a user’s session is executing a lot of SQL statements, resulting in the generation of a large number of trace files. While investigating the reason, you find that SQL trace has been enabled at the instance level. You want to disable SQL trace, remotely, only for that user session to reduce the volume of trace data being generated. How do you achieve this objective?

A.    by setting the SQL_TRACE parameter to FALSE in the parameter file
B.    by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
C.    by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
D.    by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session

Answer: B

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