SQL/SQL MCQ SET 5 Sample Test,Sample questions

Question:
 The shebang line is ______

1.#!

2.!#

3.#$

4.$#

Posted Date:-2021-07-18 21:13:06


Question:
A synonym for CHARACTER SET is ______

1.CSET

2.CHSET

3.CHARSET

4.CHCSET

Posted Date:-2021-07-18 21:13:06


Question:
Comparing a known value with NULL results into _______

1.null

2.zero

3.a positive value

4.a negative value

Posted Date:-2021-07-18 21:13:06


Question:
For failure, mysql_query() returns ______

1.0

2.1

3.-1

4.a non-zero

Posted Date:-2021-07-18 21:13:06


Question:
In Perl DBI, functions are called ______

1.functions

2.procedures

3.methods

4.programs

Posted Date:-2021-07-18 21:13:06


Question:
Issuing ‘SELECT’ on a MERGE table is like ______

1.UNION

2.UNION ALL

3.UNION DISTINCT

4.JOIN

Posted Date:-2021-07-18 21:13:06


Question:
mysql_fetch_row() returns ______

1.integer

2.float

3.structure

4.pointer

Posted Date:-2021-07-18 21:13:06


Question:
On failure, ‘mysql_query()’ returns ______

1.0

2.1

3.-1

4.a non-zero value

Posted Date:-2021-07-18 21:13:06


Question:
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

Posted Date:-2021-07-18 21:13:06


Question:
The argument to the function mysql_error() is ________

1.integer

2.float

3.structure

4.pointer

Posted Date:-2021-07-18 21:13:06


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

1.unix only

2.windows only

3.all

4.none

Posted Date:-2021-07-18 21:13:06


Question:
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

Posted Date:-2021-07-18 21:13:06


Question:
The default path to perl in Unix is ______

1./usr/bin/perl

2./usr/bin

3./usr/perl

4./usr/perl/bin

Posted Date:-2021-07-18 21:13:06


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

1.libmysqla

2.libmysqlb

3.libmysqlc

4.libmysqld

Posted Date:-2021-07-18 21:13:06


Question:
The exec_stmt_ssl is written in ______

1.C++

2.C

3.Python

4.Perl

Posted Date:-2021-07-18 21:13:06


Question:
The general statement-issuing routine is _______

1.mysql_real_query()

2.mysql_query_real()

3.mysql_image_query()

4.mysql_query_image()

Posted Date:-2021-07-18 21:13:06


Question:
The generic handle whose meaning depends on context is _____

1.$dbh

2.$sth

3.$fh

4.$h

Posted Date:-2021-07-18 21:13:06


Question:
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

Posted Date:-2021-07-18 21:13:06


Question:
The maximum collations a character set can have is ______________

1.0

2.1

3.2

4.more than 1

Posted Date:-2021-07-18 21:13:06


Question:
The name of the option file in Unix is ______

1..my.cnf

2..my.ini

3.my.opt

4.my.opc

Posted Date:-2021-07-18 21:13:06


Question:
The non handle array representing a row of values is ________

1.$rc

2.$rv

3.$rows

4.$ary

Posted Date:-2021-07-18 21:13:06


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

1.=

2.==

3.<=

4.>=

Posted Date:-2021-07-18 21:13:06


Question:
The Perl DBI is _______

1.database inheritance

2.database integrity

3.database interface

4.database isolation

Posted Date:-2021-07-18 21:13:06


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

1.CHANGE

2.ALTER

3.ALTERNATE

4.UPDATE

Posted Date:-2021-07-18 21:13:06


Question:
The statement to remove indexes on tables is _______

1.DROP INDEX

2.DELETE INDEX

3.REMOVE INDEX

4.FLUSH INDEX

Posted Date:-2021-07-18 21:13:06


Question:
The statement used to change the table name is ____

1.RENAME

2.CHANGE

3.CHANGENAME

4.CHANGENM

Posted Date:-2021-07-18 21:13:06


Question:
The statement used to remove indexes on tables is _____

1.DROP INDEX

2.DELETE INDEX

3.REMOVE INDEX

4.FLUSH INDEX

Posted Date:-2021-07-18 21:13:06


Question:
The statement used to select a default database is ______

1.USE

2.CREATE

3.DROP

4.SCHEMA

Posted Date:-2021-07-18 21:13:06


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

1.$dbh

2.$sth

3.$fh

4.$h

Posted Date:-2021-07-18 21:13:06


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

1.COMBINE

2.CONCAT

3.JOIN

4.UNION

Posted Date:-2021-07-18 21:13:06


Question:
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;

Posted Date:-2021-07-18 21:13:06


Question:
What allows nesting one select statement into another?

1.nesting

2.binding

3.subquerying

4.encapsulating

Posted Date:-2021-07-18 21:13:06


Question:
What does mysql_real_connect() return if it fails?

1.integer

2.float

3.structure

4.NULL

Posted Date:-2021-07-18 21:13:06


Question:
What enables encrypted connections to be established?

1.exec_stmt_ssl

2.exec_ssl_stmt

3.exec_stmnt_ssl

4.exec_ssl_stmnt

Posted Date:-2021-07-18 21:13:06


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

1.nesting

2.binding

3.subquerying

4.encapsulating

Posted Date:-2021-07-18 21:13:06


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

1.datum

2.info

3.record

4.metadata

Posted Date:-2021-07-18 21:13:06


Question:
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

Posted Date:-2021-07-18 21:13:06


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

1..

2._

3.$

4.2

Posted Date:-2021-07-18 21:13:06


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

1.WHERE

2.IS

3.SAME

4.LIKE

Posted Date:-2021-07-18 21:13:06


Question:
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

Posted Date:-2021-07-18 21:13:06


Question:
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

Posted Date:-2021-07-18 21:13:06


Question:
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

Posted Date:-2021-07-18 21:13:06


Question:
Which of these operators does not perform relative value comparisons?

1.=

2.==

3.<=

4.>=

Posted Date:-2021-07-18 21:13:06


Question:
Which option enables multiple-statement execution?

1.CLIENT_MULTI_STATEMENTS

2.CLIENT_STATEMENTS_MULTI

3.MULTI_STATEMENTS_CLIENT

4.MULTI_CLIENTS_STATEMENTS

Posted Date:-2021-07-18 21:13:06


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

1.ensure

2.force

3.violent

4.run

Posted Date:-2021-07-18 21:13:06


Question:
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

Posted Date:-2021-07-18 21:13:06


Question:
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`

Posted Date:-2021-07-18 21:13:06


Question:
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

Posted Date:-2021-07-18 21:13:06


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

1.$dbh

2.$sth

3.$fh

4.$h

Posted Date:-2021-07-18 21:13:06


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

1.$rc

2.$rv

3.$rows

4.$ary

Posted Date:-2021-07-18 21:13:06


More MCQS

  1. SQL MCQ SET 1
  2. SQL MCQ SET 2
  3. SQL MCQ SET 3
  4. SQL MCQ SET 4
  5. SQL MCQ SET 5
  6. SQL MCQ SET 6
  7. SQL MCQ SET 7
  8. SQL MCQ SET 8
  9. SQL MCQ SET 9
  10. SQL MCQ SET 10
  11. SQL MCQ SET 11
  12. SQL MCQ SET 12
  13. SQL MCQ SET 13
  14. SQL MCQ SET 14
  15. SQL MCQ SET 15
  16. SQL MCQ SET 16
  17. SQL MCQ SET 17
  18. SQL MCQ SET 18
  19. MCQ | SQL – Basics
  20. MCQ | SQL – Data Types
  21. SQL Server DBA Multiple Choice Questions
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!