QUESTION 5 Storing data in a permanent, denormalized table is a recommended solu

Question

QUESTION 5

Storing data in a permanent, denormalized table is a recommended solution.

True

False

2 points   

QUESTION 6

If a table has multiple candidate keys and one of them is a composite key, the table can have partial dependencies based on this composite candidate key, even when the primary key chosen is a single attribute.

True

False

2 points   

QUESTION 7

A Primary Key can be used to uniquely identify a column or row within a table?

True

False

2 points   

QUESTION 8

When two or more tables share the same number of columns, and when their corresponding columns share the same or compatible domains, they are said to be ____?

join-compatible

domain-compatible

shared-compatible

union-compatable

2 points   

QUESTION 9

Each table must have a two Primary keys.

True

False

2 points   

QUESTION 10

The ER Model should be validated against expected processes. The 3 expected processes are inserts, updates, and _____.

queries

extracts

distributes

deletes

join-compatible

domain-compatible

shared-compatible

union-compatable

Explanation / Answer

QUESTION 5
Storing data in a permanent, denormalized table is a recommended solution.
False -- Because it will have data anomalies

QUESTION 6
If a table has multiple candidate keys and one of them is a composite key, the table can have partial dependencies based on this composite candidate key, even when the primary key chosen is a single attribute.
True

QUESTION 7
A Primary Key can be used to uniquely identify a column or row within a table?
False -- Primary key is only for row not for the column

QUESTION 8
When two or more tables share the same number of columns, and when their corresponding columns share the same or compatible domains, they are said to be ____?
union-compatible -- Because we can perform union operation over these tables

QUESTION 9
Each table must have a two Primary keys.
False -- Need not to, one primary key is also sufficient

QUESTION 10
The ER Model should be validated against expected processes. The 3 expected processes are inserts, updates, and _____
deletes -- These are the operations

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects