CSCI 466 FINAL EXAM QUESTIONS WITH ANSWERS
100% VERIFIED
The set of allowable values for an attribute in a relational schema is called what? - ANSWER
Domain
Which of the following is an atomic value? - ANSWER 42.1232
What needs to be true of a relation that has already been determined to be in 2NF in order
for it to be in 3NF - ANSWER There must be transitive depndencies
An attribute or set of attributes within a relation that references a key of some other relation
is a? - ANSWER Foreign Key
Which of the following must be trueof a table that has already been found to be in 1NF in
order for it to be in 2NF - ANSWER No attribute in the relation may be functionally
dependent upon the primary key
What does "S" stand for in inheritance - ANSWER Specialization
What does "O" stand for in inheritance - ANSWER Overlapping
, An upside down triangle represents ? - ANSWER is-a inheritance
If a relation is not in 1NF, what needs to be done to fix it? - ANSWER Find the real primary key
If a relation is not in 2NF, what needs to be done to fix it? - ANSWER Decompose
If a relation is not in 3NF, what needs to be done to fix it? - ANSWER Decompose
To get rid of rows in a table, I should use this command - ANSWER DELETE
(T or F)UPDATE and ALTER TABLE are two names for the same command - ANSWER False
To put a new row into a table, use this command: - ANSWER INSERT
To change the schema of an existing table, this SQL command should be used: - ANSWER
ALTER TABLE
CREATE TABLE is a command in what language - ANSWER DDL
DROP TABLE is a command in - ANSWER DDL
100% VERIFIED
The set of allowable values for an attribute in a relational schema is called what? - ANSWER
Domain
Which of the following is an atomic value? - ANSWER 42.1232
What needs to be true of a relation that has already been determined to be in 2NF in order
for it to be in 3NF - ANSWER There must be transitive depndencies
An attribute or set of attributes within a relation that references a key of some other relation
is a? - ANSWER Foreign Key
Which of the following must be trueof a table that has already been found to be in 1NF in
order for it to be in 2NF - ANSWER No attribute in the relation may be functionally
dependent upon the primary key
What does "S" stand for in inheritance - ANSWER Specialization
What does "O" stand for in inheritance - ANSWER Overlapping
, An upside down triangle represents ? - ANSWER is-a inheritance
If a relation is not in 1NF, what needs to be done to fix it? - ANSWER Find the real primary key
If a relation is not in 2NF, what needs to be done to fix it? - ANSWER Decompose
If a relation is not in 3NF, what needs to be done to fix it? - ANSWER Decompose
To get rid of rows in a table, I should use this command - ANSWER DELETE
(T or F)UPDATE and ALTER TABLE are two names for the same command - ANSWER False
To put a new row into a table, use this command: - ANSWER INSERT
To change the schema of an existing table, this SQL command should be used: - ANSWER
ALTER TABLE
CREATE TABLE is a command in what language - ANSWER DDL
DROP TABLE is a command in - ANSWER DDL
