What is the primary function of Data Definition Language (DDL) in a database?

DDL defines the database schema and describes how data should reside in the database.

Fill in the blank: The command used to remove all records from a table in SQL is called ______.

TRUNCATE

True or False: Data Manipulation Language (DML) includes commands like CREATE and ALTER.

False. DML includes commands like SELECT, INSERT, UPDATE, and DELETE.

Riddle: I manage data and ensure its integrity, but I'm not a file. What am I?

Database Management System (DBMS)

Which of the following is NOT a phase of database design? A) Conceptual Design B) Logical Design C) Physical Design D) Application Design

D) Application Design

Fill in the blank: The capability to modify data at one level without affecting another level is known as ______.

Data Independence

True or False: The external level in DBMS architecture provides different views of data based on user needs.

True

What is a significant disadvantage of the Two-Tier Architecture in DBMS?

Poor performance when there are a large number of users.

Riddle: I have three layers; the client talks to me, but I don’t talk directly to the database. What am I?

Application Server in Three-Tier Architecture

Which command in DML is used to combine INSERT, UPDATE, and DELETE operations into a single statement?

MERGE