Answer:- The use of ENUM will limit the values that can go into a table. For example, a user can create a table giving specific month values and other month values would not enter into the table.

Answer:- For this, it is necessary to review the layered architecture and determine hardware and software configuration dependencies with respect to application put to test.

Answer:- While both are used to enforce the uniqueness of the column defined, the primary key would create a clustered index, whereas the unique key would create a non-clustered index on the column. The primary key does not allow ‘NULL’, but the unique key does.

Answer:- The command line SQLSERVER.EXE used with ‘-m’ will restart SQL Server into single-user mode and the same with ‘-f’ will restart it in the minimal configuration mode.

Answer:- Primary Key: • It helps in the unique identification of data in a database • There can only be one primary key for a table • Primary key attributes cannot have duplicate values in a table • Null values are not acceptable • We can define primary key constraints for temporarily created tables • The primary key index is automatically created Foreign Key : • It helps establish a link between tables • There can be more than one foreign key for a table • Duplicate values are acceptable for a foreign key • Null values are acceptable • It cannot be defined for temporary tables • The index is not created automatically

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.

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.

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.

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.

Answer:- • SELECT version(); • SHOW VARIABLES LIKE “%version%”;

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

Answer:- A DISTINCT keyword is used to filter the duplicate data from the table while retrieving the records from a table.

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.

Answer:- CONCAT() function is used to combine two or more string data.