网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）
A
A leaf will be marked as invalid.
B
An update in a leaf row takes place.
C
The index will be updated automatically at commit.
D
A leaf row in the index will be deleted and inserted.
E
The index becomes invalid when you make any updates.
参考答案
参考解析
解析：
暂无解析
更多 “单选题As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）A A leaf will be marked as invalid.B An update in a leaf row takes place.C The index will be updated automatically at commit.D A leaf row in the index will be deleted and inserted.E The index becomes invalid when you make any updates.” 相关考题
考题
You would like to create a custom performance counter for an application that you created recently.To do this, you decide to create a custom category named ApplicationPerformance and a performance counter named HitNumber.You need to ensure that this counter is shared across numerous applications.What should you do?（）A.B.C.D.
考题
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.
考题
Evaluate the CREATE TABLE statement： CREATE TABLE products （product_id NUMBER （6） CONSTRAINT prod_id_pk PRIMARY KEY， product_name VARCHAR2 （15））； Which statement is true regarding the PROD_ID_PK constraint？（）A、 It would be created only if a unique index is manually created first.B、 It would be created and would use an automatically created unique index.C、 It would be created and would use an automatically created nonunique index.D、 It would be created and remains in a disabled state because no index is specified in the command.
考题
As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）A、A leaf will be marked as invalid.B、An update in a leaf row takes place.C、The index will be updated automatically at commit.D、A leaf row in the index will be deleted and inserted.E、The index becomes invalid when you make any updates.
考题
While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn 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 work as a database administrator for Certkiller .com. As a result of performance analysis， you created an index on theprod_namecolumn of the Certkiller prodtable， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）A、A leaf will be marked as invalid.B、An update in a leaf row takes place.C、The index will be updated automatically at commit.D、A leaf row in the index will be deleted and inserted.E、The index becomes invalid when you make any updates
考题
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQLCREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）A、disabling the indexB、making the index invisibleC、making the index unusableD、using the MONITORING USAGE clause for the index
考题
In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）A、hash clustersB、index clustersC、partitioned tablesD、indexorganized table （IOT）
考题
A bitmap join index is defined as（）.A、An index used to join two bitmap indexes on a table.B、A bitmap index created for the join of two or more tables.C、A bitmap index created on the join of two or more indexes.D、A bitmap index created on the join of two or more indexed-organized tables.
考题
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 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）A、A primary XML index should be created on the XML column.B、Statistics should be created on the nvarchar columns.C、A view should be created， and only the four columns that the query utilizes are contained by a view.D、A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.
考题
单选题You work as a database administrator for Certkiller .com. As a result of performance analysis， you created an index on theprod_namecolumn of the Certkiller prodtable， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）A
A leaf will be marked as invalid.B
An update in a leaf row takes place.C
The index will be updated automatically at commit.D
A leaf row in the index will be deleted and inserted.E
The index becomes invalid when you make any updates
考题
单选题You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics？（）A
The baseline， once created， cannot be removed.B
Disable the baseline metrics in the Database Control Manage Metrics page.C
The baseline will be automatically removed once the database performance has been optimized.D
Drop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.
考题
单选题View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table： ALTER TABLE emp ADD CONSTRAINT emp_id_pk PRIMARY KEY （emp_id） USING INDEX emp_id_idx； Which statement is true regarding the effect of the command？（）A
The PRIMARY KEY is created along with a new index.B
The PRIMARY KEY is created and it would use an existing unique index.C
The PRIMARY KEY would be created in a disabled state because it is using an existing index.D
The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.
考题
单选题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_ALERTB
DBMS_ADVISORC
DBMS_RESOURCE_MANAGERD
DBMS_REPAIR
考题
单选题As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）A
A leaf will be marked as invalid.B
An update in a leaf row takes place.C
The index will be updated automatically at commit.D
A leaf row in the index will be deleted and inserted.E
The index becomes invalid when you make any updates.
考题
单选题You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective？（）A
Rebuild the index.B
Coalesce the index.C
Drop and re-create the index in the new tablespace.D
Relocate the index using the ALTER INDEX...MOVE statement.
考题
单选题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.
考题
单选题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 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 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）A
A primary XML index should be created on the XML column.B
Statistics should be created on the nvarchar columns.C
A view should be created， and only the four columns that the query utilizes are contained by a view.D
A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.
考题
单选题While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn 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 notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）A
Enable Memory Access Mode, which reads performance data from SGA.B
Use emergency monitoring to fetch data directly from SGA analysis.C
Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.D
Use Active Session History (ASH) data and hang analysis in regular performance monitoring.E
Run ADDM in diagnostic mode.
考题
单选题You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）A
The index can be changed from NOLOGGING to LOGGINGB
The index cannot be recovered even in the ARCHIVELOG mode.C
The index can only be created if the base table is created with the NOLOGGING option.D
The index can be recovered if you perform a backup after the CREATE INDEX statement.
考题
单选题You manage a SQL Server 2005 database that contains a table with many indexes. You notice that data modification performance has degraded over time. You suspect that some of the indexes are unused. You need to identify which indexes were not used by any queries since the last time SQL Server 2005 started. Which dynamic management view should you use？（）A
sys.dm fts index populationB
sys.dm exec query statsC
sys. dm db index usage statsD
sys.dm db index physical stats
考题
单选题Evaluate the CREATE TABLE statement： CREATE TABLE products （product_id NUMBER （6） CONSTRAINT prod_id_pk PRIMARY KEY， product_name VARCHAR2 （15））； Which statement is true regarding the PROD_ID_PK constraint？（）A
It would be created only if a unique index is manually created first.B
It would be created and would use an automatically created unique index.C
It would be created and would use an automatically created nonunique index.D
It would be created and remains in a disabled state because no index is specified in the command.
考题
单选题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
考题
单选题An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command： SQLCREATE INDEX ord_custname_ix ON orders（custname）； The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test. Which is the most efficient method of performing this task？（）A
disabling the indexB
making the index invisibleC
making the index unusableD
using the MONITORING USAGE clause for the index
考题
单选题A bitmap join index is defined as（）.A
An index used to join two bitmap indexes on a table.B
A bitmap index created for the join of two or more tables.C
A bitmap index created on the join of two or more indexes.D
A bitmap index created on the join of two or more indexed-organized tables.
考题
多选题Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFComposite index on ORDER_ID and ORDER_DATE
热门标签
最新试卷
