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

What does mysql_fetch_row() return?

1. integer
2. float
3. structure
4. pointer

✅ Correct Answer: 4

Hexadecimal values assigned to user variables are treated as _______

1. strings
2. non binary strings
3. binary strings
4. integers

✅ Correct Answer: 3

What is the type of Audit_log_events system variable?

1. string
2. integer
3. float
4. double

✅ Correct Answer: 2

The option that enables multiple-statement execution is ______

1. CLIENT_MULTI_STATEMENTS
2. CLIENT_STATEMENTS_MULTI
3. MULTI_STATEMENTS_CLIENT
4. MULTI_CLIENTS_STATEMENTS

✅ Correct Answer: 1

What does mysql_query() return on failure?

1. 0
2. 1
3. -1
4. a non-zero

✅ Correct Answer: 4

Which statement upgrades the database directory name encoding?

1. ALTER DATABASE
2. ALTER SERVER
3. ALTER EVENT
4. ALTER FUNCTION

✅ Correct Answer: 1

The statement that alters an existing event to have the given definition is ______

1. ALTER EVENT
2. ALTER DATABASE
3. ALTER FUNCTION
4. ALTER DATABASE

✅ Correct Answer: 1

What sets up an association between one or more MyISAM tables and the named key cache?

1. BEGIN
2. CACHE INDEX
3. ALTER DATABASE
4. ALTER EVENT

✅ Correct Answer: 2

Which statement can produce the same output as ‘SHOW COLUMNS’?

1. DESCRIBE
2. DISPLAY
3. SEE
4. GET

✅ Correct Answer: 1

The option that executes all SQL statements in a SQL script irrespective of the number of errors is ______________

1. –run
2. –ensure
3. –force
4. –violent

✅ Correct Answer: 3

The clause that is used to display information that matches a given pattern is _____________

1. WHERE
2. IS
3. SAME
4. LIKE

✅ Correct Answer: 4

The header that should be included first is ________________

1. my_global.h
2. my_sys.h
3. mysql.h
4. my_local.h

✅ Correct Answer: 1

What does mysql_init() return?

1. integer
2. float
3. structure
4. pointer to a structure

✅ Correct Answer: 4

The statement that constructs a branching flow-control construct is _____________

1. BEGIN…END
2. CASE
3. ITERATE
4. LEAVE

✅ Correct Answer: 2

Which statement terminates the execution of a function?

1. BEGIN…END
2. RETURN
3. ITERATE
4. LOOP

✅ Correct Answer: 2

Association between one or more MyISAM tables and the named key cache is set by _____________

1. BEGIN
2. CACHE INDEX
3. ALTER DATABASE
4. ALTER EVENT

✅ Correct Answer: 2

Which statement exits a labeled flow-control construct?

1. DESCRIBE
2. LEAVE
3. LOOP
4. RETURN

✅ Correct Answer: 2

What is the exec_stmt_ssl written in?

1. C++
2. C
3. Python
4. Perl

✅ Correct Answer: 2

What does ‘mysql_query()’ return on failure?

1. 0
2. 1
3. -1
4. a non-zero value

✅ Correct Answer: 4

What can be used in place of MYSQL_SERVER_VERSION?

1. LIBMYSQL_VERSION
2. LIBMYSQL_VERSION_ID
3. MYSQL_VERSION_ID
4. MYSQL_ID

✅ Correct Answer: 1

What can be used interchangeably with MYSQL_VERSION_ID?

1. LIBMYSQL_VERSION
2. LIBMYSQL_VERSION_ID
3. MYSQL_VERSION_ID
4. MYSQL_ID

✅ Correct Answer: 2

Which of these is not a comment specifying construct?

1. #
2. /* */
3. —
4. !#

✅ Correct Answer: 4

What sets the association between one or more MyISAM tables and the named key cache?

1. BEGIN
2. CACHE INDEX
3. ALTER DATABASE
4. ALTER EVENT

✅ Correct Answer: 2

The statement that exits a labeled flow-control construct is _____________

1. DESCRIBE
2. LEAVE
3. LOOP
4. RETURN

✅ Correct Answer: 2

The option that executes all SQL statements in a SQL script irrespective of the number of errors is _____________

1. –force
2. –run
3. –ensure
4. –violent

✅ Correct Answer: 1

The option that is necessary to compile a C program having math functions is _____________

1. -lm
2. -ln
3. -lp
4. -lq

✅ Correct Answer: 1

