网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
Youhavearange-partitionedtableinyourdatabase.&en
Youhavearange-partitionedtableinyourdatabase.Eachpartitioninthetablecontainsthesalesdataforaquarter.
Thepartitionrelatedtothecurrentquarterismodifiedfrequentlyandotherpartitionsundergofewerdatamanipulations.Thepreferencesforthetablearesettotheirdefaultvalues.Youcollectstatisticsforthetableusingthefollowingcommandinregularintervals:SQL>EXECUTE
DBMS_STATS.GATHER_TABLE_STATS(’SH’,’SALES’,GRANULARITY=>’GLOBAL’);
Youneedstatisticstobecollectedmorequickly.
Whatcanyoudotoachievethis?()
参考答案
更多 “ Youhavearange-partitionedtableinyourdatabase.EXECUTEDBMS_STATS.GATHER_TABLE_STATS(’SH’,’SALES’,GRANULARITY=’GLOBAL’);Youneedstatisticstobecollectedmorequickly.Whatcanyoudotoachievethis?() ” 相关考题
考题
You are the network administrator for Your network consists of twoActive Directory domains. Each department has its own organizational unit (OU)for departmental user accounts. Each OU has a separate Group Policy object(GPO)A single terminal server named TestKingTerm1 is reserved for remote users. Inaddition, several departments have their own terminal servers for departmental use.Your help desk reports that user sessions on TestKingTerm1 remain connected evenif the sessions are inactive for days. Users in the accounting department report slowresponse times on their terminal server.You need to ensure that users of TestKingTerm1 are automatically logged off whentheir sessions are inactive for more than two hours. Your solution must not affectusers of any other terminal servers.What should you do?()A. For all accounting users, change the session limit settings.B. On TestKingTerm1, use the Terminal Services configuration tool to change the session limit settings.C. Modify the GPO linked to the Accounting OU by changing the session limit settings in user-level group polices.D. Modify the GPO linked to the Accounting OU by changing the session limit settings in computer-level group polices.
热门标签
最新试卷