MySQL Interview questions


Total available count: 24
Subject - Databases
Subsubject - MySQL

What are the nonstandard string types?

String Data Type Syntax

  1. The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET
  2. In some situations, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement

The following are Non-Standard string types,

  1. TINYTEXT
  2. TEXT
  3. MEDIUMTEXT
  4. LONGTEXT



Next 5 interview question(s)

1
How many TRIGGERS are allowed in MySql table?
2
What are the objects can be created using CREATE statement?
3
How to display top 50 rows?
4
How MySQL Optimizes DISTINCT?
5
Where MyISAM table will be stored and also give their formats of storage?