什么是DBMS?DBMS的主要功能有哪些?
第1题:
A.DBMS_REPAIR
B.DBMS_SCHDULER
C.DBMS_STATS
D.DBMS_RESOURCE_MANAGER
第2题:
Youwanttoenforceacompany’sbusinesspolicyonseveralobjectsbyusingasinglepolicyfunction.Whichtwotypesofpoliciescanbeassignedtothepolicy_typeargumentinthedbms_rls.add_policyproceduretoachievetheaboveobjective?()
A.DBMS_RLS.STATIC
B.DBMS_RLS.DYNAMIC
C.DBMS_RLS.SHARED_STATIC
D.DBMS_RLS.CONTEXT_SENSITIVE
E.DBMS_RLS.SHARED_CONTEXT_SENSITIVE
第3题:
Youfindthatsomequeriesonatablearetakingalongtimetoexecutebecausetherearenoindexescreatedonthetable.YoudecidetoinvoketheSQLAccessAdvisortodeterminetheappropriateindextobecreated.WhichpackagewillyouusetoinvoketheSQLAccessAdvisor?()
A.DBMS_SERVER_ALERT
B.DBMS_ADVISOR
C.DBMS_RESOURCE_MANAGER
D.DBMS_REPAIR
第4题:
什么是DBMS的多线索机制?有什么优点?
第5题:
A.DBMS_STATS
B.DBMS_ALERT
C.DBMS_SPACE
D.DBMS_MONITOR
E.DBMS_SERVER_ALERT
F.DBMS_SPACE_ADMIN
第6题:
A.DBMS_MONITOR
B.DBMS_STATS
C.DBMS_SQLTUNE
D.DBMS_ADVISOR
第7题:
A.DBMS_RCVMAN
B.DBMS_RMAN
C.DBMS_RCVCAT
D.DBMS_CATPROC
第8题:
A.DBMS_WORKLOAD_REPOSITORY
B.DBMS_RESOURCE_MANAGER
C.DBMS_SQLTUNE
D.DBMS_ADVISOR
第9题:
A.DBMS_STANDARD
B.DBMS_STD
C.DBMS_SQL
D.DBMS_TYPES
第10题:
DBMS的查询处理器有哪些成分?