41. An uncorrelated subquery does not contain any reference to the values from the outer query.
42. Which of these return a result to the client?
43. PHP variables are preceded by . . . . . . . .
44. Symlink is an applicable relocation method for . . . . . . . .
45. How many of the following take a connection handler as an argument?
mysql_store_result(), mysql_use_result()
mysql_store_result(), mysql_use_result()46. Find the error in the following SQL statement?
CREATE TABLE person
( person_id SMALLINT, name VARCHAR, LAST VARCHAR
CONSTRAINTS pk_person PRIMARY KEY (person_id));
INSERT INTO person
VALUES( person_id, name, LAST)
(1, ’s’, ’p’);
INSERT INTO person
( person_id, name, LAST)
VALUES(1,’s’,’p’);
CREATE TABLE person
( person_id SMALLINT, name VARCHAR, LAST VARCHAR
CONSTRAINTS pk_person PRIMARY KEY (person_id));
INSERT INTO person
VALUES( person_id, name, LAST)
(1, ’s’, ’p’);
INSERT INTO person
( person_id, name, LAST)
VALUES(1,’s’,’p’);47. The statement used to find out which character sets are available is . . . . . . . .
48. Is there any error in the following MySQL command?
SELECT emp_id, title, start_date, fname, fed_id
FROM person
ORDER BY RIGHT (fed_id, 3);
SELECT emp_id, title, start_date, fname, fed_id
FROM person
ORDER BY RIGHT (fed_id, 3);49. Avoiding NULL in columns may make queries simpler.
50. Which clause is used to "Identifies table from which to draw table and how the table should be joined"?
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 3
- MySQL Miscellaneous - Section 4
- 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