Sawaal
  • Home/
  • Searching for I

 Searching for "I"

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:

 In enterprise data modeling, which is incorrect?

A) You review current systems. B) You implement the new database.
C) You describe the data needed at a very high level of abstraction. D) You plan one or more database development projects.
 
Answer & Explanation Answer: B) You implement the new database.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 The first step in database development is which of the following?

A) Enterprise data modeling B) Logical database design
C) Physical database design and definition D) Database Implementation
 
Answer & Explanation Answer: A) Enterprise data modeling

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:

 The expression FOR XML RAW tells SQL Server to:

A) place the values of the columns as attributes in the resulting XML document. B) place the values of the columns into elements rather than attributes.
C) place some columns into elements and others into attributes. D) None of the above is correct.
 
Answer & Explanation Answer: A) place the values of the columns as attributes in the resulting XML document.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database