ISM 4212 Exam 2 - Armstrong EXAM QUESTIONS
AND CORRECT DETAILED ANSWERS (VERIFIED
ANSWERS)
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,.....)
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.
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
AND CORRECT DETAILED ANSWERS (VERIFIED
ANSWERS)
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,.....)
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.
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
