Online It certification exam–Pass4side

1z0-042 practice exam covers all the practice test objectives to pass 1z0-042 Exam. It includes 1z0-042 Braindumps, As well Questions & Answers, Realistic Practice Labs, and Interactive Testing Engine.

Our practice test covers the information associated with each 1z0-042 exam topics in details and includes information found in no other practice test sites on the web.

Our challenging questions with Correct Answers built to simulate the actual exam. Unlimited, FREE auto-updates so you’re never behind on any topic. The whole package comes as an automatic download so there’s no waiting or shipping. Our practice test will determine you to take your 1z0-042 certification exam and pass the official exam on your first try, guaranteed

Price: 98.00
Questions: 158:Q&As
Updated: 5/23/2008

download link: http://download.pass4side.com/1z0-042.zip

Now guaranteed 1z0-042 exam training is available in various formats to best suit your needs and learning style. Whether you are a hands-on tactile learner, visually or even a textbook training veteran, Pass4Side has the 1z0-042 resources that will enable you to pass your 1z0-042 test with flying colors.

As with other Oracle exams,or 1z0-042 exam is structured to stack or plug into other related courses. The combination of Oracle courses builds the complete core knowledge base you need to meet your 10g DBA certification requirements.

Our on-site online training experts create all of the Oracle 1z0-042 exam products available through Pass4Side. Our main goal is to get your certified with a firm understanding of the core material. Whereas other online distributors only concern themselves with helping you obtain the paper, we strive to educate the certification candidate and better prepare them for their IT career.

The 1z0-042 Questions and Answers as well as our other 1z0-042 exam training tools are not only priced to be easy on your budget - but each one is also backed with our guarantee. Pass4Side guarantees that after using our Oracle certification training tools, you will be prepared to take and pass your 10g DBA exam.

English:  www.Pass4Side.com

Big5:  www.Pass4Side.net

GB:  www.Pass4Side.cn

 

Pass4Side, Easiest Way to Pass IT Exams!

 

 

 

 

 

 More info from : http://www.pass4side.com

 

 

 

 

 

11. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason,  and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views, you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could have been the reason for this problem?

A. The advisory memory has been turned off.

B. The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.

C. The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.

D. The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.

E. The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

Answer: C

 

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

A. The database remains open.

B. The database gets dismounted.

C. The database becomes read only.

D. The database instance gets aborted.

E. The database gets shut down automatically.

F. The status of the database depends on the status of the USERS tablespace.

Answer: A

 

13. 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?

A. Coalesce the application tables at a regular interval.

B. Export and Import the application tables a regular interval.

C. Drop and recreate the application tables at a regular interval.

D. Move the application tables to a tablespace with less space usage.

E. Distribute the application tables across multiple tablespaces depending on usage.

F. Move the application tables to automatic segment space management tablespace.

Answer: F

 

14. View the Exhibit.

Your Oracle 10g database has 6 tablespaces in which:

-TEMP is the default temporary tablespace

- UNDOTBS1 is the default undo tablespace

- USERS is the default permanent tablespace

In this database, which three tablespaces can be made offline? (Choose three.)

 

A. TEMP

B. PROD

C. USERS

D. SYSAUX

E. SYSTEM

F. UNDOTBS1

Answer: BCD

 

15. You are working on a 24×7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file accidentally. Which statement in this scenario is true?

A. The database crashes.

B. The DBA needs to re-create the file.

C. The file gets re-created automatically.

D. The file gets restored automatically from the last backup.

E. The DBA needs to perform a complete database recovery.

F. The DBA needs to perform an incomplete database recovery.

Answer: C

More info from http://www.pass4side.com/1Z0-042.htm

 

6. It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?

A. cannot be used in RMAN

B. by starting up the database again

C. by using the CATALOG command of RMAN

D. by using the RECOVER CATALOG command in RMAN

E. by re-creating the target control file to rebuild the RMAN repository

Answer: C

 

7. While granting a role, SELECT_CATALOG_ROLE, to a user, SCOTT, using Oracle Enterprise Manager 10g Database Control, you have cleared the DEFAULT check box. What will be the result?

A. The user cannot use the role at all.

B. The role would not be granted to the user.

C. The user needs to enable the role explicitly.

D. The user can start using the role immediately.

E. The user would have the admin option for the role.

Answer: C

 

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

A. You are working on a database where downtime is not tolerated.

B. You are working on a database where downtime can be tolerated.

C. You are working on a database that operates in ARCHIVELOG mode.

D. You are working on a database that operates in NOARCHIVELOG mode.

E. You are working on a database where all the tablespaces are locally managed.

F. You are working on a database where control files and redo log files are multiplexed.

G. You are working on a database where control files and redo log files are not multiplexed.

Answer: BD

 

9. You determine that archiving was not successful in one of the destinations. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file?

A. USER_DUMP_DEST

B. CORE_DUMP_DEST

C. ALERT_LOG_DEST

D. ALERT_DUMP_DEST

E. TRACE_DUMP_DEST

F. BACKGROUND_DUMP_DEST

Answer: F

 

10. View the Exhibit.

The DBA creates a new user as follows:

SQL> CREATE USER manfus IDENTIFIED BY manfus TEMPORARY TABLESPACE temp;

User manfus creates a table as follows:

SQL> CREATE TABLE material(id NUMBER(3));

In which tablespace will the material table be created?

A. TEMP

B. PROD

C. USERS

D. SYSAUX

E. SYSTEM

Answer: C

More info from http://www.pass4side.com/1Z0-042.htm

1. When you try to start the Database Control by using the emctl start

dbconsole command the following error is displayed:
TZ set to America/New_york
OC4J Configuration issue.

/u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracl

e.com not found.
Which two environment variables do you need to set appropriately to avoid

such errors, and start the Database Control successfully? (Choose two.)
A. NLS_LANG
B. ORACLE_SID
C. ORACLE_HOME
D. ORACLE_BASE
E. LD_LIBRARY_PATH
Answer: BC

2. The UNDO_RETENTION parameter in your database is set to 1000 and undo

retention is not guaranteed. Which statement regarding retention of undo

data is correct?
A. Undo data becomes obsolete after 1,000 seconds.
B. Undo data gets refreshed after every 1,000 seconds.
C. Undo data will be stored permanently after 1,000 seconds.
D. Committed undo data would be retained for 1,000 seconds if free undo

space is available.
E. Undo data will be retained in the UNDO tablespace for 1,000 seconds,

then it gets moved to the TEMPORARY tablespace to provide read

consistency.
Answer: D

3. You want the size of the tablespace to increase when it is full. Which

option would you use?
A. use automatic extent allocation
B. disable threshold for the tablespace
C. use freelists to manage the free space
D. use automatic segment space management
E. create the tablespace as a bigfile tablespace
F. use the RESIZE clause while creating the tablespace
G. enable AUTOEXTEND for at least one of the data files in the tablespace
Answer: G

4. You want to administer your PROD database from a remote host machine

using a Web-enabled interface. Which Oracle tool would you use to

accomplish this task efficiently without using command-line interfaces?
A. SQL*Plus
B. iSQL*Plus
C. Management Server
D. Management Repository
E. Oracle Enterprise Manager 10g Database Control
Answer: E

5. The database is open. A media failure has occurred, resulting in loss

of all the control files in your database. Which statement regarding the

database instance is true in this scenario?
A. The instance would hang.
B. The instance needs to be shut down.
C. The instance would be in the open state.
D. The instance would abort in such cases.
E. The instance would be in the open and invalid state.
F. The instance would be in the open state, but all the background

processes will be restarted.
Answer: D