Data Definition Language (DDL): Master Database Object Management

Question 1

Which of the following database objects CANNOT be created using DDL?

Accepted Answer

Trigger

Answer

Table

Answer

View

Answer

Index

Question 2

Data normalization offers several advantages. Which of the following is NOT a benefit of this database design technique?

Accepted Answer

Increased data redundancy

Answer

Improved data integrity

Answer

Reduced data duplication

Answer

Enhanced data flexibility

Question 3

Which of the following is an invalid use of the ALTER TABLE statement?

Accepted Answer

Creating a new table

Answer

Adding a new column to an existing table

Answer

Dropping a column from an existing table

Answer

Changing the data type of an existing column

Question 4

Which DDL command is used to create a new table with a specific structure?

Accepted Answer

CREATE TABLE

Answer

ALTER TABLE

Answer

DROP TABLE

Answer

RENAME TABLE

Question 5

What is the primary purpose of a primary key?

Accepted Answer

To uniquely identify each row in a table

Answer

To enforce data integrity by preventing duplicate rows

Answer

To improve query performance by creating an index on the column

Answer

To store additional information about a row

Question 6

What is the key difference between a table and a view?

Accepted Answer

A table physically stores data, while a view is a virtual representation derived from one or more tables.

Answer

A view can be updated, while a table cannot.

Answer

A table can have multiple primary keys, while a view cannot.

Answer

There is no practical difference between a table and a view.

Question 7

Which DDL command is used to modify the structure of an existing table?

Accepted Answer

ALTER TABLE

Answer

CREATE TABLE

Answer

DROP TABLE

Answer

RENAME TABLE

Question 8

What is the primary benefit of using an index in a database?

Accepted Answer

To significantly improve query performance by providing faster data retrieval

Answer

To enforce data integrity by preventing invalid data from being inserted

Answer

To store duplicate data for backup and recovery purposes

Answer

To reduce storage space by compressing data

Question 9

Which DDL keyword is used to define a stored procedure?

Accepted Answer

CREATE PROCEDURE

Answer

CREATE FUNCTION

Answer

DECLARE PROCEDURE

Answer

DEFINE PROCEDURE

Question 10

What is the key difference between a trigger and a stored procedure?

Accepted Answer

A trigger is automatically executed when a specific event occurs on a table, while a stored procedure is manually invoked.

Answer

A stored procedure can modify data, while a trigger cannot.

Answer

A trigger can be defined on multiple tables, while a stored procedure cannot.

Answer

There is no fundamental difference between a trigger and a stored procedure.

Question 11

Which of the following is **not** a Data Definition Language (DDL) statement?

Accepted Answer

SELECT * FROM

Answer

CREATE TABLE

Answer

ALTER TABLE

Answer

DROP VIEW

Question 12

In a CREATE TABLE statement, which clause is used to specify a default value for a column?

Accepted Answer

DEFAULT

Answer

CONSTRAINT

Answer

PRIMARY KEY

Answer

UNIQUE

Question 13

What is the main purpose of indexes in a relational database?

Accepted Answer

Speeding up data retrieval

Answer

Ensuring data integrity

Answer

Enforcing referential integrity

Answer

Storing duplicate data

Question 14

Which Data Definition Language (DDL) statement is used to create a new table in a database?

Accepted Answer

CREATE TABLE

Answer

ALTER TABLE

Answer

DROP TABLE

Answer

INSERT INTO

Question 15

What is the primary purpose of a PRIMARY KEY constraint?

Accepted Answer

To uniquely identify each row in a table

Answer

To enforce data integrity by preventing duplicate values

Answer

To create an index on the specified column

Answer

To establish a relationship between two tables

Question 16

Explain the fundamental difference between a table and a view in a database.

Accepted Answer

A table stores actual data, while a view is a virtual table that is derived from one or more tables

Answer

A view can be updated, while a table cannot

Answer

A table has a fixed schema, while a view can have a dynamic schema

Answer

There is no difference between a table and a view

Question 17

What is the primary benefit of using indexes in a database?

Accepted Answer

Improved query performance

Answer

Reduced storage space

Answer

Enhanced data integrity

Answer

Simplified data retrieval

Question 18

What is the primary purpose of a stored procedure?

Accepted Answer

To group together a set of SQL statements that can be executed as a single unit

Answer

To create a new data type

Answer

To define a user-defined function

Answer

To manage database users and permissions

Question 19

What is the primary function of a database management system (DBMS)?

Accepted Answer

To manage and control access to the database

Answer

To provide a user interface for interacting with the database

Answer

To optimize query performance

Answer

To back up and restore the database

Question 20

To create a new table in a database, which DDL statement should you use?

Accepted Answer

CREATE TABLE

Answer

ALTER TABLE

Answer

DROP TABLE

Question 21

Which of the following is NOT a DDL statement used to modify an existing table's structure?

Accepted Answer

UPDATE

Answer

ALTER TABLE

Answer

ADD COLUMN

Answer

DROP COLUMN

Question 22

Which DDL statement is used to create a new table?

Accepted Answer

CREATE TABLE

Answer

UPDATE TABLE

Answer

ALTER TABLE

Answer

DROP TABLE

Question 23

What is the purpose of using a PRIMARY KEY constraint?

Accepted Answer

To uniquely identify each row in a table.

Answer

To enforce data integrity.

Answer

To define a relationship between tables.

Answer

To index data for faster retrieval.

Question 24

Which DDL statement is used to modify an existing table by adding a new column?

Accepted Answer

ALTER TABLE ADD COLUMN

Answer

UPDATE TABLE ADD COLUMN

Answer

CREATE TABLE ALTER COLUMN

Answer

MODIFY TABLE ADD COLUMN

Question 25

What is the purpose of using an index in a database?

Accepted Answer

To enhance query performance by enabling quick data retrieval.

Answer

To define relationships between tables.

Answer

To enforce data integrity.

Question 26

How do you delete an existing index from a table using DDL?

Accepted Answer

DROP INDEX

Answer

ALTER INDEX

Answer

REMOVE INDEX

Answer

DELETE INDEX

Question 27

What is the primary difference between a stored procedure and a function in DDL?

Accepted Answer

A stored procedure can modify data, while a function cannot.

Answer

A function can be called from a stored procedure but not vice versa.

Answer

A stored procedure is always faster than a function.

Question 28

Which of the following is a key objective of database normalization?

Accepted Answer

Eliminating data redundancy.

Answer

Enabling multiple user access to the database.

Answer

Increasing database size.

Answer

Ensuring data security.

Question 29

What is the purpose of using a UNIQUE constraint in a table?

Accepted Answer

To ensure distinct values in a specified column.

Answer

To define relationships between tables.

Answer

To enforce data integrity.