Mysql
Share
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
What is the meaning of “SELECT” clause in Mysql?
(a) Show me all Columns and rows
(b) Show me all columns
(c) Show me all rows
(d) None of the mentioned
Right option is (a) Show me all Columns and rowsTo explain I would say: None.
Right option is (a) Show me all Columns and rows
To explain I would say: None.
See lessA DEFAULT value cannot be supplied to spatial types.
(a) True
(b) False
This question was posed to me in an interview.
Origin of the question is MySQL Data Types in section Data Types of MySQL
Correct choice is (a) TrueThe explanation: For every data type except the BLOB and TEXT types, spatial types, or columns with the AUTO_INCREMENT attribute, a DEFAULT def_value clause can be specified to keep a default value for a column.
Correct choice is (a) True
The explanation: For every data type except the BLOB and TEXT types, spatial types, or columns with the AUTO_INCREMENT attribute, a DEFAULT def_value clause can be specified to keep a default value for a column.
See lessThe SQL mode to check for divide by zero error is ________________
(a) STRICT_ALL_TABLES
(b) ERROR_FOR_DIVISION_BY_ZERO
(c) ERROR_DIVIDE_BY_ZERO
(d) ERROR_WHEN_DIVIDE_BY_ZERO
Right answer is (b) ERROR_FOR_DIVISION_BY_ZEROTo explain: To enable the check for divide by zero errors int all the storage engines, the SQL mode named ‘ERROR_FOR_DIVISION_BY_ZERO’ can be enabled. This is done by using SET sql_mode = ‘mode_name’.
Right answer is (b) ERROR_FOR_DIVISION_BY_ZERO
To explain: To enable the check for divide by zero errors int all the storage engines, the SQL mode named ‘ERROR_FOR_DIVISION_BY_ZERO’ can be enabled. This is done by using SET sql_mode = ‘mode_name’.
See lessWhich of these values is not valid as an AUTO_INCREMENT value?
(a) 0
(b) 1
(c) 2
(d) 3
The correct option is (a) 0Explanation: In MySQL, the ‘AUTO_INCREMENT’ values are a sequence of unique values assigned to the columns such that they increase monotonically. They begin with the value 1 and increment by a unit.
The correct option is (a) 0
Explanation: In MySQL, the ‘AUTO_INCREMENT’ values are a sequence of unique values assigned to the columns such that they increase monotonically. They begin with the value 1 and increment by a unit.
See lessWhich mode does not remove trailing spaces when CHAR values are retrieved?
(a) PAD_CHAR_TO_FULL_LENGTH
(b) TO_FULL_LENGTH_CHAR_PAD
(c) CHAR_PAD_TO_FULL_LENGTH
(d) PAD_CHAR_TO_LENGTH
Right choice is (a) PAD_CHAR_TO_FULL_LENGTHFor explanation: When the CHAR values are stored, they are right-padded with spaces to the specified length. When CHAR values are retrieved, trailing spaces are removed unless the SQL mode ‘PAD_CHAR_TO_FULL_LENGTH’ is enabled.
Right choice is (a) PAD_CHAR_TO_FULL_LENGTH
For explanation: When the CHAR values are stored, they are right-padded with spaces to the specified length. When CHAR values are retrieved, trailing spaces are removed unless the SQL mode ‘PAD_CHAR_TO_FULL_LENGTH’ is enabled.
See lessFor which of these storage engines are configuration options always built?
(a) Falcon
(b) FEDERATED
(c) InnoDB
(d) MyISAM
Correct choice is (d) MyISAMTo explain I would say: The configuration options for the storage engine ‘MyISAM’ are always built. The runtime options for MyISAM are also always enabled. For the others, runtime options are explicitly enabled.
Correct choice is (d) MyISAM
To explain I would say: The configuration options for the storage engine ‘MyISAM’ are always built. The runtime options for MyISAM are also always enabled. For the others, runtime options are explicitly enabled.
See lessWhen the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called __________
(a) good
(b) bad
(c) illegal
(d) fare
Correct choice is (a) goodExplanation: The security context is good if it enables carefully written stored programs to be set up that provide controlled access to tables for users who are not able to access them directly.
Correct choice is (a) good
Explanation: The security context is good if it enables carefully written stored programs to be set up that provide controlled access to tables for users who are not able to access them directly.
See lessThe facility that allows nesting one select statement into another is called __________
(a) nesting
(b) binding
(c) subquerying
(d) encapsulating
The correct answer is (c) subqueryingEasiest explanation: The ‘subquerying’ support provided by MySQL is a capability that allows writing one ‘SELECT’ statement within parentheses and nesting within another. This allows logically selecting content from tables.
The correct answer is (c) subquerying
Easiest explanation: The ‘subquerying’ support provided by MySQL is a capability that allows writing one ‘SELECT’ statement within parentheses and nesting within another. This allows logically selecting content from tables.
See lessHexadecimal numbers can be used in scientific notation.
(a) True
(b) False
I have been asked this question in my homework.
Question is from Perl DBI Overview in portion MySQL Programs Using Perl DBI and PHP of MySQL
Right choice is (b) FalseTo explain I would say: The scientific notation for real numbers is possible in MySQL. Approximate values are represented as floating point numbers in scientific notation. It consists of a mantissa and exponent.
Right choice is (b) False
To explain I would say: The scientific notation for real numbers is possible in MySQL. Approximate values are represented as floating point numbers in scientific notation. It consists of a mantissa and exponent.
See lessThe LOCAL capability for LOAD DATA does not need to be enabled explicitly.
(a) True
(b) False
This question was posed to me in examination.
The origin of the question is Enabling or Disabling LOCAL Capability for LOAD DATA topic in section General MySQL Administration of MySQL
Correct answer is (a) TrueExplanation: The ‘LOCAL’ capability for the ‘LOAD DATA’ statement does not need to be enabled explicitly. It can be controlled at build time and at runtime. This can be achieved in two ways.
Correct answer is (a) True
Explanation: The ‘LOCAL’ capability for the ‘LOAD DATA’ statement does not need to be enabled explicitly. It can be controlled at build time and at runtime. This can be achieved in two ways.
See less