Basic SQL Trivia Quiz!
This quiz is on SQL basics. SQL is not a query language that most computer geeks aspire to understand. The primary objective for SQL creation was to give the possibility to common people get interesting data from the database. If one understands the use of this language, they have fewer problems understanding databases. Give the quiz a try and see how well you understand the language.
- 1.A statement that assigns a value to a variable
- A.
Comment statements
- B.
Declaration section
- C.
Assignment statement
- 2.Lines of text that explain or document a program step or series of steps
- A.
Explicit cursor
- B.
Comment statements
- C.
Exception handling
- 3.A variable that references a data structure that contains multiple scalar variables
- A.
Composite variable
- B.
Concatenating
- C.
Execution section
- 4.The joining of two separate strings
- A.
Data structure
- B.
Function
- C.
Concatenating
- 5.A pointer to a memory location on the database server that the DBMS uses to process an SQL query
- A.
Data Structure
- B.
Cursor
- C.
Composite variable
- 6.A data object made up of multiple individual data elements
- A.
Function
- B.
Data structure
- C.
Composite variable
- 7.A section that begins with the reserved word DECLARE and contains the commands that declare the program’s variables
- A.
Assignment statement
- B.
Comment statements
- C.
Declaration section
- 8.An unwanted event
- A.
Explicit cursor
- B.
Composite variable
- C.
Exception
- 9.Programmers place commands for displaying error messages and giving users options for fixing errors in the program’s exception section
- A.
Exception handling
- B.
Exception section
- C.
Exception
- 10.A section that starts with the EXCEPTION reserved word and contains program statements for error handling
- A.
Exception
- B.
Exception section
- C.
Exception handling
- 11.A section that starts with the BEGIN reserved word and consists of program statements, such as assignment statements, conditional structures, and looping structures
- A.
Execution section
- B.
Explicit data conversions
- C.
Exception handling
- 12.A cursor that retrieves and displays data in PL/SQL programs for a query that might retrieve multiple records or that might return no records at all
- A.
Execution section
- B.
Data structure
- C.
Explicit cursor
- 13.Conversions in which variables are converted to different data types using data conversion functions that are built into PL/SQL
- A.
Exception handling
- B.
Explicit data conversions
- C.
Implicit cursor
- 14.A program that receives one or more inputs, called parameters, and returns a single output value
- A.
Posttest loop
- B.
Function
- C.
Loop
- 15.A cursor that points to the context area, which contains information about the query, such as the number of rows that the query processes, and a parsed (machine language) representation of the query.
- A.
Implicit cursor
- B.
Explicit cursor
- C.
Data structure
- 16.Conversions in which the interpreter automatically converts a value from one data type to another
- A.
Implicit cursor
- B.
PL/SQL output buffer
- C.
Implicit data conversions
- 17.Declare variables that reference binary data objects, such as images or sounds
- A.
Parse
- B.
LOB data types
- C.
Logic error
- 18.An error that does not stop a program from running, but results in an incorrect result
- A.
Logic error
- B.
Predefined exceptions
- C.
Implicit cursor
- 19.A program structure that systematically executes a series of program statements and periodically evaluates an exit condition to determine if it should repeat or exit
- A.
Implicit cursor
- B.
Predefined exceptions
- C.
Loop
- 20.The memory area on the database server that stores the program’s output values before they are displayed to the user
- A.
PL/SQL output buffer
- B.
Procedural programming language
- C.
Scalar variables
Questions: 42 | Attempts: 9507 | Last updated: Mar 19, 2021
-
Sample QuestionWhich SQL function is used to count the number of rows in a SQL query?
Questions: 10 | Attempts: 3571 | Last updated: Mar 2, 2019
-
Sample QuestionWhen did SQL appear
Questions: 26 | Attempts: 3441 | Last updated: Jan 24, 2013
-
Sample QuestionWhich SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?
Back to top