ISM 4212 final | UPDATED Questions with 100% Verified
Answers
Q1: relational database management
A: A DBMS that manages data as a collection of
Q2: system
A: tables in which all relationships are represented
by common values in related tables
¤
Q3: a relational database management
A: false
Q4: system (DBMS) is a software
A:
Q5: package that manages the
A:
Q6: connection between the database
A:
Q7: and the schema
A:
Q8: the CREATE TABLE SQL statement
A: true
Q9: defines a new table and its
A:
Q10: columns
A:
Q11: the ALTER TABLE statement allows
A: true
Q12: you to change column
, A:
Q13: specifications
A:
Q14: a constraint that states that the
A: referential integrity
Q15: foreign key values of a table must
A:
Q16: match the primary key values of a
A:
Q17: related table is called
A:
Q18: in SQL, the UPDATE statement
A: true
Q19: modifies data in an existing row or
A:
Q20: rows
A:
Q21: DROP TABLE statement
A: allows you to remove/delete tables
Q22: DELETE FROM tablename WHERE
A: allows you to remove certain rows from a table
Q23: conditions
A:
Q24: DELETE FROM tablename
A: deletes all rows from a given table
Q25: in SQL, the INSERT statement adds
Answers
Q1: relational database management
A: A DBMS that manages data as a collection of
Q2: system
A: tables in which all relationships are represented
by common values in related tables
¤
Q3: a relational database management
A: false
Q4: system (DBMS) is a software
A:
Q5: package that manages the
A:
Q6: connection between the database
A:
Q7: and the schema
A:
Q8: the CREATE TABLE SQL statement
A: true
Q9: defines a new table and its
A:
Q10: columns
A:
Q11: the ALTER TABLE statement allows
A: true
Q12: you to change column
, A:
Q13: specifications
A:
Q14: a constraint that states that the
A: referential integrity
Q15: foreign key values of a table must
A:
Q16: match the primary key values of a
A:
Q17: related table is called
A:
Q18: in SQL, the UPDATE statement
A: true
Q19: modifies data in an existing row or
A:
Q20: rows
A:
Q21: DROP TABLE statement
A: allows you to remove/delete tables
Q22: DELETE FROM tablename WHERE
A: allows you to remove certain rows from a table
Q23: conditions
A:
Q24: DELETE FROM tablename
A: deletes all rows from a given table
Q25: in SQL, the INSERT statement adds