Question:- How To Use Mysqldump To Create A Copy Of A Database?
Answer:- Mysqldump -h mysqlhost -u username -p mydatabasename > dbdump.sql
Question:- What Does Mysqlcheck Do ?
Answer:- Mysqlcheck is a client program that checks the integrity of database tables.
Question:- What Mysql -U John -P Command Does?
Answer:- • Mysql -u john -p command will prompt for the password for user john before allowing access to the database management system. • If your database server requires a username and password to gain access the -u and -p command-line options.
Question:- What Are The Technical Features Of MySQL?
Answer:- MySQL database software is a client or server system which includes : • Multi Threaded SQL server supporting various client programs and libraries. • Different backend • Wide range of application programming interfaces • Administrative tools
Question:- Differentiate Between FLOAT And DOUBLE.
Answer:- • Floating point numbers are stored in FLOAT with eight place accuracy and it has four bytes. • Floating points numbers are stored in DOUBLE with accuracy of 18 places and it has eight bytes.
Question:- Differentiate CHAR_LENGTH And LENGTH?
Answer:- CHAR_LENGTH is a character count whereas the Length is byte count. The numbers are the same for latin characters but they are different for unicode and other encodings.
Question:- How To Represent ENUMs And SET Internally?
Answer:- ENUMs and SET are used to represent powers of two because of storage optimizations.
Question:- Define REGEXP?
Answer:- REGEXP is a pattern match that matches patterns anywhere in the search value.
Question:- Mention String Types Available For Columns.
Answer:- The string types are: • SET • BLOB • ENUM • CHAR • TEXT • VARCHAR
Question:- What Storage Engines Are Used In MySQL?
Answer:- Storage engines are called the table types and data is stored in files using various techniques. Technique involves: • Storage mechanism • Locking levels • Indexing • Capabilities and functions
Question:- What Are The Drivers In MySQL?
Answer:- Following are the drivers available in MySQL: • PHP Driver • JDBC Driver • ODBC Driver • C WRAPPER • PYTHON Driver • PERL Driver • RUBY Driver • CAP11PHP Driver • Ado.net5.mxj
Question:- What Does A TIMESTAMP Do On UPDATE CURRENT_TIMESTAMP Data Type?
Answer:- The TIMESTAMP column is updated with Zero when the table is created. The CURRENT_TIMESTAMP modifier updates the timestamp field to the current time whenever there is a change in other fields of the table.
Question:- What Is The Difference Between Primary Key And Candidate Key?
Answer:- Every row of the table is identified uniquely by the primary key. There is only one primary key for a table. The primary key is also a candidate key. By common convention, candidate key can be designated as primary and can be used for any foreign key references.
Question:- What Does Myisamchk Do?
Answer:- It compresses the MyISAM tables, which reduces their disk or memory usage.