Sort Quiz Over SQL And T-SQL

10 Questions | Total Attempts: 191

SettingsSettingsSettings
Please wait...
T SQL Quizzes & Trivia

SQL is a language used in programming for managing data held in a relational database management system. T-SQL, on the other hand, is Microsoft's and Sybase's version. How well do you understand these two? Find out below.


Related Topics
Questions and Answers
  • 1. 
    You can fetch only one row at a time.
    • A. 

      True

    • B. 

      False

  • 2. 
    A stored procedure or trigger can define two cursors with the same name if only one is executed.
    • A. 

      True

    • B. 

      False

  • 3. 
    If @@sqlstatus = 1, then:
    • A. 

      Indicates successful completion of the fetch statement.

    • B. 

      Indicates that the fetch statement resulted in an error.

    • C. 

      Indicates that there is no more data in the result set.

    • D. 

      None of these

  • 4. 
    If @@sqlstatus = 2, then:
    • A. 

      Indicates successful completion of the fetch statement.

    • B. 

      Indicates that the fetch statement resulted in an error.

    • C. 

      Indicates that there is no more data in the result set.

    • D. 

      None of these

  • 5. 
    If @@sqlstatus = 0, then:
    • A. 

      Indicates successful completion of the fetch statement.

    • B. 

      Indicates that the fetch statement resulted in an error.

    • C. 

      Indicates that there is no more data in the result set.

    • D. 

      None of these

  • 6. 
    Which of the following statements is TRUE for the having clause A) aggregates are permitted in the having clause B) subqueries are permitted in the having clause
    • A. 

      Only A

    • B. 

      Only B

    • C. 

      Both A and B

    • D. 

      Neither A nor B

  • 7. 
    The ________ operator combines result sets from multiple queries.
    • A. 

      Union

    • B. 

      Inner join

    • C. 

      Outer join

    • D. 

      Union all

  • 8. 
    Is it possible to Enable or Disable a Database trigger ?
    • A. 

      True

    • B. 

      False

  • 9. 
    You can create a trigger on a temporary object.
    • A. 

      True

    • B. 

      False

  • 10. 
    You can use the disable trigger feature only if you are the table owner or database administrator.
    • A. 

      True

    • B. 

      False