1Z0-053 Oracle Database 11g Administration II (Exam 50)

Questions
Reviews

You are required to perform the following tasks to configure Flashback Database:Op...
You are required to perform the following tasks to configure Flashback Database:
1. Open the database in MOUNT EXCLUSIVE mode.
2. Ensure that the database is in ARCHIVELOG mode.
3. Configure the flash recovery area.
4. Issue the ALTER DATABASE FLASHBACK ON; statement.
5. Set the DB_FLASHBACK_RETENTION_TARGET parameter.
  Which option identifies the correct sequence in which these steps should be performed to enable Flashback
  Database?
2, 3, 5, 1, and 4

2, 5, 3, 4, and 1

2, 4, 1, 3, and 5

5, 2, 3, 4, and 1
You are required to configure the Flashback Database feature.Which condition shoul...

You are required to configure the Flashback Database feature.
Which condition should be fulfilled to configure the Flashback Database feature?

The database must be in ARCHIVELOG mode.

The undo tablespace should be large enough to support Flashback operations.

The database must be in NOARCHIVELOG mode.

The database must be open in MOUNT mode.
You have enabled flashback data archiving for a table.Which statements can you NOT...

You have enabled flashback data archiving for a table.
Which statements can you NOT use on the table without generating an error? (Choose all that apply.)

ALTER TABLE

TRUNCATE TABLE

DROP TABLE

RENAME TABLE
You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema ...

You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema was deleted by
mistake. You decide to flash the database back to the time when the schema existed.
Which view should you query to determine the estimated size of the flashback data that you require for your
current target retention?

V$FLASHBACK_DATABASE_LOG

V$RECOVERY_FILE_DEST

V$FLASHBACK_DATABASE_STAT

V$DATABASE
You are required to flash back your database. You want to determine the amount of ...

You are required to flash back your database. You want to determine the amount of flashback data generated
since the database was opened.
Which task should you perform to obtain the required information?

Query the V$FLASHBACK_DATABASE_LOG view.

Query the V$RECOVERY_FILE_DEST view.

Query the V$FLASHBACK_DATABASE_STAT view.

Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
At the end of the financial year, an accounts accumulation batch update job is run...

At the end of the financial year, an accounts accumulation batch update job is run to update the company's
accounting records. During the batch run process, some incorrect entries were inserted into the ACCOUNT
table. You identified the bug and immediately stopped the batch run process, but 3,000 incorrect records were
inserted into the ACCOUNT table before the batch process was stopped. You want to recover the table to the
state it was in at 11:50 P.M.
Which flashback feature should you use?

Flashback Table

Flashback Version Query

Flashback Database

Flashback Version Query

Flashback Drop
You issue the following statement:FLASHBACK TABLE scott.emp TO TIMESTAMP SYSTIMEST...

You issue the following statement:
FLASHBACK TABLE scott.emp TO TIMESTAMP SYSTIMESTAMP - INTERVAL '15' MINUTE;
In which two scenarios would you issue this statement? (Choose two.)

when the schema of the user SCOTT was deleted by mistake 15 minutes ago

never, because FLASHBACK TABLE is not a valid statement

when some incorrect values were inserted in the EMP table in the user SCOTT's schema during the last 15
minutes

when the EMP table of the user SCOTT's schema was dropped by mistake 15 minutes ago

when some rows of the EMP table in the SCOTT schema were deleted by mistake 15 minutes ago
You query DBA_FLASHBACK_ARCHIVE using the following statement:SELECT flashback_arc...

You query DBA_FLASHBACK_ARCHIVE using the following statement:
SELECT flashback_archive_name, status FROM DBA_FLASHBACK_ARCHIVE;
The output indicates that you have created two flashback data archives, FLA1 and FLA2. FLA1 has a STATUS
value of DEFAULT, and FLA2 has a null STATUS.
You want to drop the FLA1 flashback data archive.
Which statement is true?

If you drop FLA1, historical data will remain in the tablespace until you manually purge it.

You cannot drop FLA1 because it is the default flashback data archive.

If you drop FLA1, any historical data archived will be lost.

You cannot drop FLA1 if data has been archived to it.
You use the FLASHBACK TABLE statement to flash back the EMP table in your database...

You use the FLASHBACK TABLE statement to flash back the EMP table in your database.
Which task is performed as a result of issuing the FLASHBACK TABLE statement?

A shared DML lock is acquired on the EMP table.

The existing indexes on the EMP table will be maintained.

The statistics of the EMP table are flashed back.

The flashback operation will be written to the trace file.
You issued the following statement:FLASHBACK TABLE employee TO SCN 567547 ENABLE T...

You issued the following statement:
FLASHBACK TABLE employee TO SCN 567547 ENABLE TRIGGERS; The current SCN number of the
database is 567987.
Which statement is NOT an impact of issuing this statement?

