Searching for "u"

Q:

 Which of the following improves a query's processing time?

A) Write complex queries. B) Combine a table with itself.
C) Query one query within another. D) Use compatible data types.
 
Answer & Explanation Answer: D) Use compatible data types.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?

A) Disjoint with total specialization B) Disjoint with partial specialization
C) Overlap with total specialization D) Overlap with partial specialization
 
Answer & Explanation Answer: C) Overlap with total specialization

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 A supertype/subtype hierarchy has which of the following features?

A) Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype. B) Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
C) Attributes are assigned at the highest logical level. D) Attributes are assigned at the lowest logical level.
 
Answer & Explanation Answer: C) Attributes are assigned at the highest logical level.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?

A) Push B) Pull
C) RFM D) OLAP
 
Answer & Explanation Answer: B) Pull

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

The "curse of dimensionality" relates to which problem of using operational data for BI reporting?

A) Dirty data B) Inconsistent data
C) Too much data D) Non-integrated data
 
Answer & Explanation Answer: C) Too much data

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

To eliminate definition duplication, XML Schemas define:

A) an intersection table. B) global elements.
C) a normalized definition table. D) None of the above is correct.
 
Answer & Explanation Answer: B) global elements.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.

A) READ_ONLY B) SCROLL_LOCK
C) OPTIMISTIC D) PESSIMISTIC
 
Answer & Explanation Answer: C) OPTIMISTIC

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

SQL Server program code that is executed instead of an SQL command that needs to be processed is called

A) INSTEAD OF trigger. B) BEFORE trigger.
C) AFTER trigger. D) BEGIN trigger.
 
Answer & Explanation Answer: A) INSTEAD OF trigger.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database