Dcommitted undo data would be retained for 1000

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: tted undo data would be retained for 1,000 seconds if free undo space is available. E.Undo data will be retained in the UNDOtablespacefor 1,000 seconds, then it gets movedmovedto the TEMPORARYtablespaceto provide read consistency. Answer: D QUESTION 11: You work as a database administrator for Certkiller .com. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users? A.Assign the DEFAULT profile to the users B.Set the RESOURCE_LIMIT parameter to TRUE in the parameter file C.Create a new profile with CPU restrictions and assign it to the users D.Specify the users as members of the DEFAULT_CONSUMER_GROUP E.Revoke the DBA role and grant CONNECT and RESOURCE role to the users Answer: B QUESTION 12: You work as a database administrator for Certkiller .com. In your Oracle database Actualtests.com - The Power of Knowing 1Z0-042 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting? A.The Oracle kernel will be placed in this location. B.The Oracle software will be placed in this location. C.The server parameter file (SPFILE) will be placed in this location. D.The database files will be placed in this location, if not specified explicitly. E.The location will be considered for the base of Oracle Managed Files (OMF). F.The location will be considered for the base of Optimal Flexible Architecture (OFA). Answer: F QUESTION 13: The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file? A.OracleSIDsonly B.Oracle homes only C.Oracle install timestamp D.Oracle inventory pointer files E.Oracle database creation timestamp F.OracleSIDsand Oracle homes only G.OracleSIDs, Oracle homes and flag for auto startup Answer: G QUESTION 14: You work as a database administrator for Certkiller .com. Your...
View Full Document

Ask a homework question - tutors are online