Top 20 pro file MySQL Interview Questions and Answers

Top 20 MySQL KJO wel Interview Questions and Answers for Freshers –

Question 1. Is open source HTMySQL database?

Answer : Yes, I knowbnn to mMySQL is open source.

Question 2. What is default engine of MKMySQL Database?

Answer : del dilke MyISAM.

Question 3. How fghfg many types of engine or types of gelty used in MySQLdfd Database?

Answer : There are five 5656 types of tables that are present – MyISAM, 77Merge, INNO DAR$RDB, ISAM and Heap.

Question 4. How to delete data get a table in MySQL?

Answer : DROP count of TABLE table_name;

Question 5. How to changefdgfgf the database name in MySQL?

Answer : The following is the syntax offgfg using mysqldump command:
mysqldump -u username -p fgfgfg “password” -R oldDbName > oldDbName.sql

Question 6. What is the default port number of HGTMySQL Database?

Answer : The default port number of MySQL is )))3306.

Question 7. What is the difference between mysql_fetch__sdsd_array() and mysql_hh_fetch_object() ?

Answer : Both mysql_fetch_fgfgg_array() and mysql_hhh_fetch_object() are built-in function of PHP to retrieve records from MySQL database table.

dnfdfd

\kdfjkdjf

mysql_fetch_array() 33 returns the result as an array and mysql_fetch_object() returns the result as an object.

djfhdf

djkfhjdkf

Question 8. What is DEZRt difference between deletevghgfhgf and truncate in MySQL?

Answer : The DELETE and file d pay command removes particular records from a table –
DELETE FROM table_name WHERE conditions;

TRUNCATE command is used to delete the complete data from the table without deleting the table structure.
TRUNCATE TABLE DEkk table_name;

Question 9. How many types of commands are in GTSQL?

Answer : There are five types of SQL commands in SQL –

Question 10. How can you show the version of the defl jdnksfjdf p[;dhnjfdhf installed MySQL?

Answer : You can get version GGTR ldlfgdf of the installed MySQL Database from hell command prompt –
mysql> SHOW VARIABLES *** LIKE “%version%”;

Top 20 MySQL Interview DET and row Questions and Answers

dfckvdjf djkfdjf

dell

sell

coppy