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.
Question:- What Is The View? How Can You Create And Drop Views In MySQL?
Answer:- A view works as a virtual table that is used to store the query and returns a result set when it is called. An updatable view is also supported by MySQL. CREATE VIEW view_name AS SELECT column1, column2 FROM table_name WHERE condition;