A primary key must exist for creation of a clustered index
A clustered index allows fulltext searching within InnoDB
The first unique index is always used as a clustered index and not a primary key
A clustered index provides direct access to a page containing row data
If no indexes exist, a hidden clustered index is generated based on row IDs
A primary key is used as a clustered index
A clustered index is a grouping of indexes from different tables into a global index for faster searching
第1题：
The Cisco AutoQoS feature is being used throughout the Company VOIP network. Which three statements about this feature are true？（）
第2题：
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？（）
第3题：
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
第4题：
Which two statements are true about InnoDB auto-increment locking?（）
第5题：
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？（）
第6题：
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？（）
第7题：
Which two statements are true about constraints? （）
第8题：
A.The auto-increment lock can be a table-level lock
B.InnoDB never uses table-level locks
C.Some settings for innodb_autoinc_lock_mode can help reduce locking
D.InnoDB always protects auto-increment updates with a table-level lock
第9题：
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?（）
第10题：
In which scenario will you create a hash cluster？（）