CROSS JOIN and JOIN are similar to __________
1.INNER JOIN
2.NATURAL JOIN
3.OUTER JOIN
4.CARTESIAN JOIN
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
MySQL stores the database character set and collation attributes in the file _________
1.dp.opt
2.db.opt
3.db.sv
4.db.zip
Post MySQL 6.0, utf8 was ___________
1.3 bytes
2.4 bytes
3.5 bytes
4.6 bytes
Prior to MySQL 6.0, utf8 was ___________
1.3 bytes
2.4 bytes
3.8 bytes
4.9 bytes
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
The ALL subquery performs which operation?
1.row
2.column
3.table
4.database
The clause that filters JOIN results is called _________
1.WHERE
2.SORT
3.GROUP
4.GROUP BY
The command which lists databases managed by the server is _____________
1.mysqld
2.mysqlshow
3.mysqllist
4.mysqldb
The default index type for MEMORY tables is __________
1.HASH
2.SPATIAL
3.FULLTEXT
4.UNIQUE
The default storage engine used is ____________
1.EXAMPLE
2.ARCHIVE
3.MyISAM
4.NDB
The facility that allows nesting one select statement into another is called __________
1.nesting
2.binding
3.subquerying
4.encapsulating
The file created by the server to store the database attributes is __________
1.db.otp
2.dp.zip
3.db.opt
4.db.cls
The general term for information about databases and the objects in MySQL is _________
1.datum
2.info
3.record
4.metadata
The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?
1.FILES
2.STATISTICS
3.SCHEMATA
4.VIEWS
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
The join where all possible row combinations are produced is called _________
1.INNER JOIN
2.OUTER
3.NATURAL
4.CARTESIAN
The left and right joins are also known as __________
1.INNER JOIN
2.NATURAL JOIN
3.OUTER JOIN
4.CARTESIAN JOIN
The option in mysqlshow to show information about indexes in a table is _________
1.–no-data
2.–indexes
3.–keys
4.–flag
The statement to change the table name is __________
1.CHANGE
2.CHANGENAME
3.CHANGENM
4.RENAME
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
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
What does UTF stand for int utf8?
1.Universal Transformation Format
2.Unicode Transformation Format
3.Universal Transformation Formula
4.Unicode Transformation Formula
What is ‘xyz’ in the following SQL statement?
1.row name
2.column name
3.table name
4.database name
What is generally used as a synonym for CHARACTER SET?
1.CSET
2.CHSET
3.CHARSET
4.CHCSET
What is joining a table to itself called?
1.COMPLETE
2.SELF
3.OBSOLETE
4.CROSS
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
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%
Which disk data does FILES table in INFORMATION_SCHEMA store?
1.NDB
2.NBD
3.NBK
4.NCD
Which keyword is the synonym for DATABASE?
1.TABLE
2.OBJECT
3.DB
4.SCHEMA
Which keyword is used to create a database?
1.CREATE
2.SET
3.SETUP
4.LINK
Which keyword is used to create a table as a temporary copy of itself?
1.TEMP
2.TEMPO
3.TEMPR
4.TEMPORARY
Which keyword used with UNION does not retain duplicate rows?
1.ALL
2.NARROW
3.STRICT
4.DISTINCT
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
Which of these operators does not perform relative-value comparisons?
1.=
2.==
3.<=
4.>=
Which of these operators perform similar operations like ALL and ANY?
1.SOME
2.MANY
3.SELECT
4.GROUP
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
Which operators test whether a subquery returns any rows?
1.IN and NOT IN
2.EXISTS and NOT EXISTS
3.PRESENT
4.ABSENT
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
Which statement is used to remove indexes on tables?
1.DROP INDEX
2.DELETE INDEX
3.REMOVE INDEX
4.FLUSH INDEX
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
Which statement is used to select a default database?
1.USE
2.CREATE
3.DROP
4.SCHEMA
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
Which statement makes changes to the database’s global attributes?
1.CHANGE
2.ALTER
3.ALTERNATE
4.UPDATE
Which storage engine enables to access tables from a MySQL server managed by another server?
1.InnoDB
2.EXAMPLE
3.MyISAM
4.FEDERATED
Which storage engine is not available in MySQL 5.0?
1.InnoDB
2.ARCHIVE
3.Falcon
4.NDB
Which subquery cannot be executed by itself as a separate statement?
1.Correlated
2.Uncorrelated
3.EXISTS
4.NOT EXISTS
Which subquery returns a single value?
1.scalar
2.column
3.row
4.table
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
Which table stores information about the threads executing within the server?
1.PROCESS
2.PROCESSLIST
3.LIST
4.THREADSLIST