Page |1
ISM 4212 Exam 2 - Armstrong Questions
and Correct Answers/ Latest Update /
Already Graded
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.
All rights reserved © 2025/ 2026 |
, Page |2
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,.....)
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?
All rights reserved © 2025/ 2026 |
, Page |3
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?
All rights reserved © 2025/ 2026 |
ISM 4212 Exam 2 - Armstrong Questions
and Correct Answers/ Latest Update /
Already Graded
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.
All rights reserved © 2025/ 2026 |
, Page |2
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,.....)
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?
All rights reserved © 2025/ 2026 |
, Page |3
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?
All rights reserved © 2025/ 2026 |
