1z0-042 Exam
oracle database 10g:administration i
* Exam Number/Code : 1z0-042
* Exam Name : oracle database 10g:administration i
* Questions and Answers : 148 Q&As
* Update Time: 2010-06-24
* Price: $ 98.00
1. 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
2. Which two statements are true about the primary key constraint in a table? (Choose two.)
A. It is not possible to disable the primary key constraint.
B. It is possible to have more than one primary key constraint in a single table.
C. The primary key constraint can be referred by only one foreign key constraint.
D. The primary key constraint can be imposed by combining more than one column.
E. The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
Answer: DE
3. 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
The Oracle 1z0-042 Practice tests that we can provide are based on the extensive research and real-world experiences from our online trainers, with over 10 years of IT and certification experience. Custom written content for on-the-go professionals such as yourself. 1z0-042 exam training, including 1z0-042 questions and answers feed into our larger product base. You can also enjoy 1z0-042 study Guides, 1z0-042 preparation Labs, and the new and improved 1z0-042 Audio Exams to pass certification.
The product that made our 100% guarantee ever a possibility: the 1z0-042 exam Q & A with downloadable exam simulator. Packed with a state of the art 1z0-042 exam simulator, Oracle training has never been so complete. Prepare for your exam with the most realistic questions, answers and explanations available for sale anywhere on the Internet or 1z0-042 exam solution provider.
The 1z0-042 realistic lab is more than a simple simulation, it will test your actual knowledge in real-life situations. We have real events and situations that your fellow professionals deal with every day – see if you are up to the challenge – when you are done check your own solutions with the correct solution based on 1z0-042 exam fundamentals.
Take full advantage of your commute, downtime and lunch breaks with the newest addition to the 1z0-042 exam line of training tools, the Oracle 1z0-042 Guide . Select your bandwidth for the best file size download, load it into your MP3 player or PC Media Player and let the training begin. Another guaranteed solution from Testinside.
The 1z0-042 Study Guide will take you from weak to geek in our 100% guaranteed solution for getting your head wrapped around the 1z0-042 exam content and theories. The 1z0-042 guide is the perfect prelude to using the 1z0-042 exam braindumps .