PRO - PL SQL Programming - Theory

Which of the following about a SELECT INTO statement is FALSE?

1 Mark(s)

The columns in select_list can be in any order as the record fields, as long as the number of fields matches
For each column in select_list, the record variable must have a corresponding, type-compatible field
The column names must precede the INTO keyword.
Any number of columns from the table can be fetched.

What is the initial value for a record variable declared with RECORD Type?

1 Mark(s)

Value that is stored in the database
Zero for all fields
NULL for all fields
NULL unless a different initial value is specified for it

Which of the following are correct results of a Boolean expression?

1 Mark(s)

TRUE or FALSE
0 or 1
YES or NO
TRUE, FALSE or NULL

What is a %ROWTYPE attribute used for?

1 Mark(s)

To declare a record variable that represents a full or partial row of a database table.
To declare a record variable that represents a full row of a database table only
To declare a record variable that represents a partial row of a database table only.
To declare a record variable from another record variable.

What are the conditions when a record variable is assigned to another record variable, the target variable is declared with a RECORD type and the source variable is declared with %ROWTYPE?

1 Mark(s)

An error is thrown
The assignment is successful only when their fields match in number and order, and corresponding fields have the same data type
The assignment is successful as long as the fields in both source and target have the same datatype, even if they do not match in number and order.
The assignment is successful only when their fields match in number, and corresponding fields have the same data type. The order of the fields does not matter.

Which of the following operators has the highest precedence?

1 Mark(s)

BETWEEN
NOT
&&
||

How is comparison made in Boolean character expression?

1 Mark(s)

Comparisons are based on the binary values of each byte in the string.
Comparisons are based on the character values of each byte in the string.
Comparisons are based on the binary values of each character in the string.
Comparisons are based on the character values of each character in the string.

Which of the following clause is not mandatory while using a SQL SELECT statement?

1 Mark(s)

SELECT
INTO
FROM
WHERE

How can a user defined record be created in PL/SQL?

1 Mark(s)

Using TYPE statement
Using %ROWTYPE
Using %TYPE
Using CREATE TYPE statement

Which one of these operators does not have the same precedence as the others?

1 Mark(s)

BETWEEN
AND
LIKE
IS NULL

What is scope and visibility of an identifier?

1 Mark(s)

The scope of an identifier is the region of a PL/SQL unit from which the identifier can be referenced.
The scope of an identifier is the region of a PL/SQL unit from which the identifier can be referenced without qualifying it.
The visibility of an identifier is the region of a PL/SQL unit from which the identifier can be referenced
The visibility of an identifier is the region of a PL/SQL unit from which the identifier can be referenced by qualifying it.

What are the two types of case expressions?

1 Mark(s)

Simple and Compound expression
Simple and Complex expression
Simple and Searched expression
Simple and Multiple expression

Which of the following is not TRUE about using records for database inserts or updates?

1 Mark(s)

If the VALUES clause of an INSERT statement contains a record variable, no other variable or value is allowed in the clause
If the INTO subclause of a RETURNING clause contains a record variable, other variable are allowed in the subclause
Record variables are not allowed in a SELECT list, WHERE clause, or ORDER BY clause.
Record variables are allowed in the VALUES clause of an INSERT statement

Which of the following correctly describes the use of a %TYPE attribute?

1 Mark(s)

The %TYPE attribute lets the user declare a data item of the same data type as a previously declared variable or column.
The %TYPE attribute lets the user declare a data item of different data type as a previously declared variable or column.
The %TYPE attribute lets the user declare a data item of the same data type as a previously declared row of data
The %TYPE attribute lets the user declare a data item of different data type as a previously declared row of data.

Which of the following about %ROWTYPE attribute is not true?

1 Mark(s)

For every column of the full or partial row, the record has a field with the same name and data type.
If the structure of the row changes, then the structure of the record changes accordingly.
The record fields inherit the constraints of the corresponding columns.
The record fields do not inherit the initial values of the corresponding columns.

Where can a % be used in LIKE conditions in PL/SQL?

1 Mark(s)

To match 1 character
To match 0 or more character
To match 1 or more character
To match 0 or 1 character

How should any declaration statement end in PL/SQL?

1 Mark(s)

Using a colon (:)
Using a period (.)
Using a semi colon (;)
Using a slash (/)

Using which of the following clauses is the MERGE condition specified?

1 Mark(s)

INTO
USING
ON
WHEN

Which of the DML statements can be used inside a PL/SQL block?

1 Mark(s)

INSERT, UPDATE, DELETE or MERGE
INSERT or UPDATE only
INSERT, UPDATE or DELETE
INSERT only

While using SELECT INTO statements where are the database columns specified?

1 Mark(s)

After the SELECT and before INT
After the SELECT and after INTO
After the SELECT and FROM clause and before INTO clause
After the SELECT ,FROM clause and INTO clause and before WHERE clause

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