Sawaal
  • Home/
  • Searching for %

 Searching for "%"

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

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

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

Q:

 A transaction for which all committed changes are permanent is called:

A) atomic. B) consistent.
C) isolated. D) durable.
 
Answer & Explanation Answer: D) durable.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 A reason for using an SQL view to hide columns is:

A) to simplify a result only. B) to prevent the display of sensitive data only.
C) to accomplish both of the above. D) None of the above are reasons for using an SQL view.
 
Answer & Explanation Answer: C) to accomplish both of the above.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 For what purposes are views used?

A) To hide rows only B) To hide columns only
C) To hide complicated SQL statements only D) All of the above are uses for SQL views.
 
Answer & Explanation Answer: D) All of the above are uses for SQL views.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database