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,.....) 1 / 3
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. 2 / 3
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)
- / 3