oracle database 10g:administration i
Exam Number/Code : 1z0-042
Exam Name : oracle database 10g:administration i
Questions and Answers : 148 Q&As

Itcerthome practice test offers free 1z0-042 dumps,1z0-042 practice test,1z0-042 exam questions for 10g DBA certification(Oracle Certified Network Associate). You can check out the question quality and usability of our 1z0-042 practice exam before you decide to buy it.

Exam : Oracle 1Z0-042
Title : Oracle certification Database 10g: Administration I
1. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct? (Choose two.)
A. This clause is not valid for a temporary or undo tablespace.
B. If the tablespace is in the NOLOGGING mode, no operation on the tablespace will generate redo.
C. The tablespace will be in the NOLOGGING mode by default, if not specified while creating a tablespace.
D. The tablespace-level logging attribute can be overridden by logging specifications at the table, index, materialized view, materialized view log, and partition levels.
Answer: AD
2. Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus?
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.
Answer: D

The related exams:
1z0-043 Oracle Database 10g: Administration II
1z0-045 oracle database 10g:new features for oracle8i ocps
1z0-047 Oracle Database SQL Expert