MySQL Basics Simulation Test

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

1. 1

   What is the purpose of a primary key in a MySQL table?

   A To uniquely identify each record in the table B To link to a foreign key in another table C To create a backup of the database
2. 2

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

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

   What does the 'SELECT' statement do in MySQL?

   A Retrieves data from one or more tables B Updates data in the database C Deletes data from the table
4. 4

   How can you limit the number of rows returned by a query?

   A LIMIT ROWS B FETCH FIRST C LIMIT
5. 5

   Which MySQL statement is used to modify existing records?

   A MODIFY B UPDATE C ALTER
6. 6

   What is a foreign key in MySQL?

   A A key that uniquely identifies a record in its own table B The main key in a table C A key used to link two tables together
7. 7

   Which command is used to add a new column to an existing table?

   A ALTER TABLE B ADD COLUMN C INSERT COLUMN
8. 8

   What is a JOIN clause used for?

   A To remove records from a table B To retrieve data from two or more tables C To increase the size of a table
9. 9

   What's the use of the 'AS' keyword in MySQL?

   A To rename a column or table in the result set B To delete an alias or a column C To change the data type of a column
10. 10

    What does the COUNT() function do in MySQL?

    A Calculates the sum of a numeric column B Counts the number of rows returned C Returns the highest value from a column