ITDB202 - SQL DDL, DML and TCL Statements

ITDB202 - SQL DDL, DML and TCL Statements

12th Grade - University

17 Qs

quiz-placeholder

Similar activities

DDL

DDL

University

15 Qs

DBMS Ex 1

DBMS Ex 1

University

15 Qs

Database concepts

Database concepts

University

15 Qs

DBMS TCS503 DDL -2

DBMS TCS503 DDL -2

University

21 Qs

DATABASE MANAGEMENT CT-1

DATABASE MANAGEMENT CT-1

University

20 Qs

MB-8

MB-8

University

15 Qs

9-mavzu. Maydon qiymatlarini tekshirish

9-mavzu. Maydon qiymatlarini tekshirish

University

20 Qs

QUIZ 3 - DFC2083

QUIZ 3 - DFC2083

University

15 Qs

ITDB202 - SQL DDL, DML and TCL Statements

ITDB202 - SQL DDL, DML and TCL Statements

Assessment

Quiz

Computers

12th Grade - University

Medium

Created by

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

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?