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

In which table of INFORMATION_SCHEMA is the information about table index characteristics stored?

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

✅ Correct Answer: 2

What is the join where all possible row combinations are produced?

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

✅ Correct Answer: 4

What is the clause that filters JOIN results called?

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

✅ Correct Answer: 1

What are CROSS JOIN and JOIN are similar to?

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

✅ Correct Answer: 1

The grant table that stores users who can connect to the server and their global privileges are ______

1. user
2. db
3. tables_priv
4. procs_priv

✅ Correct Answer: 1

The stored-routine privileges are contained in _______

1. user
2. db
3. tables_priv
4. procs_priv

✅ Correct Answer: 4

The statement used to obtain access privileges to an account is _______

1. OBTAIN
2. GET
3. GRANT
4. NEED

✅ Correct Answer: 3

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

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 the operation ______

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

✅ Correct Answer: 2

The keyword used with UNION that does not retain duplicate rows is _______

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

✅ Correct Answer: 4

The keyword used with UNION that retains duplicate rows is ________

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

✅ Correct Answer: 1

The log that contains a record of server startups and shutdowns and the messages about exceptional conditions is ______

1. error log
2. general query
3. slow query log
4. binary log

✅ Correct Answer: 1

The log that identifies statements that may be in need of being rewritten for better performance is ________

1. error log
2. general query
3. slow query log
4. binary log

✅ Correct Answer: 3

The default value in seconds in the system variable ‘long_query_time’ is ______

1. 5
2. 10
3. 20
4. 60

✅ Correct Answer: 2

The logging option to enable binary log index file is _______

1. _log-bin-index
2. _bin-log-index
3. _index-log-bin
4. _index-bin-log

✅ Correct Answer: 1

The operators that are used when a subquery returns multiple rows to be evaluated in comparison to the outer query are ____________

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 operations on _____________

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

✅ Correct Answer: 2

What is the kind of delete when deletion of an employee from the table also deletes that employee from another table?

1. transparent
2. concrete
3. elaborate
4. cascaded

✅ Correct Answer: 4

The storage engine in MySQL that provides foreign key support is ___________

1. TRANSACTION
2. InnoDB
3. MyISAM
4. MEMORY

✅ Correct Answer: 2

What is the property of InnoDB that enforces foreign key relationships stay intact?

1. atomicity
2. durability
3. consistency
4. referential integrity

✅ Correct Answer: 4

Which mode exists at both global level and session-specific level?

1. sql_mode
2. key_buffer_size
3. server_mode
4. query_mode

✅ Correct Answer: 1

Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?

1. fast_queue_size
2. general_queue_size
3. slow_queue_size
4. delayed_queue_size

✅ Correct Answer: 4

The largest value to which the variable ‘max_allowed_packet’ can be set is _______

1. 1GB
2. 2GB
3. 4GB
4. 8GB

✅ Correct Answer: 1

Increasing the value of which system variable enables mysqld to keep more tables open simultaneously?

1. table_cache
2. max_connect
3. delayed_queue_size
4. max_allowed_packet

✅ Correct Answer: 1

The keyword used with UNION that retains duplicate rows is ___________

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

✅ Correct Answer: 1

The search mode that uses natural language search as a subroutine is ________

1. Natural language
2. Boolean mode
3. Query expansion
4. Cross mode

✅ Correct Answer: 3

For what can the FULLTEXT indexes be created for?

1. MyISAM
2. InnoDB
3. MEMORY
4. TRANSITION

✅ Correct Answer: 1

For which of these storage engines are configuration options always built?

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

✅ Correct Answer: 4

The storage engine for which the runtime options are always enabled is ______

1. Falcon
2. FEDERATED
3. InnoDB
4. MEMORY

✅ Correct Answer: 4

The most important configurable resource for MyISAM is _____

1. key cache
2. memory cache
3. time cache
4. speed cache

✅ Correct Answer: 1

Which system variable enables mysqld to keep more tables open simultaneously?

1. table_cache
2. max_connect
3. delayed_queue_size
4. max_allowed_packet

✅ Correct Answer: 1

How can a view refer to multiple tables?

1. UNION
2. JOIN
3. GROUP
4. SELECT

✅ Correct Answer: 2

What is the mantissa in -1.58E5?

1. -1.58
2. 1.58
3. E
4. 5

✅ Correct Answer: 1

What is the precision of BIGINT?

1. 32
2. 64
3. 128
4. 16

✅ Correct Answer: 2

How many digits is the DECIMAL used for expressions containing only exact values with fractional part?

1. 32
2. 64
3. 65
4. 16

✅ Correct Answer: 3

The LOCAL capability for client library is enabled by _______

1. _enabled-local-file
2. _enable-local-infile
3. _enable-global-file
4. _enable-local-file

✅ Correct Answer: 2

What is the most important configurable resource for MyISAM?

1. key cache
2. memory cache
3. time cache
4. speed cache

✅ Correct Answer: 1

How many options can be used to control LOCAL capability at runtime?

1. 0
2. 1
3. 2
4. 3

✅ Correct Answer: 3

The mode used to turn off the special meaning of backslash and treat it as an ordinary character is ______

1. NO_ESCAPES_SLASH
2. NO_ESCAPES_BACKSLASH
3. NO_BACKSLASH_ESCAPES
4. NO_BACKSLASH_ESCAPE

✅ Correct Answer: 3

What is x’ffff’ in decimal?

1. 65534
2. 66535
3. 65536
4. 65537

✅ Correct Answer: 3

What are X’61626364′ and X’61626364′?

1. abcd and 1633837924
2. abcd and 4297383361
3. dcba and 1633837924
4. dcba and 4297383361

✅ Correct Answer: 1

The variable which represents the default time zone of the MySQL server is _______

1. time_zone
2. system_time_zone
3. date_and_time
4. system_time

✅ Correct Answer: 1

The number of options that can be used to control LOCAL capability at runtime is _____

1. 0
2. 1
3. 2
4. 3

✅ Correct Answer: 3

If an error occurs during the transaction the troubleshoot is ______

1. delete
2. rollback
3. commit
4. update

✅ Correct Answer: 2

The ‘A’ in the ACID property of transactions is _____

1. Availability
2. Accuracy
3. Adjustability
4. Atomicity

✅ Correct Answer: 4

The ‘C’ in the ACID property of transactions is ____

1. Compound
2. Concrete
3. Collision
4. Consistency

✅ Correct Answer: 4

The datatype that means a variable length non binary string is _____

1. VARCHAR
2. BINARY
3. VARBINARY
4. BLOB

✅ Correct Answer: 1

The date and time datatype that stores time value in ‘hh:mm:ss’ format is ______

1. DATE
2. TIME
3. DATETIME
4. TIMESTAMP

✅ Correct Answer: 2

The spatial datatype used to store a curve is _______

1. GEOMETRY
2. POINT
3. LINESTRING
4. POLYGON

✅ Correct Answer: 3

The option that supplies the pathname to root directory of MySQL installation is _______

1. –basedir
2. –datadir
3. –port
4. –socket

✅ Correct Answer: 1