ISM 4212 Exam 2 – Armstrong Questions
with Correct Answers| Latest Update 2026
What are the different types of SQL?
Data definition, data manipulation, and data control.
What does DDL do and what does it stand for?
Data definition language.
They are commands that define (create) and establish constraints.
What does DML do and what does it stand for?
Data manipulation language. Includes commands that maintain and query a
database.
What does DCL do and what does it stand for?
Data control language.
They are commands that administer privileges and execute data.
,What is referential integrity?
A constraint that states that foreign key values of a table must match primary key
values of the related table.
Give the basic form for making a table in SQL.
CREATE TABLE tblname (columnname1 datatype not null primary key,.....)
How do you add a FK to a table?
ALTER TABLE tblname ADD FOREIGN KEY (blankid) references tblname2(blankid)
How do you insert a full row of data into a table?
INSERT INTO tblname VALUES (1, 'Dodgers', '01/02/1980')
How do you insert a partial row of data?
INSERT INTO tblname (columnname1, comulmnname2) VALUES ('no',1)
How do you delete a whole table from a DB?
DROP TABLE tblname
, How do you delete all rows from a table?
DELETE FROM tblname
How do you update data in a table?
UPDATE tblname SET column1 = new value WHERE condition.
How do you delete certain rows from a table?
DELETE FROM tblname WHERE condition.
What is range control?
The allowable value limitations.
What is a database management system?
Software that handles the storage, retrieval and updating of data in a computer
system.
with Correct Answers| Latest Update 2026
What are the different types of SQL?
Data definition, data manipulation, and data control.
What does DDL do and what does it stand for?
Data definition language.
They are commands that define (create) and establish constraints.
What does DML do and what does it stand for?
Data manipulation language. Includes commands that maintain and query a
database.
What does DCL do and what does it stand for?
Data control language.
They are commands that administer privileges and execute data.
,What is referential integrity?
A constraint that states that foreign key values of a table must match primary key
values of the related table.
Give the basic form for making a table in SQL.
CREATE TABLE tblname (columnname1 datatype not null primary key,.....)
How do you add a FK to a table?
ALTER TABLE tblname ADD FOREIGN KEY (blankid) references tblname2(blankid)
How do you insert a full row of data into a table?
INSERT INTO tblname VALUES (1, 'Dodgers', '01/02/1980')
How do you insert a partial row of data?
INSERT INTO tblname (columnname1, comulmnname2) VALUES ('no',1)
How do you delete a whole table from a DB?
DROP TABLE tblname
, How do you delete all rows from a table?
DELETE FROM tblname
How do you update data in a table?
UPDATE tblname SET column1 = new value WHERE condition.
How do you delete certain rows from a table?
DELETE FROM tblname WHERE condition.
What is range control?
The allowable value limitations.
What is a database management system?
Software that handles the storage, retrieval and updating of data in a computer
system.
