1z0-042 10g DBA Braindump
ExamSoon 1z0-042 Exams
Oracle oracle database 10g:administration i
O rder : 1z0-042 Exam
Practice Exam: 1z0-042
Exam Number/Code: 1z0-042
Exam Name: oracle database 10g:administration i
Questions and Answers: 148 Q&As
Free 1z0-042 Braindumps
Exam : Oracle 1Z0-042
Title : Oracle Database 10g: Administration I
1. Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in
A. The user must be granted the database administrator (DBA) privilege.
B. The user must be listed in the password file for the authentication.
C. No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.
D. Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager, and grant the webDba
role to the user.
2. Which three statements are true regarding the logical structure of the Oracle database? (Choose three.)
A. Each segment contains one or more extents.
B. Multiple tablespaces can share single data file.
C. A data block is the smallest unit of I/O for data files.
D. It is possible to have tablespaces of different block sizes in a database.
E. Each data block in the database always corresponds to one OS block.
3. You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the
instance has shut down before synchronizing all the database files.
Which two statements are true? (Choose two.)
A. On startup, SMON coordinates instance recovery.
B. On startup, CKPT coordinates instance recovery.
C. On startup, use RMAN to perform instance recovery.
D. Uncommitted changes will be rolled back after the database is opened.
E. On startup, perform media recovery and then instance recovery.
F. On startup, all the files will be synchronized and you get both committed and uncommitted data.
4. The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of
the year-end tax and interest calculation process,