Online Access Free 1Z1-052 Practice Test

Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance?

• A.The sessions are not affected and continue to function normally
• B.The sessions are not allowed to perform any operations till the listener is started
• C.The sessions are able to perform only queries
• D.The sessions are terminated and the active transactions are rolled back

The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:
1 . Shut down the instance, if not already done.
2 . Copy one of the remaining control files to a new location.
3 . Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4. Start up the database instance to the NOMOUNT stage.
5. Recover the database to the point of failure of the control file.
6. Open the database.
Identify the correct sequence of steps?
Exhibit:

• A.2, 4, 3, 5, 6; 1 not required
• B.4, 5, 6, 2, 3; 1 not required
• C.1, 2, 4, 3, 5, 6
• D.5, 2, 3, 4; 1 and 6 not required

Which two events always cause the LGWR to write? (Choose two.)

• A.when a log switch occurs
• B.when DBWn writes dirty buffers
• C.when a checkpoint occurs
• D.when LGWR is notified by a server process that performs a COMMIT OR ROLLBACK
• E.when PMON restarts a server process

In which of the scenario will the DBA perform recovery? (Choose all that apply.)

• A.The hard disk on which the data files is stored is corrupted
• B.The alert log file is corrupted
• C.A tablespace is accidentally dropped
• D.One of the redo log members is corrupted
• E.A database user terminates the session abnormally

Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?

• A.The smallest amount of a bitmap that can be locked is a bitmap segment
• B.The DML operations re-create the bitmap index blocks
• C.Additional time is taken to remove NULL values from the bitmap index after a DML operation
• D.The bitmap index is rebuilt automatically after a DML operation