Mysql questions and answers
Top 90 MySQL interview questions and answers
- What is MySQL, In which language it is written.
- What is default port of MySQL server?
- What are the drivers in MySQL ?
- List some advantages and disadvantages of MySQL ?
- How many codds rule are followed by MySQL ?
- How to login to MySQL from Linux/unix Shell?
- Is Mysql query is case sensitive?
- How To Check MySQL service is running or not ?
- How many types of logs are there in mysql?
- What is the difference between primary key and candidate key?
- What does "i_am_a_dummy flag" do in MySQL?
- What is the difference between Unix timestamps and MySQL timestamps?
- How To Rename a Table in MySQL?
- What is REGEXP?
- What myisamchk do ?
- What is Query Cache in MySQL?
- How To Get a List of Indexes of an Existing Table?
- How would you get the current date in Mysql?
- How To Increment Dates by 1111 MySQL?
- How do you find out slow queries in mysql?
- How to get Current MySQL version from query.
- How to get distinict columns values in MySql
- How Many Groups of Data Types?
- What is Foreign Key?
- Explain Storage Engine Available in MySQL ?
- How To Delete an Existing Column in a Table?
- How do you control the max size of a HEAP table?
- Explain the difference between FLOAT, DOUBLE and REAL.?
- What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
- Which RAID level is best suited for MySQL?
- What Is Index?
- How many columns can be used for creating Index?
- Is Rollback transaction supports for DDL statements?
- How do you change a password for an existing user via mysqladmin?
- Query to see all indexes of MySQL Table?
- How many triggers are available in MySQL,
- How would you select all the users, whose phone number is null?
- How to view all Triggers in MySQL?
- How To Enter Boolean Values in SQL Statements?
- How To Concatenate Two Character Strings?
- How To Enter Characters as HEX Numbers?
- What is mysqldump?
- Differentiate between CHAR_LENGTH and LENGTH ?
- List column comparision operators availoable in MySQL?
- How many columns we can update in single MySQL query?
- How MySQL Optimizes DISTINCT ?
- What Is Transaction?
- If I created a column with data type VARCHAR(3), what would I expect to see in MySQL table?
- Explain ENUM in MySQL?
- How are ENUMs and SETs represented internally?
- What Is Union?
- Flow To Rename an Existing Column in a Table?
- How To Use LIKE Conditions?
- How to use outer Join in MySQL?
- What Are the Differences between CHAR and NCHAR?
- How To Drop an Existing Index in MySQL?
- How To Drop an Existing Table in MySQL?
- But what if you really want to store the timestamp data, such as the publication date of the article?
- What are HEAP tables in MySQL?
- How MySQL Optimizes LEFT JOIN and RIGHT JOIN ?
- Explain federated tables. ?
- What are CSV tables?
- What is Blog in MySQL?
- What are types of joins in MySQL?
- Differene between Blob and Text?
- Explain the difference between BOOL, TINYINT and BIT.?
- How To Convert Numeric Values to Character Strings?
- Explain TIMESTAMP DEFAULT ‘2006:09:02 17:38:44?
ON UPDATE CURRENT_TIMESTAMP.?
- How To Add a New Column to an Existing Table in MySQL?
- What happens if a table has one column defined as TIMESTAMP?
- What are the storage models of OLAP?
- What is DDL, DML and DCL?
- How To Use IN Conditions?
- How To Calculate the Difference between Two Dates?
- What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?
- What is primary key?
- What Is CSV?
- How To Create a Table Index in MySQL?
- How can one take incremental backup in MySQL?
- What Is ISAM?
- What Is Rollback?
- Explain Profiling in MySQL?
- How To Drop an Existing View in MySQL?
- What Is InnoDB?
- What Is Commit?
- How To Escape Special Characters in SQL statements?
- What is SERIAL data type in MySQL?
- What is the difference between LIKE and REGEXP operators in MySQL ?
- Define Routine and Stored Procedure in MySQL database?
No comments:
Post a Comment