单项选择题
You work as a database administrator for Certkiller .com. In your Oracle database10g 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).
相关考题
-
单项选择题
YouworkasadatabaseadministratorforCertkiller.com.YoufindthatuserswithDBAroleareusingmoreCPUresourcesthanwhatisallocatedintheirprofiles.Whichactionwouldyoutaketoensurethatresourceslimitsareimposedontheseusers?()
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 -
单项选择题
YouworkasadatabaseadministratorforCertkiller.com.TheUNDO_RETENTIONparameterinyourdatabaseissetto1000andundoretentionisnotguaranteed.Whichstatementregardingretentionofundodataiscorrect?()
A.Undo data becomes obsolete after 1,000 seconds.
B.Undo data gets refreshed after 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 UNDOtablespacefor 1,000 seconds, then it gets movedmovedto the TEMPORARYtablespaceto provide read consistency. -
单项选择题
YourCertkiller.comdatabaseisinARCHIVELOGmode.ThedatafilethatbelongstotheSYSTEMtablespacehasbecomecorrupted.Uptowhatpointcanyourecoverthedatabase?()
A.Until last commit
B.Until the time you perform recovery
C.Until the time the date file got corrupted
D.Until the point where the last transaction begun
E.You cannot recover the SYSTEMtablespaceand must re-create the database.
