For what can the FULLTEXT indexes be created for?
1.MyISAM
2.InnoDB
3.MEMORY
4.TRANSITION
For which of these storage engines are configuration options always built?
1.Falcon
2.FEDERATED
3.InnoDB
4.MyISAM
How can a view refer to multiple tables?
1.UNION
2.JOIN
3.GROUP
4.SELECT
How many digits is the DECIMAL used for expressions containing only exact values with fractional part?
1.32
2.64
3.65
4.16
How many options can be used to control LOCAL capability at runtime?
1.0
2.1
3.2
4.3
If an error occurs during the transaction the troubleshoot is ______
1.delete
2.rollback
3.commit
4.update
In which table of INFORMATION_SCHEMA is the information about table index characteristics stored?
1.FILES
2.STATISTICS
3.SCHEMATA
4.VIEWS
Increasing the value of which system variable enables mysqld to keep more tables open simultaneously?
1.table_cache
2.max_connect
3.delayed_queue_size
4.max_allowed_packet
The ALL subquery performs operations on _____________
1.row
2.column
3.table
4.database
The ALL subquery performs the operation ______
1.row
2.column
3.table
4.database
The ‘A’ in the ACID property of transactions is _____
1.Availability
2.Accuracy
3.Adjustability
4.Atomicity
The ‘C’ in the ACID property of transactions is ____
1.Compound
2.Concrete
3.Collision
4.Consistency
The datatype that means a variable length non binary string is _____
1.VARCHAR
2.BINARY
3.VARBINARY
4.BLOB
The date and time datatype that stores time value in ‘hh:mm:ss’ format is ______
1.DATE
2.TIME
3.DATETIME
4.TIMESTAMP
The default value in seconds in the system variable ‘long_query_time’ is ______
1.5
2.10
3.20
4.60
The grant table that stores users who can connect to the server and their global privileges are ______
1.user
2.db
3.tables_priv
4.procs_priv
The keyword used with UNION that does not retain duplicate rows is _______
1.ALL
2.NARROW
3.STRICT
4.DISTINCT
The keyword used with UNION that retains duplicate rows is ________
1.ALL
2.NARROW
3.STRICT
4.DISTINCT
The keyword used with UNION that retains duplicate rows is ___________
1.ALL
2.NARROW
3.STRICT
4.DISTINCT
The largest value to which the variable ‘max_allowed_packet’ can be set is _______
1.1GB
2.2GB
3.4GB
4.8GB
The LOCAL capability for client library is enabled by _______
1._enabled-local-file
2._enable-local-infile
3._enable-global-file
4._enable-local-file
The log that contains a record of server startups and shutdowns and the messages about exceptional conditions is ______
1.error log
2.general query
3.slow query log
4.binary log
The log that identifies statements that may be in need of being rewritten for better performance is ________
1.error log
2.general query
3.slow query log
4.binary log
The logging option to enable binary log index file is _______
1._log-bin-index
2._bin-log-index
3._index-log-bin
4._index-bin-log
The mode used to turn off the special meaning of backslash and treat it as an ordinary character is ______
1.NO_ESCAPES_SLASH
2.NO_ESCAPES_BACKSLASH
3.NO_BACKSLASH_ESCAPES
4.NO_BACKSLASH_ESCAPE
The most important configurable resource for MyISAM is _____
1.key cache
2.memory cache
3.time cache
4.speed cache
The number of options that can be used to control LOCAL capability at runtime is _____
1.0
2.1
3.2
4.3
The operators that are used when a subquery returns multiple rows to be evaluated in comparison to the outer query are ____________
1.IN and NOT IN
2.EXISTS and NOT EXISTS
3.OUTER JOIN and INNER JOIN
4.LEFT JOIN and RIGHT JOIN
The operators used when a subquery returns multiple rows to be evaluated in comparison to the outer query are _______
1.IN and NOT IN
2.EXISTS and NOT EXISTS
3.OUTER JOIN and INNER JOIN
4.LEFT JOIN and RIGHT JOIN
The option that supplies the pathname to root directory of MySQL installation is _______
1.–basedir
2.–datadir
3.–port
4.–socket
The search mode that uses natural language search as a subroutine is ________
1.Natural language
2.Boolean mode
3.Query expansion
4.Cross mode
The spatial datatype used to store a curve is _______
1.GEOMETRY
2.POINT
3.LINESTRING
4.POLYGON
The statement used to obtain access privileges to an account is _______
1.OBTAIN
2.GET
3.GRANT
4.NEED
The storage engine for which the runtime options are always enabled is ______
1.Falcon
2.FEDERATED
3.InnoDB
4.MEMORY
The storage engine in MySQL that provides foreign key support is ___________
1.TRANSACTION
2.InnoDB
3.MyISAM
4.MEMORY
The stored-routine privileges are contained in _______
1.user
2.db
3.tables_priv
4.procs_priv
The variable which represents the default time zone of the MySQL server is _______
1.time_zone
2.system_time_zone
3.date_and_time
4.system_time
What are CROSS JOIN and JOIN are similar to?
1.INNER JOIN
2.NATURAL JOIN
3.OUTER JOIN
4.CARTESIAN JOIN
What are X’61626364′ and X’61626364′?
1.abcd and 1633837924
2.abcd and 4297383361
3.dcba and 1633837924
4.dcba and 4297383361
What is the clause that filters JOIN results called?
1.WHERE
2.SORT
3.GROUP
4.GROUP BY
What is the join where all possible row combinations are produced?
1.INNER JOIN
2.OUTER
3.NATURAL
4.CARTESIAN
What is the kind of delete when deletion of an employee from the table also deletes that employee from another table?
1.transparent
2.concrete
3.elaborate
4.cascaded
What is the mantissa in -1.58E5?
1.-1.58
2.1.58
3.E
4.5
What is the most important configurable resource for MyISAM?
1.key cache
2.memory cache
3.time cache
4.speed cache
What is the precision of BIGINT?
1.32
2.64
3.128
4.16
What is the property of InnoDB that enforces foreign key relationships stay intact?
1.atomicity
2.durability
3.consistency
4.referential integrity
What is x’ffff’ in decimal?
1.65534
2.66535
3.65536
4.65537
Which mode exists at both global level and session-specific level?
1.sql_mode
2.key_buffer_size
3.server_mode
4.query_mode
Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?
1.fast_queue_size
2.general_queue_size
3.slow_queue_size
4.delayed_queue_size
Which system variable enables mysqld to keep more tables open simultaneously?
1.table_cache
2.max_connect
3.delayed_queue_size
4.max_allowed_packet