Question:- What Is The TIMESTAMP Datatype ?
Answer:- TIMESTAMP in mysql server helps in row versioning. Row versioning is a type of concurrency that allows retaining the value until it is committed in the database. It shows the instant time of any event. It consists of both the date and time of the event. Also, TIMESTAMP helps in backing up data during the failure of a transaction.
Question:- What Is The Difference Between BLOB And TEXT?
Answer:- BLOB is a binary large object holding huge data. Four types of BLOBs are TINYBLOB, BLOB, MEDIBLOB, and LONGBLOB. TEXT is a case-sensitive BLOB. Four types of TEXT are TINY TEXT, MEDIUMTEXT, and LONG TEXT.
Question:- What Is The Difference Between BLOB And TEXT?
Answer:- BLOB is a binary large object holding huge data. Four types of BLOBs are TINYBLOB, BLOB, MEDIBLOB, and LONGBLOB. TEXT is a case-sensitive BLOB. Four types of TEXT are TINY TEXT, MEDIUMTEXT, and LONG TEXT.
Question:- What Is The Difference Between BLOB And TEXT?
Answer:- BLOB is a binary large object holding huge data. Four types of BLOBs are TINYBLOB, BLOB, MEDIBLOB, and LONGBLOB. TEXT is a case-sensitive BLOB. Four types of TEXT are TINY TEXT, MEDIUMTEXT, and LONG TEXT.
Question:- How Can You Find Out The Version Of The Installed MySQL?
Answer:- • SELECT version(); • SHOW VARIABLES LIKE “%version%”;
Question:- What Are The Advantages And Disadvantages Of Using MySQL?
Answer:- There are several advantages of MySQL which are making it a more popular database system now. Advantages: • It is well-known for its reliable and secure database management system. Transactional tasks of the website can be done more securely by using this software. • It supports different types of storage engines to store the data and it works faster for this feature. • It can handle millions of queries with a high-speed transactional process. • It supports many advanced level database features, such as multi-level transaction, data integrity, and deadlock identification. Disadvantages: • It is hard to make MySQL scalable. • It is not suitable for a very large type of database. • The uses of stored routine and triggers are limited to MySQL. • Temporary tables uses
Question:- How Can You Filter The Duplicate Data While Retrieving Records From The Table?
Answer:- A DISTINCT keyword is used to filter the duplicate data from the table while retrieving the records from a table.
Question:- What Is The Difference Between NOW() And CURRENT_DATE()?
Answer:- Both NOW() and CURRENT_DATE() are built-in MySQL methods. NOW() is used to show the current date and time of the server and CURRENT_DATE() is used to show only the date of the server.
Question:- Which MySQL Function Is Used To Concatenate Strings?
Answer:- CONCAT() function is used to combine two or more string data.
Question:- How Can You Change The Name Of Any Existing Table By Using The SQL Statement?
Answer:- The following SQL command is used to rename an existing table of the database. RENAME TABLE table_name TO new_name;
Question:- How Can You Retrieve A Portion Of Any Column Value By Using A Select Query?
Answer:- SUBSTR() function is used to retrieve the portion of any column.
Question:- How Can You Rename And Remove Any Column Of A Table?
Answer:- To rename column: ALTER TABLE table_name CHANGE COLUMN old_column_name new_column_name column_defination.
Question:- What Is An Index?How Can An Index Be Declared In MySQL?
Answer:- An index is a data structure of a MySQL table that is used to speed up the queries. It is used by the database search engine to find out the records faster. One or more fields of a table can be used as an index key. Index key can be assigned at the time of table declaration or can be assigned after creating the table. • Create INDEX: CREATE INDEX [index name] ON [table name]([column name]); • List all indexes: SHOW INDEXES FROM[table name];
Question:- How Many Columns Can Be Used For Creating An Index?
Answer:- A maximum of 16 indexed columns can be created for any standard table.