R4RIN – MCQs, Mock Tests | SQL SQL MCQ SET 15

Which MySQL statement is used to find out which character sets are available?

1. SHOW CHARACTER SET
2. SHOW COLLATION
3. SHOW CHARACTER SETS
4. SHOW COLLATIONS

✅ Correct Answer: 1

Which collations does this MySQL statement list?

1. names beginning with utf8
2. names ending with utf8
3. names containing utf8% anywhere
4. names ending in utf8%

✅ Correct Answer: 1

Which statement is used to show the server’s current character set and collation settings?

1. SHOW CONSTANTS
2. SHOW CONSTRAINTS
3. SHOW VARIABLES
4. DISP VARIABLES

✅ Correct Answer: 3

What does UTF stand for int utf8?

1. Universal Transformation Format
2. Unicode Transformation Format
3. Universal Transformation Formula
4. Unicode Transformation Formula

✅ Correct Answer: 2

Prior to MySQL 6.0, utf8 was ___________

1. 3 bytes
2. 4 bytes
3. 8 bytes
4. 9 bytes

✅ Correct Answer: 1

Post MySQL 6.0, utf8 was ___________

1. 3 bytes
2. 4 bytes
3. 5 bytes
4. 6 bytes

✅ Correct Answer: 2

What is generally used as a synonym for CHARACTER SET?

1. CSET
2. CHSET
3. CHARSET
4. CHCSET

✅ Correct Answer: 3

Which statement is used to select a default database?

1. USE
2. CREATE
3. DROP
4. SCHEMA

✅ Correct Answer: 1

Which keyword is the synonym for DATABASE?

1. TABLE
2. OBJECT
3. DB
4. SCHEMA

✅ Correct Answer: 4

Which keyword is used to create a database?

1. CREATE
2. SET
3. SETUP
4. LINK

✅ Correct Answer: 1

The file created by the server to store the database attributes is __________

1. db.otp
2. dp.zip
3. db.opt
4. db.cls

✅ Correct Answer: 3

To create a database only if it doesn’t already exist, which clause is used?

1. IF EXISTS
2. IF NOT EXISTS
3. CREATE EXISTS
4. EXISTS IF

✅ Correct Answer: 2

MySQL stores the database character set and collation attributes in the file _________

1. dp.opt
2. db.opt
3. db.sv
4. db.zip

✅ Correct Answer: 2

Which statement is used to see the definition for an existing database?

1. SHOW CREATE DATABASE
2. SHOW DATABASE
3. SHOW CREATE
4. SHOW CREATE DATABASE TABLE

✅ Correct Answer: 1

Which statement makes changes to the database’s global attributes?

1. CHANGE
2. ALTER
3. ALTERNATE
4. UPDATE

✅ Correct Answer: 2

Which statement is used to remove indexes on tables?

1. DROP INDEX
2. DELETE INDEX
3. REMOVE INDEX
4. FLUSH INDEX

✅ Correct Answer: 1

Which storage engine is not available in MySQL 5.0?

1. InnoDB
2. ARCHIVE
3. Falcon
4. NDB

✅ Correct Answer: 3

The default storage engine used is ____________

1. EXAMPLE
2. ARCHIVE
3. MyISAM
4. NDB

✅ Correct Answer: 3

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

1. my_tbl.fmt
2. my_tbl.frm
3. my_tbl.fmr
4. my_tbl.ftm

✅ Correct Answer: 2

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

1. TEMP
2. TEMPO
3. TEMPR
4. TEMPORARY

✅ Correct Answer: 4

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

1. InnoDB
2. EXAMPLE
3. MyISAM
4. FEDERATED

✅ Correct Answer: 4

The default index type for MEMORY tables is __________

1. HASH
2. SPATIAL
3. FULLTEXT
4. UNIQUE

✅ Correct Answer: 1

The statement to change the table name is __________

1. CHANGE
2. CHANGENAME
3. CHANGENM
4. RENAME

✅ Correct Answer: 4

The general term for information about databases and the objects in MySQL is _________

1. datum
2. info
3. record
4. metadata

✅ Correct Answer: 4

Which statement is used to determine the storage engine for individual tables?

