ISM 4212 Exam 2 - Armstrong EXAM (updated 2026)
Questions & Answers | With 100% Correct Answers graded
A+ Guaranteed Success!!
Leave the first rating
Save
Students also studied
Flashcard sets Study guides
DC Unit 6 Domain Controller and Ac... IPv4 and IPv6 Computer Science Paper 2 EE
Teacher 39 terms Teacher 67 terms Teacher 160 terms Te
incredibleTiffanny Preview sinwar6 Preview Caser78 Preview
Practice questions for this set
Learn 1 /7 Study with Learn
What is an outer join?
Choose an answer
Rows that do not have matching values are Rows that only appear in the left table are
1 2
completely removed from the result set. excluded from the result.
Rows that do not have matching values in
Rows that match in both tables are returned
3 common columns, are still a result. Can use 4
twice in the result.
left or right outer join.
Don't know?
Terms in this set (98)
What are the different types of SQL? Data definition, data manipulation, and data control.
What does DDL do and what does it stand for? Data definition language.
They are commands that define (create) and establish constraints.
, What does DML do and what does it stand for? Data manipulation language. Includes commands that maintain and query a
database.
What does DCL do and what does it stand for? Data control language.
They are commands that administer privileges and execute data.
What is referential integrity? 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. CREATE TABLE tblname (columnname1 datatype not null primary key,.....)
How do you add a FK to a table? ALTER TABLE tblname ADD FOREIGN KEY (blankid) references
tblname2(blankid)
How do you insert a full row of data into a table? INSERT INTO tblname VALUES (1, 'Dodgers', '01/02/1980')
How do you insert a partial row of data? INSERT INTO tblname (columnname1, comulmnname2) VALUES ('no',1)
How do you delete a whole table from a DB? DROP TABLE tblname
How do you delete all rows from a table? DELETE FROM tblname
How do you update data in a table? UPDATE tblname SET column1 = new value WHERE condition.
How do you delete certain rows from a table? DELETE FROM tblname WHERE condition.
What is range control? The allowable value limitations.
What is a database management system? Software that handles the storage, retrieval and updating of data in a computer
system.
What is a relational database management system? A DBMS that manages data as a collection of tables in which relationships are
represented by a common values in related tables.
Questions & Answers | With 100% Correct Answers graded
A+ Guaranteed Success!!
Leave the first rating
Save
Students also studied
Flashcard sets Study guides
DC Unit 6 Domain Controller and Ac... IPv4 and IPv6 Computer Science Paper 2 EE
Teacher 39 terms Teacher 67 terms Teacher 160 terms Te
incredibleTiffanny Preview sinwar6 Preview Caser78 Preview
Practice questions for this set
Learn 1 /7 Study with Learn
What is an outer join?
Choose an answer
Rows that do not have matching values are Rows that only appear in the left table are
1 2
completely removed from the result set. excluded from the result.
Rows that do not have matching values in
Rows that match in both tables are returned
3 common columns, are still a result. Can use 4
twice in the result.
left or right outer join.
Don't know?
Terms in this set (98)
What are the different types of SQL? Data definition, data manipulation, and data control.
What does DDL do and what does it stand for? Data definition language.
They are commands that define (create) and establish constraints.
, What does DML do and what does it stand for? Data manipulation language. Includes commands that maintain and query a
database.
What does DCL do and what does it stand for? Data control language.
They are commands that administer privileges and execute data.
What is referential integrity? 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. CREATE TABLE tblname (columnname1 datatype not null primary key,.....)
How do you add a FK to a table? ALTER TABLE tblname ADD FOREIGN KEY (blankid) references
tblname2(blankid)
How do you insert a full row of data into a table? INSERT INTO tblname VALUES (1, 'Dodgers', '01/02/1980')
How do you insert a partial row of data? INSERT INTO tblname (columnname1, comulmnname2) VALUES ('no',1)
How do you delete a whole table from a DB? DROP TABLE tblname
How do you delete all rows from a table? DELETE FROM tblname
How do you update data in a table? UPDATE tblname SET column1 = new value WHERE condition.
How do you delete certain rows from a table? DELETE FROM tblname WHERE condition.
What is range control? The allowable value limitations.
What is a database management system? Software that handles the storage, retrieval and updating of data in a computer
system.
What is a relational database management system? A DBMS that manages data as a collection of tables in which relationships are
represented by a common values in related tables.
