MySQL Interview Questions | Eklavya Online

MySQL Interview Questions

What are DDL, DML, and DCL?

Majorly SQL commands can be divided into three categories, i.e., DDL, DML & DCL. Data Definition Language (DDL) deals with all the database schemas, and it defines how the data should reside in the database. Commands like CreateTABLE and ALTER TABLE are part of DDL. Data Manipulative Language (DML) deals with operations and manipulations on …

What are DDL, DML, and DCL? Read More »

What is ISAM?

It is a system for file management developed by IBM, which allows records to access sequentially or even randomly.

What is InnoDB?

InnoDB is a storage database for SQL. The ACID-transactions are also provided in InnoDB and also includes support for the foreign key. Initially owned by InnobaseOY now belongs to Oracle Corporation after it acquired the latter since 2005.

Which command is used to view the content of the table in MySQL?

The SELECT command is used to view the content of the table in MySQL. Explain Access Control Lists. An ACL is a list of permissions that are associated with an object. MySQL keeps the Access Control Lists cached in memory, and whenever the user tries to authenticate or execute a command, MySQL checks the permission …

Which command is used to view the content of the table in MySQL? Read More »