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

The argument to the function mysql_error() is ________

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

✅ Correct Answer: 4

What does mysql_real_connect() return if it fails?

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

✅ Correct Answer: 4

The –protocol value ‘TCP’ runs on which operating systems?

1. unix only
2. windows only
3. all
4. none

✅ Correct Answer: 3

The general statement-issuing routine is _______

1. mysql_real_query()
2. mysql_query_real()
3. mysql_image_query()
4. mysql_query_image()

✅ Correct Answer: 1

For failure, mysql_query() returns ______

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

✅ Correct Answer: 4

mysql_fetch_row() returns ______

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

✅ Correct Answer: 4

What enables encrypted connections to be established?

1. exec_stmt_ssl
2. exec_ssl_stmt
3. exec_stmnt_ssl
4. exec_ssl_stmnt

✅ Correct Answer: 1

The exec_stmt_ssl is written in ______

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

✅ Correct Answer: 2

On failure, ‘mysql_query()’ returns ______

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

✅ Correct Answer: 4

Which mode prevents MySQL to perform full checking of date parts?

1. PREVENT_DATE_CHECK
2. STOP_DATES_CHECK
3. ALLOW_DATES_INVALID
4. ALLOW_INVALID_DATES

✅ Correct Answer: 4

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

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

✅ Correct Answer: 1

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

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

✅ Correct Answer: 1

The embedded server library containing the MySQL server linkable into applications is ______

1. libmysqla
2. libmysqlb
3. libmysqlc
4. libmysqld

✅ Correct Answer: 4

When building from source, the embedded server library is enabled by _____

1. with-embedded-server
2. with-server-embedded
3. with-embedded-library
4. with-library-embedded

✅ Correct Answer: 1

Which clause is used to display information that matches a given pattern?

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

✅ Correct Answer: 4

Comparing a known value with NULL results into _______

1. null
2. zero
3. a positive value
4. a negative value

✅ Correct Answer: 1

Which is the command to move the cursor to the beginning of line in mysql input editor?

1. Ctrl-E
2. Ctrl-D
3. Esc-a
4. Ctrl-A

✅ Correct Answer: 4

The name of the option file in Unix is ______

1. .my.cnf
2. .my.ini
3. my.opt
4. my.opc

✅ Correct Answer: 1

System variable in MySQL server that enables to configure the SQL mode is ____

1. sql_mode
2. sql_config
3. sql_server
4. sql_enable

✅ Correct Answer: 1

Which option enables multiple-statement execution?

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

✅ Correct Answer: 1

Which option executes all SQL statements in a SQL script irrespective of the number of errors?

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

✅ Correct Answer: 2

To see the table structure which command is issued?

1. VIEW tbl_name;
2. SELECT TABLE tbl_name;
3. SELECT tbl_name;
4. DESCRIBE tbl_name;

✅ Correct Answer: 4

Which character is illegal in naming an unquoted identifier in SQL?

1. .
2. _
3. $
4. 2

✅ Correct Answer: 1

Which statement is valid if ‘`sampledb`’ is a database and ‘`tbl`’ is a table in it?

1. SELECT * FROM `sampledb.member`
2. SELECT * FROM `sampledb`.`member`
3. SELECT * FROM `member`.`sampledb`
4. SELECT * FROM `member.sampledb`

✅ Correct Answer: 2

The default case sensitivity of the database and table names depends on ___________

1. Server SQL mode
2. Operating system of machine
3. Does not depend on anything
4. SQL server

✅ Correct Answer: 2

The maximum collations a character set can have is ______________

1. 0
2. 1
3. 2
4. more than 1

✅ Correct Answer: 4

A synonym for CHARACTER SET is ______

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

✅ Correct Answer: 3

The statement used to select a default database is ______

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

✅ Correct Answer: 1

The statement that makes changes to the global attributes of the database is ______

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

✅ Correct Answer: 2

The statement used to remove indexes on tables is _____

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

✅ Correct Answer: 1

The statement used to change the table name is ____

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

✅ Correct Answer: 1

What is the general term for information about databases and the objects in MySQL?

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

✅ Correct Answer: 4

The shebang line is ______

1. #!
2. !#
3. #$
4. $#

✅ Correct Answer: 1

The Perl DBI is _______

1. database inheritance
2. database integrity
3. database interface
4. database isolation

✅ Correct Answer: 3

The default path to perl in Unix is ______

1. /usr/bin/perl
2. /usr/bin
3. /usr/perl
4. /usr/perl/bin

✅ Correct Answer: 1

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

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

✅ Correct Answer: 4

What is the facility that allows nesting one select statement into another?

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

✅ Correct Answer: 3

Which of these operators does not perform relative value comparisons?

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

✅ Correct Answer: 2

To combine multiple retrievals, which keyword is used to write several SELECT statements between them?

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

✅ Correct Answer: 4

Issuing ‘SELECT’ on a MERGE table is like ______

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

✅ Correct Answer: 2

In Perl DBI, functions are called ______

1. functions
2. procedures
3. methods
4. programs

✅ Correct Answer: 3

Which variable is used as a handle to an open file?

1. $dbh
2. $sth
3. $fh
4. $h

✅ Correct Answer: 3

The variable that is a handle to a database object is ______

1. $dbh
2. $sth
3. $fh
4. $h

✅ Correct Answer: 1

Which variable returns code from operations that return true or false?

1. $rc
2. $rv
3. $rows
4. $ary

✅ Correct Answer: 1

The statement to remove indexes on tables is _______

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

✅ Correct Answer: 1

What allows nesting one select statement into another?

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

✅ Correct Answer: 3

The operator that does not perform relative-value comparisons is ________

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

✅ Correct Answer: 2

The key declares that an index in one table is related to that in another is called ______

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

✅ Correct Answer: 3

The generic handle whose meaning depends on context is _____

1. $dbh
2. $sth
3. $fh
4. $h

✅ Correct Answer: 4

The non handle array representing a row of values is ________

1. $rc
2. $rv
3. $rows
4. $ary

✅ Correct Answer: 4