1z0-043 Oracle - Braindumps.com.ua: question list for "Oracle Database 10g: Administration II", page: 1

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1z0-043: Oracle Database 10g: Administration II

#1. You observe that a database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.
Which advisory component would you refer to, in order to determine that required size of the database buffer cache?

#2. Exhibit

In your production database, the total waits and the time waited for log file parallel write are significantly high. While investigating the reason, you find that there are three redo log groups with two members in each group, and all redo log members are places on a single physical disk.
What action would you take to minimize the waits?

#3. One of the tablespace is read-only in your database. The loss of all control files forced you to recreate the control file.
Which operation do you need to perform after re-creating the control file and opening the database?

#4. You have set some of the initialization parameters as:

 DB_BLOCK_SIZE = 8KB 
 SGA_MAX_SIZE = 2GB 
 SGA_TARGET = 0 
 SHARED_POOL_SIZE = 120MB 
 DB_CACHE_SIZE = 896MB 
 STREAM_POOL_SIZE = 0 
 LARGE_POOL_SIZE = 110 MB

Which two statements are correct? (Choose two.) You cannot set a value for the DB_8K_CACHE_SIZE parameter.

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

#6. Exhibit

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?

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

#8. You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?

#9. Exhibit

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.)

#10. The current time zone for one of the user sessions is set to the database local time zone. For one application, the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions.
Which two solutions could the user implement to achieve this objective? (Choose two.)

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [18]

gen. 0.134

Server date 02:36 10-01-2009

Oracle 1z0-043

Forum

Start online exam simulation

Master braindump

User braindumps