SQL/SQL MCQ SET 5 Sample Test,Sample questions

Question:
 The shebang line is ______

1.#!

2.!#

3.#$

4.$#


Question:
A synonym for CHARACTER SET is ______

1.CSET

2.CHSET

3.CHARSET

4.CHCSET


Question:
Comparing a known value with NULL results into _______

1.null

2.zero

3.a positive value

4.a negative value


Question:
For failure, mysql_query() returns ______

1.0

2.1

3.-1

4.a non-zero


Question:
In Perl DBI, functions are called ______

1.functions

2.procedures

3.methods

4.programs


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

1.UNION

2.UNION ALL

3.UNION DISTINCT

4.JOIN


Question:
mysql_fetch_row() returns ______

1.integer

2.float

3.structure

4.pointer


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

1.0

2.1

3.-1

4.a non-zero value


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


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

1.integer

2.float

3.structure

4.pointer


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

1.unix only

2.windows only

3.all

4.none


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


Question:
The default path to perl in Unix is ______

1./usr/bin/perl

2./usr/bin

3./usr/perl

4./usr/perl/bin


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

1.libmysqla

2.libmysqlb

3.libmysqlc

4.libmysqld


Question:
The exec_stmt_ssl is written in ______

1.C++

2.C

3.Python

4.Perl


Question:
The general statement-issuing routine is _______

1.mysql_real_query()

2.mysql_query_real()

3.mysql_image_query()

4.mysql_query_image()


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

1.$dbh

2.$sth

3.$fh

4.$h


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


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

1.0

2.1

3.2

4.more than 1


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

1..my.cnf

2..my.ini

3.my.opt

4.my.opc


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

1.$rc

2.$rv

3.$rows

4.$ary


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

1.=

2.==

3.<=

4.>=


Question:
The Perl DBI is _______

1.database inheritance

2.database integrity

3.database interface

4.database isolation


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

1.CHANGE

2.ALTER

3.ALTERNATE

4.UPDATE


Question:
The statement to remove indexes on tables is _______

1.DROP INDEX

2.DELETE INDEX

3.REMOVE INDEX

4.FLUSH INDEX


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

1.RENAME

2.CHANGE

3.CHANGENAME

4.CHANGENM


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

1.DROP INDEX

2.DELETE INDEX

3.REMOVE INDEX

4.FLUSH INDEX


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

1.USE

2.CREATE

3.DROP

4.SCHEMA


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

1.$dbh

2.$sth

3.$fh

4.$h


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

1.COMBINE

2.CONCAT

3.JOIN

4.UNION


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;


Question:
What allows nesting one select statement into another?

1.nesting

2.binding

3.subquerying

4.encapsulating


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

1.integer

2.float

3.structure

4.NULL


Question:
What enables encrypted connections to be established?

1.exec_stmt_ssl

2.exec_ssl_stmt

3.exec_stmnt_ssl

4.exec_ssl_stmnt


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

1.nesting

2.binding

3.subquerying

4.encapsulating


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

1.datum

2.info

3.record

4.metadata


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


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

1..

2._

3.$

4.2


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

1.WHERE

2.IS

3.SAME

4.LIKE


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


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


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


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

1.=

2.==

3.<=

4.>=


Question:
Which option enables multiple-statement execution?

1.CLIENT_MULTI_STATEMENTS

2.CLIENT_STATEMENTS_MULTI

3.MULTI_STATEMENTS_CLIENT

4.MULTI_CLIENTS_STATEMENTS


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


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


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`


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


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

1.$dbh

2.$sth

3.$fh

4.$h


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

1.$rc

2.$rv

3.$rows

4.$ary


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!