Page 1 of 33
ISM 4212 Exam 2 Armstrong ALL QUESTIONS
AND CORRECT ANSWERS LATEST UPDATE THIS
YEAR
ISM 4212 Exam 2
FINAL EXAMINATION
Academic Year: 2026–2027
Exam Title: ISM 4212 Exam 2
Content: Multiple-Choice Questions with Verified Solutions
Edition: Latest Update This Year
EXAMINATION INSTRUCTIONS
This examination evaluates core knowledge of Structured Query Language (SQL) and
database management systems, including data definition, manipulation, control, integrity
constraints, and basic SQL syntax.
Each question has four answer options. Select the single best answer.
Rationales are provided to reinforce understanding of database concepts and SQL command
usage.
Answer all questions based on standard SQL principles.
EXAM COVERAGE
• Types of SQL languages
• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Data Control Language (DCL)
• Referential integrity
• Table creation syntax
• Foreign key constraints
• Data insertion methods
1
, Page 2 of 33
• Table deletion and row deletion
• Data updating commands
• Range control
• Database management systems (DBMS)
EXAM QUESTIONS
Question 1
What are the different types of SQL?
A) Data storage, data retrieval, and data indexing
B) Data definition, data manipulation, and data control
C) Data formatting, data input, and data output
D) Data access, data encryption, and data sharing
Correct Answer:
B) Data definition, data manipulation, and data control
Rationale:
SQL is divided into DDL for defining structures, DML for manipulating data, and DCL for
controlling access and permissions.
Question 2
What does DDL stand for, and what does it do?
A) Data Design Language; retrieves records
B) Data Definition Language; defines tables and constraints
C) Data Description Language; manages users
D) Data Distribution Language; moves data between servers
Correct Answer:
B) Data Definition Language; defines tables and constraints
Rationale:
DDL commands such as CREATE, ALTER, and DROP are used to define database objects and
establish constraints.
2
, Page 3 of 33
Question 3
What does DML stand for, and what does it include?
A) Data Management Language; security commands
B) Data Manipulation Language; commands that maintain and query data
C) Data Mapping Language; relationship enforcement
D) Data Monitoring Language; performance tracking
Correct Answer:
B) Data Manipulation Language; commands that maintain and query data
Rationale:
DML includes INSERT, UPDATE, DELETE, and SELECT, which are used to modify and
retrieve data.
Question 4
What does DCL stand for, and what is its purpose?
A) Data Creation Language; defines schemas
B) Data Control Language; administers privileges and access
C) Data Constraint Language; enforces integrity
D) Data Communication Language; transfers data
Correct Answer:
B) Data Control Language; administers privileges and access
Rationale:
DCL commands such as GRANT and REVOKE control user permissions within a database
system.
Question 5
What is referential integrity?
A) A rule ensuring all table values are unique
B) A constraint requiring foreign keys to match primary keys
C) A method for encrypting relational data
D) A process for backing up databases
3
, Page 4 of 33
Correct Answer:
B) A constraint requiring foreign keys to match primary keys
Rationale:
Referential integrity maintains consistency between related tables by enforcing valid foreign key
relationships.
Question 6
What is the basic SQL syntax for creating a table?
A) MAKE TABLE tblname ADD column datatype
B) CREATE TABLE tblname (columnname datatype constraints)
C) BUILD TABLE tblname WITH fields
D) INSERT TABLE tblname VALUES
Correct Answer:
B) CREATE TABLE tblname (columnname datatype constraints)
Rationale:
The CREATE TABLE command defines a table, its columns, data types, and constraints such as
PRIMARY KEY and NOT NULL.
Question 7
How do you add a foreign key to an existing table?
A) CREATE FOREIGN KEY ON tblname
B) INSERT FOREIGN KEY INTO tblname
C) ALTER TABLE tblname ADD FOREIGN KEY (...) REFERENCES tblname2(...)
D) UPDATE tblname SET FOREIGN KEY
Correct Answer:
C) ALTER TABLE tblname ADD FOREIGN KEY (...) REFERENCES tblname2(...)
Rationale:
Foreign keys are added using the ALTER TABLE command with a REFERENCES clause.
Question 8
4
ISM 4212 Exam 2 Armstrong ALL QUESTIONS
AND CORRECT ANSWERS LATEST UPDATE THIS
YEAR
ISM 4212 Exam 2
FINAL EXAMINATION
Academic Year: 2026–2027
Exam Title: ISM 4212 Exam 2
Content: Multiple-Choice Questions with Verified Solutions
Edition: Latest Update This Year
EXAMINATION INSTRUCTIONS
This examination evaluates core knowledge of Structured Query Language (SQL) and
database management systems, including data definition, manipulation, control, integrity
constraints, and basic SQL syntax.
Each question has four answer options. Select the single best answer.
Rationales are provided to reinforce understanding of database concepts and SQL command
usage.
Answer all questions based on standard SQL principles.
EXAM COVERAGE
• Types of SQL languages
• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Data Control Language (DCL)
• Referential integrity
• Table creation syntax
• Foreign key constraints
• Data insertion methods
1
, Page 2 of 33
• Table deletion and row deletion
• Data updating commands
• Range control
• Database management systems (DBMS)
EXAM QUESTIONS
Question 1
What are the different types of SQL?
A) Data storage, data retrieval, and data indexing
B) Data definition, data manipulation, and data control
C) Data formatting, data input, and data output
D) Data access, data encryption, and data sharing
Correct Answer:
B) Data definition, data manipulation, and data control
Rationale:
SQL is divided into DDL for defining structures, DML for manipulating data, and DCL for
controlling access and permissions.
Question 2
What does DDL stand for, and what does it do?
A) Data Design Language; retrieves records
B) Data Definition Language; defines tables and constraints
C) Data Description Language; manages users
D) Data Distribution Language; moves data between servers
Correct Answer:
B) Data Definition Language; defines tables and constraints
Rationale:
DDL commands such as CREATE, ALTER, and DROP are used to define database objects and
establish constraints.
2
, Page 3 of 33
Question 3
What does DML stand for, and what does it include?
A) Data Management Language; security commands
B) Data Manipulation Language; commands that maintain and query data
C) Data Mapping Language; relationship enforcement
D) Data Monitoring Language; performance tracking
Correct Answer:
B) Data Manipulation Language; commands that maintain and query data
Rationale:
DML includes INSERT, UPDATE, DELETE, and SELECT, which are used to modify and
retrieve data.
Question 4
What does DCL stand for, and what is its purpose?
A) Data Creation Language; defines schemas
B) Data Control Language; administers privileges and access
C) Data Constraint Language; enforces integrity
D) Data Communication Language; transfers data
Correct Answer:
B) Data Control Language; administers privileges and access
Rationale:
DCL commands such as GRANT and REVOKE control user permissions within a database
system.
Question 5
What is referential integrity?
A) A rule ensuring all table values are unique
B) A constraint requiring foreign keys to match primary keys
C) A method for encrypting relational data
D) A process for backing up databases
3
, Page 4 of 33
Correct Answer:
B) A constraint requiring foreign keys to match primary keys
Rationale:
Referential integrity maintains consistency between related tables by enforcing valid foreign key
relationships.
Question 6
What is the basic SQL syntax for creating a table?
A) MAKE TABLE tblname ADD column datatype
B) CREATE TABLE tblname (columnname datatype constraints)
C) BUILD TABLE tblname WITH fields
D) INSERT TABLE tblname VALUES
Correct Answer:
B) CREATE TABLE tblname (columnname datatype constraints)
Rationale:
The CREATE TABLE command defines a table, its columns, data types, and constraints such as
PRIMARY KEY and NOT NULL.
Question 7
How do you add a foreign key to an existing table?
A) CREATE FOREIGN KEY ON tblname
B) INSERT FOREIGN KEY INTO tblname
C) ALTER TABLE tblname ADD FOREIGN KEY (...) REFERENCES tblname2(...)
D) UPDATE tblname SET FOREIGN KEY
Correct Answer:
C) ALTER TABLE tblname ADD FOREIGN KEY (...) REFERENCES tblname2(...)
Rationale:
Foreign keys are added using the ALTER TABLE command with a REFERENCES clause.
Question 8
4
