SQL/SQL MCQ SET 12 Sample Test,Sample questions

Question:
“COUNT” keyword belongs to which categories in Mysql?

1.Aggregate functions

2.Operators

3.Clauses

4.All of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Is “GROUP BY” clause is similar to “ORDER BY” clause?

1.Yes

2.No

3.Depends

4.None of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Keyword “ASC” and “DESC” cannot be used without which clause in Mysql?

1.ORDER BY

2.GROUP BY

3.SELECT

4.HAVING

Posted Date:-2021-07-18 21:18:32


Question:
Select odd one out?

1.Equality Conditions

2.Inequality Conditions

3.Range condition

4.Between

Posted Date:-2021-07-18 21:18:32


Question:
The best datatype for a column that is expected to store values up to 2 million is _________

1.SMALLINT

2.TINYINT

3.MEDIUMINT

4.BIGINT

Posted Date:-2021-07-18 21:18:32


Question:
The function that returns a reference to an array of row values is ______________

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Posted Date:-2021-07-18 21:18:32


Question:
The function that returns reference to hash of row values is ____________

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Posted Date:-2021-07-18 21:18:32


Question:
The log in which data changes received from a replication master server are written is _____

1.error log

2.general query log

3.binary log

4.relay log

Posted Date:-2021-07-18 21:18:32


Question:
The number of files that each end of a client/server connection including SSL support use to set up secure communications is __________

1.0

2.1

3.2

4.3

Posted Date:-2021-07-18 21:18:32


Question:
The program that copies the databases from one server to another is ____________

1.mysqldbcopy

2.mysqlcopydb

3.mysqlflushdb

4.mysqldbflush

Posted Date:-2021-07-18 21:18:32


Question:
The security context when a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access is __________

1.bad

2.good

3.fare

4.illegal

Posted Date:-2021-07-18 21:18:32


Question:
What is the meaning of “Equality Conditions”?

1.Equal to

2.Not equal to

3.Both Equal to and Not equal to

4.None of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
What is the meaning of “GROUP BY” clause in Mysql?

1.Group data by column values

2.Group data by row values

3.Group data by column and row values

4.None of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
What is the meaning of “HAVING” clause in Mysql?

1.To filter out the row values

2.To filter out the column values

3.To filter out the row and column values

4.None of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
What is the meaning of “Inequality Condition”?

1.Not equal to

2.Equal to

3.Both Not equal to and Equal to

4.None of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
What is the meaning of “NULL” in Mysql?

1.Not applicable

2.Value not yet known

3.Value undefined

4.All of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
What is the meaning of “ORDER BY” clause in Mysql?

1.Sorting your result set using column data

2.Aggregation of fields

3.Sorting your result set using row data

4.None of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
What is the meaning of “Range Conditions”?

1.Expression is equal to Expression

2.Expression is not equal to Expression

3.Expression fall under certain range

4.None of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
What is the meaning of the “WHERE” clause in Mysql?

1.Filtering out unwanted rows from result set

2.Filtering out unwanted columns from result set

3.Filtering out unwanted rows and columns from result set

4.None of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
What is the TLS protocol?

1.transparent layer security

2.transport layer security

3.transparent level security

4.transport level security

Posted Date:-2021-07-18 21:18:32


Question:
What will be the output of the following MySQL statement “NOT (Null)”?

1.TRUE

2.Null

3.FALSE

4.None of the mentioned

Posted Date:-2021-07-18 21:18:32


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

1.TRUE

2.Null

3.FALSE

4.None of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Which among the following belongs to an “aggregate function”?

1.COUNT

2.UPPER

3.LOWER

4.All of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Which among the following data types can be used with “Range Condition”?

1.Numeric data type

2.Temporal data type

3.String data type

4.Both Numeric and Temporal data type

Posted Date:-2021-07-18 21:18:32


Question:
Which among the following operators is/are belongs to “Equality conditions”?

1.<>

2.!=

3.=

4.>/<

Posted Date:-2021-07-18 21:18:32


Question:
Which among the following operators is/are belongs to “Inequality conditions”?

1.<>

2.!=

3.=

