You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）

单项选择题Youspecifiedextentmanagementaslocalforatablespace.Howwillitaffectspacemanagementinthetablespace？（）

A.All the extents will be of the same size.
B.Bitmap will be used to record free and allocated extents.
C.Free extents will be managed by the data dictionary tables.
D.The tablespace will be system managed and the users cannot specify the extent size.

单项选择题YouexecutedtheSTARTUPMOUNTcommandtostartyourdatabase.ForwhichdatabaseoperationdoyouneedtostartthedatabaseintheMOUNTstate？（）

A.renaming the control files
B.dropping a user in your database
C.enabling or disabling redo log archiving
D.dropping a tablespace in your database
E.re-creating the control files， after you lost all the control files in your database

单项选择题When you try to open your database， you receive the following error：  ORA-00205： error in identifying controlfile  Where would you find the details required to resolve this error？（）

A.audit trail
B.alert log file
C.user trace file
D.online trace file
E.background trace file
F.operating system event viewer

单项选择题User SCOTT wants to export his objects using Oracle Data Pump and executes the following command： $ expdp scott tiger  directory = EXPORT_DIR  dumpfile = scott.dmp include = table  include = view： like ’%DEPARTMENTS%’   content = DATA_ONLY  Which task would the command accomplish？（）

A.A
B.B
C.C
D.D
E.E

单项选择题Userscomplainabouttheslowresponsetimeofqueries.WhileinvestigatingthecauseyoufindthattheOracleInstanceisnotconfiguredtocacheallofthedatablockstosatisfytheusers’queries.WhichcomponentoftheOracleInstancewouldyouchangetoimproveperformance？（）

A.Java pool
B.Large pool
C.Shared pool
D.Streams pool
E.Library cache
F.Redo log buffer
G.Data dictionary cache
H.Database buffer cache