The SQL Procedure: Trivia Quiz

6 Questions | Total Attempts: 942

SettingsSettingsSettings
Please wait...
The SQL Procedure: Trivia Quiz

There are different types of Stored Procedure in SQL server and we got to cover all of them in our previous classes. SQL is used to communicate with a database in a computer to accomplish a task. Take up the quiz below and get to see how well you understood the procedures used in this structured query languages. All the best!


Related Topics
Questions and Answers
  • 1. 
    A query that joins a table to itself
    • A. 

      Outer join

    • B. 

      Self-join

    • C. 

      Inner join

  • 2. 
    Built-in functions that return a single result for each row of data retrieved 
    • A. 

      Single-row functions

    • B. 

      Search condition

    • C. 

      Table alias

  • 3. 
    Contains current date and time 
    • A. 

      Single-row functions

    • B. 

      Savepoint

    • C. 

      SYSDATE pseudocolumn

  • 4. 
    An alternative name that you assign to the table in the query’s FROM clause 
    • A. 

      Query

    • B. 

      Table alias

    • C. 

      Single-row functions

  • 5. 
    A series of action queries that represent a logical unit of work 
    • A. 

      Query

    • B. 

      Single Row Function

    • C. 

      Transaction

  • 6. 
    Removes all of a table’s data without saving any rollback information
    • A. 

      Roll Back

    • B. 

      Truncate

    • C. 

      Single-row functions