ISM 4212 Exam 2 - Armstrong | UPDATED Questions with 100% Verified Answers

ISM 4212 Exam 2 - Armstrong | UPDATED Questions with
100% Verified Answers
Q1: What are the different types of
A: Data definition, data manipulation, and data


Q2: SQL?
A: control.


Q3: What does DDL do and what does
A: Data definition language.


Q4: it stand for?
A: They are commands that define (create) and
establish constraints.


Q5: What does DML do and what does
A: Data manipulation language. Includes


Q6: it stand for?
A: commands that maintain and query a database.


Q7: What does DCL do and what does
A: Data control language.


Q8: it stand for?
A: They are commands that administer privileges
and execute data.


Q9: What is referential integrity?
A: A constraint that states that foreign key values of
a table must match primary key values of the
related table.


Q10: Give the basic form for making a
A: CREATE TABLE tblname (columnname1 datatype


Q11: table in SQL.
A: not null primary key,.....)

, Q12: How do you add a FK to a table?
A: ALTER TABLE tblname ADD FOREIGN KEY
(blankid) references tblname2(blankid)


Q13: How do you insert a full row of
A: INSERT INTO tblname VALUES (1, 'Dodgers',


Q14: data into a table?
A: '01/02/1980')


Q15: How do you insert a partial row of
A: INSERT INTO tblname (columnname1,


Q16: data?
A: comulmnname2) VALUES ('no',1)


Q17: How do you delete a whole table
A: DROP TABLE tblname


Q18: from a DB?
A:


Q19: How do you delete all rows from a
A: DELETE FROM tblname


Q20: table?
A:


Q21: How do you update data in a
A: UPDATE tblname SET column1 = new value


Q22: table?
A: WHERE condition.