About interview Questions Collection(Basic,Intermediate and Advanced) in MySQL

本文主要是介绍About interview Questions Collection(Basic,Intermediate and Advanced) in MySQL，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

Basic MySQL Interview Questions

1.What is Mysql?

Database management system for web servers

2.What are some of the advantages of using MySQL?

Flexibility
Power
Enterprise-Level SQL Feature
Full-Text Indexing and Searching
Query Caching
Replication
Configuration and Security

3.What do you mean by `Database`?

A structured collection of data stored
Organized to be quickly searched
Information can be rapidly retrieved

4.What does SQL in MySQL stand for ?

Structured Query Language

5.What does a MySQL database contain?

one or more tables
records and rows
columns and fields

6.How can you interact with MySQL?

using a command line
via a web interface
through a programming language

7.What are MySQL Database Queries?

a specific request or a question

8.What are some of the common MySQL commands?

Alter
Backup
\c (to cancel input)
Create
Delete
Describe
Drop
Exit
Grant
Insert
Lock
Quit
Rename
Show
Source
Status
Truncate
Unlock
Update
Use

9.How do you create a database in MySQL?

Create Database database_name;

10.How do you remove a column from a database?

Alter Table books drop pages;

11.How do you view a database in MySQL ?

Show databases;

12.What are the Numeric Data Type in MySQL?

TINYINT
SMALLINT
MEDIUMINT
INT
BIGINT
DECIMAL
FLOAT
DOUBLE
BIT

13.What are the String Data Types in MySQL?

CHAR
VARCHAR
BINARY
VARBINARY
TINYBLOB
BLOB
MEDIUMLOB
LONGBLOB
TINYTEXT
TEXT
MEDIUMTEXT
LONGTEXT
ENUM
SET
NULL

14.What are the Temporal Data Type in MySQL?

DATE
TIME
DATETIME
TIMESTAMP
YEAR

15.What is BLOB in MySQL?

BLOB is an acronym that stand for a binary large object.
It is used to hold a variable amount of data
TINYBLOB
BLOB
MEDIUMBLOB
LONGBLOB
A BLOB can hold a very large amount of data.(document,images,videos)

16. How to add users in MySQL?

CREATE USER 'testuser' IDENTIFIED BY 'sample password';

Intermediate MySQL Interview Questions

17. What are MySQL "Views"?

a view consists of a set of rows that is returned
virtual table
making the query available via an alias
Advantages of views : Simplicity Security Maintainability

18.What are MySQL Trigger?

a task that executes in response to database event that involves inserting,modifying,or deleting table data
Trigger purpose including Audit Trails and Validation and Referential Integrity enforcement

19.How many Triggers are possible in MySQL?

Six triggers allowed to use in the MySQL database:

Before Insert
After Insert
Before Update
After Update
Before Delete
After Delete

20.What is the MySQL server?

The server mysqld,is the hub of a MySQL installation,It performs all manipulation of databases and tables.

21.What are the MySQL clients and utilities?

mysql (an interactive program enable client to server,execute bash shell )
mysqladmin (An administrate program for performing tasks: shut down the server,checking its configuration,monitoring its status)
mysqldump (backing up your database or copying database)
mysqlcheck and myisamchk (perform table checking,analysis and optimization)

22.What are the types of relationships used in MySQL?

One-to-One
One-to-Many
Many-to-Many

Advanced MySQL Interview Questions

23.Can you explain the logical architecture of MySQL?

The top layer: contains the services most network-based client/server tools
The second layer contains much of MySQL's brains
The third layer contains the storage engines that are responsible for storing and retriveing the data stored in MySQL.