什么是DBMS?DBMS的主要功能有哪些?
什么是DBMS?DBMS的主要功能有哪些?
相关考题:
Youfindthatsomequeriesonatablearetakingalongtimetoexecutebecausetherearenoindexescreatedonthetable.YoudecidetoinvoketheSQLAccessAdvisortodeterminetheappropriateindextobecreated.WhichpackagewillyouusetoinvoketheSQLAccessAdvisor?()A.DBMS_SERVER_ALERTB.DBMS_ADVISORC.DBMS_RESOURCE_MANAGERD.DBMS_REPAIR
YouarecreatingaSQLTuningSettoallowagroupofSQLstatementstobepassedintotheSQLTuningAdvisor.WhichpackageswillyouusetocreatetheSQLTuningSet?() A.DBMS_WORKLOAD_REPOSITORYB.DBMS_RESOURCE_MANAGERC.DBMS_SQLTUNED.DBMS_ADVISOR
YouwanttorebuildafreelistinthefreelistsoftheEMPLOYEEtableintheScottschema.Whichpackagewillyouusetoaccomplishthis?() A.DBMS_REPAIRB.DBMS_SCHDULERC.DBMS_STATSD.DBMS_RESOURCE_MANAGER
WhichpackageprovidesAPI’sfortheSQLTuningAdvisor?() A.DBMS_MONITORB.DBMS_STATSC.DBMS_SQLTUNED.DBMS_ADVISOR
Youwanttoenforceacompany’sbusinesspolicyonseveralobjectsbyusingasinglepolicyfunction.Whichtwotypesofpoliciescanbeassignedtothepolicy_typeargumentinthedbms_rls.add_policyproceduretoachievetheaboveobjective?()A.DBMS_RLS.STATICB.DBMS_RLS.DYNAMICC.DBMS_RLS.SHARED_STATICD.DBMS_RLS.CONTEXT_SENSITIVEE.DBMS_RLS.SHARED_CONTEXT_SENSITIVE
Whichofthefollowingpackagesmaintainsinformationintherecoverycatalog?() A.DBMS_RCVMANB.DBMS_RMANC.DBMS_RCVCATD.DBMS_CATPROC
Youexplicitlyspecifiedthetablespaceusagethresholdvalueswhilecreatingatablespace.Youneedtoreverttothedatabase-widedefaulttablespaceusagethresholdvaluesforthe tablespace.WhichPL/SQLpackagewouldyouuse?() A.DBMS_STATSB.DBMS_ALERTC.DBMS_SPACED.DBMS_MONITORE.DBMS_SERVER_ALERTF.DBMS_SPACE_ADMIN
Which of the following packages maintains information in the recovery catalog? ()A、DBMS_RCVMANB、DBMS_RMANC、DBMS_RCVCATD、DBMS_CATPROC
问答题DBMS的查询处理器有哪些成分?