FeedBack Form

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

MYSQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
6. What query do you use to display top 50 rows?
  SELECT * FROM table_name LIMIT 0,50
Your Name Your Email-ID
Your Answer
 
7. Explain SHOW commands.
 
  • SHOW AUTHORS .
  • HOW BINLOG EVENTS
  • HOW BINARY LOGS
  • SHOW CHARACTER SET
  • SHOW COLLATION
  • SHOW COLUMNS
  • SHOW CONTRIBUTORS
  • SHOW COUNT(*)ERRORS
  • SHOW COUNT(*) WARNINGS
  • SHOW CREATE DATABASE
  • SHOW CREATE EVENT
  • SHOW CREATE FUNCTION
  • SHOW CREATE PROCEDURE
  • SHOW CREATE SCHEMA
  • SHOW CREATE TABLE
  • SHOW CREATE TRIGGER
  • SHOW CREATE VIEW
  • SHOW DATABASES
  • SHOW FULL TABLES
  • SHOW GRANTS
  • SHOW INDEX
  • SHOW INDEXES
  • SHOW MASTER STATUS
  • SHOW OPEN TABLES
  • SHOW PRIVILEGES
  • SHOW PROCEDURE CODE
Your Name Your Email-ID
Your Answer
 
8. What are the objects you can use with CREATE statement?
  DATABASE, EVENT, FUNCTION, INDEX, PROCEDURE, TABLE, TRIGGER, USER, VIEW.
Your Name Your Email-ID
Your Answer
 
9. What are the nonstandard string types?
 
  • TINYTEXT
  • TEXT
  • MEDIUMTEXT
  • LONGTEXT
Your Name Your Email-ID
Your Answer
 
10. How many TRIGGERS allows per table in mysql?
  SIX. BEFORE INSERT, AFTER INSERT, BEFORE UPDATE, AFTER UPDATE, BEFORE DELETE and AFTER DELETE
Your Name Your Email-ID
Your Answer