ISM 4212 final Exam Questions and Answers Graded A+

ISM 4212 final Exam Questions and
Answers Graded A+

relational database management system - Correct answer-A DBMS that manages

data as a collection of tables in which all relationships are represented by common

values in related tables

¤

a relational database management system (DBMS) is a software package that

manages the connection between the database and the schema - Correct answer-

false

the CREATE TABLE SQL statement defines a new table and its columns - Correct

answer-true

the ALTER TABLE statement allows you to change column specifications -

Correct answer-true

a constraint that states that the foreign key values of a table must match the

primary key values of a related table is called: - Correct answer-referential integrity



©COPYRIGHT 2025, ALL RIGHTS RESERVED 1

, in SQL, the UPDATE statement modifies data in an existing row or rows - Correct

answer-true

DROP TABLE statement - Correct answer-allows you to remove/delete tables

DELETE FROM tablename WHERE conditions - Correct answer-allows you to

remove certain rows from a table

DELETE FROM tablename - Correct answer-deletes all rows from a given table

in SQL, the INSERT statement adds one or more rows to a table - Correct answer-

true

in a SQL statement, the wildcard (*) retrieves all rows and columns in a table -

Correct answer-true

in a SQL statement, you use the AND, OR, and NOT operators for customizing

conditions in the WHERE clause - Correct answer-true

in SQL, all select statements will contain the keyword WHERE - Correct answer-

false

an example of an explicit join notation is - Correct answer-SELECT * FROM

employee JOIN department ON employee.departmentID =

department.departmentID



©COPYRIGHT 2025, ALL RIGHTS RESERVED 2