1Z0-053 무료 덤프문제 온라인 액세스

You execute the following FLASHBACK TABLE command:
SQL> FLASHBACK TABLE emp TO TIMESTAMP TO_TIMESTAMP('2008-01-04 11:00:00','YYYY-MMDD HH24:MI:SS');
Which two statements are correct? (Choose two.)

• A.The changes made to the emp table since the specified time are undone if no constraint is violated during flashback.
• B.The FLASHBACK TABLE statement does not maintain existing indexes on the emp table.
• C.The emp table that was dropped by mistake earlier is restored.
• D.The FLASHBACK TABLE statement is executed as a single transaction.

Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT;
Which activity is performed when the preceding command is executed?

• A.The high-water mark (HWM) for the BOOKING table is shifted from its original position
• B.The shrink operation touches every block in the BOOKING table
• C.The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
• D.The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations.
While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?

• A.Open the database in read-only mode
• B.Open the database with the RESETLOGS option
• C.Open the database in RESTRICTED mode
• D.Open the database in NORMAL mode

Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:
SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?

• A.Server process
• B.System Monitor (SMON)
• C.Checkpoint process (CKPT)
• D.User process
• E.Process Monitor (PMON)

Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)

• A.Optimizer statistics gathering
• B.Automatic SQL Tuning Advisor
• C.SQL Access Advisor
• D.Segment Advisor
• E.Automatic Database Diagnostics Monitor