多选题The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?()AA primary key must exist for creation of a clustered indexBA clustered index allows fulltext searching within InnoDBCThe first unique index is always used as a clustered index and not a primary keyDA clustered index provides direct access to a page containing row dataEIf no indexes exist, a hidden clustered index is generated based on row IDsFA primary key is used as a clustered indexGA clustered index is a grouping of indexes from different tables into a global index for faster searching

多选题
The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?()
A

A primary key must exist for creation of a clustered index

B

A clustered index allows fulltext searching within InnoDB

C

The first unique index is always used as a clustered index and not a primary key

D

A clustered index provides direct access to a page containing row data

E

If no indexes exist, a hidden clustered index is generated based on row IDs

F

A primary key is used as a clustered index

G

A clustered index is a grouping of indexes from different tables into a global index for faster searching


参考解析

解析: 暂无解析

相关考题:

The InnoDB engine has a feature known as clustered indexes.Which three statements are true about clustered indexes as used in InnoDB?() A.A primary key must exist for creation of a clustered indexB.A clustered index allows fulltext searching within InnoDBC.The first unique index is always used as a clustered index and not a primary keyD.A clustered index provides direct access to a page containing row dataE.If no indexes exist, a hidden clustered index is generated based on row IDsF.A primary key is used as a clustered indexG.A clustered index is a grouping of indexes from different tables into a global index for faster searching

Which two statements are true about InnoDB auto-increment locking?() A.The auto-increment lock can be a table-level lockB.InnoDB never uses table-level locksC.Some settings for innodb_autoinc_lock_mode can help reduce lockingD.InnoDB always protects auto-increment updates with a table-level lock

The Cisco AutoQoS feature is being used throughout the Company VOIP network.  Which three  statements about this feature are true?()A、The "mls qos" global configuration command must be entered before configuring AutoQoS.B、CEF must be enabled.C、The "no auto qos voip" command is used to disable Cisco AutoQos and revoke all  configurations generated by Cisco AutoQos.D、CDP must be enabled.E、SNMP must be enabled.

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 table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key.  So what action should you perform to achieve this goal?()  A、You should drop the XML index on the table. Modify the primary key. Recreate the XML index B、You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. C、You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. D、You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.

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

Which two statements are true about constraints? ()A、The UNIQUE constraint does not permit a null value for the column.B、A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.C、The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.D、The NOT NULL constraint ensures that null values are not permitted for the column.

You executed the following code:   SQL CERATE TABLE COUNTRY   (COUNTRY_ID CHAR(2) CONSTRAINT COUNTRY_ID_nn NOT NULL,   COUNTRY_NAME VARCHAR2(20),   CURRENCY_NAME VARCHAR2(20),   CONSTRAINT COUNTRY_ID_PK PRIMARY KEY (COUNTRY_ID))   ORGANIZATION INDEX;   Which types of tables will be created automatically?()A、 journal tableB、 clustered tableC、 mapping tableD、 partitioned table

You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell> mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell> mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell> mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?()A、It exports tables with the most indexes first to assist with import speedsB、It ensures that unique indexes have no conflicts when the data is dumpedC、It orders by primary key to assist in speeding up importing to InnoDB tablesD、It must be specified so index data is dumped correctly when –on-create-info is used

Which two statements are true about InnoDB auto-increment locking?()A、The auto-increment lock can be a table-level lockB、InnoDB never uses table-level locksC、Some settings for innodb_autoinc_lock_mode can help reduce lockingD、InnoDB always protects auto-increment updates with a table-level lock

In which scenario will you create a hash cluster?()A、 when you want the data to be returned automatically in chronological orderB、 if the application uses queries joining tables only occasionallyC、 if the queries against the clustered table use the equality operator (=) to retrieve the desired rowD、 if the full table scan is executed often on only one of the clustered tables

Which two statements are true about the WebLogic Cluster ?()A、 Clustered Servers capacity can be increased by adding new server instance to the cluster on an existing machineB、 Clustered Servers can be on a same or different machine with same operating system onlyC、 Clustered Servers can only be on a same machine or different operating systemD、 Clustered Servers can be on a same or different machine with same or different operating system

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

