+91 90691 39140 | +1 253 214 3115 | info@hub4tech.com | hub4tech

My SQL Interview Questions and Answers

1
How many TRIGGERS are allowed in MySql table?

MySql table allows following 6 triggers:

  • BEFORE INSERT
  • AFTER INSERT
  • BEFORE UPDATE
  • AFTER UPDATE
  • BEFORE DELETE and
  • AFTER DELETE
2
What is MySQL?

MySQL is an open source DBMS which is built, supported and distributed by MySQL AB (now acquired by Oracle)

3
Differentiate between FLOAT and DOUBLE.

FLOAT stores floating point numbers with accuracy up to eight places and has four bytes while DOUBLE stores floating point numbers with accuracy upto 18 places and has eight bytes.

4
What are the technical features of MySQL?

MySQL database software is a client or server system which includes

  • Multithreaded SQL server supporting various client programs and libraries
  • Different backend
  • Wide range of application programming interfaces and
  • Administrative tools.
5
How are MySQL timestamps seen to a user?

MySQL time stamps are seen to a user in a readable format : YYYY-MM-DD HH:MM:SS.

Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.
FOLLOW US