1. SHOW STATUS OF TABLE
2. SHOW STATUS TABLE
3. SHOW TABLE STATUS
4. SHOW DEFAULT STATUS

✅ Correct Answer: 3

Which disk data does FILES table in INFORMATION_SCHEMA store?

1. NDB
2. NBD
3. NBK
4. NCD

✅ Correct Answer: 1

The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?

1. FILES
2. STATISTICS
3. SCHEMATA
4. VIEWS

✅ Correct Answer: 2

Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?

1. ENGINES, PLUGINS
2. FILES, PLUGINS
3. ENGINES, FILES
4. PLUGINS, STATISTICS

✅ Correct Answer: 1

Which table stores information about the threads executing within the server?

1. PROCESS
2. PROCESSLIST
3. LIST
4. THREADSLIST

✅ Correct Answer: 2

The command which lists databases managed by the server is _____________

1. mysqld
2. mysqlshow
3. mysqllist
4. mysqldb

✅ Correct Answer: 2

The option in mysqlshow to show information about indexes in a table is _________

1. –no-data
2. –indexes
3. –keys
4. –flag

✅ Correct Answer: 3

SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional?

1. select_list
2. table_list
3. row_constraint
4. grouping_columns

✅ Correct Answer: 1

The join where all possible row combinations are produced is called _________

1. INNER JOIN
2. OUTER
3. NATURAL
4. CARTESIAN

✅ Correct Answer: 4

The clause that filters JOIN results is called _________

1. WHERE
2. SORT
3. GROUP
4. GROUP BY

✅ Correct Answer: 1

CROSS JOIN and JOIN are similar to __________

1. INNER JOIN
2. NATURAL JOIN
3. OUTER JOIN
4. CARTESIAN JOIN

✅ Correct Answer: 1

The left and right joins are also known as __________

1. INNER JOIN
2. NATURAL JOIN
3. OUTER JOIN
4. CARTESIAN JOIN

✅ Correct Answer: 3

What is joining a table to itself called?

1. COMPLETE
2. SELF
3. OBSOLETE
4. CROSS

✅ Correct Answer: 2

In which join all the rows from the left table appear in the output irrespective of the content of the other table?

1. RIGHT JOIN
2. LEFT JOIN
3. INNER JOIN
4. OUTER JOIN

✅ Correct Answer: 2

The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ___________

1. CARTESIAN JOIN
2. CROSS JOIN
3. INNER JOIN
4. RIGHT JOIN

✅ Correct Answer: 4

The facility that allows nesting one select statement into another is called __________

1. nesting
2. binding
3. subquerying
4. encapsulating

✅ Correct Answer: 3

Which subquery returns a single value?

1. scalar
2. column
3. row
4. table

✅ Correct Answer: 1

Which operators are used when a subquery returns multiple rows to be evaluated in comparison to the outer query?

1. IN and NOT IN
2. EXISTS and NOT EXISTS
3. OUTER JOIN and INNER JOIN
4. LEFT JOIN and RIGHT JOIN

✅ Correct Answer: 1

The ALL subquery performs which operation?

1. row
2. column
3. table
4. database

✅ Correct Answer: 2

Which of these operators perform similar operations like ALL and ANY?

1. SOME
2. MANY
3. SELECT
4. GROUP

✅ Correct Answer: 1

Which operators test whether a subquery returns any rows?

1. IN and NOT IN
2. EXISTS and NOT EXISTS
3. PRESENT
4. ABSENT

✅ Correct Answer: 2

Which subquery cannot be executed by itself as a separate statement?

1. Correlated
2. Uncorrelated
3. EXISTS
4. NOT EXISTS

✅ Correct Answer: 1

Which of these operators does not perform relative-value comparisons?

1. =
2. ==
3. <=
4. >=

✅ Correct Answer: 2

To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword?

1. COMBINE
2. CONCAT
3. JOIN
4. UNION

✅ Correct Answer: 4

What is ‘xyz’ in the following SQL statement?

1. row name
2. column name
3. table name
4. database name

✅ Correct Answer: 2

Which keyword used with UNION does not retain duplicate rows?

1. ALL
2. NARROW
3. STRICT
4. DISTINCT

✅ Correct Answer: 4