1z0-042 Oracle - Braindumps.com.ua: question list for "Oracle Database 10g: Administration I", page: 4

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

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-042: Oracle Database 10g: Administration I

#31. You work as a database administrator for Company.com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.
Which advisory component would you refer to, in order to determine the appropriate indexes?

#32. You work as a database administrator for Company.com. In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2.
What would this setting achieve?

#33. You work as a database administrator for Company.com. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further?

#34. You work as a database administrator for Company.com. users in the prod database complain about the slow response when accessing the database. in the active session waiting: configuration page you find that the majority of the wait time is for the redo log buffer. Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks, and that the disk I/O for the redo log files is the reason for the performance degradation.
Which two actions would you take to gain performance? Choose two

#35. Your boss at Company.com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?

#36. You work as a database administrator for Company.com. In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario? Choose two

#37. You work as a database administrator for Company.com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database.
Which method would you use to recover the data file?

#38. You work as a database administrator for Company.com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.
How would you do this? Select two.

#39. you work as a database administrator for Company.com. you are using three database, db01, db02, and db03, on different host machines in your development environment. the database server configuration, such as ip address and listener port number, change frequently due to development requirements, and you have the task of notifying the developers of the changes. Which connection method would you use to overcome this overhead?

#40. Exhibit :

You work as a database administrator for Company.com. While creating a new user or changing the password for existing users, the password must adhere to the restrictions specified in the exhibit.
Which option would you use to achieve this objective?

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

gen. 0.06

Server date 06:43 02-12-2008

Oracle 1z0-042

Forum

Start online exam simulation

Master braindump

User braindumps