网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）
A
run Segment Advisor
B
run SQL Tuning Advisor on top SQL statements
C
run the Automatic Workload Repository （AWR） report
D
run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
参考答案
参考解析
解析：
暂无解析
更多 “单选题You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）A run Segment AdvisorB run SQL Tuning Advisor on top SQL statementsC run the Automatic Workload Repository （AWR） reportD run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements” 相关考题
考题
You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）A.B.C.D.
考题
You define a multiple－row subquery in the WHERE clause of an SQL query with a comparison operator "=". What happens when the main query is executed? ()
A. The main query executes with the first value returned by the subquery.B. The main query executes with the last value returned by the subquery.C. The main query executes with all the values returned by the subquery.D. The main query fails because the multiple-row subquery cannot be used with the comparison operator.E. You cannot define a multiple-row subquery in the WHERE clause of a SQL query.
考题
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）A. Execute the query and view Active Session History (ASH) for information about the query.B. Enable SQL trace for the query.C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
考题
You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. This table is used to store information about customer complaints.The customer service representatives in your company add and edit the information in the complaints table. They work with this table by using a number of client applications, including a web-based application and a Microsoft Windows 32-bit application.The customer service manager discovers that some customer complaints are marked as closed before they are resolved to the customer’s satisfaction.You need to notify the customer service manager whenever a complaint is marked as closed. You do not want to make any changes to the client applications.What should you do?A．Create an UPDATE trigger that sends an e-mail message.B．Create a stored procedure that sends an e-mail message. Use the stored procedures to make changes to the data.C．Create a user-defined function that sends an e-mail message. Use the function to make changes to the data.D．Create a rule that validates data entry. Bind the rule to the CompliantClosed column.
考题
You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）A、 VERSIONS_STARTSCNB、 VERSIONS_STARTTIMEC、 VERSIONS_XIDD、 VERSIONS_OPERATION
考题
Which statement is true when you run the SQL Tuning Advisor with limited scope？（）A、Access path analysis is not performed for the SQL statements.B、SQL structure analysis is not performed for the SQL statements.C、SQL Profile recommendations are not generated for the SQL statements.D、The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.
考题
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 AdvisorB、Segment AdvisorC、SQL Access AdvisorD、Automatic Workload Repository （AWR）E、Automatic Database Diagnostic Monitor （ADDM）
考题
You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".What happens when the main query is executed?（）A、The main query executes with the first value returned by the subquery.B、The main query executes with the last value returned by the subquery.C、The main query executes with all the values returned by the subquery.D、The main query fails because the multiple-row subquery cannot be used with the comparison operator.E、You cannot define a multiple-row subquery in the WHERE clause of a SQL query.
考题
By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） A list of changes made along with the transaction identifier of each change. b） The necessary SQL statements to undo the erroneous changes. Which option would you choose？（）A、 RMAN only.B、 Flashback Table only.C、 Flashback Version Query only.D、 Flashback Database and Flashback Transaction Query.E、 Flashback Version Query and Flashback Transaction Query.
考题
You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）A、Configure a Linked Server connection to the application database.B、Write a query that uses an OPENDATASOURCE command.C、Write a query that uses an OPENQUERY command.D、Configure a Remote Server connection to the application database.
考题
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform？（）A、In a SQL Trace log file， you should look for queries with low duration values and high read and write values.B、In a query execution plan， you should look for queries with missing or out-of-date statistics.C、In a SQL Trace log file， you should look for queries with high duration values and low read and write values.D、In a query execution plan， you should look for queries with a large number of table scans.
考题
TestKing.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins.You need to write a distributed query that joins the data on SQL1 with the data on SQL2. What should you do？（）A、Ensure that both SQL1 and SQL2 use the same login name as the security context for each server.B、Configure SQL2 as a remote server. Write the query on SQL1.C、Configure SQL2 as a linked server to impersonate the remote login.D、Configure SQL2 as a distributed server. Use pass-through authentication.
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked. Which tool should you use? （） A、You should use the Database Engine Tuning Advisor tool B、You should use the Windows System Monitor tool C、You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio D、You should use the Activity Monitor tool in Microsoft SQL Server Management Studio
考题
单选题You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）A
VERSIONS_STARTSCNB
VERSIONS_STARTTIMEC
VERSIONS_XIDD
VERSIONS_OPERATION
考题
单选题You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）A
run Segment AdvisorB
run SQL Tuning Advisor on top SQL statementsC
run the Automatic Workload Repository （AWR） reportD
run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
考题
单选题A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）A
Execute the query and view Active Session History (ASH) for information about the query.B
Enable SQL trace for the query.C
Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D
Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
考题
单选题You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader（ ）;You need to execute a method named Do Work（ ） that takes one second to run while the SQL query is executing. DoWork（ ） must run as many times as possible while the SQL query is executing. Which code segment should you use? （）A
while（ar.AsyncWaitHandle==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；B
while（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；C
while（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；D
while（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）；
考题
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked. Which tool should you use? （）A
You should use the Database Engine Tuning Advisor tool B
You should use the Windows System Monitor tool C
You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio D
You should use the Activity Monitor tool in Microsoft SQL Server Management Studio
考题
单选题You are creating an online catalog application that will display product information on the company Web site. The product data is stored in a SQL Server 2005 database. The data is stored as relational data but must be passed to the application as an XML document by using FOR XML. You test your application and notice that not all of the items matching your query appear in the XML document. Only those products that have values for all elements in the schema appear. You need to modify your Transact-SQL statement so that all products matching your query appear in the XML document. What should you do？（）A
Add an XML index to the table that contains the product data.B
Add the XSINIL argument to the ELEMENTS directive in the query.C
Add a HAVING clause to the query.D
Add the replace value of clause to the query.
考题
单选题You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".What happens when the main query is executed?（）A
The main query executes with the first value returned by the subquery.B
The main query executes with the last value returned by the subquery.C
The main query executes with all the values returned by the subquery.D
The main query fails because the multiple-row subquery cannot be used with the comparison operator.E
You cannot define a multiple-row subquery in the WHERE clause of a SQL query.
考题
单选题Your network contains an Active Directory domain. The domain contains four domain controllers. You modify the Active Directory schema. You need to verify that all the domain controllers received the schema modification. Which command should you run（）A
dcdiag.exe /aB
netdom.exe query fsmoC
repadmin.exe /showrepl *D
sc.exe query ntds
考题
单选题You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）A
enable index monitoring and query the DBA_OBJECTS viewB
enable index monitoring and query the DBA_INDEXES viewC
enable index monitoring and query the V$OBJECT_USAGE viewD
enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
考题
单选题You need to resolve the blocking issue that is affecting the performance of the CRM system. What should you do?（）A
Replace the named query with an SQL view.B
Set the transaction isolation level to serializable in the named query.C
Set the source database to use snapshot isolation.D
Set the transaction isolation level to repeatable read in the named query.
考题
单选题By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） a list of changes made along with the transaction identifier of each change b） the necessary SQL statements to undo the erroneous changes Which option would you choose？（）A
RMAN onlyB
Flashback Table onlyC
Flashback Versions Query onlyD
Flashback Database and Flashback Transaction QueryE
Flashback Versions Query and Flashback Transaction Query
考题
单选题By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） A list of changes made along with the transaction identifier of each change. b） The necessary SQL statements to undo the erroneous changes. Which option would you choose？（）A
RMAN only.B
Flashback Table only.C
Flashback Version Query only.D
Flashback Database and Flashback Transaction Query.E
Flashback Version Query and Flashback Transaction Query.
考题
单选题You work in a Organization which is named Wiikigo Corp. The Organization uses SQL Server 2008. You are the administrator of the Organization database. Now you are in charge of a SQL Server 2008 instance. Look at the following query: SELECT s.*, i.* FROM SensitiveTbl AS s INNER JOIN InsensitiveTbl AS iON i. OrganizationName = s.OrganizationName You use the above query to join two tables on a column named OrganizationName. The following error is returned when you execute the query. "Msg 468, Level 16, State 9, Line 17 Cannot resolve the collation conflict between 'SQL_Latin1_General_CP1_CS_AS' and 'SQL_Latin1_General_CP1_CI_AS' in the equal to operation." The ON clause of the query has to be modified so that it can perform a case-sensitive joinsuccessfully. What should you do? （）A
ON LOWER(i.OrganizationName) = LOWER(s.OrganizationName)B
ON UPPER(i.OrganizationName) = UPPER(s.OrganizationName) C
ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CS_AS D
ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CI_AS
热门标签
最新试卷
