Answer:- The maximum limit of indexed columns that can be created for any table is 16.

Answer:- In MySQL, the different types of strings that can be used for database columns are SET, BLOB, VARCHAR, TEXT, ENUM and CHAR.

Answer:- A column is a series of cells in a table that stores one value for each row in a table. We can add columns in an existing table using the ALTER TABLE statement as follows: ALTER TABLE table_name ADD COLUMN column_name column_defination [FIRST|AFTER existing_column];

Answer:- In such cases when the password is lost, the user should start the DB with skip-grants-table and then change the password. Thereafter, with the new password, the user should restart the DB in a normal mode.

Answer:- When the data disk is full and overloaded, the way out is to create a soft link and move the .frm and the .idb files into that link location.

Answer:- Basically, DELETE TABLE is a logged operation, and every row deleted is logged. Therefore, the process is usually slow. TRUNCATE TABLE also deletes rows in a table, but it will not log any of the rows deleted. The process is faster here in comparison. TRUNCATE TABLE can be rolled back and is functionally similar to the DELETE statement without a WHERE clause.

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.