FeedBack Form

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

MYSQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
36. What are the two arguments for LIMIT clause?
  LIMIT skip_count, row_count
Your Name Your Email-ID
Your Answer
 
37. Tell me the standard character string types in MYSQL.
 
  • CHAR
  • VARCHAR
  • TINY TEXT
  • TEXT
  • MEDIUM TEXT
  • LONG TEXT
  • BINARY
  • VARBINARY
  • TINYBLOB
  • MEDIUMBLOG
  • BLOB
  • LONGBLOB
  • ENUM
  • SET
Your Name Your Email-ID
Your Answer
 
38. What do you know about TIMESTAMP?
  The TIMESTAMP data type allows for automatic updating via the attributes DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT TIMESTAMP. There can be only one automatically updating TIMESTAMP field per table. That is, there can be only one TIMESTAMP field that is specified with DEFAULT CURRENT_TIMESTAMP or ON UPDATE CURRENT_TIMESTAMP. Either or both attributes can be specified on one field.
Your Name Your Email-ID
Your Answer
 
39. Is DATETIME data type a STRING type?
  DATETIME data types are usually formatted as strings, and can be inputted as strings. However, they also have numerical representations, which can be seen by casting the value into a numeric data type.
Your Name Your Email-ID
Your Answer
 
40. Are UNIQUE KEY, PRIMARY KEY AND FOREIGN KEY contains INDEX?
  Unique key constraints in MySQL (UNIQUE KEY and PRIMARY KEY) limit the data in a table by allowing only one set of values for the indexed data. A foreign key constraint (FOREIGN KEY) limits the data in a table by requiring that the set of values for the indexed data match data from outside the table.
Your Name Your Email-ID
Your Answer