Page 100 - PowerPoint Presentation
P. 100
CAVITE STATE UNIVERSITY
T3 CAMPUS
Department of Information Technology DCIT 55 – Advance Database System
ID PersonName Age
1 Christian 22
2 John Mark 22
3 Jayson 23
4 Nigel 22
The following SQL statement drops/deletes a table named ‘Persons’
DROP TABLE Persons;
Once we execute above statement, the ‘Persons’ table is deleted from the database.
Online Assessment 1: Create your own database, tables and apply different queries.
Write/Type everything on a piece of paper.
1. Create Database and name it Quiz_1, then use it.
2. Create a table and name it as Your_Surname with an attribute of (ID, Name,
Address, Age, BDAY), and use proper data types.
3. Write a query to insert records in your table (at least 10)
4. Change the table name to Quiz_1_Your_Surname. (example: Quiz_1_Langit)
5. Change the name of all fields in this format. (Person_ID, Person_Name,
Person_Address, Person_Age, Person_Birthday)
6. Write a query to display all the records in your table.
7. Delete 4 inputs from your table.
8. Write a query to display all the remaining records in your table.
9. Write a query that displays only the Person_Name and Person_Address.
10. Write a query that deletes all the records in your table.
11. Drop the database you created.
Page | 16
