Trying to set your dream career as a software professional at SQL? Look into wisdomjobs to search for the job that meets your requirements. MY SQL is a relational database management system that utilizes SQL to add and manage content in a database. The role of DBA is installation, migration, database design, security, and performance monitoring. MY SQL DBA job has exponential growth with a long life career. MY SQL DBA jobs require experience in all type of SQL, knowledge on limitations of MY SQL, performance tuning, and Database optimization. MY SQL DBA jobs offer various placements as Lead SQL DBA, senior system analyst, Senior Database Administrator in many reputed IT organizations. www.wisdomjobs.com designed MY SQL DBA job interview questions and answers page to enhance your interview clearing capabilities. Register with us to have a broad view of all latest job notifications.
MySQL is a multithreaded, multi-user SQL database management system which has more than 11 million installations. This is the world's second most popular and widely used open source database.
Question 2. In Which Language Mysql Is Written?
MySQL is written in C and C++ and its SQL parser is written in yacc.
Question 3. What Are The Technical Specification Of Mysql?
MySQL has the following technical specifications -
Question 4. What Is The Difference Between Mysql And Sql?
SQL is known as standard query language. It is used to interact with the database like MySQL. MySQL is a database that stores various types of data and keeps it safe.
A PHP script is required to store and retrieve the values inside the database.
Question 5. What Is The Difference Between Database And Table?
There is a major difference between a database and a table. The differences are as follows:
Question 6. Why Do We Use Mysql Database Server?
The MySQL database server is very fast, reliable and easy to use. You can easily use and modify the software. MySQL software can be downloaded free of cost from the internet.
Question 7. What Are The Different Tables Present In Mysql?
There are many tables that remain present by default. But, MyISAM is the default database engine used in MySQL. There are five types of tables that are present:
Question 8. What Is The Difference Between Char And Varchar?
A list of differences between CHAR and VARCHAR:
Question 9. What Is The Difference Between Truncate And Delete In Mysql?
The DELETE command is used to delete data from a table. It only deletes the rows of data from the table while, truncate is very dangerous command and should be used carefully because it deletes every row permanently from a table.
Question 10. How Many Triggers Are Possible In Mysql?
There are only six Triggers allowed to use in MySQL database.
Question 11. What Is Heap Table?
Tables that are present in memory is known as HEAP tables. When you create a heap table in MySQL, you should need to specify the TYPE as HEAP. These tables are commonly known as memory tables. They are used for high speed storage on temporary basis. They do not allow BLOB or TEXT fields.
Question 12. What Is Blob And Text In Mysql?
BLOB is an acronym stands for binary large object. It is used to hold a variable amount of data.
There are four types of BLOB.
The differences among all these are the maximum length of values they can hold. TEXT is case-insensitive BLOB. TEXT values are non-binary strings (character string). They have a character set and values are stored and compared based on the collation of the character set.
There are four types of TEXT.
Question 13. What Is A Trigger In Mysql?
A trigger is a set of codes that executes in response to some events.
Question 14. What Is The Difference Between Heap Table And Temporary Table?
Question 15. What Is The Difference Between Float And Double?
FLOAT stores floating point numbers with accuracy up to 8 places and allocates 4 bytes, on the other hand DOUBLE stores floating point numbers with accuracy up to 18 places and allocates 8 bytes.
Question 16. What Are The Advantages Of Mysql In Comparison To Oracle?
Question 17. What Are The Disadvantages Of Mysql?
Question 18. What Is The Difference Between Mysql_connect And Mysql_pconnect?
Question 19. What Does " I_am_a_dummy Flag" Do In Mysql?
The " i_am_a_dummy flag" enables MySQL engine to refuse any UPDATE or DELETE statement to execute if the WHERE clause is not present.
Question 20. How To Get The Current Date In Mysql?
To get current date, use the following syntax:
Question 21. What Are The Security Alerts While Using Mysql?
Question 22. How To Change A Password For An Existing User Via Mysqladmin?
Mysqladmin -u root -p password "newpassword".
Question 23. What Is The Difference Between Unix Timestamps And Mysql Timestamps?
Actually both Unix timestamp and MySQL timestamp are stored as 32-bit integers but MySQL timestamp is represented in readable format of YYYY-MM-DD HH:MM:SS format.
Question 24. How To Display Nth Highest Salary From A Table In A Mysql Query?
Let us take a table named employee.
To find Nth highest salary is:
1. select distinct(salary) from employee order by salary desc limit n-1,1
if you want to find 3rd largest salary:
1. select distinct(salary) from employee order by salary desc limit 2,1
Question 25. What Is Mysql Default Port Number?
MySQL default port number is 3306.
REGEXP is a pattern match using regular expression. Regular expression is a powerful way of specifying a pattern for a complex search.
Question 27. How Many Columns Can You Create For An Index?
You can create maximum of 16 indexed columns for a standard table.
Question 28. What Is The Difference Between Now() And Current_date()?
NOW() command is used to show current year, month, date with hours, minutes and seconds while CURRENT_DATE() shows the current year with month and date only.
Question 29. Which Command Is Used To View The Content Of The Table In Mysql?
The SELECT command is used to view the content of the table in MySQL.
Question 30. What Is The Usage Of I-am-a-dummy Flag In Mysql?
In MySQL, the i-am-a-dummy flag makes the MySQL engine to deny the UPDATE and DELETE commands unless the WHERE clause is present.
Question 31. What Is The Usage Of Regular Expressions In Mysql?
In MySQL, regular expressions are used in queries for searching a pattern in a string.
The following statement retrieves all rows where column employee_name contains the text 1000 (example salary):
Question 32. How Do You Determine The Location Of Mysql Data Directory?
The default location of MySQL data directory in windows is C:mysqldata or C:Program FilesMySQLMySQL Server 5.0 data.
Question 33. What Is Mysql Data Directory?
MySQL data directory is a place where MySQL stores its data. Each subdirectory under this data dictionary represents a MySQL database. By default the information managed my MySQL = server mysqld is stored in data directory.
Question 34. What Is The Use Of Mysql_close()?
Mysql_close() cannot be used to close the persistent connection. Though it can be used to close connection opened by mysql_connect().
Question 35. How Is Myisam Table Stored?
MyISAM table is stored on disk in three formats.
Question 36. What Is The Usage Of Enums In Mysql?
ENUMs are used to limit the possible values that go in the table:
For example: CREATE TABLE months (month ENUM 'January', 'February', 'March'); INSERT months VALUES ('April').
Question 37. What Are The Advantages Of Myisam Over Innodb?
MyISAM follows a conservative approach to disk space management and stores each MyISAM table in a separate file, which can be further compresses, if required. On the other hand, InnoDB stores the tables in tablespace. Its further optimization is difficult.
Question 38. What Are The Differences Between Mysql_fetch_array(), Mysql_fetch_object(), Mysql_fetch_row()?
Mysql_fetch_object is used to retrieve the result from the database as objects while mysql_fetch_array returns result as an array. This will allow access to the data by the field names.
Using mysql_fetch_object field can be accessed as $result->name.
Using mysql_fetch_array field can be accessed as $result->[name].
Using mysql_fetch_row($result) where $result is the result resource returned from a successful query executed using the mysql_query() function.
1.$result = mysql_query("SELECT * from students");
2.while($row = mysql_fetch_row($result))
Question 39. How Do You Backup A Database In Mysql?
It is easy to backing up data with phpMyAdmin. Select the database you want to backup by clicking the database name in the left hand navigation bar. Then click the export button and make sure that all tables are highlighted that you want to backup. Then specify the option you want under export and save the output.
SQLyog program is the most popular GUI tool for admin. It is the most popular MySQL manager and admin tool. It combines the features of MySQL administrator, phpMyadmin and others MySQL front ends and MySQL GUI tools.
MYSQL DBA Related Tutorials
|PHP Tutorial||MySQL Tutorial|
|Drupal Tutorial||WordPress Tutorial|
|Joomla Tutorial||CakePHP Tutorial|
|CodeIgniter Tutorial||PHP7 Tutorial|
MYSQL DBA Related Interview Questions
|PHP Interview Questions||MySQL Interview Questions|
|PHP+MySQL Interview Questions||Drupal Interview Questions|
|PHP5 Interview Questions||WordPress Interview Questions|
|Joomla Interview Questions||CakePHP Interview Questions|
|CodeIgniter Interview Questions||PHP7 Interview Questions|
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.