Exam information

Exam 1z0-043: Database 10g: Administration II (October 26th, 2014)

Other exams

Which advisory component would you refer to, in order to determine that required size of the database buffer cache?

You observe that a database performance has degraded over a period of time. Whileinvestigating the reason, you find that the size of the database buffer cache is not largeenough to cache all the needed data blocks. Which advisory component would you refer to,in order to determine that required […]

What action would you take to minimize the waits?

ExhibitIn your production database, the total waits and the time waited for log file parallel write aresignificantly high. While investigating the reason, you find that there are three redo loggroups with two members in each group, and all redo log members are places on a singlephysical disk. […]


you need to perform after re-creating the control file and opening the database?

One of the tablespaces is read-only in your database. The loss of all control files forced youto re-create the control file. Which operation do you need to perform after re-creating thecontrol file and opening the database?

Which two statements are correct?

You have set some of the initialization parameters as:DB_BLOCK_SIZE = 8KBSGA_MAX_SIZE = 2GBSGA_TARGET = 0SHARED_POOL_SIZE = 120MBDB_CACHE_SIZE = 896MBSTREAM_POOL_SIZE = 0LARGE_POOL_SIZE = 110 MBWhich two statements are correct? (Choose two.)

Which two statements are correct?

You have set some of the initialization parameters as:DB_BLOCK_SIZE = 8KBSGA_MAX_SIZE = 2GBSGA_TARGET = 0SHARED_POOL_SIZE = 120MBDB_CACHE_SIZE = 896MBSTREAM_POOL_SIZE = 0LARGE_POOL_SIZE = 110 MBWhich two statements are correct? (Choose two.)

Which two statements are correct in this scenario?

You are performing a block media recovery on the tools01.dbf data file in the SALESdatabase using RMAN. Which two statements are correct in this scenario? (Choose two.)

Which type of backup would this command perform?

ExhibitYou executed the following command to perform a backup of the USERS tablespace:RMAN > BACKUP TABLESPACE USERS;Which type of backup would this command perform?

How would you recover the lost redo log member?

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

Which statement regarding an incomplete recovery is true?

You are using Oracle Database 10g. Which statement regarding an incomplete recovery istrue?

Which two effects would be the result of this setting?

ExhibitView the Exhibit and examine the Resource Manager settings for the groups at differentlevels. Which two effects would be the result of this setting? (Choose two.)

Page 1 of 2212345...1020...Last »