SQL Table: Trivia Questions!

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Tmaharaj007

Tmaharaj007

Community Contributor

Quizzes Created: 1 | Total Attempts: 590

Questions: 7 | Attempts: 590 | Updated: Mar 20, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

The trivia questions below are on the SQL table. Basically we know the definitaion and basic interpretation of SQL. However, are you sure you have what it takes to take up more than just the basics? In a bit, we are going to realise how much you know. Take up this test and get to see what you have learnt about SQL so far. All the best!

Questions and Answers

1.

To make a PARAMETER mandatory, we use the OBLIGATORY option
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
The statement is true because when we want to make a parameter mandatory, we use the "OBLIGATORY" option. This means that the parameter must be provided and cannot be left empty or omitted. Using the "OBLIGATORY" option ensures that the parameter is required and must be provided by the user or system.

Rate this question:
2.

To make a PARAMETER as a radiobutton we use AS CHECKBOX option
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
The statement is false because to make a parameter as a radiobutton, we do not use the "AS CHECKBOX" option. Instead, we use the "AS RADIOBUTTON" option. The AS CHECKBOX option is used to create a parameter as a checkbox, not a radiobutton.

Rate this question:
3.

To make a PARAMETER as a checkbox we use AS CHECKBOX option
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
To make a parameter as a checkbox, the "AS CHECKBOX" option is used. This option allows the parameter to be displayed as a checkbox, which can be selected or deselected by the user. By selecting the checkbox, the user can enable or disable the parameter, providing a convenient way to toggle a specific setting or condition. Therefore, the given answer "True" is correct as it accurately states that the "AS CHECKBOX" option is used to make a parameter a checkbox.

Rate this question:
4.

When we create a SELECT-OPTIONS it creates a range table with the following columns
- A.
  
  SIGN
- B.
  
  OPTION
- C.
  
  LOW
- D.
  
  HIGH
- E.
  
  IN
- F.
  
  SCRAMBLE
Correct Answer(s)
A. SIGN
B. OPTION
C. LOW
D. HIGH

Explanation
When we create a SELECT-OPTIONS, it creates a range table with columns such as SIGN, OPTION, LOW, HIGH, IN, and SCRAMBLE. These columns are used to define the range of values that can be selected in the SELECT-OPTIONS field. The SIGN column is used to specify the sign of the value (positive or negative), OPTION is used to specify the range option (EQ, NE, BT, etc.), LOW is used to specify the lower limit of the range, and HIGH is used to specify the upper limit of the range.

Rate this question:
5.

To create a block on the SELECTION SCREEN .... SELECTION-SCREEN BEGIN of ______ B1.

Correct Answer(s)
block

Explanation
The correct answer is "block" because the code snippet provided is using the statement "SELECTION-SCREEN BEGIN of block B1." This syntax is used to define a block on the selection screen in ABAP programming language. By using the "block" keyword, the code is instructing the system to create a block named "B1" on the selection screen.

Rate this question:

4
6.

To create a line on the SELECTION SCREEN .... SELECTION-SCREEN BEGIN of ______ B1.

Correct Answer(s)
line

Explanation
The correct answer is "line". This is because the code snippet "SELECTION-SCREEN BEGIN of line B1." is used to create a line on the selection screen. The keyword "line" is used to define the line element and "B1" is the name of the line element.

Rate this question:

4
7.

To write text on the SELECTION SCREEN .... SELECTION-SCREEN BEGIN of ______ ......

Correct Answer(s)
COMMENT

Explanation
The correct answer is "COMMENT" because in ABAP programming, the "COMMENT" statement is used to write explanatory text on the selection screen. This allows developers to add comments or instructions for the user to understand how to interact with the selection screen elements. The "COMMENT" statement is typically placed within the "SELECTION-SCREEN BEGIN OF BLOCK" statement to provide context-specific instructions.

Rate this question:

4

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 20, 2023

Quiz Edited by
ProProfs Editorial Team
Nov 03, 2012

Quiz Created by
Tmaharaj007

SQL Table: Trivia Questions!

To make a PARAMETER mandatory, we use the OBLIGATORY option

To make a PARAMETER as a radiobutton we use AS CHECKBOX option

To make a PARAMETER as a checkbox we use AS CHECKBOX option

When we create a SELECT-OPTIONS it creates a range table with the following columns

To create a block on the SELECTION SCREEN .... SELECTION-SCREEN BEGIN of ______ B1.

To create a line on the SELECTION SCREEN .... SELECTION-SCREEN BEGIN of ______ B1.

To write text on the SELECTION SCREEN .... SELECTION-SCREEN BEGIN of ______ ......