网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）
A
The index remains invisible.
B
The index is not updated by the DML statements on the indexed table.
C
The index automatically becomes visible in order to have it updated by DML on the table.
D
The index becomes unusable but the table is updated by the DML.
E
The index is updated by the DML on the table.
参考答案
参考解析
解析：
暂无解析
更多 “多选题You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）AThe index remains invisible.BThe index is not updated by the DML statements on the indexed table.CThe index automatically becomes visible in order to have it updated by DML on the table.DThe index becomes unusable but the table is updated by the DML.EThe index is updated by the DML on the table.” 相关考题
考题
They are just () you because you have no problems in school.
A.jealous ofB.invisible toC.superior toD.impatient for
考题
View the Exhibit for some of the parameter settings. You start a session and issue the following command:SQLCREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE;What is the outcome of the above command?（）A. The index is not used by the optimizer but is maintained during DML operations.B. The index is not used by the optimizer and is not maintained during DML operations.C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.
考题
You have a computer that runs Windows Vista Ultimate.You open the Windows System Performance Rating tool and receive a Windows Experience Index base score of 1.0. The subscores are as follows:·Processor: 4.7·Memory (RAM): 3.6·Graphics: 1.0·Gaming Graphics: 1.0·Primary Hard Disk: 3.0You upgrade your video adapter card with a new card that meets the minimum requirements for Windows Aero.You open the System Performance and Rating tool and notice the base score and subscores have not changed.You need to enable Windows Aero.What should you do?（）A.AB.BC.CD.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.
考题
At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）A、 Start the database in OPEN mode， and create a new index tablespace.B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
考题
You executed the following procedure to collect statistics regarding an index： SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（） A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE
考题
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
考题
You issued the following statement to monitor the usage of the index： SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（） A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE
考题
You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）A、 by using the Flashback Database featureB、 by using RMAN incomplete recoveryC、 by performing a user-managed incomplete recoveryD、 by dropping and re-creating the index tablespace
考题
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 altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）A、The index remains invisible.B、The index is not updated by the DML statements on the indexed table.C、The index automatically becomes visible in order to have it updated by DML on the table.D、The index becomes unusable but the table is updated by the DML.E、The index is updated by the DML on the 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 database named named Dworks in the instance. The Dworks database has a table named Bills which contains several indexes and a great amount of rows. An enterprise Web environment is supported by the database. Onthe Bills table 28% of the indexes have been fragmented. You have to defragment the indexes， making sure that you reduce the effect on database availability to the least. In the ALTER INDEX statement， which option should be included？（）A、Sort in tempdb B、Online C、Fill factor D、Pad index
考题
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
考题
多选题On your Oracle 12c database, you Issue the following commands to create indexes SQL CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?（）ABoth the indexes are created; however, only the ORD_COSTOMER index is visible.BThe optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.COnly the ORD_CUSTOMER_IX1 index is created.DOnly the ORD_CUSTOMER_IX2 index is created.EBoth the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
考题
单选题You executed the following procedure to collect statistics regarding an index： SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（）A
INDEX_STATSB
DBA_INDEXESC
DBA_IND_COLUMNSD
V$OBJECT_USAGE
考题
单选题I have altered course to 245 degrees for（）.A
identifyB
identifierC
identityD
identification
考题
多选题In which scenarios would you rebuild an index？（）Awhen you need to disable the index usageBwhen you need to change storage optionsCwhen you need to enable index monitoringDwhen you need to move the index to another tablespace
考题
单选题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.
考题
多选题On your Oracle Database, you issue the following commands to create indexes: SQL CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）AOnly the ORD_CUSTOMER_IX1 index created.BBoth the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.CBoth the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.DThe ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.EBoth the indexes are created and used by the optimizer for queries on the ORDERS table.FBoth the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS 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 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.
考题
单选题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 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.
考题
单选题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 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 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
热门标签
最新试卷