SQL, Database Management, and Data
Warehousing Concepts for ISM 4212
Exam Questions and Answers Graded A+
What are the different types of SQL? - Correct answer-Data definition, data
manipulation, and data control.
What does DDL stand for and what does it do? - Correct answer-Data definition
language; it defines (creates) and establishes constraints.
What does DML stand for and what does it do? - Correct answer-Data
manipulation language; it includes commands that maintain and query a database.
What does DCL stand for and what does it do? - Correct answer-Data control
language; it administers privileges and executes data.
What is referential integrity? - Correct answer-A constraint that states that foreign
key values of a table must match primary key values of the related table.
What is the basic form for making a table in SQL? - Correct answer-CREATE
TABLE tblname (columnname1 datatype not null primary key,.....)
©COPYRIGHT 2025, ALL RIGHTS RESERVED 1
, How do you add a foreign key to a table? - Correct answer-ALTER TABLE
tblname ADD FOREIGN KEY (blankid) references tblname2(blankid)
How do you insert a full row of data into a table? - Correct answer-INSERT INTO
tblname VALUES (1, 'Dodgers', '01/02/1980')
How do you insert a partial row of data? - Correct answer-INSERT INTO tblname
(columnname1, columnname2) VALUES ('no', 1)
How do you delete a whole table from a database? - Correct answer-DROP TABLE
tblname
How do you delete all rows from a table? - Correct answer-DELETE FROM
tblname
How do you update data in a table? - Correct answer-UPDATE tblname SET
column1 = new value WHERE condition.
How do you delete certain rows from a table? - Correct answer-DELETE FROM
tblname WHERE condition.
What is range control? - Correct answer-The allowable value limitations.
What is a database management system? - Correct answer-Software that handles
the storage, retrieval, and updating of data in a computer system.
©COPYRIGHT 2025, ALL RIGHTS RESERVED 2
Warehousing Concepts for ISM 4212
Exam Questions and Answers Graded A+
What are the different types of SQL? - Correct answer-Data definition, data
manipulation, and data control.
What does DDL stand for and what does it do? - Correct answer-Data definition
language; it defines (creates) and establishes constraints.
What does DML stand for and what does it do? - Correct answer-Data
manipulation language; it includes commands that maintain and query a database.
What does DCL stand for and what does it do? - Correct answer-Data control
language; it administers privileges and executes data.
What is referential integrity? - Correct answer-A constraint that states that foreign
key values of a table must match primary key values of the related table.
What is the basic form for making a table in SQL? - Correct answer-CREATE
TABLE tblname (columnname1 datatype not null primary key,.....)
©COPYRIGHT 2025, ALL RIGHTS RESERVED 1
, How do you add a foreign key to a table? - Correct answer-ALTER TABLE
tblname ADD FOREIGN KEY (blankid) references tblname2(blankid)
How do you insert a full row of data into a table? - Correct answer-INSERT INTO
tblname VALUES (1, 'Dodgers', '01/02/1980')
How do you insert a partial row of data? - Correct answer-INSERT INTO tblname
(columnname1, columnname2) VALUES ('no', 1)
How do you delete a whole table from a database? - Correct answer-DROP TABLE
tblname
How do you delete all rows from a table? - Correct answer-DELETE FROM
tblname
How do you update data in a table? - Correct answer-UPDATE tblname SET
column1 = new value WHERE condition.
How do you delete certain rows from a table? - Correct answer-DELETE FROM
tblname WHERE condition.
What is range control? - Correct answer-The allowable value limitations.
What is a database management system? - Correct answer-Software that handles
the storage, retrieval, and updating of data in a computer system.
©COPYRIGHT 2025, ALL RIGHTS RESERVED 2
