单项选择题

A.DROP TABLE B.ALTER TABLE C.RESIZE D.COALESCEYouaretry……

You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）

A.DROP TABLE
B.ALTER TABLE
C.RESIZE
D.COALESCE

<上一题目录下一题>

热门试题

单项选择题Yourapplicationregularlyissuesthefollowingstatement:SELECT*FROMBANK_ACCTWHEREACCT_BALANCEBETWEEN1000and10000;Whichofthefollowingdatabaseobjectswouldbeinappropriateforusewiththisstatement?（）

A.Materialized views
B.Indexes
C.Index-organized tables
D.Hash clusters

单项选择题Youareattemptingtoincreasethecheckpointintervalonyourdatabase.Eachofthefollowingchoiceswillaffectthedurationand orfrequencyofcheckpoints,exceptone.Whichisit?（）

A.Size of redo logs
B.Number of datafiles
C.LOG_CHECKPOINT_INTERVAL
D.LOG_CHECKPOINT_TIMEOUT

单项选择题YouareaddingredologstotheOracledatabase.CreatinganewredologaddsinformationtowhichofthefollowingOracleresources?（）

A.Shared pool
B.Control file
C.SGA
D.PGA

单项选择题Inordertofindouthowmanydatabaseobjectsauserhascreated,whichviewwouldtheDBAqueryintheOracledatadictionary?（）

A.DBA_USERS
B.DBA_OBJECTS
C.DBA_TS_QUOTAS
D.DBA_TAB_PRIVS

单项选择题heDBAisabouttoenableauditingontheOracledatabaseinanattempttodiscoversomesuspiciousactivity.Audittrailinformationisstoredinwhichofthefollowingdatabaseobjectnames?（）

A.SYS.SOURCE$
B.SYS.AUD$
C.DBA_SOURCE
D.DBA_AUDIT_TRAIL