MCQ | SQL – Script

SQL Script MCQ: This section contains the Multiple-Choice Questions & Answers on SQL Script.
Submitted by Anushree Goswami, on October 10, 2021

SQL Script MCQs

1. Select the correct statement about SQL Scripts?

At the run time, the SQL*Plus commands are ignored.
SQL Scripts and SQL Commands in the SQL Scripts have no interaction.
Through the SQL Script editor, SQL Commands are cut and pasted.
All of the above

Answer: D) All of the above

Explanation:

Explanation: Points to be noted about SQL Scripts are –

At the run time, the SQL*Plus commands are ignored.
SQL Scripts and SQL Commands in the SQL Scripts have no interaction.
Through the SQL Script editor, SQL Commands are cut and pasted.

Discuss this Question

2. _____ variables are not supported by SQL Script.

Bind
Dynamic
Both A) and B)
None of the above

Answer: C) Both A) and B)

Explanation:

Bind or Dynamic variables are not supported by SQL Script.

Discuss this Question

3. Name of the control in SQL Script –

Script
Owner
Opinion
All of the above

Answer: D) All of the above

Explanation:

Name of the controls in SQL Script are Script, Owner and Opinion.

Discuss this Question

4. In the script field, script is found by entering the –

Script Name
Script Number
Script ID
Script Symbol

Answer: A) Script Name

Explanation:

In the script field, script is finding by entering the partial name or script name.

Discuss this Question

5. The description in SQL Script, displays script in –

One Line
Two Line
Three Line
Many Lines

Answer: A) One Line

Explanation:

The description in SQL Script, displays the script in One Line.

Discuss this Question

6. Description allows the Script to load the –

Owner of the script
Script name
Script Editor
All of the above

Answer: D) All of the above

Explanation:

Description allows the Script to load the owner of the script, script name and script editor.

Discuss this Question

7. What does task list consist of in SQL Script?

Import
Show Quotas
Manage Results
All of the above

Answer: D) All of the above

Explanation:

Task list consist of Import, Export, Show Quotas and Manage Results in SQL Script.

Discuss this Question

8. The ____ size of the result is shown by Script Quota.

Minimum
Maximum
Average
None of the above

Answer: B) Maximum

Explanation:

The maximum size of the result is shown by Script Quota.

Discuss this Question

9. What is Export Script by default?

Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl

Answer: C) Workspace_name_script/sql

Explanation:

Export script is by default "Workspace_name_script/sql/".

Discuss this Question

10. What is the shortcut key to open SQL Script?

Ctrl+Shift+S
Ctrl+Shift+Q
Ctrl+Shift+N
Ctrl+Shift+O

Answer: D) Ctrl+Shift+O

Explanation:

Shortcut key to open SQL Script Ctrl+Shift+O.

Discuss this Question

11. In order to delete the Script in the Script Editor, the following steps need to be followed:

In the Script Editor, select the script to be deleted.
Go to the workspace home page and select SQL Workshop, then SQL Scripts. On the screen, you will see the SQL Scripts page.
Remove the script from the Script Repository by clicking the Delete button. Prior to the deletion of the script, we are required to confirm our action.

Options:

iii > i > ii
iii > ii > i
ii > i > iii
i > ii > iii

Answer: C) ii > i > iii

Explanation:

The correct order in which the steps need to be followed in order to delete the script in the script editor is as follows:

Go to the workspace home page and select SQL Workshop, then SQL Scripts. On the screen, you will see the SQL Scripts page.
In the Script Editor, select the script to be deleted.
Remove the script from the Script Repository by clicking the Delete button. Prior to the deletion of the script, we are required to confirm our action.

Discuss this Question

12. Scripts ____ from various workspaces can be imported through import.