SQL/SQL MCQ SET 11 Sample Test,Sample questions

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


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


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


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

1.FROM

2.WHERE

3.ORDER BY

4.All of the mentioned


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

1.YES

2.NO

3.DEPENDS

4.None of the mentioned


Question:
Hexadecimal values assigned to user variables are treated as _______

1.strings

2.non binary strings

3.binary strings

4.integers


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


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

1.WHERE

2.IS

3.SAME

4.LIKE


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

1.makefile

2.dofile

3.putfile

4.pushfile


Question:
The header that should be included first is ________________

1.my_global.h

2.my_sys.h

3.mysql.h

4.my_local.h


Question:
The option that enables multiple-statement execution is ______

1.CLIENT_MULTI_STATEMENTS

2.CLIENT_STATEMENTS_MULTI

3.MULTI_STATEMENTS_CLIENT

4.MULTI_CLIENTS_STATEMENTS


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


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


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

1.-lm

2.-ln

3.-lp

4.-lq


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


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

1.BEGIN…END

2.CASE

3.ITERATE

4.LEAVE


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

1.DESCRIBE

2.LEAVE

3.LOOP

4.RETURN


Question:
What can be used in place of MYSQL_SERVER_VERSION?

1.LIBMYSQL_VERSION

2.LIBMYSQL_VERSION_ID

3.MYSQL_VERSION_ID

4.MYSQL_ID


Question:
What can be used interchangeably with MYSQL_VERSION_ID?

1.LIBMYSQL_VERSION

2.LIBMYSQL_VERSION_ID

3.MYSQL_VERSION_ID

4.MYSQL_ID


Question:
What does ‘mysql_query()’ return on failure?

1.0

2.1

3.-1

4.a non-zero value


Question:
What does mysql_fetch_row() return?

1.integer

2.float

3.structure

4.pointer


Question:
What does mysql_init() return?

1.integer

2.float

3.structure

4.pointer to a structure


Question:
What does mysql_query() return on failure?

1.0

2.1

3.-1

4.a non-zero


Question:
What is the exec_stmt_ssl written in?

1.C++

2.C

3.Python

4.Perl


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


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


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


Question:
What is the type of Audit_log_events system variable?

1.string

2.integer

3.float

4.double


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


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


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


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

1.FALSE

2.Null

3.Depend

4.None of the mentioned


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

1.TRUE

2.Null

3.False

4.None of the mentioned


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

1.TRUE

2.Null

3.FALSE

4.None of the mentioned


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

1.TRUE

2.Null

3.Depend

4.None of the mentioned


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

1.TRUE

2.Null

3.FALSE

4.None of the mentioned


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


Question:
Which among the following is an optional Keyword?

1.DISTINICTS

2.ALL

3.AS

4.Both AS and ALL


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

1.FROM

2.WHERE

3.Both FROM and WHERE

4.None of the mentioned


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


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

1.DISTINCTS

2.MODIFY

3.DISTINCT

4.All of the mentioned


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

1.SELECT

2.WHERE

3.FROM

4.None of the mentioned


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


Question:
Which of the following table exist in Mysql?

1.Permanent Tables

2.Virtual tables

3.Temporary tables

4.All of the mentioned


Question:
Which of these is not a comment specifying construct?

1.#

2./* */

3.—

4.!#


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

1.-e

2.-o

3.-a

4.-b


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

1.DESCRIBE

2.DISPLAY

3.SEE

4.GET


Question:
Which statement exits a labeled flow-control construct?

1.DESCRIBE

2.LEAVE

3.LOOP

4.RETURN


Question:
Which statement terminates the execution of a function?

1.BEGIN…END

2.RETURN

3.ITERATE

4.LOOP


Question:
Which statement upgrades the database directory name encoding?

1.ALTER DATABASE

2.ALTER SERVER

3.ALTER EVENT

4.ALTER FUNCTION


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!