Com you enabled tracing while creating a listener to

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: g a listener to your database. Actualtests.com - The Power of Knowing 1Z0-042 What additional information is available to you when you enable tracing? A.Information about each Oracle Net connection. B.Information about each entry in theLinstener.orafile C.Information about the changed done in the database D.Information about the different listeners in your system E.Information about all thenondatabasefiles required to operate the database Answer: A QUESTION 50: You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? A.Hot backup B.Online backup C.consistent backup D.incremental backup E.inconsistent backup Answer: C QUESTION 51: You work as a database administrator for Certkiller .com. Because of space constraints, you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows: ERROR at Line 1: ORA-10635: Invalid segment ortablespacetype What could be the reason? A.The table is partitioned B.The table name is wrong. C.It is an index-Organized table (IOT) D.The table is stored in locally managedtablespace. E.The table is stored in atablespacewhere segment space is managed manually. Answer: E QUESTION 52: You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable. Actualtests.com - The Power of Knowing 1Z0-042 Which two tasks must you perform to achieve this? Choose two. A.Set the UNDO_RETENTION parameter to AUTO. B.Create an initial undo segment in undotablespace. C.Set the UNDO_RETENTION parameter to 900 or more D.Set the initialization parameter UNDO_MANAGEMENT to AUTO E.Set the UNDO_MANAGEMENT parameter to the name of an undotablespace Answer: D, E QUESTION 53: You work as a database administrator for Certkiller .com. In your organization, you have four databases, Certkiller DB01, Certkiller DB02, Certkiller DB03, and Certkiller DB04, which are located in Berlin, Frankfurt,Rammstein, and Munich respectively, and which were created using Database Configuration Assistant (DBCA). You want to perform administrative task...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online