单项选择题

A.Materialized views B.Indexes C.Index-organized tables……

Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）

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

单项选择题Whichofthefollowingdatatypesareusedinsituationswhereyouwantanorderedsetofdataelements,whereeveryelementisthesamedatatype,andwhereyoupredefinethenumberofelementsthatappearintheset?（）

A.REF
B.TABLE
C.CLOB
D.VARRAY