0
Q:

 A distributed database can use which of the following strategies?

A) Totally centralized one location and accessed by many sites B) Partially or totally replicated across sites
C) Partitioned into segments at different sites D) All of the above

Answer:   D) All of the above

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 767
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 957
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 1558
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 1222
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 972