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

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

#121. Your database performance has degraded due to frequent checkpointing. What would you do in this scenario?

#122. Exhibit:

View the Exhibit to see the structure of the EMPLOYEES and DEPARTMENTS tables. Your organization plans to dissolve the department with department ID 30. You execute the following command to delete rows from the DEPARTMENTS table:

 SQL>delete FROM DEPARTMENTS 
 WHERE DEPT_ID = 30;

The command fails and displays the following error:
ERROR at line 1:
ORA-02292: integrity constraint (HR.SYS_C005374) violated - child record found
Which two actions would you take to overcome this error? (Choose two.)

#123. As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead?

#124. On which three can you use Recovery Manager (RMAN) to perform incremental backup? (Choose three.)

#125. Due to media failure you lost one of the data files belonging to the USERS tablespace, and the table space is not available to use. Which statement regarding the status of the database is true?

#126. In which two cases would you perform only consistent backup? (Choose two.)

#127. You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change the UNDO_RETENTION value?

#128. You executed the following command in the lsnrctl utility to stop the listener:
lsnrctl> STOP L1
What is the effect of this command if L1 is the only listener configured for your database?

#129. You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.
Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?

#130. You need to rename a data file of a tablespace. How would you perform this?

[1] ... [11] [12] [13] [14] [15] [16] [17] [18] [19]

gen. 0.059

Server date 02:31 10-01-2009

Oracle 1z0-042

Forum

Start online exam simulation

Master braindump

User braindumps