Database Test 5 Computer Subject
Database Test 5 Computer Subject
Question 11
Which of the following is TRUE from functional dependency shown as (A, B) → (C, D)?
From (A, B) → (C, D), both A and B together determine C and D. Therefore, A and B together determine D is true.
Not clear enough?
Question 12
What is the highest normal form a relation is in if every determinant is a candidate key?
A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a candidate key.
Not clear enough?
Question 13
A relation is considered a _____?
A relation in a relational database is a two-dimensional table consisting of rows and columns.
Not clear enough?
Question 14
A functional dependency is a relationship between or among?
A functional dependency expresses a relationship between attributes where one attribute determines another.
Not clear enough?
Question 15
Which of the following is a group of one or more attributes that uniquely identifies a row?
A key is a set of one or more attributes that uniquely identifies a row in a relation.
Not clear enough?
Question 16
For some relations, changing the data can have undesirable consequences, called _____?
Modification anomalies occur when changes to data cause inconsistencies or errors due to redundancy.
Not clear enough?
Question 17
When the values in one attribute must exist in another attribute, it is called _____?
Referential integrity ensures that a foreign key in one table corresponds to a valid primary key in another table.
Not clear enough?
Question 18
The different classes of relations and the techniques for preventing anomalies are called _____?
Normal forms are sets of guidelines that prevent redundancy and anomalies in relational databases.
Not clear enough?
Question 19
Two or more attributes or attribute collections that can be a key are called _____?
Candidate keys are attributes or sets of attributes that can uniquely identify rows and qualify as possible primary keys.
Not clear enough?
Question 20
A relation is in this form if it is in BCNF and has no multi-value dependencies?
A relation in BCNF with no multi-valued dependencies is in Fourth Normal Form (4NF).
Not clear enough?
You might like
"Fear not, stand firm, and see the salvation of the Lord, which He will work for you today..." Moses made this statement when the Israelites
A man donates 10% of his monthly net earnings to his church. If it amounts to N4,500, what is his net monthly income?
select the option that best explains the information conveyed in the sentence.
The team adapted to the new tactic as clean as a whistle.
A feature of supermarkets which distinguishes it from other large scale retail outlets is that items sold are
A box is filled with cookies ranging in weight from 3.2 grams to 3.8 grams. How many cookies are in the box?
(1) The gross weight of the box and the cookies is 130 grams.
(2) The net weight of the cookies is 112 grams.