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 a synonym for CHARACTER SET?
(a) CSET
(b) CHSET
(c) CHARSET
(d) CHCSET
Right choice is (c) CHARSETTo elaborate: ‘CHARACTER SET’ can be abbreviated into ‘CHARSET’ and can be used in the same contexts and statements where ‘CHARACTER SET’ is used. ‘charset’ is the server-supported character set.
Right choice is (c) CHARSET
To elaborate: ‘CHARACTER SET’ can be abbreviated into ‘CHARSET’ and can be used in the same contexts and statements where ‘CHARACTER SET’ is used. ‘charset’ is the server-supported character set.
See lessThe bit-field values are prefixed with __________
(a) 0b
(b) 0bit
(c) bit-
(d) ‘bit’
The correct option is (a) 0bThe best explanation: In MySQL, the bit-field values can be either written as b’value’ or 0bvalue. Here, value is a sequence of digits zero or/and one. For example, b’1010′ and 0b1010 are decimal value 10.
The correct option is (a) 0b
The best explanation: In MySQL, the bit-field values can be either written as b’value’ or 0bvalue. Here, value is a sequence of digits zero or/and one. For example, b’1010′ and 0b1010 are decimal value 10.
See lessThe function returning an array of row values is ______________
(a) fetchrow_array()
(b) fetchrow_arrayref()
(c) fetch()
(d) fetchrow_hashref()
The correct option is (a) fetchrow_array()To explain I would say: The function ‘fetchrow_array()’ returns an array of row values. ‘fetchrow_arrayref()’ returns a reference to an array of row values. ‘fetch()’ is the same as fetchrow_arrayref().
The correct option is (a) fetchrow_array()
To explain I would say: The function ‘fetchrow_array()’ returns an array of row values. ‘fetchrow_arrayref()’ returns a reference to an array of row values. ‘fetch()’ is the same as fetchrow_arrayref().
See lessWhat is the meaning of “REFERENCES” in table definition?
(a) Primary key
(b) NULL
(c) Foreign Key
(d) A ”foreign Key” belong to this particular table
The correct option is (d) A ”foreign Key” belong to this particular tableThe best I can explain: When “Foreign Key” declared in a table then it necessary to define the name of the table to which it belong with help of constraint “REFERENCES”.
The correct option is (d) A ”foreign Key” belong to this particular table
The best I can explain: When “Foreign Key” declared in a table then it necessary to define the name of the table to which it belong with help of constraint “REFERENCES”.
See less“COUNT” keyword belongs to which categories in Mysql?
(a) Aggregate functions
(b) Operators
(c) Clauses
(d) All of the mentioned
The correct option is (a) Aggregate functionsExplanation: None.
The correct option is (a) Aggregate functions
Explanation: None.
See lessThe DECIMAL used for expressions containing only exact values with fractional part is of digit precision _________
(a) 32
(b) 64
(c) 65
(d) 16
The correct answer is (c) 65For explanation I would say: In MySQL, for the expressions containing only exact values and where one or more values have a fractional part, the DECIMAL arithmetic is used with digits of precision equal to 65.
The correct answer is (c) 65
For explanation I would say: In MySQL, for the expressions containing only exact values and where one or more values have a fractional part, the DECIMAL arithmetic is used with digits of precision equal to 65.
See lessThe header that should be included first is ______________
(a) my_global.h
(b) my_sys.h
(c) mysql.h
(d) my_local.h
Correct answer is (a) my_global.hExplanation: The file ‘my_global.h’ takes care of including several other header files that are likely to be generally useful, like ‘stdio.h’. It also includes Windows compatibility information.
Correct answer is (a) my_global.h
Explanation: The file ‘my_global.h’ takes care of including several other header files that are likely to be generally useful, like ‘stdio.h’. It also includes Windows compatibility information.
See lessFor which language is the PEAR module used?
(a) Python
(b) Perl
(c) PHP
(d) C
The correct choice is (c) PHPFor explanation I would say: The PEAR database module is specified for the language PHP. PHP is a server side scripting language and it provides an appropriate method of embedding programs in the web pages.
The correct choice is (c) PHP
For explanation I would say: The PEAR database module is specified for the language PHP. PHP is a server side scripting language and it provides an appropriate method of embedding programs in the web pages.
See lessWhat executes on a time activated basis according to a schedule?
(a) Stored program
(b) Events
(c) Triggers
(d) Stored procedures
The correct option is (b) EventsThe best I can explain: In MySQL, the events execute on a time activated basis according to a schedule. Triggers are defined to execute when the table is modified via INSERT, DELETE or UPDATE statements.
The correct option is (b) Events
The best I can explain: In MySQL, the events execute on a time activated basis according to a schedule. Triggers are defined to execute when the table is modified via INSERT, DELETE or UPDATE statements.
See lessWhich statement can be used for modifying the definition for an existing table?
(a) ALTER
(b) Modified
(c) SELECT
(d) FROM
Correct choice is (a) ALTEREasiest explanation: None.
Correct choice is (a) ALTER
Easiest explanation: None.
See less