Languages

Question 1

What are the five sublanguages of SQL?

Answer 1

• Data Definition Language (DDL)
• Data Query Language (DQL)
• Data Manipulation Language (DML)
• Data Control Language (DCL)
• Data Transaction Language (DTL)

Each sublanguage serves a specific purpose in managing and interacting with databases.

Question 2

What does Data Definition Language (DDL) do?

Answer 2

Defines the structure of the database columns

Includes commands like CHANGE/ADD/DROP columns, ADD FOREIGN KEY, CREATE VIEW, CREATE INDEX, DROP TABLE, DROP VIEW, DROP INDEX.

Question 3

What is the purpose of Data Query Language (DQL)?

Answer 3

Retrieves data from the database

DQL is essential for querying and obtaining information stored in the database.

Question 4

What actions are performed by Data Manipulation Language (DML)?

Answer 4

• DELETE
• UPDATE
• INSERT
• SELECT

DML is used to manipulate rows of data stored in a database.

Question 5

What does Data Control Language (DCL) control?

Answer 5

Database user access

DCL is used to grant or revoke permissions to users in a database.

Question 6

What is the function of Data Transaction Language (DTL)?

Answer 6

Manages database transactions

DTL ensures that transactions are processed reliably and adhere to ACID properties.

Question 7

What does DML stand for in database management?

Answer 7

Changing/Choosing ROWS of data in a table

DML includes operations such as DELETE, UPDATE, INSERT, and SELECT.

Question 8

What does DDL refer to in the context of databases?

Answer 8

Altering COLUMNS in a table or the ALTERing the STRUCTURE of a table

DDL operations include ALTER TABLE, CREATE VIEW, CREATE INDEX, CREATE TABLE, DROP VIEW, DROP INDEX, and DROP TABLE.

Question 9

List the DML operations.

Answer 9

• DELETE
• UPDATE
• INSERT
• SELECT

These operations are used to manipulate data within a database.

Question 10

List the DDL operations.

Answer 10

• ALTER TABLE
• CREATE VIEW
• CREATE INDEX
• CREATE TABLE
• DROP VIEW
• DROP INDEX
• DROP TABLE

These operations are used to define or modify the structure of a database.

Question 11

Fill in the blank: DML stands for _______.

Answer 11

Data Manipulation Language

DML is used for managing data within schema objects.

Question 12

Fill in the blank: DDL stands for _______.

Answer 12

Data Definition Language

DDL is used for defining and modifying database structures.