Quiz for SQL – Data Definition Language (DDL) and Data Manipulation Language (DML)

Course: Database Management System | Subject: Unit 2 | Topic: Relational Model and Relational Algebra

A. CREATE TABLE B. INSERT INTO C. DROP TABLE D. ALTER TABLE

A. TRUNCATE B. DROP C. DELETE D. REMOVE

A. ALTER TABLE B. CREATE TABLE C. DROP TABLE D. UPDATE TABLE

A. INSERT INTO B. UPDATE C. DELETE D. SELECT

A. UPDATE B. INSERT INTO C. DELETE D. CREATE

A. DROP TABLE B. DELETE C. TRUNCATE D. REMOVE TABLE

A. CREATE TABLE B. INSERT INTO C. UPDATE D. DROP TABLE

A. WHERE B. ORDER BY C. GROUP BY D. HAVING

A. SELECT B. INSERT INTO C. UPDATE D. DROP

A. ORDER BY B. WHERE C. GROUP BY D. HAVING

A. DELETE B. DROP C. TRUNCATE D. REMOVE

A. DROP TABLE B. DELETE C. TRUNCATE D. ALTER TABLE

A. GROUP BY B. ORDER BY C. WHERE D. HAVING

A. HAVING B. WHERE C. GROUP BY D. ORDER BY

A. UPDATE B. INSERT INTO C. DROP D. CREATE

A. ALTER TABLE ADD COLUMN B. CREATE TABLE C. DROP TABLE D. INSERT INTO

A. ALTER TABLE DROP COLUMN B. DROP TABLE C. DELETE COLUMN D. REMOVE COLUMN

A. ALTER TABLE MODIFY B. CREATE TABLE C. DROP TABLE D. INSERT INTO

A. Saves all changes to the database B. Rolls back changes C. Drops a table D. Updates rows

Are you ready to start test? Set your time limit