Test: SQL - 2 - Computer Science Engineering (CSE) MCQ

Hierarchical

Network

Relational

Object-Oriented

UPDATE

DELETE

INSERT

SELECT

Data integrity

Data redundancy

Scalability

Efficiency

TEXT

VARCHAR

CHAR

BLOB

CHAR is fixed length, VARCHAR is variable length

CHAR is variable length, VARCHAR is fixed length

No difference

VARCHAR is used only for numeric data

CREATE

ALTER

DROP

TRUNCATE

Deletes specific rows from a table

Removes all rows from a table

Changes table structure

Creates a new table

DROP deletes the table, TRUNCATE deletes only the table data

TRUNCATE deletes the table, DROP deletes only the table data

No difference

Both commands modify table data

SELECT

DELETE

UPDATE

INSERT

Specifies which database to use

Specifies which table to delete from

Specifies which records to delete

Specifies how to order the records