subject: 1z0-042 Practice Questions [print this page] 1z0-042 Exam oracle database 10g:administration i Exam Number/Code : 1z0-042 Exam Name : oracle database 10g:administration i Questions and Answers : 287 Q&As Update Time: 2010-09-28
Oracle Database 10g: Administration I Exam Number:1Z0-042 Associated Certifications: Oracle Database 10g DBA OCA Exam Price: US$ 195 Duration: 120 minutes Number of Questions: 84 Passing Score: 68% Managing Schema Objects Exam Topics Create and modify tables Define constraints and states of constraints (7) Dropping and truncating tables (7) Create and use B-Tree and Bitmap indexes (8) Create Views Create sequences Use data dictionary Managing Data and Concurrency Manipulate data through the use of SQL Identify and administer PL/SQL objects Describe triggers and triggering events Define levels of locking List possible causes of lock conflict Monitor and resolve lock conflicts Managing Undo Data Monitor and administer undo Configure undo retention Describe the relationship between undo and transactions Size the undo tablespace
Testinside designed 1Z0-042 preparation kit to help you get certified effortlessly. Now you do not need to spend your time and money searching for study materials, books, etc., this1Z0-042 exam preparation kit contains everything you need to get certified, Just follow the instructions, focus on the study material and getting certified will be easy.
At Others Testinside 1Z0-042 braindumps for exam page we have all the information which will increase your vision about solving the real on line problems. The basic aim of Testinside team is passing 1Z0-042 exam on your first try. The best way to do this is to buy Testinside 1Z0-042 exam guide.
TestinsideOracle 1Z0-042 Practice Questions and Answers with Explanations are the best way to prepare for your coming Oracle 1Z0-042 Certification Exam. With the help of Testinsides Oracle1Z0-042 study guide with Explanations, your success is just a few steps away. You can pass your Oracle 1Z0-042 Certification Exam on your first attempt using our advanced Oracle 1Z0-042 Practice Questions and Answers with Explanations.
1Z0-042 practice exam 1. You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate? A. SQL script B. PL/SQL script C. Operating System (OS) script D. Enterprise Manager (EM) script E. Recovery Manager (RMAN) script Answer: E 2. 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. Answer: AD 3. 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