4.Both <> and !=

Posted Date:-2021-07-18 21:18:32


Question:
Which among the following operators is/are belongs to “Range conditions”?

1.<>

2.!=

3.=

4.>/<

Posted Date:-2021-07-18 21:18:32


Question:
Which clause is similar to “HAVING” clause in Mysql?

1.SELECT

2.WHERE

3.FROM

4.None of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Which clause is used with an “aggregate functions”?

1.GROUP BY

2.SELECT

3.WHERE

4.Both GROUP BY and WHERE

Posted Date:-2021-07-18 21:18:32


Question:
Which grant table scope columns are case insensitive?

1.Host

2.User

3.Password

4.Db

Posted Date:-2021-07-18 21:18:32


Question:
Which keyword is used for sorting the data in ascending order in Mysql?

1.DESC

2.ASC

3.ALTER

4.MODIFY

Posted Date:-2021-07-18 21:18:32


Question:
Which keyword is used for sorting the data in descending order in Mysql?

1.DESC

2.ASC

3.ALTER

4.MODIFY

Posted Date:-2021-07-18 21:18:32


Question:
Which of the following are TCL commands?

1.UPDATE and TRUNCATE

2.SELECT and INSERT

3.GRANT and REVOKE

4.ROLLBACK and SAVEPOINT

Posted Date:-2021-07-18 21:18:32


Question:
Which of the following belongs to an “aggregate function”?

1.COUNT

2.SUM/AVG

3.MIN/MAX

4.All of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Which of the following is not a DDL command?

1.UPDATE

2.TRUNCATE

3.ALTER

4.None of the Mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Which of the following operators is/are used in “Condition Evaluation”?

1.AND

2.OR

3.NOT

4.All of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Which of the following SQL clauses is used to DELETE tuples from a database table?

1.DELETE

2.REMOVE

3.DROP

4.CLEAR

Posted Date:-2021-07-18 21:18:32


Question:
Which of the following statements is/are correct?

1.True AND true =true

2.True AND false= false

3.False AND false= false

4.All of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Which of the following statements is/are correct?

1.True OR true =true

2.True OR false= true

3.False OR false= false

4.All of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Which of the following statements is/are correct?

1.NOT(true)=false

2.NOT(false)=true

3.Both NOT(true)=false and NOT(false)=true

4.None of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Which of the following statements is/are correct?

1.NOT(true AND true) =false

2.NOT(false AND false)=true

3.NOT (true AND false)= true

4.All of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Which of the following statements is/are correct?

1.NOT(true OR true) = false

2.NOT(false OR false)= true

3.NOT (true OR false)= false

4.All of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Which operator is used to check the expression is not “NULL”?

1.IS NULL

2.NOT NULL

3.ON

4.None of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Which operator is used to check whether the expression is “NULL”?

1.IS NULL

2.NOT NULL

3.ON

4.None of the mentioned

Posted Date:-2021-07-18 21:18:32


Question:
Which option is used in mysqldump to make all tables in the destination databases to use a different storage engine?

1.–next-storage-engine

2.–new-storage-engine

3.–clear-storage-engine

4.–get-storage-engine

Posted Date:-2021-07-18 21:18:32


Question:
Which privileges are required on the source server to use mysqldbcopy?

1.CREATE

2.INSERT

3.UPDATE

4.SELECT

Posted Date:-2021-07-18 21:18:32


Question:
Which SQL function is used to count the number of rows in a SQL query?

1.COUNT()

2.NUMBER()

3.SUM()

4.COUNT(*)

Posted Date:-2021-07-18 21:18:32


Question:
Which SQL keyword is used to retrieve a maximum value?

1.MOST

2.TOP

3.MAX

4.UPPER

Posted Date:-2021-07-18 21:18:32


Question:
Which type stores the longest length of strings?

1.CHAR

2.VARCHAR

3.TINYTEXT

4.TEXT

Posted Date:-2021-07-18 21:18:32


Question:
_____removes all rows from a table without logging the individual row deletions.

1.DELETE

2.REMOVE

3.DROP

4.TRUNCATE

Posted Date:-2021-07-18 21:18:32


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!