Which option is used for specifying the executable name while compiling with gcc?

1. -e
2. -o
3. -a
4. -b

✅ Correct Answer: 2

The file that can be used to execute multiple compile statements is _________________

1. makefile
2. dofile
3. putfile
4. pushfile

✅ Correct Answer: 1

What is the meaning of “SELECT” clause in Mysql?

1. Show me all Columns and rows
2. Show me all columns
3. Show me all rows
4. None of the mentioned

✅ Correct Answer: 1

Which of the following clause is evaluated in the last by database server?

1. SELECT
2. WHERE
3. FROM
4. None of the mentioned

✅ Correct Answer: 1

Can “SELECT” clause be used without the clause “FROM”?

1. YES
2. NO
3. DEPENDS
4. None of the mentioned

✅ Correct Answer: 2

Which clause is mandatory with clause “SELECT” in Mysql?

1. FROM
2. WHERE
3. Both FROM and WHERE
4. None of the mentioned

✅ Correct Answer: 1

Which among the following can also be included with “SELECT” clause while writing query in Mysql?

1. Literals
2. Expressions
3. User defined functions
4. All of the mentioned

✅ Correct Answer: 4

What is the need of “column Aliases” in “SELECT” clause?

1. To assign a new label to the column in result set
2. To overwrite the existing column name in result set
3. To modify the column name while using literals, Expression, built_in functions with “SELECT clause
4. All of the mentioned

✅ Correct Answer: 4

Which Keyword is used to remove duplicate rows in the result set?

1. DISTINCTS
2. MODIFY
3. DISTINCT
4. All of the mentioned

✅ Correct Answer: 1

Which among the following is an optional Keyword?

1. DISTINICTS
2. ALL
3. AS
4. Both AS and ALL

✅ Correct Answer: 4

How can we define the clause “FROM” in Mysql?

1. It defines the tables used by a query
2. It defines the linking of tables in Mysql
3. It defines the tables used by a query & linking of tables in Mysql
4. None of the mentioned

✅ Correct Answer: 3

Which of the following table exist in Mysql?

1. Permanent Tables
2. Virtual tables
3. Temporary tables
4. All of the mentioned

✅ Correct Answer: 4

“CREATE TABLE …” command is used to create which type of table in Mysql?

1. Permanent Tables
2. Virtual tables
3. Temporary tables
4. All of the mentioned

✅ Correct Answer: 1

“CREATE VIEW …” command is used to create which type of table in Mysql?

1. Permanent Tables
2. Virtual tables
3. Temporary tables
4. All of the mentioned

✅ Correct Answer: 2

What is the meaning of “Temporary Tables” in Mysql?

1. Rows returned by sub query
2. Permanent tables
3. Virtual tables
4. All of the mentioned

✅ Correct Answer: 1

“SELECT” clause cannot be used without which clause in Mysql?

1. FROM
2. WHERE
3. ORDER BY
4. All of the mentioned

✅ Correct Answer: 1

Which of the following statements is/are correct with respect to “VIEW”?

1. “VIEW” is a query that stored in the data dictionary
2. There is no data associated with “VIEW”
3. 'VIEW” creates virtual tables in Database
4. All of the mentioned

✅ Correct Answer: 4

Which command is used to create “Temporary tables” in MySQL?

1. CREATE TABLE;
2. CREATE VIEW
3. Both CREATE TABLE; and CREATE VIEW
4. None of the mentioned

✅ Correct Answer: 4

What is the use of “VIEW” in Mysql?

1. To hide columns from the users
2. To hide the complexity of the database
3. To simplify complexity of database design
4. All of the mentioned

✅ Correct Answer: 4

What will be the output of the following MySQL statement “true AND Null”?

1. TRUE
2. Null
3. Depend
4. None of the mentioned

✅ Correct Answer: 2

What will be the output of the following MySQL statement “false AND Null”?

1. FALSE
2. Null
3. Depend
4. None of the mentioned

✅ Correct Answer: 2

What will be the output of the following MySQL statement “Null AND Null”?

1. TRUE
2. Null
3. FALSE
4. None of the mentioned

✅ Correct Answer: 2

What will be the output of the following MySQL statement “true OR Null”?

1. TRUE
2. Null
3. FALSE
4. None of the mentioned

✅ Correct Answer: 1

What will be the output of the following MySQL statement “false OR Null”?

1. TRUE
2. Null
3. False
4. None of the mentioned

✅ Correct Answer: 2