CSCI 466 Final Exam Question and
answers rated A+ 2025
The set of allowable values for an attribute in a relational schema is called
what? - correct answer ✔Domain
Which of the following is an atomic value? - correct 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 - correct 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? - correct 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 - correct answer ✔No attribute in the
relation may be functionally dependent upon the primary key
What does "S" stand for in inheritance - correct answer ✔Specialization
What does "O" stand for in inheritance - correct answer ✔Overlapping
An upside down triangle represents ? - correct answer ✔is-a inheritance
If a relation is not in 1NF, what needs to be done to fix it? - correct answer
✔Find the real primary key
, If a relation is not in 2NF, what needs to be done to fix it? - correct answer
✔Decompose
If a relation is not in 3NF, what needs to be done to fix it? - correct answer
✔Decompose
To get rid of rows in a table, I should use this command - correct answer
✔DELETE
(T or F)UPDATE and ALTER TABLE are two names for the same command -
correct answer ✔False
To put a new row into a table, use this command: - correct answer ✔INSERT
To change the schema of an existing table, this SQL command should be
used: - correct answer ✔ALTER TABLE
CREATE TABLE is a command in what language - correct answer ✔DDL
DROP TABLE is a command in - correct answer ✔DDL
To control which rows are affected by an SQL command that works on rows,
one of these is needed: - correct answer ✔WHERE
To change the values of attributes in a row that already exists, this command
should be used: - correct answer ✔Update
answers rated A+ 2025
The set of allowable values for an attribute in a relational schema is called
what? - correct answer ✔Domain
Which of the following is an atomic value? - correct 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 - correct 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? - correct 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 - correct answer ✔No attribute in the
relation may be functionally dependent upon the primary key
What does "S" stand for in inheritance - correct answer ✔Specialization
What does "O" stand for in inheritance - correct answer ✔Overlapping
An upside down triangle represents ? - correct answer ✔is-a inheritance
If a relation is not in 1NF, what needs to be done to fix it? - correct answer
✔Find the real primary key
, If a relation is not in 2NF, what needs to be done to fix it? - correct answer
✔Decompose
If a relation is not in 3NF, what needs to be done to fix it? - correct answer
✔Decompose
To get rid of rows in a table, I should use this command - correct answer
✔DELETE
(T or F)UPDATE and ALTER TABLE are two names for the same command -
correct answer ✔False
To put a new row into a table, use this command: - correct answer ✔INSERT
To change the schema of an existing table, this SQL command should be
used: - correct answer ✔ALTER TABLE
CREATE TABLE is a command in what language - correct answer ✔DDL
DROP TABLE is a command in - correct answer ✔DDL
To control which rows are affected by an SQL command that works on rows,
one of these is needed: - correct answer ✔WHERE
To change the values of attributes in a row that already exists, this command
should be used: - correct answer ✔Update
