网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER （ ） functions against a VARCHAR (10000) column quite often. An example of the start of one row of data: 'GREEN01020495888331993-12-10/2…' What should you do to improve the overall performance?（）
A
Convert the column to TEXT and add a fulltext index to the table
B
Create multiple prefix indexes of differing lengths
C
Convert their column to BINARY
D
Redesign the table so that the most commonly searched for string patterns are in their own columns
参考答案
参考解析
解析：
暂无解析
更多 “单选题Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER （ ） functions against a VARCHAR (10000) column quite often. An example of the start of one row of data: 'GREEN01020495888331993-12-10/2…' What should you do to improve the overall performance?（）A Convert the column to TEXT and add a fulltext index to the tableB Create multiple prefix indexes of differing lengthsC Convert their column to BINARYD Redesign the table so that the most commonly searched for string patterns are in their own columns” 相关考题
考题
Your developers have created table to store some of their program‘s data.After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER () functions against a VARCHAR (10000) column quite often.An example of the start of one row of data: ‘GREEN01020495888331993-12-10/2…‘What should you do to improve the overall performance?（）A.Convert the column to TEXT and add a fulltext index to the tableB.Create multiple prefix indexes of differing lengthsC.Convert their column to BINARYD.Redesign the table so that the most commonly searched for string patterns are in their own columns
考题
Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?()
A.MysqlaccessB.MysqldumpC.MysqlshowD.MysqlslowE.Mysqldumpslow
考题
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.
考题
In your test database， you have created the ORDERS table as an index/x7forganized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）A、export and import the mapping tableB、drop and recreate the mapping tableC、truncate the mapping table and reinsert the valuesD、use the ALTER TABLE .. REBUILD command to defragment the mapping table
考题
Which two are true about aggregate functions? （）A、You can use aggregate functions in any clause of a SELECT statement.B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.E、You can use aggregate functions on a table, only by grouping the whole table as one single group.F、You cannot group the rows of a table by more than one column while using aggregate functions.
考题
You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（） A、 Flashback TableB、 Flashback QueryC、Flashback Version QueryD、 Flashback Transaction Query
考题
You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）A、Upgrade the hardware/memory to accommodate the data.B、Load the data into your database by using the PARALLEL clause.C、Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.D、Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.
考题
You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）A、After the query. B、Enter the report and change the column's position in the field tab. C、Alter the column's position in the object navigator. D、Enter the report wizard and change the column's position in the data tab. E、Alter the column's position within its group and change the layout.
考题
Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER （ ） functions against a VARCHAR (10000) column quite often. An example of the start of one row of data: 'GREEN01020495888331993-12-10/2…' What should you do to improve the overall performance?（）A、Convert the column to TEXT and add a fulltext index to the tableB、Create multiple prefix indexes of differing lengthsC、Convert their column to BINARYD、Redesign the table so that the most commonly searched for string patterns are in their own columns
考题
You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）A、 space allocated in the tablespaceB、 space required for the bitmap index on a column of the tableC、 space remaining in the tablespace after creating the tableD、 estimated value of the PCTFREE storage parameter
考题
Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?（）A、MysqlaccessB、MysqldumpC、MysqlshowD、MysqlslowE、Mysqldumpslow
考题
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.
考题
单选题In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）A
export and import the mapping tableB
drop and re-create the mapping tableC
truncate the mapping table and reinsert the valuesD
use the ALTER TABLE···REBUILD command to defragment the mapping table
考题
单选题You want a record of all queries that are not using indexes. How would you achieve this?（）A
By enabling the Slow Query Log because all queries that are not using indexes will be logged automaticallyB
By enabling the Error Log because not using indexes is an errorC
By enabling the Slow Query Log and using the – log-queries-not-using-indexes optionD
By enabling the Error Log and using the – log-queries-not-using-indexes option
考题
单选题You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）A
space allocated in the tablespaceB
space required for the bitmap index on a column of the tableC
space remaining in the tablespace after creating the tableD
estimated value of the PCTFREE storage parameter
考题
单选题The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table？（）A
The materialized view should have a complete refresh performed after the online table redefinition is completed.B
The materialized view should have a fast refresh performed after the online table redefinition is completed.C
The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.D
The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
考题
单选题You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）A
After the query. B
Enter the report and change the column's position in the field tab. C
Alter the column's position in the object navigator. D
Enter the report wizard and change the column's position in the data tab. E
Alter the column's position within its group and change the layout.
考题
单选题You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（）A
Flashback TableB
Flashback QueryC
Flashback Version QueryD
Flashback Transaction Query
考题
单选题In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrees when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）A
Export and import the mapping table.B
Drop and re-create the mapping table.C
Truncate the mapping table and reinsert the values.D
Use the ALTER TABLE .. REBUILD command to defragment the mapping table.
考题
单选题Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?（）A
MysqlaccessB
MysqldumpC
MysqlshowD
MysqlslowE
Mysqldumpslow
考题
单选题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.
考题
单选题You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of cluster will you create？（）A
Index clusterB
Hash clusterC
Sorted Hash clusterD
Real Application Cluster
考题
单选题You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）A
Upgrade the hardware/memory to accommodate the data.B
Load the data into your database by using the PARALLEL clause.C
Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.D
Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.
考题
单选题Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER （ ） functions against a VARCHAR (10000) column quite often. An example of the start of one row of data: 'GREEN01020495888331993-12-10/2…' What should you do to improve the overall performance?（）A
Convert the column to TEXT and add a fulltext index to the tableB
Create multiple prefix indexes of differing lengthsC
Convert their column to BINARYD
Redesign the table so that the most commonly searched for string patterns are in their own columns
考题
单选题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 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.
热门标签
最新试卷