Question:- How Do You Start MySQL On Linux?
Answer:- /etc/init.d/mysql start command is used to start MySQL on Linux.
Question:- Explain The Difference Between MySQL And MySQL Interfaces In PHP.
Answer:- • Mysqli is the object-oriented version of mysql library functions used in PHP. • Mysql_connect() • Mysqli_connect()
Question:- What Does The Tee Command Do In MySQL?
Answer:- Tee followed by a filename turns on MySQL logging to a specified file. It can be stopped by a command note.
Question:- How Do You Change The Password For An Existing User In MySQLAdmin?
Answer:- Mysqladmin -u root -p password “newpassword”
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