单项选择题

You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）

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

单项选择题A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work. ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）

A.Modify the profile assigned to the user.
B.Modify the roles assigned to the users.
C.Modify the object privileges assigned to the user.
D.Modify the system privileges assigned to the users.
E.Modify the value for the RESOURCE_LIMIT parameter in the parameter file.