C170 - Data Management Applications Questions and Answers (100% Correct Answers) Already Graded A+

For Expert help and assignment handling,
1





C170 - Data Management Applications
Questions and Answers (100% Correct
Answers) Already Graded A+
Relational ModelAns: database model based on mathematical
principles


3 parts of relational modelAns: A data structure that prescribes how data
© 2026 Assignment Expert




is organized.


Operations that manipulate data structures.
Guru01 - Stuvia




Rules that govern valid relational data.


What adds, deletes, or modifies columns on an existing tableAns: ALTER
TABLE statement


ALTER TABLE AddAns: Adds a column


Alter Table ChangeAns: Modifies a column


Alter Table DropAns: Deletes a Column


What is the function of the Primary Key Constraint?Ans: Names the tables
column that uniquely identify each row


PRIMARY KEY (Column Name)

, For Expert help and assignment handling,
2




What is the Foreign Key Syntax?Ans: FOREIGN KEY (Column 2 Name)
REFERENCES (Column 1 Name)


What is the function of the Foreign Key Constraint?Ans: Refers to the
Primary Key of another table


What does Create Table Statement do?Ans: Creates a new table and
specifies the table name, column and column data types
© 2026 Assignment Expert




What does the DROP TABLE statement do?Ans: Deletes a table and the
table's rows from a database.


What does the ALTER TABLE statement do?Ans: Adds, deletes or modifies
Guru01 - Stuvia




Columns on an existing table. It specifies a table name followed by a
clause that indicates what should be altered.


What are the 3 ALTER TABLE Clauses?Ans: Add - adds a column


Change - Modifies a column


Drop - Deletes a column


What actions are specified with the FOREIGN KEY Constraint?Ans: On
Delete


On Update


What are the 4 Foreign Key Action Responses?Ans: Restrict - Rejects an
insert, update or delete