• HOME
  • QUIZ
  • CONTACT US
EXAMIANS
  • COMPUTER
  • CURRENT AFFAIRS
  • ENGINEERING
    • Chemical Engineering
    • Civil Engineering
    • Computer Engineering
    • Electrical Engineering
    • Mechanical Engineering
  • ENGLISH GRAMMAR
  • GK
  • GUJARATI MCQ

SQL Server 2000

SQL Server 2000
SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.

True
False

ANSWER DOWNLOAD EXAMIANS APP

SQL Server 2000
SQL Server program code that is executed after an SQL command has been processed is called a(n):

INSTEAD OF trigger
BEFORE trigger
BEGIN trigger
AFTER trigger

ANSWER DOWNLOAD EXAMIANS APP

SQL Server 2000
Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?

SCROLL_LOCK
READ_ONLY
READCOMMITTED
OPTIMISTIC

ANSWER DOWNLOAD EXAMIANS APP

SQL Server 2000
SQL Server automatically creates an index on all primary and foreign keys.

False
True

ANSWER DOWNLOAD EXAMIANS APP

SQL Server 2000
SQL Server supports two kinds of indexes: clustered and nonclustered.

False
True

ANSWER DOWNLOAD EXAMIANS APP

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

OPTIMISTIC
SCROLL_LOCK
READ_ONLY
PESSIMISTIC

ANSWER DOWNLOAD EXAMIANS APP
MORE MCQ ON SQL Server 2000

DOWNLOAD APP

  • APPLE
    from app store
  • ANDROID
    from play store

SEARCH

LOGIN HERE


  • GOOGLE

FIND US

  • 1.70K
    FOLLOW US
  • EXAMIANSSTUDY FOR YOUR DREAMS.
  • SUPPORT :SUPPORT EMAIL ACCOUNT : examians@yahoo.com

OTHER WEBSITES

  • GUJARATI MCQ
  • ACCOUNTIANS

QUICK LINKS

  • HOME
  • QUIZ
  • PRIVACY POLICY
  • DISCLAIMER
  • TERMS & CONDITIONS
  • CONTACT US
↑