PRO - PL SQL Programming - Theory

Where can a variable be assigned values in PL/SQL?

1 Mark(s)

Declaration block only
Executable block only
Decalaration and Executable only
Exceutable and Exception block only

What is a package in PL/SQL?

1 Mark(s)

A package is a named PL/SQL unit stored in the database to perform action based on an event
A package is an anonymous block in PL/SQL.
package is a schema object that groups logically related PL/SQL objects.
A package is a subprogram in the database.

What is an anonymous block in PL/SQL?

1 Mark(s)

A PL/SQL unit without decalaration
A PL/SQL unit without a body to execute
A PL/SQL unit without an exception handler
PL/SQL unit without a name

How many parts of a PL/SQL block are optional?

1 Mark(s)

3
2
1
0

Which of the following are inherited by the referencing value from the referenced value while using a %TYPE attribute to declare variables?

1 Mark(s)

The referencing item inherits the Data type and size and Constraints always but never inherits the initial value of the referenced item
The referencing item inherits the Data type and size and Constraints (unless the referenced item is a column) but never inherits the initial value of the referenced item.
The referencing item inherits the Data type , size , Constraints and the initial value of the referenced item
The referencing item inherits the Data type and size and Constraints (unless the referenced item is a column) and the initial value of the referenced item.

How does an execution block start and end in PL/SQL?

1 Mark(s)

Starts with START and ends with END
Starts with BEGIN and ends with END
Starts with START and ends with ; (semi colon)
Starts with BEGIN and ends with ; (semi colon)

How can a PL/SQL block be executed?

1 Mark(s)

By using a semi colon at the end.
By using a colon at the end.
By using a slash (/)at the end
By pressing "Enter" .

I know you are very sorry that you broke the pot but accidents will happen.

1 Mark(s)

things will take place
things do occur
things take place often
things often go wrong

Which command should be used to turn on the output of PL/SQL commands in SQL*Plus?

1 Mark(s)

set serveroutput on
showserveroutput on
set output on
set PL/SQL on

He kept saying he didn't do it but in the end he said he had done it.

1 Mark(s)

at the end
finally
at last
by the end

How are multi-line comments defined in PL/SQL?

1 Mark(s)

By two hyphens (--)
Starts with /* and ends with */
Starts with /$ and ends with $/
Starts with /^ and ends with ^/

How can values be assigned to a variable in PL/SQL?

1 Mark(s)

Using assignnment operator only.
Using a subprogram only.
Using SELECT..INTO statement,a subprogram or an assignment operator
Using SELECT..INTO statement, or an assignment operator only.

What are composite variables in PL/SQL?

1 Mark(s)

Native datatypes
Variables having internal components
Scalar variables
User defined datatypes

Which of the following is not a subtype of PLS_INTEGER datatype?

1 Mark(s)

POSITIVEN
NATURALN
SIGN_TYPE
SIMPLE_N_INTEGER

Which of the following is true about PL/SQL programs?

1 Mark(s)

PL/SQL programs can exist with or without any SQL statements
PL/SQL programs can exist only with any SQL statements
PL/SQL programs can exist only without any SQL statements.
SQL programs can exist only with PL/SQL statements.

The battleships were all waiting in the harbour ready for action.

1 Mark(s)

prepared for war
prepared for anything
prepared for something
prepared for take off

Which of the following is not allowed in an identifier name?

1 Mark(s)

Digits
The characters $, #, _,
Punctuation or hyphens
Letters and Digits

What are the different types of identifiers?

1 Mark(s)

Pre-defined and system defined identifier
Pre-defined,user defined and reserved keywords
User defined and system defined identifier
Pre defined and Post defined identifier

What is an identifier in PL/SQL?

1 Mark(s)

Identifier is a character, or character combination, that has a special meaning in PL/SQL
Identifiers provide a named reference to PL/SQL objects
Identifier is a value that is neither represented by an literal nor calculated from other values.
Identifier is a string that is used to help other application developers understand the source text

What is the scope of a local declaration?

1 Mark(s)

Subprogram
Session
Block
Schema

PRO - PL SQL Programming - Theory - 1 : Question 1 of 20