4/20/26, 9:12 AM ISM 4212 Exam 2 - Armstrong EXAM (updated 2026) Questions & Answers | With 100% Correct Answers graded A+ Guaranteed S…
ISM 4212 Exam 2 - Armstrong EXAM (updated
2026) Questions & Answers | With 100% Correct
Answers graded A+ Guaranteed Success!!
Save
Terms in this set (98)
What are the different types of SQL? Data definition, data manipulation, and data
control.
What does DDL do and what does it Data definition language.
stand for? They are commands that define (create) and
establish constraints.
What does DML do and what does it Data manipulation language. Includes commands
stand for? that maintain and query a database.
What does DCL do and what does it Data control language.
stand for? 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 CREATE TABLE tblname (columnname1 datatype
table in SQL. not null primary key,.....)
https://quizlet.com/1170063870/ism-4212-exam-2-armstrong-exam-updated-2026-questions-answers-with-100-correct-answers-graded-a-guaranteed… 1/12
, 4/20/26, 9:12 AM ISM 4212 Exam 2 - Armstrong EXAM (updated 2026) Questions & Answers | With 100% Correct Answers graded A+ Guaranteed S…
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 INSERT INTO tblname VALUES (1, 'Dodgers',
into a table? '01/02/1980')
How do you insert a partial row of INSERT INTO tblname (columnname1,
data? comulmnname2) VALUES ('no',1)
How do you delete a whole table DROP TABLE tblname
from a DB?
How do you delete all rows from a DELETE FROM tblname
table?
How do you update data in a table? UPDATE tblname SET column1 = new value WHERE
condition.
How do you delete certain rows DELETE FROM tblname WHERE condition.
from a table?
What is range control? The allowable value limitations.
What is a database management Software that handles the storage, retrieval and
system? updating of data in a computer system.
What is a relational database A DBMS that manages data as a collection of
management system? tables in which relationships are represented by a
common values in related tables.
What is SQL? A special-purpose programming language
designed for managing data in a RDBMS.
https://quizlet.com/1170063870/ism-4212-exam-2-armstrong-exam-updated-2026-questions-answers-with-100-correct-answers-graded-a-guaranteed… 2/12
ISM 4212 Exam 2 - Armstrong EXAM (updated
2026) Questions & Answers | With 100% Correct
Answers graded A+ Guaranteed Success!!
Save
Terms in this set (98)
What are the different types of SQL? Data definition, data manipulation, and data
control.
What does DDL do and what does it Data definition language.
stand for? They are commands that define (create) and
establish constraints.
What does DML do and what does it Data manipulation language. Includes commands
stand for? that maintain and query a database.
What does DCL do and what does it Data control language.
stand for? 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 CREATE TABLE tblname (columnname1 datatype
table in SQL. not null primary key,.....)
https://quizlet.com/1170063870/ism-4212-exam-2-armstrong-exam-updated-2026-questions-answers-with-100-correct-answers-graded-a-guaranteed… 1/12
, 4/20/26, 9:12 AM ISM 4212 Exam 2 - Armstrong EXAM (updated 2026) Questions & Answers | With 100% Correct Answers graded A+ Guaranteed S…
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 INSERT INTO tblname VALUES (1, 'Dodgers',
into a table? '01/02/1980')
How do you insert a partial row of INSERT INTO tblname (columnname1,
data? comulmnname2) VALUES ('no',1)
How do you delete a whole table DROP TABLE tblname
from a DB?
How do you delete all rows from a DELETE FROM tblname
table?
How do you update data in a table? UPDATE tblname SET column1 = new value WHERE
condition.
How do you delete certain rows DELETE FROM tblname WHERE condition.
from a table?
What is range control? The allowable value limitations.
What is a database management Software that handles the storage, retrieval and
system? updating of data in a computer system.
What is a relational database A DBMS that manages data as a collection of
management system? tables in which relationships are represented by a
common values in related tables.
What is SQL? A special-purpose programming language
designed for managing data in a RDBMS.
https://quizlet.com/1170063870/ism-4212-exam-2-armstrong-exam-updated-2026-questions-answers-with-100-correct-answers-graded-a-guaranteed… 2/12
