ISM 4212 Exam 2 – Armstrong Questions
with Complete Solutions (Latest 2025)
What are the different types of SQL? - Correct Answers
✅Data definition, data manipulation, and data control.
What does DDL do and what does it stand for? - Correct
Answers ✅Data definition language.
They are commands that define (create) and establish
constraints.
What does DML do and what does it stand for? - Correct
Answers ✅Data manipulation language. Includes
commands that maintain and query a database.
What does DCL do and what does it stand for? - Correct
Answers ✅Data control language.
They are commands that administer privileges and execute
data.
What is referential integrity? - Correct Answers ✅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. - Correct
Answers ✅CREATE TABLE tblname (columnname1 datatype
not null primary key,.....)
,ISM 4212 Exam 2 – Armstrong Questions
with Complete Solutions (Latest 2025)
How do you add a FK to a table? - Correct Answers ✅ALTER
TABLE tblname ADD FOREIGN KEY (blankid) references
tblname2(blankid)
How do you insert a full row of data into a table? - Correct
Answers ✅INSERT INTO tblname VALUES (1, 'Dodgers',
'01/02/1980')
How do you insert a partial row of data? - Correct Answers
✅INSERT INTO tblname (columnname1, comulmnname2)
VALUES ('no',1)
How do you delete a whole table from a DB? - Correct
Answers ✅DROP TABLE tblname
How do you delete all rows from a table? - Correct Answers
✅DELETE FROM tblname
How do you update data in a table? - Correct Answers
✅UPDATE tblname SET column1 = new value WHERE
condition.
How do you delete certain rows from a table? - Correct
Answers ✅DELETE FROM tblname WHERE condition.
, ISM 4212 Exam 2 – Armstrong Questions
with Complete Solutions (Latest 2025)
What is range control? - Correct Answers ✅The allowable
value limitations.
What is a database management system? - Correct
Answers ✅Software that handles the storage, retrieval and
updating of data in a computer system.
What is a relational database management system? -
Correct Answers ✅A DBMS that manages data as a
collection of tables in which relationships are represented by
a common values in related tables.
What is SQL? - Correct Answers ✅A special-purpose
programming language designed for managing data in a
RDBMS.
how do you create a database? - Correct Answers
✅CREATE DATABASE dbname
Which terms are used alongside of select statements? -
Correct Answers ✅from, where, group by, having, order by
How do you add a primary key that's composite? - Correct
Answers ✅ALTER TABLE xyz ADD CONSTRAINT xxxxxID
primary key (pkname1, pkname2)
with Complete Solutions (Latest 2025)
What are the different types of SQL? - Correct Answers
✅Data definition, data manipulation, and data control.
What does DDL do and what does it stand for? - Correct
Answers ✅Data definition language.
They are commands that define (create) and establish
constraints.
What does DML do and what does it stand for? - Correct
Answers ✅Data manipulation language. Includes
commands that maintain and query a database.
What does DCL do and what does it stand for? - Correct
Answers ✅Data control language.
They are commands that administer privileges and execute
data.
What is referential integrity? - Correct Answers ✅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. - Correct
Answers ✅CREATE TABLE tblname (columnname1 datatype
not null primary key,.....)
,ISM 4212 Exam 2 – Armstrong Questions
with Complete Solutions (Latest 2025)
How do you add a FK to a table? - Correct Answers ✅ALTER
TABLE tblname ADD FOREIGN KEY (blankid) references
tblname2(blankid)
How do you insert a full row of data into a table? - Correct
Answers ✅INSERT INTO tblname VALUES (1, 'Dodgers',
'01/02/1980')
How do you insert a partial row of data? - Correct Answers
✅INSERT INTO tblname (columnname1, comulmnname2)
VALUES ('no',1)
How do you delete a whole table from a DB? - Correct
Answers ✅DROP TABLE tblname
How do you delete all rows from a table? - Correct Answers
✅DELETE FROM tblname
How do you update data in a table? - Correct Answers
✅UPDATE tblname SET column1 = new value WHERE
condition.
How do you delete certain rows from a table? - Correct
Answers ✅DELETE FROM tblname WHERE condition.
, ISM 4212 Exam 2 – Armstrong Questions
with Complete Solutions (Latest 2025)
What is range control? - Correct Answers ✅The allowable
value limitations.
What is a database management system? - Correct
Answers ✅Software that handles the storage, retrieval and
updating of data in a computer system.
What is a relational database management system? -
Correct Answers ✅A DBMS that manages data as a
collection of tables in which relationships are represented by
a common values in related tables.
What is SQL? - Correct Answers ✅A special-purpose
programming language designed for managing data in a
RDBMS.
how do you create a database? - Correct Answers
✅CREATE DATABASE dbname
Which terms are used alongside of select statements? -
Correct Answers ✅from, where, group by, having, order by
How do you add a primary key that's composite? - Correct
Answers ✅ALTER TABLE xyz ADD CONSTRAINT xxxxxID
primary key (pkname1, pkname2)
