ISM 4212 EXAM 2 – ARMSTRONG
QUESTIONS AND ANSWERS GRADED A+
2026
What are the different types of SQL? - ANS Data definition, data manipulation, and data
control.
What does DDL do and what does it stand for? - ANS Data definition language.
They are commands that define (create) and establish constraints.
What does DML do and what does it stand for? - ANS Data manipulation language. Includes
commands that maintain and query a database.
What does DCL do and what does it stand for? - ANS Data control language.
They are commands that administer privileges and execute data.
What is referential integrity? - ANS 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. - ANS CREATE TABLE tblname (columnname1
datatype not null primary key,.....)
@COPYRIGHT 2026/2027 ALL RIGHTS RESERVED
1
, How do you add a FK to a table? - ANS ALTER TABLE tblname ADD FOREIGN KEY (blankid)
references tblname2(blankid)
How do you insert a full row of data into a table? - ANS INSERT INTO tblname VALUES (1,
'Dodgers', '01/02/1980')
How do you insert a partial row of data? - ANS INSERT INTO tblname (columnname1,
comulmnname2) VALUES ('no',1)
How do you delete a whole table from a DB? - ANS DROP TABLE tblname
How do you delete all rows from a table? - ANS DELETE FROM tblname
How do you update data in a table? - ANS UPDATE tblname SET column1 = new value WHERE
condition.
How do you delete certain rows from a table? - ANS DELETE FROM tblname WHERE
condition.
What is range control? - ANS The allowable value limitations.
What is a database management system? - ANS Software that handles the storage, retrieval
and updating of data in a computer system.
What is a relational database management system? - ANS A DBMS that manages data as a
collection of tables in which relationships are represented by a common values in related tables.
@COPYRIGHT 2026/2027 ALL RIGHTS RESERVED
2
QUESTIONS AND ANSWERS GRADED A+
2026
What are the different types of SQL? - ANS Data definition, data manipulation, and data
control.
What does DDL do and what does it stand for? - ANS Data definition language.
They are commands that define (create) and establish constraints.
What does DML do and what does it stand for? - ANS Data manipulation language. Includes
commands that maintain and query a database.
What does DCL do and what does it stand for? - ANS Data control language.
They are commands that administer privileges and execute data.
What is referential integrity? - ANS 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. - ANS CREATE TABLE tblname (columnname1
datatype not null primary key,.....)
@COPYRIGHT 2026/2027 ALL RIGHTS RESERVED
1
, How do you add a FK to a table? - ANS ALTER TABLE tblname ADD FOREIGN KEY (blankid)
references tblname2(blankid)
How do you insert a full row of data into a table? - ANS INSERT INTO tblname VALUES (1,
'Dodgers', '01/02/1980')
How do you insert a partial row of data? - ANS INSERT INTO tblname (columnname1,
comulmnname2) VALUES ('no',1)
How do you delete a whole table from a DB? - ANS DROP TABLE tblname
How do you delete all rows from a table? - ANS DELETE FROM tblname
How do you update data in a table? - ANS UPDATE tblname SET column1 = new value WHERE
condition.
How do you delete certain rows from a table? - ANS DELETE FROM tblname WHERE
condition.
What is range control? - ANS The allowable value limitations.
What is a database management system? - ANS Software that handles the storage, retrieval
and updating of data in a computer system.
What is a relational database management system? - ANS A DBMS that manages data as a
collection of tables in which relationships are represented by a common values in related tables.
@COPYRIGHT 2026/2027 ALL RIGHTS RESERVED
2
