SQL/SQL MCQ SET 11 Sample Test,Sample questions

  1. Home

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

Posted on by Online Exam TestTeam

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
Olete Team
Online Exam TestTop Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on Online Exam Testwebsite 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!