
ITDB202 - SQL DDL, DML and TCL Statements

Quiz
•
Computers
•
12th Grade - University
•
Medium
Mel PJ
Used 65+ times
FREE Resource
17 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which of the following allows you to add Address column with string value up to 50 characters in your EMP table?
ALTER TABLE emp ADD address VARCHAR2(50);
ALTER TABLE emp ADD COLUMN address VARCHAR2(50);
ALTER TABLE emp ADD address VARCHAR2(30);
ALTER TABLE emp DROP COLUMN address;
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which is an example of Data Manipulation Language (DML) command?
CREATE
INSERT
ALTER
DROP
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which is an example of Data Definition Language (DDL) command?
INSERT
DELETE
CREATE
UPDATE
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following will display all the records in EMPLOYEES table?
SELECT salary FROM employees;
SELECT * FROM employees;
SELECT ALL FROM employees;
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which command will delete your table from the database?
DROP
DELETE
TRUNCATE
MERGE
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which data type should you use for the BIRTHDAY column in STUDENTS table?
CHAR
VARCHAR2
DATE
NUMBER
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which command will execute properly?
INSERT INTO emp (101, 'Melissa', 300);
INSERT INTO emp VALUES (101, Melissa, 300);
INSERT INTO emp VALUES (101, 'Melissa', 300);
INSERT INTO emp VALUES ('101', Melissa, '300');
Create a free account and access millions of resources
Similar Resources on Wayground
20 questions
DBTHON-23 Round-1

Quiz
•
University
15 questions
SQL and Database Quiz

Quiz
•
University
15 questions
MYSQL

Quiz
•
12th Grade
20 questions
SQL

Quiz
•
11th - 12th Grade
20 questions
DATABASE MANAGEMENT CT-1

Quiz
•
University
14 questions
Parcial I - Base de Datos

Quiz
•
University
20 questions
BASIS DATA - Modul 05

Quiz
•
University
13 questions
MySQL- group by and foreign key

Quiz
•
12th Grade
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade