51. Is duplicate entry of primary key is allowed in SQL?
52. The columns containing binary value that include null bytes will not print properly using the %s printf() format specifier.
53. MySQL uses security based on ACL. What does it stand for?
54. Find out the logical error in the following MySQL code snippet?
CREATE TABLE person
( person_id VARCHAR(20),
Name VARCHAR (20),
Address VARCHAR (20),
Mobile_no SMALLINT
);
CREATE TABLE person
( person_id VARCHAR(20),
Name VARCHAR (20),
Address VARCHAR (20),
Mobile_no SMALLINT
);55. To disallow zero month or day parts in dates, the option used is . . . . . . . .
56. Which statement is used to force the optimizer to use tables in a particular order?
57. Which option suppresses output unless there are errors in the table?
58. How many values can be returned from a stored procedure?
59. The server is told to accept spaces after function names by . . . . . . . .
60. The following SQL statement is invalid.
SELECT abc, xyz FROM table1 UNION abc, def FROM table2;
SELECT abc, xyz FROM table1 UNION abc, def FROM table2;Read More Section(MySQL Miscellaneous)
Each Section contains maximum 100 MCQs question on MySQL Miscellaneous. To get more questions visit other sections.
- MySQL Miscellaneous - Section 1
- MySQL Miscellaneous - Section 2
- MySQL Miscellaneous - Section 4
- MySQL Miscellaneous - Section 5
- MySQL Miscellaneous - Section 6
- MySQL Miscellaneous - Section 7
- MySQL Miscellaneous - Section 8
- MySQL Miscellaneous - Section 9
- MySQL Miscellaneous - Section 10
- MySQL Miscellaneous - Section 11
- MySQL Miscellaneous - Section 12