网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）
- A、SQL Access Advisor
- B、 Memory Advisor
- C、SQL Tuning Advisor
- D、 Segment Advisor
参考答案
更多 “You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（） A、SQL Access AdvisorB、 Memory AdvisorC、SQL Tuning AdvisorD、 Segment Advisor” 相关考题
考题
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A、The Automatic Memory Manager (AMM)B、The SQL Tuning AdvisorC、The Segment AdvisorD、The SQL Access Advisor SQL
考题
While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.
考题
While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（） A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.
考题
You are a database administrator for your company. The company uses a SQL Server 2005 database that includes a table named Inventory. The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation. Updates to the Price column are made by various means， including by using ad hoc queries. You need to ensure that this company policy is enforced. What should you do？（）A、Create a trigger that rolls back changes to the Price column that violate company policy.B、Create a stored procedure that disallows changes to the Price column that violate company policy.C、On the Price column， create a check constraint that requires a specified minimum value.D、On the Price column， create a foreign key constraint to a table that contains valid prices.
考题
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?（）A、Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.B、Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.C、Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.D、Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned columnE、Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.F、Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
考题
You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）A、create baseline metrics for today’s performanceB、write the current database metrics to a database table and create a trigger to compare with future database statisticsC、write the current database metrics to a flat file and create an operating script to compare with future database statisticsD、write the current database metrics to a database table and create a procedure to compare with future database statisticsE、write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
考题
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache. What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?（）A、Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.B、Run the Automatic Workload Repository Monitor (ADDM).C、Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.D、Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
考题
In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A、REBUILDB、CASCADEC、TRUNCATED、ROW MOVEMENTE、SHRINK SPACE COMPACTF、SHRINK SPACE CASCADE
考题
You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）A、Monitor thealert.logfileB、Enable server-side SQL tracing for user sessionsC、Enable fine-grained auditing for the customer tableD、Enable Fine-Grained Access Control （FGAC） for the customer tableE、Write a database trigger on the customer table on the SELECT event
考题
Which three tasks can be performed by using the performance Schema?（）A、Finding queries that are not using indexesB、Finding rows that are locked by InnoDBC、Finding client connection attributesD、Finding the part of a code in which a single query is spending timeE、Finding the size of each table
考题
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A、The Automatic Memory Manager (AMM)B、The SQL Tuning AdvisorC、The Segment AdvisorD、The SQL Access Advisor
考题
You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）A、 create a hash cluster to store the dataB、 create an index cluster to store the dataC、 create a partitioned table to store the dataD、 create a sorted hash cluster to store the dataE、 create a heap table with rowid to store the data
考题
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. A SQL Server 2005 computer is managed by you， and a database named Customers is included by the SQL Server 2005 computer. A table named CustInfo is included by the database. An identity column named CustID and an nvarchar column named CustName are included by the table. According to the company requirement， rows which duplicate CustName values are included should be moved from the CustInfo table every year. However， the company requests to have rows removed from the CustInfo table after the rows have been manually examined and verified as being duplicates. Since you are the technical support， you are required to think out a method to have potential duplicate rows identified for manual examination. The minimum amount of administrative effort should be utilized. Which action should be performed to finish the task？（）A、A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.B、A new unique index should be created on the CustName column. And then， IGNORE_DUP_KEY = ON should be specified when creating index.C、On the CustName column， a foreign key constraint should be created， and a distinct list of CustName values is referenced by the foreign key constraint.D、A SELECT INTO query should be utilized， and GROUP BY and HAVING clauses should be included by the query to create a new table that contains duplicate rows from the CustInfo table.
考题
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 database which is named Sellings in the instance. The Sellings database contains a table named Productions. The table is used to stores information about all types of products. The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column contains the NULL value for all products other than Radios. Currently no index exists on the RadionSize column. According to the requirement of the company CIO, you have to optimize the query performance and reduce the effect on the disk space to the least. So what action should you perform to achieve this goal?（） A、On the Products table, you should create a view. B、On the RadioSize column, you should create a clustered index C、On the RadioSize column, you should create a filtered index D、On the RadioSize column, you should create a unique clustered index
考题
A Windows Azure application retrieves data from SQL Azure. You need to recommend an approach for improving application query performance. What should you recommend？（）A、 Create a database view to retrieve the data.B、 Use a clustered index on the SQL Azure database tables.C、 Open a new database connection when an operation times out.D、 Create SQL Azure database table indexes basedon application queries
考题
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. There is a n On-Line Analytical Processing （OLAP） database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table. In the options below， which compression technology should you use？（）A、You should use row compression B、You should use page compression C、You should use backup compression D、You should use windows NTFS file system compression
考题
单选题You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A
The Automatic Memory Manager (AMM)B
The SQL Tuning AdvisorC
The Segment AdvisorD
The SQL Access Advisor
考题
单选题You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）A
The Automatic Memory Manager （AMM）B
The SQL Tuning AdvisorC
The Segment AdvisorD
The SQL Access Advisor
考题
单选题You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）A
create baseline metrics for today’s performanceB
write the current database metrics to a database table and create a trigger to compare with future database statisticsC
write the current database metrics to a flat file and create an operating script to compare with future database statisticsD
write the current database metrics to a database table and create a procedure to compare with future database statisticsE
write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
考题
单选题In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A
REBUILDB
CASCADEC
TRUNCATED
ROW MOVEMENTE
SHRINK SPACE COMPACTF
SHRINK SPACE CASCADE
考题
单选题You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A
The Automatic Memory Manager (AMM)B
The SQL Tuning AdvisorC
The Segment AdvisorD
The SQL Access Advisor SQL
考题
单选题You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）A
SQL Access AdvisorB
Memory AdvisorC
SQL Tuning AdvisorD
Segment Advisor
考题
多选题Which three tasks can be performed by using the performance Schema?（）AFinding queries that are not using indexesBFinding rows that are locked by InnoDBCFinding client connection attributesDFinding the part of a code in which a single query is spending timeEFinding the size of each table
考题
单选题You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. A maintenance strategy should be designed for a mission-critical database, and a large table named Orders is contained by the database. Index maintenance operations are contained in the design plan. When you design the strategy, the facts listed below should be taken into consideration. First, the users continuously access to the Orders table in the database. Secondly, a column of the xml data type is contained by Orders table. Thirdly, the new rows are regularly added to the Orders table. Fourthly, the average fragmentation for the clustered index of the Orders table is no more than 2 percent. A strategy should be designed to have the performance of the queries on the table optimized. Which action will you perform?（）A
The clustered index of the Orders table should be dropped.B
The clustered index of the Orders table offline should be rebuilt once a month.C
The clustered index of the Orders table should be excluded from scheduled reorganizing or rebuilding operations.D
The clustered index of the Orders table should be reorganized by reducing the fill factor.
考题
单选题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. A SQL Server 2005 computer is managed by you， and a database named Customers is included by the SQL Server 2005 computer. A table named CustInfo is included by the database. An identity column named CustID and an nvarchar column named CustName are included by the table. According to the company requirement， rows which duplicate CustName values are included should be moved from the CustInfo table every year. However， the company requests to have rows removed from the CustInfo table after the rows have been manually examined and verified as being duplicates. Since you are the technical support， you are required to think out a method to have potential duplicate rows identified for manual examination. The minimum amount of administrative effort should be utilized. Which action should be performed to finish the task？（）A
A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.B
A new unique index should be created on the CustName column. And then， IGNORE_DUP_KEY = ON should be specified when creating index.C
On the CustName column， a foreign key constraint should be created， and a distinct list of CustName values is referenced by the foreign key constraint.D
A SELECT INTO query should be utilized， and GROUP BY and HAVING clauses should be included by the query to create a new table that contains duplicate rows from the CustInfo table.
考题
单选题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. There is a n On-Line Analytical Processing （OLAP） database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table. In the options below， which compression technology should you use？（）A
You should use row compression B
You should use page compression C
You should use backup compression D
You should use windows NTFS file system compression
考题
单选题In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A
REBUILDB
CASCADEC
TRUNCATED
ROW MOVEMENTE
SHRINK SPACE COMPACTF
SHRINK SPACE CASCADE
热门标签
最新试卷