The SQL Procedure: Trivia Quiz
6 Questions
| Total Attempts: 942
Settings
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
Back to top