网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
当需要重建某个索引ix_customername,可以使用()方式。
A
ALTER INDEX ix_customername REBUILD
B
ALTER INDEX ix_customername BUILD
C
UPDATE INDEX ix_customername BUILD
D
UPDATE INDEX ix_customername REBUILD
参考答案
参考解析
解析:
暂无解析
更多 “单选题当需要重建某个索引ix_customername,可以使用()方式。A ALTER INDEX ix_customername REBUILDB ALTER INDEX ix_customername BUILDC UPDATE INDEX ix_customername BUILDD UPDATE INDEX ix_customername REBUILD” 相关考题
考题
( 31 )下列 SQL 语句中,哪一(些)组包含了不正确的定义语句?I . CREATE TABLE … CREATE VIEW … CREATE INDEX …II . DROP TABLE … DROP VIEW … DROP INDEX …III . ALTER TABLE … ALTER VIEW … ALTER INDEX …A )只有 IB )只有 IIC )只有 IIID ) I 和 II
考题
(32)下列 SQL 的数据定义语句组中,( )包含了不正确的数据定义语句。Ⅰ.CREATE TABLE? CREATE VIEW? CREATE INDEX?Ⅱ.DROP TABLE? DROP VIEW? DROP INDEX?Ⅲ.ALTER TABLE? ALTER VIEW? ALTER INDEX?A)仅ⅠB)仅ⅡC)仅ⅢD)都包含
考题
下列SQL语句中,包含了不正确定义语句的组是( )。Ⅰ. CREATE TABLE CREATE VIEW CREATE INDEXⅡ. DROP TABLE DROP VIEW DROP INDEXⅢ. ALTER TABLE ALTER VIEW ALTER INDEXA)只有IB)只有ⅡC)只有ⅢD)Ⅰ和Ⅱ
考题
下列SQL的数据定义语句组中,哪一(些)组包含了不正确的数据定义语句?Ⅰ.CREATE TABLE… CREATE VIEW… CREATE INDEX…Ⅱ.DROP TABLE… DROP VIEW… DROP INDEX…Ⅲ.ALTER TABLE… ALTER VIEW… ALTER INDEX…A.仅ⅠB.仅ⅡC.仅ⅢD.都包含
考题
下列SQL的数据定义语句组中,哪一组是正确的?A.CREATE SCHEMA...,DROP SCHEMA…,ALTER SCHEMA…B.CREATE TABLE......,DROP TABLE....,ALTER TABLE....C.CREATE VIEW..:,DROP VIEW...,ALTER VIEW…D.CREATE INDEX...,DROP INDEX…,ALTER INDEX…
考题
下列SQL语言的定义语句组中,哪一(些)组包含了不正确的定义语句?I . CREATE TABLE...CREATE VIEW... CREATE INDEX...Ⅱ. DROP TABLE... DROP VIEW... DROP INDEX...Ⅲ. ALTER TABLE...ALTER VIEW...ALTER INDEX...
考题
当需要重建某个索引ix_customername,可以使用()方式。
A.ALTER INDEX ix_customername REBUILDB.ALTER INDEX ix_customername BUILDC.UPDATE INDEX ix_customername BUILDD.UPDATE INDEX ix_customername REBUILD
考题
在下列SQL语句中,( )包含了不正确的定义语句。Ⅰ、CREATE TABLE CREATE VIEW CREATE INDEXⅡ、DROP TABLE DROP VIEW DROP INDEXⅢ、ALTER TABLE ALTER VIEW ALTER INDEXA)Ⅰ和ⅡB)只有ⅡC)只有ⅢD)Ⅱ和Ⅲ
考题
“雇员”表在LAST_NAME列上有一个名为LN_IDX的索引。您要将此索引更改为FIRST_NAME列的索引。以下哪条SQL语句将实现此操作()A、ALTER INDEX ln_idx ON employees(first_name)B、ALTER INDEX ln_idx TO employees(first_name)C、ALTER INDEX ln_idx TO fn_idx ON employees(first_name)D、以上都不能;您无法变更索引
考题
You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX: SQL ALTER INDEX EMP_NO_INDX REBUILD ONLINE; Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation?() A、 Index-organized tableB、 Mapping TableC、 Clustered TableD、 Journal Table
考题
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.
考题
Which statement describes the effect on an index, when the indexed column for the rows is updatedin the base table()A、An update in a leaf row takes place.B、The index becomes invalid after the update.C、The leaf block containing the row to be updated is marked as invalid.D、A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
考题
为了监视索引的空间使用效率,可以首先分析该索引的结构,使用()语句,然后查询INDEX_STATE视图。A、SELECT INDEX … VALIDATE STRUCTUREB、ANALYZE INDEX … VALIDATE STRUCTUREC、UPDATE INDEX … VALIDATE STRUCTURED、REBUILD INDEX … VALIDATE STRUCTURE
考题
The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan?()A、ALTER TABLE employees monitor index employee_idx_fk; B、ALTER INDEX employee_idx_fk monitoring on; C、ALTER TABLE employees monitor all indexes; D、ALTER INDEX employee_idx_fk monitoring usage;
考题
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
考题
当需要重建某个索引ix_customername,可以使用()方式。A、ALTER INDEX ix_customername REBUILDB、ALTER INDEX ix_customername BUILDC、UPDATE INDEX ix_customername BUILDD、UPDATE INDEX ix_customername REBUILD
考题
An index-organized table (IOT) called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed, while minimizing the impact for users?()A、EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.B、ALTER TABLE … COALESCE ;C、ALTER INDEX …REBUILD ONLINE;D、CREATE TABLE …AS SELECT_ONLINE;
考题
单选题Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?()A
Oracle Data Pump.B
An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.C
An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.D
Online Table Redefinition.E
Edition-Based Table Redefinition.
考题
单选题Which statement describes the effect on an index, when the indexed column for the rows is updatedin the base table()A
An update in a leaf row takes place.B
The index becomes invalid after the update.C
The leaf block containing the row to be updated is marked as invalid.D
A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
考题
单选题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.
考题
单选题You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX: SQL ALTER INDEX EMP_NO_INDX REBUILD ONLINE; Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation?()A
Index-organized tableB
Mapping TableC
Clustered TableD
Journal Table
考题
单选题为了监视索引的空间使用效率,可以首先分析该索引的结构,使用()语句,然后查询INDEX_STATE视图。A
SELECT INDEX … VALIDATE STRUCTUREB
ANALYZE INDEX … VALIDATE STRUCTUREC
UPDATE INDEX … VALIDATE STRUCTURED
REBUILD INDEX … VALIDATE STRUCTURE
考题
单选题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
热门标签
最新试卷