CP1222-WEEK 1-2 QUIZ

is a language that allows you to perform operations on a database

• HTML

• SQL

• JAVA

• C++

is used for deleting an existing database

• Create Database

• Drop Table

• Drop Database

• Create Table

is used for creating a new database

• Create Database

• Drop Table

• Drop Database

• Create Table

is used for creating a new table

• Create Database

• Drop Table

• Drop Database

• Create Table

is used for deleting an existing table

• Create Database

• Drop Table

• Drop Database

• Create Table

SQL> INSERT INTO Employees VALUES (100, 18, 'Zara', 'Ali');

• INSERT Data

• UPDATE Data

• SELECT Data

• DELETE Data

SQL> SELECT first, last, age FROM Employees WHERE first LIKE '%Zara%';

• INSERT Data

• UPDATE Data

• SELECT Data

• DELETE Data

SQL> UPDATE Employees SET age=20 WHERE id=100;

• INSERT Data

• UPDATE Data

• SELECT Data

• DELETE Data

SQL> DELETE FROM Employees WHERE id=100;

• INSERT Data

• UPDATE Data

• SELECT Data

• DELETE Data

CRUD stands for?

• Creates, Reads, Updates, and Deletes

• Created, Reader, Updated, and Deleted

• Creater, Reader, Updater, and Deleter

• Create, Read, Update, and Delete