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

ISM 4212 Exam #2 | UPDATED Questions with 100%
Verified Answers
Q1: The ALTER TABLE statement allows
A: True


Q2: you to change column
A:


Q3: specifications. True/False
A:


Q4: SQL (Structured Query Language)
A: True


Q5: is a programming language used to
A:


Q6: manage data in relational database
A:


Q7: management systems (RDBMS).
A:


Q8: True/False
A:


Q9: DELETE FROM tablename WHERE
A: allows you to remove certain rows from a table


Q10: condition
A:


Q11: DROP TABLE statement
A: allows you to remove named tables from the
database


Q12: DELETE FROM tablename
A: deletes all rows from a given table

,Q13: In SQL, the CREATE TABLE
A: True


Q14: statement defines a new table and
A:


Q15: its columns.
A:


Q16: True/False
A:


Q17: In SQL, the UPDATE statement
A: True


Q18: modifies data in an existing row (or
A:


Q19: rows). True/False
A:


Q20: Data Definition Language
A: define a database (creating, altering, and


Q21: commands that ....
A: dropping tables)


Q22: Data manipulation Language
A: maintain and query a database


Q23: commands that ....
A:


Q24: Data control Language: commands
A: control a database


Q25: that ...
A:

, Q26: The SQL statement SELECT does
A: 3. Determines what columns of data you want


Q27: what?
A:


Q28: 1. Indicates the conditions under
A:


Q29: which a row will be included
A:


Q30: 2. Indicates the table(s) from which
A:


Q31: the data will be obtained
A:


Q32: 3. Determines what columns of
A:


Q33: data you want
A:


Q34: The SQL statement FROM does
A: 2. Indicates the table(s) from which the data will


Q35: what?
A: be obtained


Q36: 1. Indicates the conditions under
A:


Q37: which a row will be included
A:


Q38: 2. Indicates the table(s) from which
A: