logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ SQL Server 2000 Comments
  • Question

  • An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:


  • Options
  • A. COBOL.
  • B. VB.NET.
  • C. TRANSACT SQL.
  • D. Visual Basic.

  • Correct Answer
  • TRANSACT SQL. 

    • SQL Server 2000 problems

    Search Results

    • 1. SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):

    • Options
    • A. INSTEAD OF trigger.
    • B. BEFORE trigger.
    • C. AFTER trigger.
    • D. BEGIN trigger.
      • Discuss
    • 2. SQL Server 2000 stored procedures can:

    • Options
    • A. never be kept within the database.
    • B. be kept within the database and invoked by application programs.
    • C. be stored on the users' computer.
    • D. support BEFORE, INSTEAD OF and AFTER types.
      • Discuss
    • 3. Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?

    • Options
    • A. #
    • B. %
    • C. &
    • D. @
      • Discuss
    • 4. What mode of authentication does SQL Server NOT provide?

    • Options
    • A. Windows-only security
    • B. Both SQL Server and Windows-only security
    • C. Mixed security
    • D. SQL Server only security
      • Discuss
    • 5. Which of the following is not a factor in determining the concurrency control behavior of SQL Server?

    • Options
    • A. Lock level
    • B. Transaction isolation level
    • C. Cursor concurrency setting
    • D. Locking hints
      • Discuss
    • 6. SQL Server program code that is executed after an SQL command has been processed is called a(n):

    • Options
    • A. INSTEAD OF trigger.
    • B. BEFORE trigger.
    • C. AFTER trigger.
    • D. BEGIN trigger.
      • Discuss
    • 7. Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?

    • Options
    • A. READ_ONLY
    • B. SCROLL_LOCK
    • C. OPTIMISTIC
    • D. READCOMMITTED
      • Discuss
    • 8. With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?

    • Options
    • A. Differential recovery
    • B. Full recovery
    • C. Simple recovery
    • D. Bulk-logged recovery
      • Discuss
    • 9. With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.

    • Options
    • A. READ_ONLY
    • B. SCROLL_LOCK
    • C. OPTIMISTIC
    • D. PESSIMISTIC
      • Discuss
    • 10. HTML is an application of a more robust document markup language called:

    • Options
    • A. XHTML.
    • B. XML.
    • C. SGML.
    • D. None of the above is correct.
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.