Database Quiz Sept 7 and sql related .pptx

Introcuction to Database and related quiz on SQL

1. Part 1 15points.

2. Write True if the statement is correct. 5points. MySQL is a NoSQL database management system. DDL commands allow you to interact with the data stored in the database. SQL allows you to perform calculations on data using aggregate functions. Joins improve the speed of data retrieval. Update statement is used to add new records to a table.

3. Write the letter of the correct answer.

4. Part 2

5. Write the line of codes that will enable you do the following: 40points. 1. Create the table below and insert data into it. 2. Delete then record where ID is equal to 4. 3. Finally display table here Last_Name was arranged in ASC order.