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