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

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

#21. Exhibit :

Which statement regarding the dept and emp tables are true?

#22. You work as a database administrator for Company.com. Users in the Company.com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero.
What would you do to overcome this problem?

#23. You are working on a test database where instance recovery takes a considerable amount of time. How can reduce the recovery time? Choose two.

#24. Exhibit #1

Exhibit #2, command

Exhibit #3, error

You work as a database administrator for Company.com. You have created a database link, devdb.uk.oracle.com, between the database PRODDB and DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from the development database, DEVDB, to the production database, PRODDB.
View Exhibit #1 to see the source and target database.l
You execute the code in Exhibit #2.
The code fails and produces the error displayed in Exhibit #3.
What would you do to overcome the error?

#25. You work as a database administrator for Company.com. The database is open. A media failure has occurred, resulting in loss of all the control files in your database.
Which statement regarding the database instance is true in this scenario?

#26. You work as a database administrator for Company.com. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?

#27. You are working on the Company database. What is the default name of the alert log file in this database?

#28. You work as a database administrator for Company.com. You have set the retention period for Automatic Repository (AWR) statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics? Choose two

#29. You work as a database administrator for Company.com. As a result of performance analysis, you created an index on the prod_name column of the Companyprod table, which contains about ten thousand rows. Later, you updated a product name in the table.
How does this change affect the index?

#30. Two database users, Company are accessing the staff table of the db database. when ExamS modifies a value in the table, the new value is invisible to Sheets.
Which is the modified value invisible to SHEETS?

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

gen. 0.063

Server date 06:03 02-12-2008

Oracle 1z0-042

Forum

Start online exam simulation

Master braindump

User braindumps