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

The storage in bytes required for VARCHAR(4) type ‘abcd’ is _____

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

✅ Correct Answer: 3

Which mode does not remove trailing spaces when CHAR values are retrieved?

1. PAD_CHAR_TO_FULL_LENGTH
2. TO_FULL_LENGTH_CHAR_PAD
3. CHAR_PAD_TO_FULL_LENGTH
4. PAD_CHAR_TO_LENGTH

✅ Correct Answer: 1

What is the minimum value stored by signed TINYINT?

1. -256
2. -128
3. 0
4. 128

✅ Correct Answer: 2

For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option?

1. –multiple-transaction
2. –single-transaction
3. –double-transaction
4. –no-transaction

✅ Correct Answer: 2

What is used to reload a delimited text data file?

1. mysqldump
2. mysqld
3. mysqlimport
4. mysqlnaive

✅ Correct Answer: 3

What is SBR replication?

1. Statement based
2. Row based
3. Column based
4. Table based

✅ Correct Answer: 1

Which is the library file that contains various portability macros and definitions?

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

✅ Correct Answer: 2

Which is the header that should be included first?

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

✅ Correct Answer: 1

Which of these has special automatic update behavior?

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

✅ Correct Answer: 3

To disallow zero month or day parts in dates, the option used is _______

1. NO_ZERO_IN_DATE
2. NO_DATE_WITH_ZERO
3. ZERO_IN_DATE
4. DATE_WITH_ZERO

✅ Correct Answer: 1

The mode that does not remove trailing spaces when CHAR values are retrieved is ________

1. PAD_CHAR_TO_FULL_LENGTH
2. TO_FULL_LENGTH_CHAR_PAD
3. CHAR_PAD_TO_FULL_LENGTH
4. PAD_CHAR_TO_LENGTH

✅ Correct Answer: 1

The functions in Perl DBI called?

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

✅ Correct Answer: 3

The variable used as a handle to an open file is _______

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

✅ Correct Answer: 3

Which variable is a handle to a database object?

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

✅ Correct Answer: 1

Which classes does spatial data types in MySQL correspond to?

1. OpenGSS
2. OpenGIS
3. ClosedGSS
4. ClosedGIS

✅ Correct Answer: 2

Which type can store a collection of objects of any type?

1. GEOMETRYCOLLECTION
2. MULTIPOINT
3. MULTILINESTRING
4. MULTIPOLYGON

✅ Correct Answer: 1

What is the generic handle whose meaning depends on context?

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

✅ Correct Answer: 4

What is the non handle array representing a row of values?

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

✅ Correct Answer: 4

The mode of search is the search string parsed into words and the search looks for rows is _________

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

✅ Correct Answer: 2

In which mode is the indicator of the presence/absence of a word in search used?

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

✅ Correct Answer: 2

Which operator is used to return value from JSON columns after evaluating the path and unquoting the result?

1. ->
2. ->>
3. <<
4. >>

✅ Correct Answer: 2

Which operator compares sounds?

1. MATCH SOUNDS
2. CHECK SOUNDS
3. SOUNDS LIKE
4. SOUNDS SIMILAR

✅ Correct Answer: 3

What does RTF refer to?

1. Rich Text Format
2. Right Text Format
3. Rich Text Function
4. Right Text Function

✅ Correct Answer: 1

Which function returns an array of row values?

1. fetchrow_array()
2. fetchrow_arrayref()
3. fetch()
4. fetchrow_hashref()

✅ Correct Answer: 1

Which function returns a reference to hash of row values?

1. fetchrow_array()
2. fetchrow_arrayref()
3. fetch()
4. fetchrow_hashref()

✅ Correct Answer: 4

‘fetchrow_hashref()’ returns a reference to the hash of row values keyed by what?

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

✅ Correct Answer: 2

The server is told to accept spaces after function names by _______

1. –sql-mode=SKIP_SPACE
2. –sql-mode=IGNORE_SPACE
3. –sql-mode=SPACE_IGNORE
4. –sql-mode=SPACE_SKIP

✅ Correct Answer: 2

Which function returns NULL if expr1 = expr2?

1. CASE
2. IF()
3. IFNULL()
4. NULLIF()

✅ Correct Answer: 4

The operator that compares sounds is ________

1. MATCH SOUNDS
2. CHECK SOUNDS
3. SOUNDS LIKE
4. SOUNDS SIMILAR

✅ Correct Answer: 3

The string function that returns the index of the first occurrence of substring is ______

1. INSERT()
2. INSTR()
3. INSTRING()
4. INFSTR()

✅ Correct Answer: 2

What does the AUTO_INCREMENT sequences begin at by default?

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

✅ 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 ________

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

✅ Correct Answer: 3

Which system variable when set to 1, makes all temporary tables to get stored on disk rather than in memory?

1. basedir
2. back_log
3. big_tables
4. bind_address

✅ Correct Answer: 3

The permitted value type for the variable ‘character_set_client’ is ________

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

✅ Correct Answer: 4

Which string function returns the index of the first occurrence of substring?

1. INSERT()
2. INSTR()
3. INSTRING()
4. INFSTR()

✅ Correct Answer: 2

Which module links DBI to the web?

1. CGI.pn
2. CGI.pem
3. CGI.pm
4. CGI.po

✅ Correct Answer: 3

What does CGI stand for?

1. Computer Gateway Interface
2. Common Gateway Interface
3. Computer Generated Interface
4. Common Generated Interface

✅ Correct Answer: 2

The line that is written at the top of the script to write a Perl script using CGI.pm is ___________

1. use this CGI
2. put CGI
3. use CGI
4. include CGI

✅ Correct Answer: 3

What is the shebang line?

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

✅ Correct Answer: 1

Which of these is a read only variable?

1. error_count
2. big_tables
3. autocommit
4. foreign_key_checks

✅ Correct Answer: 1

Which variable when set to 1 would enable foreign key checking for InnoDB tables?

1. error_count
2. identity
3. foreign_key_checks
4. autocommit

✅ Correct Answer: 3

The synonym for last_insert_id session variable is ______

1. insert_id
2. identity
3. sql_auto_is_null
4. sql_big_selects

✅ Correct Answer: 2

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

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

✅ Correct Answer: 1

What returns a string containing an error message?

1. mysql_error()
2. mysql_errno()
3. mysql_sqlstate()
4. mysql_close()

✅ Correct Answer: 1

The statement that views status variables by aggregating the values over all connections is _________

1. SHOW SESSION STATUS
2. SHOW LOCAL STATUS
3. SHOW GLOBAL STATUS
4. SHOW STATUS

✅ Correct Answer: 3

Which keyword inserted in the SHOW STATUS statement shows the values for the current connection?

1. GLOBAL
2. SESSION
3. LOCAL
4. DEFAULT

✅ Correct Answer: 2

What is the synonym for last_insert_id session variable?

1. insert_id
2. identity
3. sql_auto_is_null
4. sql_big_selects

✅ Correct Answer: 2

The Audit_log_events system variable is of type ________

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

✅ Correct Answer: 2

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

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

✅ Correct Answer: 2