Q. What does a foreign key do in a relational database?
-
A.
Links two tables together
-
B.
Defines a primary key
-
C.
Indexes a table
-
D.
Stores unique values
Solution
A foreign key in a relational database links two tables together by referencing the primary key of another table.
Correct Answer:
A
— Links two tables together
Learn More →
Q. What is the main purpose of normalization?
-
A.
To reduce data redundancy
-
B.
To increase data redundancy
-
C.
To improve query performance
-
D.
To create backups
Solution
The main purpose of normalization is to reduce data redundancy and improve data integrity in a database.
Correct Answer:
A
— To reduce data redundancy
Learn More →
Showing 1 to 2 of 2 (1 Pages)
