The SQL Procedure: Trivia Quiz

6 Questions | By Roadman19771 | Last updated: Sep 2, 2019 | Total Attempts: 990

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!

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