Sawaal
  • Home/
  • Searching for I

 Searching for "I"

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

Q:

Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?

A) Supertype entity B) Subtype entity
C) Archetype entity D) Instance entity
 
Answer & Explanation Answer: A) Supertype entity

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

Which of the following indicates the maximum number of entities that can be involved in a relationship?

A) Minimum cardinality B) Maximum cardinality
C) ERD D) Greater Entity Count (GEC)
 
Answer & Explanation Answer: B) Maximum cardinality

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database