Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 13 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

The statement to change the table name is __________

A. CHANGE
B. CHANGENAME
C. CHANGENM
D. RENAME
Answer» E.
Discussion
2.

The default index type for MEMORY tables is __________

A. HASH
B. SPATIAL
C. FULLTEXT
D. UNIQUE
Answer» B. SPATIAL
Discussion
3.

It is possible to drop multiple tables in the same statement.

A. True
B. False
Answer» B. False
Discussion
4.

THE_DEFAULT_INDEX_TYPE_FOR_MEMORY_TABLES_IS___________?$

A. HASH
B. SPATIAL
C. FULLTEXT
D. UNIQUE
Answer» B. SPATIAL
Discussion
5.

The_statement_to_change_the_table_name_is___________$

A. CHANGE
B. CHANGENAME
C. CHANGENM
D. RENAME
Answer» E.
Discussion
6.

It is possible to drop multiple tables in the same statement?

A. True
B. False
Answer» B. False
Discussion
7.

Which storage engine enables to access tables from a MySQL server managed by another server?

A. InnoDB
B. EXAMPLE
C. MyISAM
D. FEDERATED
Answer» E.
Discussion
8.

Which keyword is used to create a table as a temporary copy of itself?

A. TEMP
B. TEMPO
C. TEMPR
D. TEMPORARY
Answer» E.
Discussion
9.

In the CREATE TABLE statement, the engine name specified is case sensitive.

A. True
B. False
Answer» C.
Discussion
10.

What is the name of the format file for a table named my_tbl?

A. my_tbl.fmt
B. my_tbl.frm
C. my_tbl.fmr
D. my_tbl.ftm
Answer» C. my_tbl.fmr
Discussion
11.

The default storage engine used is ____________

A. EXAMPLE
B. ARCHIVE
C. MyISAM
D. NDB
Answer» D. NDB
Discussion
12.

Which storage engine is not available in MySQL 5.0?

A. InnoDB
B. ARCHIVE
C. Falcon
D. NDB
Answer» D. NDB
Discussion
13.

Which statement is used to remove indexes on tables?

A. DROP INDEX
B. DELETE INDEX
C. REMOVE INDEX
D. FLUSH INDEX
Answer» B. DELETE INDEX
Discussion