Basic and Advance databases programming :: MySQL Programming Job Interview Questions and Answers

Learn MySQL Programming with interview questions and answers

1 What Is MySQL?
2 What Is mSQL?
3 What Is SQL?
4 What Is Table?
5 What Is Column?
6 What Is Row?
7 What Is Primary Key?
8 What Is Foreign Key?
9 What Is Index?
10 What Is View?
11 What Is Join?
12 What Is Union?
13 What Is ISAM?
14 What Is MyISAM?
15 What Is InnoDB?
16 What Is BDB (BerkeleyDB)?
17 What Is CSV?
18 What Is Transaction?
19 What Is Commit?
20 What Is Rollback?
21 Explain what Is MySQL?
22 How To Install MySQL?
23 How To Start MySQL Server?
24 How Do You Know If Your MySQL Server Is Alive?
25 How Do You Know the Version of Your MySQL Server?
26 How To Create a Test Table in Your MySQL Server?
27 How To Shutdown MySQL Server?
28 What Tools Available for Managing MySQL Server?
29 What Is "mysqld"?
30 What Is "mysqladmin" in MySQL?
31 How To Check Server Status with "mysqladmin"?
32 How To Shut Down the Server with "mysqladmin"?
33 How To Use "mysql" to Run SQL Statements?
34 How To Show All Tables with "mysql"?
35 What Is "mysqlcheck"?
36 How To Analyze Tables with "mysqlcheck"?
37 What Is "mysqlshow"?
38 How To Show Table Names with "mysqlshow"?
39 What Is "mysqldump"?
40 How To Dump a Table to a File with "mysqldump"?
41 What Is "mysqlimport"?
42 How To Load Data Files into Tables with "mysqlimport"?
43 What Is the Command Line End User Interface - mysql?
44 What Are the "mysql" Command Line Options?
45 What Are the "mysql" Command Line Arguments?
46 How Many SQL DDL Commands Are Supported by "mysql"?
47 How Many SQL DML Commands Are Supported by "mysql"?
48 What Are the Non-Standard SQL Commands Supported by "mysql"?
49 How To Get Help Information from the Server?
50 How To Run "mysql" Commands from a Batch File?
51 How To Return Query Output in HTML Format?
52 How To Return Query Output in XML Format?
53 What Is SQL in MySQL?
54 How Many Groups of Data Types?
55 What Are String Data Types?
56 What Are the Differences between CHAR and NCHAR?
57 What Are the Differences between CHAR and VARCHAR?
58 What Are the Differences between BINARY and VARBINARY?
59 What Are Numeric Data Types?
60 What Are Date and Time Data Types?
61 How To Calculate Expressions with SQL Statements?
62 How To Include Comments in SQL Statements?
63 How To Include Character Strings in SQL statements?
64 How To Escape Special Characters in SQL statements?
65 How To Concatenate Two Character Strings?
66 How To Include Numeric Values in SQL statements?
67 How To Enter Characters as HEX Numbers?
68 How To Enter Numeric Values as HEX Numbers?
69 How To Enter Binary Numbers in SQL Statements?
70 How To Enter Boolean Values in SQL Statements?
71 What Are NULL Values?
72 What Happens If NULL Values Are Involved in Expressions?
73 How To Convert Numeric Values to Character Strings?
74 How To Convert Character Strings to Numeric Values?
75 How To Use IN Conditions?
76 How To Use LIKE Conditions?
77 How To Use Regular Expression in Pattern Match Conditions?
78 How To Use CASE Expression?
79 What Are Date and Time Data Types in MySQL?
80 How To Write Date and Time Literals?
81 How To Enter Microseconds in SQL Statements?
82 How To Convert Dates to Character Strings?
83 How To Convert Character Strings to Dates?
84 What Are Date and Time Intervals?
85 How To Increment Dates by 1 in MySQL?
86 How To Decrement Dates by 1 in MySQL?
87 How To Calculate the Difference between Two Dates?
88 How To Calculate the Difference between Two Time Values?
89 How To Present a Past Time in Hours, Minutes and Seconds?
90 How To Extract a Unit Value from a Date and Time?
91 What Are Date and Time Functions in MySQL?
92 What Is TIMESTAMP in MySQL?
93 How Many Ways to Get the Current Time?
94 What Are DDL Statements in MySQL?
95 How To Create a New Table in MySQL?
96 What Happens If You No CREATE Privilege in a Database?
97 How To Get a List of All Tables in a Database?
98 How To Get a List of Columns in an Existing Table?
99 How To See the CREATE TABLE Statement of an Existing Table?
100 How To Create a New Table by Selecting Rows from Another Table in MySQL?
101 How To Add a New Column to an Existing Table in MySQL?
102 How To Delete an Existing Column in a Table?
103 How To Rename an Existing Column in a Table?
104 How To Rename an Existing Table in MySQL?
105 How To Drop an Existing Table in MySQL?
106 How To Create a Table Index in MySQL?
107 How To Get a List of Indexes of an Existing Table?
108 How To Drop an Existing Index in MySQL?
109 How To Create a New View in MySQL?
110 How To Drop an Existing View in MySQL?