Technical Questions

Q:

 Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?

A) Nonrepeatable read B) Phantom read
C) Dirty read D) Consistent read
 
Answer & Explanation Answer: A) Nonrepeatable read

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 2860
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

0 4664
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

0 3159
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

0 3063
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

0 2932
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

0 3979
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

0 4249
Q:

 Which of the following is an advantage of partitioning?

A) Complexity B) Inconsistent access speed
C) Extra space D) Security
 
Answer & Explanation Answer: D) Security

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 2847