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

Which keyword used with UNION retains duplicate rows?

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

✅ Correct Answer: 1

Which clause is used to sort a UNION result as a whole?

1. LIMIT
2. ORDER BY
3. GROUP BY
4. SORT

✅ Correct Answer: 2

Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword is used for this?

1. LIMIT
2. RESTRICT
3. COUNT
4. SORT

✅ Correct Answer: 1

Which table is used to run a UNION-type query on MyISAM tables?

1. TRADITIONAL
2. MERGE
3. SERVELET
4. UNITE

✅ Correct Answer: 2

SELECT on a MERGE table is like _____________

1. UNION ALL
2. UNION
3. UNION DISTINCT
4. JOIN

✅ Correct Answer: 1

Which of these is also known as a virtual table?

1. SCHEMA
2. DATABASE
3. JOIN
4. VIEW

✅ Correct Answer: 4

What is xyz in the following MySQL statement?

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

✅ Correct Answer: 3

What is abc in the following MySQL statement?

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

✅ Correct Answer: 2

A view can refer to multiple tables via __________

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

✅ Correct Answer: 2

A view can be deleted using the command __________

1. REMOVE
2. DELETE
3. CLEAR
4. DROP

✅ Correct Answer: 4

What cannot be done on a view?

1. display
2. filter
3. index
4. drop

✅ Correct Answer: 3

What can be used to check for views that have been invalidated by DROP or ALTER operations?

1. CREATE TABLE
2. VERIFY TABLE
3. DETAILS TABLE
4. CHECK TABLE

✅ Correct Answer: 4

Which of the following does not support a materialized view?

1. MySQL
2. Oracle
3. PostgreSQL
4. SybaseSQL

✅ Correct Answer: 1

To perform a delete on a single-table, how is the name of a column qualified?

1. qualification not necessary
2. column name
3. table name
4. database name

✅ Correct Answer: 1

What is xyz in the following SQL statement?

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

✅ Correct Answer: 2

What is abc in the following SQL statement?

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

✅ Correct Answer: 1

What is x in the following MySQL statement?

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

✅ Correct Answer: 2

What is the value of val2 in the following MySQL statement?

1. previous val1
2. updated val1
3. unchanged
4. val1 + 1

✅ Correct Answer: 2

UPDATE statement is a DML statement. What does DML stand for?

1. Data Manipulation Language
2. Data Manipulation Level
3. Data Markup Language
4. Data Markup Level

✅ Correct Answer: 1

Which keyword in the UPDATE statement is used to assign values to columns?

1. ASSIGN
2. SET
3. MARK
4. GET

✅ Correct Answer: 2

Which keyword is used to delete all the rows from the table?

1. TRUNCATE
2. REMOVE
3. DELETE ALL
4. CLEAR

✅ Correct Answer: 1

What is known as the set of SQL statements that either executes successfully or none of them have an effect?

1. joins
2. transactions
3. filters
4. deletions

✅ Correct Answer: 2

What is generally done after the transactions are executed successfully?

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

✅ Correct Answer: 3

What is generally done if an error occurs during the transaction?

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

✅ Correct Answer: 2

What does ‘A’ stand for in the ACID property of transactions?

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

✅ Correct Answer: 4

What does ‘C’ stand for in the ACID property of transactions?

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

✅ Correct Answer: 4

What is the isolation property of transactions?

1. statements form a logic unit
2. database remains consistent
3. one transaction does not affect the other
4. transaction effects are recorded permanently

✅ Correct Answer: 3

What is the command to disable autocommit and launch a transaction?

1. INITIATE TRANSACTION
2. START TRANSACTION
3. DISABLE AUTOCOMMIT
4. TRANSACTION

✅ Correct Answer: 2

What is the durability property of transactions?

1. statements form a logic unit
2. database remains consistent
3. one transaction does not affect the other
4. transaction effects are recorded permanently

✅ Correct Answer: 4

How many storage engines among the following are transaction-safe?

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

✅ Correct Answer: 2

Which key declares that an index in one table is related to that in another?

1. primary
2. secondary
3. foreign
4. cross

✅ Correct Answer: 3

Deletion of an employee from table also deletes that employee from another table. This kind of delete is called ____________

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

✅ Correct Answer: 4

Which storage engine in MySQL provides foreign key support?

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

✅ Correct Answer: 2

The property of InnoDB that enforces foreign key relationships stay intact is called _____________

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

✅ Correct Answer: 4

Which clause names the parent table and the index columns in the table?

1. REFERENCES
2. ON DELETE
3. CONSTRAINT
4. FOREIGN KEY

✅ Correct Answer: 1

Which clause is used to remove a foreign key constraint?

1. REMOVE
2. DELETE
3. DROP
4. EXCLUDE

✅ Correct Answer: 3

Which keyword is used to specify the foreign key after the table is created?

1. SETUP
2. SET
3. ALTER TABLE
4. SPECIFY

✅ Correct Answer: 3

Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key.

1. SET
2. MATCH
3. ON DELETE
4. ON CASCADE

✅ Correct Answer: 2

In which mode of search is the search string parsed into words and the search looks for rows?

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

✅ Correct Answer: 1

The indicator of presence or absence of a word in search is used in which mode?

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

✅ Correct Answer: 2

Which search mode uses natural language search as a subroutine?

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

✅ Correct Answer: 3

FULLTEXT indexes can be created only for ____________

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

✅ Correct Answer: 1

Which keyword is used to search through natural language fulltext?

1. MATCH
2. AGAINST
3. SEARCH
4. FIND

✅ Correct Answer: 1

Which parameter determines the shortest words to index in FULLTEXT indexes?

1. ft_min_word_len
2. ft_min_len_word
3. ft_word_min_len
4. ft_word_len_word

✅ Correct Answer: 1

Which statement is used to access an existing Database?

1. Use
2. use database.name
3. USE databasename;
4. None of the mentioned

✅ Correct Answer: 3

The “Mysql command line tool” format the results in which of the following format?

1. Rectangle
2. Square
3. Sphere
4. None of the mentioned

✅ Correct Answer: 1

The “Mysql command line tool” formats are bounded by _____

1. +-|
2. +-*
3. +-/
4. +-}

✅ Correct Answer: 1

Which command is used on Mysql command line tool to return to window command shell?

1. exit
2. exit;
3. exit()
4. exit();

✅ Correct Answer: 1

Which command is used in Mysql command line tool to return to window command shell?

1. exit;
2. quit;
3. both exit; and quit;
4. only exit;

✅ Correct Answer: 3

Which command is used for taking “server side help” in Mysql command line tool?

1. /h
2. /c
3. /e
4. None of the mentioned

✅ Correct Answer: 1