The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?()A、A primary key must exist for creation of a clustered indexB、A clustered index allows fulltext searching within InnoDBC、The first unique index is always used as a clustered index and not a primary keyD、A clustered index provides direct access to a page containing row dataE、If no indexes exist, a hidden clustered index is generated based on row IDsF、A primary key is used as a clustered indexG、A clustered index is a grouping of indexes from different tables into a global index for faster searching

You work for a bank that uses a SQL Server 2005 database to store line items from customer banking transactions. The bank processes 50,000 transactions every day. The application requires a clustered index on the TransactionID column. You need to create a table that supports an efficient reporting solution that queries the transactions by date. What are the two ways to achieve this goal?()A、Place a nonclustered index on the date column.B、Add a unique clustered index on the date column.C、Map each partition to a filegroup, with each filegroup accessing a different physical drive.D、Create a partitioning scheme that partitions the data by date.

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

多选题You work for a bank that uses a SQL Server 2005 database to store line items from customer banking transactions. The bank processes 50,000 transactions every day. The application requires a clustered index on the TransactionID column. You need to create a table that supports an efficient reporting solution that queries the transactions by date. What are the two ways to achieve this goal?()APlace a nonclustered index on the date column.BAdd a unique clustered index on the date column.CMap each partition to a filegroup, with each filegroup accessing a different physical drive.DCreate a partitioning scheme that partitions the data by date.

多选题Which two statements are true about InnoDB auto-increment locking?()AThe auto-increment lock can be a table-level lockBInnoDB never uses table-level locksCSome settings for innodb_autoinc_lock_mode can help reduce lockingDInnoDB always protects auto-increment updates with a table-level lock

多选题Examine the following output: SQL SELECT index_name,status FROM dba_indexes WHERE status=’UNUSABLE’; INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true()AIt is ignored by the query optimizer.BIt is not used while the index is being rebuilt.CThe index cannot be rebuilt, and has to be re-created.DThe index is automatically rebuilt when used the next time

单选题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?()AThe clustered index of the Orders table should be dropped.BThe clustered index of the Orders table offline should be rebuilt once a month.CThe clustered index of the Orders table should be excluded from scheduled reorganizing or rebuilding operations.DThe clustered index of the Orders table should be reorganized by reducing the fill factor.

多选题Which two statements are true about constraints? ()AThe UNIQUE constraint does not permit a null value for the column.BA UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.CThe PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.DThe NOT NULL constraint ensures that null values are not permitted for the column.

单选题In which scenario will you create a hash cluster?()A when you want the data to be returned automatically in chronological orderB if the application uses queries joining tables only occasionallyC if the queries against the clustered table use the equality operator (=) to retrieve the desired rowD if the full table scan is executed often on only one of the clustered tables

多选题The Cisco AutoQoS feature is being used throughout the Company VOIP network.  Which three  statements about this feature are true?()AThe mls qos global configuration command must be entered before configuring AutoQoS.BCEF must be enabled.CThe no auto qos voip command is used to disable Cisco AutoQos and revoke all  configurations generated by Cisco AutoQos.DCDP must be enabled.ESNMP must be enabled.

单选题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

多选题Which two statements are true about the primary key constraint in a table? ()AIt is not possible to disable the primary key constraint.BIt is possible to have more than one primary key constraint in a single table.CThe primary key constraint can be referred by only one foreign key constraint.DThe primary key constraint can be imposed by combining more than one column.EThe non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.

多选题The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?()AA primary key must exist for creation of a clustered indexBA clustered index allows fulltext searching within InnoDBCThe first unique index is always used as a clustered index and not a primary keyDA clustered index provides direct access to a page containing row dataEIf no indexes exist, a hidden clustered index is generated based on row IDsFA primary key is used as a clustered indexGA clustered index is a grouping of indexes from different tables into a global index for faster searching

单选题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 executed the following code:   SQL CERATE TABLE COUNTRY   (COUNTRY_ID CHAR(2) CONSTRAINT COUNTRY_ID_nn NOT NULL,   COUNTRY_NAME VARCHAR2(20),   CURRENCY_NAME VARCHAR2(20),   CONSTRAINT COUNTRY_ID_PK PRIMARY KEY (COUNTRY_ID))   ORGANIZATION INDEX;   Which types of tables will be created automatically?()A journal tableB clustered tableC mapping tableD partitioned table