搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（） 

A、Memory Advisor

B、Segment Advisor

C、SQL Access Advisor

D、Automatic Workload Repository （AWR）

E、Automatic Database Diagnostic Monitor （ADDM）

查看正确答案
更多“You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（） ”相关的问题
第1题
[单选题] If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）

A、V_CONTROLFILE_RECORD_SECTION   B、V_CONTROLFILE   C、V$PARAMETER   D、init.ora file  

点击查看答案
第2题
[单选题] You are working on a debug build of an application.You need to find the line of code that caused an exception to be thrown. Which property of the Exception class should you use to achieve this goal？（）

A、Data  B、Message  C、Stack Trace  D、Source  

点击查看答案
第3题
[单选题] During consultation， you find that a customer has multiple asset closets and will be adding more inthe future. Which NAS physical deployment model would you suggest to this customer？（）

A、 edge  B、 central  C、 Layer 2  D、 Layer 3  

点击查看答案
第4题
[多选题] Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery？（）

A、You find that one of the redo log members in each redo log group is lost.  B、You find that a data file that belongs to the USERS tablespace is damaged.  C、You find that a data file that belongs to the SYSTEM tablespace is damaged.  D、You find that the current redo log group is damaged and is not available for recovery.  E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.  

点击查看答案
第5题
[多选题] Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）

A、 You find that one of the redo log members in each redo log group is lost.  B、 You find that a data file that belongs to the USERS tablespace is damaged.  C、 You find that a data file that belongs to the SYSTEM tablespace is damaged.  D、 You find that the current redo log group is damaged and is not available for recovery.  E、 You realized while performing a recovery that an archived redo log file needed for recovery is lost.  

点击查看答案
第6题
[] You work as the enterprise exchange administrator at Xxx .The Xxx network is running in a Microsoft Exchange Server 2010 environment.How can you find out about the mailboxes that exceeds 2 GB in size？（）

A、A.You must use the Get-MailboxStatistics cmdlet.  B、B.You must use the Test-Mailflow cmdlet.  C、C.You must use the Get-StoreUsageStatistics.  D、D.You must use the Test-ServiceHealth cmdlet.  

点击查看答案
第7题
[单选题] You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）

A、V$SESSION   B、V$SYSSTAT   C、DBA_SEGMENTS   D、V$SORT_USAGE  

点击查看答案
第8题
[单选题] During consultation， you find that a customer has only a single asset closet and is looking for asolution that is easy to deploy. Which NAS physical deployment model would you suggest to this customer？（）

A、 edge  B、 central  C、 Layer 2  D、 Layer 3  

点击查看答案
第9题
[] You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQLQ

A、A.You should check SQL1.log  B、B.You should check SQLAGENT.OUT  C、C.You should check log_xx.trc  D、D.You should check ERRORLOG  

点击查看答案
第10题
[单选题] You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（） 

A、DBMS_SERVER_ALERT  B、DBMS_ADVISOR  C、DBMS_RESOURCE_MANAGER  D、DBMS_REPAIR  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服