logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ SQL Server 2000 See What Others Are Saying!
  • 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. 

    • More questions

    • 1. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

    • Options
    • A. LIKE only.
    • B. IN only.
    • C. NOT IN only.
    • D. Both IN and NOT IN.
      • Discuss
    • 2. Static extract is used for ongoing warehouse maintenance.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. Which of the following is true concerning an ODBMS?

    • Options
    • A. They have the ability to store complex data types on the Web.
    • B. They are overtaking RDBMS for all applications.
    • C. They are most useful for traditional, two-dimensional database table applications.
    • D. All of the above.
      • Discuss
    • 4. Which of the following statements is true concerning routines and triggers?

    • Options
    • A. Both consist of procedural code.
    • B. Both have to be called to operate.
    • C. Both run automatically.
    • D. Both are stored in the database.
      • Discuss
    • 5. With SQL Server, parameters and variables in T-SQL start with the "%" sign.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. The functional dependency R ? S means that the value of S can be determined when we are given a value of R.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. A distributed database is which of the following?

    • Options
    • A. A single logical database that is spread to multiple locations and is interconnected by a network
    • B. A loose collection of file that is spread to multiple locations and is interconnected by a network
    • C. A single logical database that is limited to one location.
    • D. A loose collection of file that is limited to one location.
      • Discuss
    • 8. Which of the following is NOT an Oracle-supported trigger?

    • Options
    • A. BEFORE
    • B. DURING
    • C. AFTER
    • D. INSTEAD OF
      • Discuss
    • 9. A distributed database has which of the following advantages over a centralized database?

    • Options
    • A. Software cost
    • B. Software complexity
    • C. Slow Response
    • D. Modular growth
      • Discuss
    • 10. ________ is considered to be one of the foundations of data access in the Microsoft world.

    • Options
    • A. ODBC
    • B. OLE DB
    • C. JPCD
    • D. ADO
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.