The SQL Procedure: Trivia Quiz

6 Questions | By Roadman19771 | Last updated: Mar 20, 2022 | Total Attempts: 1049

Questions

Settings

Create your own 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!

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