Answer:- We can check the MySQL version on linux using the below command: mysql -v (Linux)

Answer:- In either Windows or POSIX systems, the named pipes provide ways of inter-process communications to connect different processes running on the same machine. It dispenses with the necessity of using network stack, and data can be sent without affecting the performance.

Answer:- The default port for MySQL server is 3306. Another standard default port is 1433 in TCP/IP for SQL Server.

Answer:- DDL is the abbreviation for Data Definition Language dealing with database schemas, as well as the description of how data resides in a database. For instance CREATE TABLE command. DML denotes Data Manipulation Language which includes commands such as SELECT, INSERT, etc. DCL stands for Data Control Language and includes commands like GRANT, REVOKE etc.

Answer:- This is among the beginner interview questions. In MYSQL joins are used to query data from two or more tables. The query is made using the relationship between certain columns existing in the table. There are four types of joins in MYSQL.

Answer:- Common MYSQL functions are as follows: • NOWO: The function for returning the current date and time as a single value CURRDATEO: The function for returning the current date or time • CONCAT(X, Y): The function to concatenate two strings values creating a single string output • DATEDIFF (X, Y): The function to determine the difference between two dates

Answer:- When a table is created, CHAR is used to define the fixed length of the table and columns. The length value could be in the range of 1-255. The VARCHAR command is used to adjust the column and table lengths as required.

Answer:- This is among the intermediate interview questions. Heap tables are in-memory tables used for high-speed temporary storage. But, TEXT or BLOB fields are not allowed within them. They also do not support AUTO INCREMENT. It works as a temporary table and it uses the indexes that make it faster than another table type.

Answer:- In mysql database server the syntax for concatenating database table in MYSQL: CONCAT(string 1, string 2, string 3)

Answer:- The maximum limit of indexed columns that can be created for any table is 16.

Answer:- In MySQL, the different types of strings that can be used for database columns are SET, BLOB, VARCHAR, TEXT, ENUM and CHAR.

Answer:- A column is a series of cells in a table that stores one value for each row in a table. We can add columns in an existing table using the ALTER TABLE statement as follows: ALTER TABLE table_name ADD COLUMN column_name column_defination [FIRST|AFTER existing_column];

Answer:- In such cases when the password is lost, the user should start the DB with skip-grants-table and then change the password. Thereafter, with the new password, the user should restart the DB in a normal mode.

Answer:- When the data disk is full and overloaded, the way out is to create a soft link and move the .frm and the .idb files into that link location.