Database Test 5 Computer Subject
Database Test 5 Computer Subject
Question 1
In relational databases, the table is also called _____?
In relational databases, a table is referred to as a relation, which is a collection of tuples representing data organized by attributes.
Not clear enough?
Question 2
In 3NF a non key attribute must not depend on a _____?
In third normal form (3NF), non-key attributes must not depend on another non-key attribute to eliminate transitive dependency.
Not clear enough?
Question 3
Different attributes in two different tables having same name are referred to as _____?
When attributes in two different tables share the same name but represent different meanings, they are called homonyms.
Not clear enough?
Question 4
Every relation must have _____?
Every relation must have a primary key to uniquely identify each tuple in the table.
Not clear enough?
Question 5
The Entity integrity rules states that _____?
Entity integrity rule ensures that no primary key attribute can have a null value since it uniquely identifies a record.
Not clear enough?
Question 6
A rule that states that each foreign key value must match a primary key value in the other relation is called _____?
Referential integrity constraint ensures that a foreign key in one table corresponds to a valid primary key in another table.
Not clear enough?
Question 7
Two or more attributes having different names but same meaning are called _____?
Attributes with different names but representing the same meaning are called synonyms in database terminology.
Not clear enough?
Question 8
A constraint between two attributes is called _____?
A functional dependency specifies the relationship between two attributes, where one determines the other.
Not clear enough?
Question 9
The attribute on the left hand side of the arrow in a functional dependency is _____?
In a functional dependency, the attribute on the left side is called the determinant because it determines the value of another attribute.
Not clear enough?
Question 10
The goal of normalization is to ____?
The purpose of normalization is to create a stable data structure by reducing redundancy and improving consistency.
Not clear enough?
You might like
This question is based on Literary Principles
''She wanted to spit herself. But she checked herself. 'Get dressed,' she said earnestly. 'Get dressed and let's go You known I have a lot of things to do. And if we are going to meet again like this, ...'she slapped the Samson and Deliah.''
Festus Iyayi: Violence
In the passage above, the speaker can be described as
The headquarters of the Economic Community of West African States (ECOWAS) is located in which country?
"I have no silver and gold, but I give you what I have; In the name of Jesus Christ of Nazareth, walk". This was said by Peter to a lame man