SQL/SQL MCQ SET 15 Sample Test,Sample questions

Question:
CROSS JOIN and JOIN are similar to __________

1.INNER JOIN

2.NATURAL JOIN

3.OUTER JOIN

4.CARTESIAN JOIN


Question:
In which join all the rows from the left table appear in the output irrespective of the content of the other table?

1.RIGHT JOIN

2.LEFT JOIN

3.INNER JOIN

4.OUTER JOIN


Question:
MySQL stores the database character set and collation attributes in the file _________

1.dp.opt

2.db.opt

3.db.sv

4.db.zip


Question:
Post MySQL 6.0, utf8 was ___________

1.3 bytes

2.4 bytes

3.5 bytes

4.6 bytes


Question:
Prior to MySQL 6.0, utf8 was ___________

1.3 bytes

2.4 bytes

3.8 bytes

4.9 bytes


Question:
SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional?

1.select_list

2.table_list

3.row_constraint

4.grouping_columns


Question:
The ALL subquery performs which operation?

1.row

2.column

3.table

4.database


Question:
The clause that filters JOIN results is called _________

1.WHERE

2.SORT

3.GROUP

4.GROUP BY


Question:
The command which lists databases managed by the server is _____________

1.mysqld

2.mysqlshow

3.mysqllist

4.mysqldb


Question:
The default index type for MEMORY tables is __________

1.HASH

2.SPATIAL

3.FULLTEXT

4.UNIQUE


Question:
The default storage engine used is ____________

1.EXAMPLE

2.ARCHIVE

3.MyISAM

4.NDB


Question:
The facility that allows nesting one select statement into another is called __________

1.nesting

2.binding

3.subquerying

4.encapsulating


Question:
The file created by the server to store the database attributes is __________

1.db.otp

2.dp.zip

3.db.opt

4.db.cls


Question:
The general term for information about databases and the objects in MySQL is _________

1.datum

2.info

3.record

4.metadata


Question:
The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?

1.FILES

2.STATISTICS

3.SCHEMATA

4.VIEWS


Question:
The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ___________

1.CARTESIAN JOIN

2.CROSS JOIN

3.INNER JOIN

4.RIGHT JOIN


Question:
The join where all possible row combinations are produced is called _________

1.INNER JOIN

2.OUTER

3.NATURAL

4.CARTESIAN


Question:
The left and right joins are also known as __________

1.INNER JOIN

2.NATURAL JOIN

3.OUTER JOIN

4.CARTESIAN JOIN


Question:
The option in mysqlshow to show information about indexes in a table is _________

1.–no-data

2.–indexes

3.–keys

4.–flag


Question:
The statement to change the table name is __________

1.CHANGE

2.CHANGENAME

3.CHANGENM

4.RENAME


Question:
To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword?

1.COMBINE

2.CONCAT

3.JOIN

4.UNION


Question:
To create a database only if it doesn’t already exist, which clause is used?

1.IF EXISTS

2.IF NOT EXISTS

3.CREATE EXISTS

4.EXISTS IF


Question:
What does UTF stand for int utf8?

1.Universal Transformation Format

2.Unicode Transformation Format

3.Universal Transformation Formula

4.Unicode Transformation Formula


Question:
What is ‘xyz’ in the following SQL statement?

1.row name

2.column name

3.table name

4.database name


Question:
What is generally used as a synonym for CHARACTER SET?

1.CSET

2.CHSET

3.CHARSET

4.CHCSET


Question:
What is joining a table to itself called?

1.COMPLETE

2.SELF

3.OBSOLETE

4.CROSS


Question:
What is the name of the format file for a table named my_tbl?

1.my_tbl.fmt

2.my_tbl.frm

3.my_tbl.fmr

4.my_tbl.ftm


Question:
Which collations does this MySQL statement list?

1.names beginning with utf8

2.names ending with utf8

3.names containing utf8% anywhere

4.names ending in utf8%


Question:
Which disk data does FILES table in INFORMATION_SCHEMA store?

1.NDB

2.NBD

3.NBK

4.NCD


Question:
Which keyword is the synonym for DATABASE?

1.TABLE

2.OBJECT

3.DB

4.SCHEMA


Question:
Which keyword is used to create a database?

1.CREATE

2.SET

3.SETUP

4.LINK


Question:
Which keyword is used to create a table as a temporary copy of itself?

1.TEMP

2.TEMPO

3.TEMPR

4.TEMPORARY


Question:
Which keyword used with UNION does not retain duplicate rows?

1.ALL

2.NARROW

3.STRICT

4.DISTINCT


Question:
Which MySQL statement is used to find out which character sets are available?

1.SHOW CHARACTER SET

2.SHOW COLLATION

3.SHOW CHARACTER SETS

4.SHOW COLLATIONS


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

1.=

2.==

3.<=

4.>=


Question:
Which of these operators perform similar operations like ALL and ANY?

1.SOME

2.MANY

3.SELECT

4.GROUP


Question:
Which operators are used when a subquery returns multiple rows to be evaluated in comparison to the outer query?

1.IN and NOT IN

2.EXISTS and NOT EXISTS

3.OUTER JOIN and INNER JOIN

4.LEFT JOIN and RIGHT JOIN


Question:
Which operators test whether a subquery returns any rows?

1.IN and NOT IN

2.EXISTS and NOT EXISTS

3.PRESENT

4.ABSENT


Question:
Which statement is used to determine the storage engine for individual tables?

1.SHOW STATUS OF TABLE

2.SHOW STATUS TABLE

3.SHOW TABLE STATUS

4.SHOW DEFAULT STATUS


Question:
Which statement is used to remove indexes on tables?

1.DROP INDEX

2.DELETE INDEX

3.REMOVE INDEX

4.FLUSH INDEX


Question:
Which statement is used to see the definition for an existing database?

1.SHOW CREATE DATABASE

2.SHOW DATABASE

3.SHOW CREATE

4.SHOW CREATE DATABASE TABLE


Question:
Which statement is used to select a default database?

1.USE

2.CREATE

3.DROP

4.SCHEMA


Question:
Which statement is used to show the server’s current character set and collation settings?

1.SHOW CONSTANTS

2.SHOW CONSTRAINTS

3.SHOW VARIABLES

4.DISP VARIABLES


Question:
Which statement makes changes to the database’s global attributes?

1.CHANGE

2.ALTER

3.ALTERNATE

4.UPDATE


Question:
Which storage engine enables to access tables from a MySQL server managed by another server?

1.InnoDB

2.EXAMPLE

3.MyISAM

4.FEDERATED


Question:
Which storage engine is not available in MySQL 5.0?

1.InnoDB

2.ARCHIVE

3.Falcon

4.NDB


Question:
Which subquery cannot be executed by itself as a separate statement?

1.Correlated

2.Uncorrelated

3.EXISTS

4.NOT EXISTS


Question:
Which subquery returns a single value?

1.scalar

2.column

3.row

4.table


Question:
Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?

1.ENGINES, PLUGINS

2.FILES, PLUGINS

3.ENGINES, FILES

4.PLUGINS, STATISTICS


Question:
Which table stores information about the threads executing within the server?

1.PROCESS

2.PROCESSLIST

3.LIST

4.THREADSLIST


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!