For what can the FULLTEXT indexes be created for?
1.MyISAM
2.InnoDB
3.MEMORY
4.TRANSITION
Posted Date:-2021-07-19 04:14:50
For which of these storage engines are configuration options always built?
1.Falcon
2.FEDERATED
3.InnoDB
4.MyISAM
Posted Date:-2021-07-19 04:14:50
How can a view refer to multiple tables?
1.UNION
2.JOIN
3.GROUP
4.SELECT
Posted Date:-2021-07-19 04:14:50
How many digits is the DECIMAL used for expressions containing only exact values with fractional part?
1.32
2.64
3.65
4.16
Posted Date:-2021-07-19 04:14:50
How many options can be used to control LOCAL capability at runtime?
1.0
2.1
3.2
4.3
Posted Date:-2021-07-19 04:14:50
If an error occurs during the transaction the troubleshoot is ______
1.delete
2.rollback
3.commit
4.update
Posted Date:-2021-07-19 04:14:50
In which table of INFORMATION_SCHEMA is the information about table index characteristics stored?
1.FILES
2.STATISTICS
3.SCHEMATA
4.VIEWS
Posted Date:-2021-07-19 04:14:50
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
Posted Date:-2021-07-19 04:14:50
The ALL subquery performs operations on _____________
1.row
2.column
3.table
4.database
Posted Date:-2021-07-19 04:14:50
The ALL subquery performs the operation ______
1.row
2.column
3.table
4.database
Posted Date:-2021-07-19 04:14:50
The ‘A’ in the ACID property of transactions is _____
1.Availability
2.Accuracy
3.Adjustability
4.Atomicity
Posted Date:-2021-07-19 04:14:50
The ‘C’ in the ACID property of transactions is ____
1.Compound
2.Concrete
3.Collision
4.Consistency
Posted Date:-2021-07-19 04:14:50
The datatype that means a variable length non binary string is _____
1.VARCHAR
2.BINARY
3.VARBINARY
4.BLOB
Posted Date:-2021-07-19 04:14:50
The date and time datatype that stores time value in ‘hh:mm:ss’ format is ______
1.DATE
2.TIME
3.DATETIME
4.TIMESTAMP
Posted Date:-2021-07-19 04:14:50
The default value in seconds in the system variable ‘long_query_time’ is ______
1.5
2.10
3.20
4.60
Posted Date:-2021-07-19 04:14:50
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
Posted Date:-2021-07-19 04:14:50
The keyword used with UNION that does not retain duplicate rows is _______
1.ALL
2.NARROW
3.STRICT
4.DISTINCT
Posted Date:-2021-07-19 04:14:50
The keyword used with UNION that retains duplicate rows is ________
1.ALL
2.NARROW
3.STRICT
4.DISTINCT
Posted Date:-2021-07-19 04:14:50
The keyword used with UNION that retains duplicate rows is ___________
1.ALL
2.NARROW
3.STRICT
4.DISTINCT
Posted Date:-2021-07-19 04:14:50
The largest value to which the variable ‘max_allowed_packet’ can be set is _______
1.1GB
2.2GB
3.4GB
4.8GB
Posted Date:-2021-07-19 04:14:50
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
Posted Date:-2021-07-19 04:14:50
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
Posted Date:-2021-07-19 04:14:50
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
Posted Date:-2021-07-19 04:14:50
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
Posted Date:-2021-07-19 04:14:50
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
Posted Date:-2021-07-19 04:14:50
The most important configurable resource for MyISAM is _____
1.key cache
2.memory cache
3.time cache
4.speed cache
Posted Date:-2021-07-19 04:14:50
The number of options that can be used to control LOCAL capability at runtime is _____
1.0
2.1
3.2
4.3
Posted Date:-2021-07-19 04:14:50
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
Posted Date:-2021-07-19 04:14:50
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
Posted Date:-2021-07-19 04:14:50
The option that supplies the pathname to root directory of MySQL installation is _______
1.–basedir
2.–datadir
3.–port
4.–socket
Posted Date:-2021-07-19 04:14:50
The search mode that uses natural language search as a subroutine is ________
1.Natural language
2.Boolean mode
3.Query expansion
4.Cross mode
Posted Date:-2021-07-19 04:14:50
The spatial datatype used to store a curve is _______
1.GEOMETRY
2.POINT
3.LINESTRING
4.POLYGON
Posted Date:-2021-07-19 04:14:50
The statement used to obtain access privileges to an account is _______
1.OBTAIN
2.GET
3.GRANT
4.NEED
Posted Date:-2021-07-19 04:14:50
The storage engine for which the runtime options are always enabled is ______
1.Falcon
2.FEDERATED
3.InnoDB
4.MEMORY
Posted Date:-2021-07-19 04:14:50
The storage engine in MySQL that provides foreign key support is ___________
1.TRANSACTION
2.InnoDB
3.MyISAM
4.MEMORY
Posted Date:-2021-07-19 04:14:50
The stored-routine privileges are contained in _______
1.user
2.db
3.tables_priv
4.procs_priv
Posted Date:-2021-07-19 04:14:50
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
Posted Date:-2021-07-19 04:14:50
What are 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:14:50
What are X’61626364′ and X’61626364′?
1.abcd and 1633837924
2.abcd and 4297383361
3.dcba and 1633837924
4.dcba and 4297383361
Posted Date:-2021-07-19 04:14:50
What is the clause that filters JOIN results called?
1.WHERE
2.SORT
3.GROUP
4.GROUP BY
Posted Date:-2021-07-19 04:14:50
What is the join where all possible row combinations are produced?
1.INNER JOIN
2.OUTER
3.NATURAL
4.CARTESIAN
Posted Date:-2021-07-19 04:14:50
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
Posted Date:-2021-07-19 04:14:50
What is the mantissa in -1.58E5?
1.-1.58
2.1.58
3.E
4.5
Posted Date:-2021-07-19 04:14:50
What is the most important configurable resource for MyISAM?
1.key cache
2.memory cache
3.time cache
4.speed cache
Posted Date:-2021-07-19 04:14:50
What is the precision of BIGINT?
1.32
2.64
3.128
4.16
Posted Date:-2021-07-19 04:14:50
What is the property of InnoDB that enforces foreign key relationships stay intact?
1.atomicity
2.durability
3.consistency
4.referential integrity
Posted Date:-2021-07-19 04:14:50
What is x’ffff’ in decimal?
1.65534
2.66535
3.65536
4.65537
Posted Date:-2021-07-19 04:14:50
Which mode exists at both global level and session-specific level?
1.sql_mode
2.key_buffer_size
3.server_mode
4.query_mode
Posted Date:-2021-07-19 04:14:50
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
Posted Date:-2021-07-19 04:14:50
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
Posted Date:-2021-07-19 04:14:50