FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

MYSQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
26. IS SQL reserved words like SELECT, FROM, NULL, and AS are Case Sensitive?
  No. These words are case-insensitive, meaning that SELECT, select, and SeLeCt are all parsed by mysqld as the same reserved word.
Your Name Your Email-ID
Your Answer
 
27. Tell me some important rules to know about some of the language structure in MySQL
 
  • Comments and portability
  • Case-sensitivity
  • Escape characters
  • Naming limitations
  • Quoting
  • Time zones
  • Character sets and collations
Your Name Your Email-ID
Your Answer
 
28. Describe DAYOFMONTH()
  Returns the day of the month for date, in the range 1 to 31.
Your Name Your Email-ID
Your Answer
 
29. What do you use with ALTER TABLE statement?
 
  • Add or drop columns
  • Change the name or definition of a column
  • Add or drop indexes
  • Sort the table’s rows in a particular order
  • Rename the table
Your Name Your Email-ID
Your Answer
 
30. Tell me the types of indexes.
 
  • A nonunique index is an index in which any key value may occur multiple times.
  • A UNIQUE index is unique-valued; that is, every key value is required to be different from all other keys.
  • A PRIMARY KEY is a unique-valued index that’s similar to a UNIQUE index but has additional restrictions (the major one being that no NULL values are allowed).
  • A FULLTEXT index is specially designed for text searching.
Your Name Your Email-ID
Your Answer