Exam information

Exam 1z0-043: Database 10g: Administration II (update June 13th, 2013)

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. While investigatingthe reason, you find that the size of the database buffer cache is not large enough to cache all theneeded data blocks. Which advisory component would you refer to, in order to determine thatrequired […]

What action would you take to minimize the waits?

In 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 log groups withtwo members in each group, and all redo log members are places on a single physical 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 you to re-create the control file. Which operation do you need to perform after re-creating the control file andopening 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 in this scenario?

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

Which type of backup would this command perform?

You 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 is lostdue 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 is true?

Which two effects would be the result of this setting?

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

Which two solutions could the user implement to achieve this objective?

The current time zone for one of the user sessions is set to the database local time zone. For oneapplication, the user session requires the time zone to be set to the local operating system timezone without affecting other user sessions. Which two solutions could the user implement toachieve […]

Page 1 of 1912345...10...Last »