单项选择题
You work as a database administrator for Supportcenter.cn. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？（）
A.3 hours
B.6 months
C.until last year
D.until last commit
E.until the point when the undotablespacewas refreshed
F.until the database is shut down and the memory erased
相关考题
-
单项选择题
TheoperatingsystemfilecratabintheLinuxplatformgetsupdatedwheneveryoucreateanewdatabaseonthesamehostmachine.Whatkindofinformationisstoredisstoredinthisfile？（）
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 -
单项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.InyourOracledatabase10ginstallationyouhavesetORACLE_BASEto/u01/app/oracle.Whichobjectivewillbeachievedbythissetting？（）
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）. -
单项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.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