The EMPLOYEE table is flashed back to SCN number 567547.

The triggers on the EMPLOYEE table are disabled during the operation and changed back to the enabled
state after completion of the flashback operation.

The statement acquires DML locks on all the tables during the flashback operation.

A record of issuing the statement is written in the alert log file.
Which two statements are true about a Flashback Table operation? (Choose two.)

Which two statements are true about a Flashback Table operation? (Choose two.)

A Flashback Table operation cannot be performed on fixed tables.

If a constraint is violated during a Flashback Table operation, the table will be flashed back, but a message
will be written to the alert log file.

Row movement should be disabled before performing a Flashback Table operation.

The Flashback Table operation shrinks segments that correspond to the table that is being flashed back.

Flashback Table uses LogMiner to determine the earlier state of the table.
Observe the following sequence of events:A user in your database performs an erron...

Observe the following sequence of events:
A user in your database performs an erroneous update of data in the EMP table at 7:10 P.M.
You find out about this at 8:00 P.M.
You flash back the EMP table to its state at 7:05 P.M.
At 8:30 P.M., you find out that the EMP table must be recovered to its state at 7:30 P.M.
What should you do to recover the table using minimum administrative effort?

Roll back the earlier flashback operation, and perform another flashback operation on the table.

Perform an incomplete recovery to recover the database to its state at 7:30 P.M.

Flash back the database to its state at 7:30 P.M.

Flash back the EMP table to its state at 7:30 P.M.
You have created two jobs, JOBA and JOBB, which are both assigned to the same job ...

You have created two jobs, JOBA and JOBB, which are both assigned to the same job class and are scheduled
with the same start time. You need to prioritize these jobs so that JOBB begins first.
Which action should you take?

Modify the jobs to be assigned to different job classes.

Set the job_priority attribute of JOBB to a value lower than the job_priority attribute of JOBA.

Associate each job with a different resource consumer group and allocate more resources to the resource
consumer group associated with JOBB.

Set the job_priority attribute of JOBA to a value lower than the job_priority attribute of JOBB.
Which statements about job classes are true? (Choose all that apply.)

Which statements about job classes are true? (Choose all that apply.)

Job classes can be used to assign the same job attributes to multiple jobs.

All jobs that are not explicitly associated with a job class are associated with the default job class.

To create job classes, no special privilege is required.

All job classes belong to the SYS schema.
Which Scheduler object should you use to automatically switch between the two reso...

Which Scheduler object should you use to automatically switch between the two resource plans?

a window

a window group

a program

a job class
Which component is NOT used by the Scheduler for prioritizing jobs?

Which component is NOT used by the Scheduler for prioritizing jobs?

a resource consumer group

a PL/SQL procedure

a window

a resource plan

a job class

a window group
Which statements about windows are NOT true? (Choose all that apply.)

Which statements about windows are NOT true? (Choose all that apply.)

A job running within a window is allocated resources based solely on the resource plan associated with the
window.

When you create a window, you must specify a unique window name.

A window can be used to specify that a job should start, but not to change the resources allocated.

When you create a window, you must specify the job to which it should be associated.

At any given time, a maximum of three windows can be open at a given time.
You want to create a lightweight job. You execute the code shown in the exhibit. (...

You want to create a lightweight job. You execute the code shown in the exhibit. (Click the Exhibit(s) button.)
What is the result?

A single lightweight job is created from the PROG1 template that will run at regular intervals.

An error occurs because you must specify a value for the REPEAT_INTERVAL argument.

An array of lightweight jobs is created from the PROG1 template.

An error occurs because you specified an invalid value for the JOB_STYLE argument.
You create a job chain object using the CREATE_CHAIN procedure. You want to define...

You create a job chain object using the CREATE_CHAIN procedure. You want to define chain steps to run
three programs. If the third program executes successfully, you want to run a fourth program.
Which statement is true in this scenario?

You can accomplish this, but only if all jobs in the chain are time-based.

You cannot accomplish this because a job chain can have only one dependency.

You can accomplish this by defining a chain rule.

You cannot accomplish this because a job chain cannot contain steps that include nested jobs.
Which statements about persistent lightweight jobs are true? (Choose all that apply.)

Which statements about persistent lightweight jobs are true? (Choose all that apply.)

A persistent lightweight job generates minimum redo when the job starts.

A persistent lightweight job generates excessive redo when the job starts.

Persistent lightweight jobs can be created directly through EM without using a template.

Persistent lightweight jobs must be created using a template created with the CREATE_PROGRAM
procedure.

Oct. 26, 2018

review by Siyi He (@maofer)

Take this Quiz

Quiz Info
Feb. 8, 2016, 4:24 a.m.

20 questions

16 completed

88 views

4 takers

ORACLE

Database

1Z0-053 Oracle Database 11g Administration II (Exam 50) QR code

Ratings

ratings