MySQL Advanced Features Test

Auto audio on: the next questions will be read aloud when you click Continue.

1. 1

   What is the purpose of the AUTO_INCREMENT attribute in a MySQL table?

   A To automatically adjust the number of rows in a table B To automatically generate a unique value for each new row C To update timestamps automatically with INSERT commands
2. 2

   Which MySQL command is used to remove a table from a database?

   A DROP TABLE B DELETE TABLE C TRUNCATE TABLE
3. 3

   How can you rename a column in a MySQL table?

   A ALTER TABLE table_name MODIFY COLUMN old_name new_name; B UPDATE COLUMN table_name SET old_name = new_name; C ALTER TABLE table_name CHANGE old_name new_name column_type;
4. 4

   What does the term 'ACID compliance' stand for in MySQL?

   A Automatic Compliance in Data B Atomicity, Consistency, Isolation, Durability C Advanced Compliance in Databases
5. 5

   Which storage engine in MySQL supports transactions?

   A MyISAM B InnoDB C MEMORY
6. 6

   Which of these is a valid MySQL collation type?

   A utf64_bin B latin9_ci C utf8_general_ci
7. 7

   How can you display indexed columns in a table?

   A SHOW INDEX FROM table_name; B DESCRIBE table_name; C SHOW COLUMNS FROM table_name;
8. 8

   What is the purpose of a foreign key in a MySQL database?

   A To store binary large objects B To enforce unique column values C To maintain referential integrity between tables
9. 9

   Which function is used to return the current date in MySQL?

   A GETDATE() B CURDATE() C CURRENTTIME()
10. 10

    How do you create an index on a column in a table?

    A CREATE INDEX index_name ON table_name(column_name); B INDEX ON table_name(column_name); C NEW INDEX ON table_name(column_name);
11. 11

    Which MySQL statement is used to change privileges for a user?

    A SET PRIVILEGES B ALTER USER PRIVILEGES C GRANT