ISM 4212 Exam 2 – Armstrong With 98 ques ons and
answers Newest RATED A+ 2025/2026 NEW EDITON!!
What are the different types of SQL? - Ans Data defini on, data manipula on, and data
control.
What does DDL do and what does it stand for? - Ans Data defini on language.
They are commands that define (create) and establish constraints.
What does DML do and what does it stand for? - Ans Data manipula on 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 referen al 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 par al 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
condi on.
How do you delete certain rows from a table? - Ans DELETE FROM tblname WHERE condi on.
What is range control? - Ans The allowable value limita ons.
What is a database management system? - Ans SoBware that handles the storage, retrieval
and upda ng of data in a computer system.
What is a rela onal database management system? - Ans A DBMS that manages data as a
collec on of tables in which rela onships are represented by a common values in related tables.
What is SQL? - Ans A special-purpose programming language designed for managing data in a
RDBMS.
how do you create a database? - Ans CREATE DATABASE dbname
Which terms are used alongside of select statements? - Ans from, where, group by, having,
order by
answers Newest RATED A+ 2025/2026 NEW EDITON!!
What are the different types of SQL? - Ans Data defini on, data manipula on, and data
control.
What does DDL do and what does it stand for? - Ans Data defini on language.
They are commands that define (create) and establish constraints.
What does DML do and what does it stand for? - Ans Data manipula on 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 referen al 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 par al 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
condi on.
How do you delete certain rows from a table? - Ans DELETE FROM tblname WHERE condi on.
What is range control? - Ans The allowable value limita ons.
What is a database management system? - Ans SoBware that handles the storage, retrieval
and upda ng of data in a computer system.
What is a rela onal database management system? - Ans A DBMS that manages data as a
collec on of tables in which rela onships are represented by a common values in related tables.
What is SQL? - Ans A special-purpose programming language designed for managing data in a
RDBMS.
how do you create a database? - Ans CREATE DATABASE dbname
Which terms are used alongside of select statements? - Ans from, where, group by, having,
order by
