MySQL Interview questions


Total available count: 24
Subject - Databases
Subsubject - MySQL

What are the objects can be created using CREATE statement?

The following objects are created using the CREATE statement,

  1. DATABASE
  2. EVENT
  3. FUNCTION
  4. INDEX
  5. PROCEDURE
  6. TABLE
  7. TRIGGER
  8. USER
  9. VIEW



Next 5 interview question(s)

1
How to display top 50 rows?
2
How MySQL Optimizes DISTINCT?
3
Where MyISAM table will be stored and also give their formats of storage?
4
What is the difference between mysql_fetch_array and mysql_fetch_object?
5
What is the difference between BLOB AND TEXT?