Improve Your MySQL Ability : Part-4

Q. 22. ) How much storage space does DATETIME require?
A. 4 bytes
B. 2 bytes
C. 8 bytes
D. 1 bytes

Q. 23. ) Can I call a trigger directly from an application?
A. Yes
B. No

Q. 24. ) recorAn outer join requires each record in the two joined tables to have a matching record.
A. True
B. Falsee

Q. 25. ) –i-am-a-dummy flag is used Makes the MySQL engine refuse UPDATE and which other command?
A. WHERE
B. INSERT
C. DELETE
D. TRUNCATE

Q. 26. ) Which is the default order of sort in ORDER BY clause?
A. Ascending
B. Descending

Q. 27. ) Can DISTINCT command be used for more than one column?
A. No
B. Yes

Q. 28. ) On executing DELETE command, if you get an error "foreign key constraint"- what does it imply?
A. Foreign key not defined
B. Table is empty
A. Connectivity issue
B. Data is present in the other table


                   Previous-------------------------------Next