0
Q:

 The load and index is which of the following?

A) A process to reject data from the data warehouse and to create the necessary indexes B) A process to load the data in the data warehouse and to create the necessary indexes
C) A process to upgrade the quality of data after it is moved into a data warehouse D) A process to upgrade the quality of data before it is moved into a data warehouse

Answer:   B) A process to load the data in the data warehouse and to create the necessary indexes

Explanation:
Subject: Database
Q:

The benefits of object-oriented modeling are which of the following?

A) The ability to tackle more challenging problems B) Reusability of analysis, design, and programming results
C) Improved communication between users, analysts, etc. D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database

4 766
Q:

 A proxy server is used for which of the following?

A) To provide security against unauthorized users B) To process client requests for Web pages
C) To process client requests for database access D) To provide TCP/IP
 
Answer & Explanation Answer: A) To provide security against unauthorized users

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database

2 952
Q:

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;

A) Equi-join B) Natural join
C) Outer join D) Cartesian join
 
Answer & Explanation Answer: D) Cartesian join

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database

6 1556
Q:

When mapping a supertype/subtype relationship which of the following is true?

A) The supertype primary key is assigned to each subtype. B) The subtype primary key is assigned to each supertype.
C) There is no link between the supertype/subtype entities. D) There is no primary key/foreign key relationship between a supertype/subtype.
 
Answer & Explanation Answer: A) The supertype primary key is assigned to each subtype.

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database

1 1220
Q:

 A transitive dependency is which of the following?

A) A functional dependency between two or more key attributes. B) A functional dependency between two or more nonkey attributes.
C) A relation that is in first normal form. D) A relation that is in second normal form.
 
Answer & Explanation Answer: B) A functional dependency between two or more nonkey attributes.

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database

3 969