SQL/SQL MCQ SET 11 Sample Test,Sample questions

  1. Home
  2. Back

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

1.FROM

2.WHERE

3.ORDER BY

4.All of the mentioned

Posted Date:-2021-07-19 04:17:45

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

1.YES

2.NO

3.DEPENDS

4.None of the mentioned

Posted Date:-2021-07-19 04:17:45

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

1.strings

2.non binary strings

3.binary strings

4.integers

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

1.WHERE

2.IS

3.SAME

4.LIKE

Posted Date:-2021-07-19 04:17:45

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

1.makefile

2.dofile

3.putfile

4.pushfile

Posted Date:-2021-07-19 04:17:45

Question: 
The header that should be included first is ________________

1.my_global.h

2.my_sys.h

3.mysql.h

4.my_local.h

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

1.-lm

2.-ln

3.-lp

4.-lq

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

1.BEGIN…END

2.CASE

3.ITERATE

4.LEAVE

Posted Date:-2021-07-19 04:17:45

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

1.DESCRIBE

2.LEAVE

3.LOOP

4.RETURN

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

Question: 
What can be used interchangeably with MYSQL_VERSION_ID?

1.LIBMYSQL_VERSION

2.LIBMYSQL_VERSION_ID

3.MYSQL_VERSION_ID

4.MYSQL_ID

Posted Date:-2021-07-19 04:17:45

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

1.0

2.1

3.-1

4.a non-zero value

Posted Date:-2021-07-19 04:17:45

Question: 
What does mysql_fetch_row() return?

1.integer

2.float

3.structure

4.pointer

Posted Date:-2021-07-19 04:17:45

Question: 
What does mysql_init() return?

1.integer

2.float

3.structure

4.pointer to a structure

Posted Date:-2021-07-19 04:17:45

Question: 
What does mysql_query() return on failure?

1.0

2.1

3.-1

4.a non-zero

Posted Date:-2021-07-19 04:17:45

Question: 
What is the exec_stmt_ssl written in?

1.C++

2.C

3.Python

4.Perl

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

Question: 
What is the type of Audit_log_events system variable?

1.string

2.integer

3.float

4.double

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

Question: 
Which among the following is an optional Keyword?

1.DISTINICTS

2.ALL

3.AS

4.Both AS and ALL

Posted Date:-2021-07-19 04:17:45

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

1.FROM

2.WHERE

3.Both FROM and WHERE

4.None of the mentioned

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

1.DISTINCTS

2.MODIFY

3.DISTINCT

4.All of the mentioned

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

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

Posted Date:-2021-07-19 04:17:45

Question: 
Which of the following table exist in Mysql?

1.Permanent Tables

2.Virtual tables

3.Temporary tables

4.All of the mentioned

Posted Date:-2021-07-19 04:17:45

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

1.#

2./* */

3.—

4.!#

Posted Date:-2021-07-19 04:17:45

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

1.-e

2.-o

3.-a

4.-b

Posted Date:-2021-07-19 04:17:45

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

1.DESCRIBE

2.DISPLAY

3.SEE

4.GET

Posted Date:-2021-07-19 04:17:45

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

1.DESCRIBE

2.LEAVE

3.LOOP

4.RETURN

Posted Date:-2021-07-19 04:17:45

Question: 
Which statement terminates the execution of a function?

1.BEGIN…END

2.RETURN

3.ITERATE

4.LOOP

Posted Date:-2021-07-19 04:17:45

Question: 
Which statement upgrades the database directory name encoding?

1.ALTER DATABASE

2.ALTER SERVER

3.ALTER EVENT

4.ALTER FUNCTION

Posted Date:-2021-07-19 04:17:45

Posted on by R4R Team

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!