Nested tables are a good choice when

The index values are not consecutive.

There is no set number of index values. However, a maximum limit is imposed.

You need to delete or update some elements, but not all the elements at once.

You would usually create a separate lookup table, with multiple entries for each row of the main table, and access it through join queries.

In the Restrictions on Record Inserts and Updates, which of the following are not supported?

Record inserts and updates using the EXECUTE IMMEDIATE statement

For which of the following can pragma be applied?

Top-level (not nested) anonymous PL/SQL blocks

Local, standalone, and packaged functions and procedures

Simple Mail Transaction Protocol

Single Mail Transaction Protocol

Simple Mail Transaction Protocol

A nested cursor is implicitly opened when the containing row is fetched from the parent cursor. The nested cursor is closed in which of the following case(s)?

The nested cursor is explicitly closed by the user

The parent cursor is re-executed

151 + Mcqs in PL SQL Interview Questions in Computer Science Page 3 McqOptions

101.	Packages HTF and HTP allow your PL/SQL programs to generate HTML tags.
A.	True
B.	False
Answer» B. False

Discussion

102.	Oracle predefined errors are not associated with specific error codes.
A.	True
B.	False
Answer» C.

Discussion

103.	Oracle-supplied package called DBMS_LOB is used to manipulate the LOB objects.
A.	True
B.	False
Answer» B. False

Discussion

104.	Only EXISTS can be applied to automatically null collections. If you apply another method to such collections, PL/SQL raises COLLECTION_IS_NULL.
A.	Yes
B.	No
Answer» B. No

Discussion

105.	“NO_DATA_FOUND” and “TOO_MANY_ROWS” are the two most common errors found when executing a SELECT statement.
A.	True
B.	False
Answer» B. False

Discussion

106.	Nested tables can be sparse: you can delete arbitrary elements, rather than just removing an item from the end.
A.	Yes
B.	No
Answer» B. No

Discussion

107.	Nested tables are a good choice when
A.	The index values are not consecutive.
B.	There is no set number of index values. However, a maximum limit is imposed.
C.	You need to delete or update some elements, but not all the elements at once.
D.	You would usually create a separate lookup table, with multiple entries for each row of the main table, and access it through join queries.
E.	All mentioned above
Answer» F.

Discussion

108.	LOB parameters are not permitted in a server-to-server RPC.
A.	Yes
B.	No
Answer» B. No

Discussion

109.	LOB locators are values, which specify the location of the large object.
A.	True
B.	False
Answer» B. False

Discussion

110.	Like all identifiers, the names of constants, variables, and parameters are case sensitive.
A.	True
B.	False
Answer» C.

Discussion

111.	Is it possible to define a NOT NULL field in a record?
A.	Yes
B.	No
Answer» B. No

Discussion

112.	Is it possible to define a CONSTANT value in a record?
A.	Yes
B.	No
Answer» C.

Discussion

113.	__________ is a numeric expression that must return a value of type PLS_INTEGER,BINARY_INTEGER, or a value implicitly convertible to that datatype.
A.	index
B.	indicator_name
C.	field_name
D.	host_variable_name
Answer» B. indicator_name

Discussion

114.	In which subprogram a RETURN statement does not return a value and so cannot contain an expression?
A.	In Procedures
B.	In Functions
C.	Both A & B
D.	None of the above
Answer» B. In Functions

Discussion

115.	In which parameter mode Formal parameter acts like an initialized variable?
A.	IN
B.	OUT
C.	IN OUT
D.	None of the above
Answer» D. None of the above

Discussion

116.	In which of the following, do you specify the same parameters in the same order as they are declared in the procedure?
A.	Positional notation
B.	Named notation
C.	Mixed notation
D.	All mentioned above
Answer» B. Named notation

Discussion

117.	In which mode parameter lets you pass values to the subprogram being called? It cannot be assigned a value.
A.	Using the IN mode
B.	Using the OUT mode
C.	Both A & B
D.	None of the above
Answer» B. Using the OUT mode

Discussion

118.	In which binding operation a database value is assigned to a PL/SQL variable or a host variable by the RETURNING clause of an INSERT, UPDATE, or DELETE statement.
A.	out-bind
B.	in-bind
C.	define
D.	None of the above
Answer» B. in-bind

Discussion

119.	In the Restrictions on Record Inserts and Updates, which of the following are not supported?
A.	Nested record types
B.	Functions that return a record
C.	Record inserts and updates using the EXECUTE IMMEDIATE statement
D.	All mentioned above
Answer» E.

Discussion

120.	In PL/SQL, a warning or error condition is called an exception.
A.	True
B.	False
Answer» B. False

Discussion

121.	In internal exception oracle raises the exception for you implicitly. You still need to declare the exception and handle it, but you don’t need to raise it.
A.	True
B.	False
Answer» B. False

Discussion

122.	In CASE Expressions, which expression selects a result from one or more alternatives, and returns the result?
A.	Simple CASE Expression
B.	Searched CASE Expression
C.	Both A & B
D.	None of the above
Answer» B. Searched CASE Expression

Discussion

123.	How many types of literals are available in PL/SQL?
A.	6
B.	2
C.	5
D.	4
Answer» D. 4

Discussion

124.	How many nested IF clauses can be included within an IF clause?
A.	1
B.	0
C.	15
D.	Any number
Answer» E.

Discussion

125.	How many bytes does each character in the AL16UTF16 encoding take up?
A.	1
B.	2
C.	3
D.	6
Answer» C. 3

Discussion

126.	How many attributes does every explicit cursor and cursor variable have?
A.	3
B.	2
C.	4
D.	5
Answer» D. 5

Discussion

127.	From the following PL/SQL Delimiters which symbol is exponentiation operator.
A.	<>
B.	~=
C.	**
D.	–
Answer» D. –

Discussion

128.	For which of the following can pragma be applied?
A.	Top-level (not nested) anonymous PL/SQL blocks
B.	Local, standalone, and packaged functions and procedures
C.	Methods of a SQL object type
D.	Database triggers
E.	All mentioned above
Answer» F.

Discussion

129.	For a user-defined exception, SQLCODE returns 1, and SQLERRM returns ___________.
A.	“User-defined Exception”
B.	1
C.	0
D.	None of the above
Answer» B. 1

Discussion

130.	Explicit datatypes, %TYPE and %ROWTYPE, without size specification can be used for parameters in a procedure.
A.	True
B.	False
Answer» B. False

Discussion

131.	Dynamic SQL enables you to build SQL statements dynamically at runtime.
A.	True
B.	False
Answer» B. False

Discussion

132.	________ does not correlate with an oracle error, instead, user_define exceptions usually enforce business rules in situations in which an oracle error would not necessarily occur
A.	Predefined Exception
B.	Internal Exception
C.	User defined Exception
D.	None of the above
Answer» D. None of the above

Discussion

133.	Cursor attributes are not affected by autonomous transactions.
A.	True
B.	False
Answer» B. False

Discussion

134.	Constructors are functions that return a new object as its value.
A.	True
B.	False
Answer» B. False

Discussion

135.	Collection is an ordered group of elements, all of the same type.
A.	True
B.	False
Answer» B. False

Discussion

136.	Can BOOLEAN datatype be used in functions that are called from SQL statements?
A.	Yes
B.	No
Answer» C.

Discussion

137.	By using which clause, the mode is OUT, so you cannot specify a parameter mode for output bind arguments?
A.	USING Clause
B.	RETURNING INTO Clause
C.	Both A & B
D.	None of the above
Answer» C. Both A & B

Discussion

138.	Associative arrays also known as index-by tables.
A.	True
B.	False
Answer» B. False

Discussion

139.	Arrays in other languages become varrays in PL/SQL.
A.	True
B.	False
Answer» B. False

Discussion

140.	Any subprogram not in the package specification but coded in the package body is called a ___________ .
A.	Public object
B.	Private object
C.	Both A & B
D.	None of the above
Answer» C. Both A & B

Discussion

141.	An object type can represent any real-world entity.
A.	Yes
B.	No
Answer» B. No

Discussion

142.	An Explicit cursor is defined by the program for any query that returns more than one row of data.
A.	True
B.	False
Answer» B. False

Discussion

143.	Abbreviate SMTP?
A.	Single Mail Transaction Protocol
B.	Simple Mail Transfer Protocol
C.	Simple Mail Transaction Protocol
D.	Simple Mail Transfer Package
Answer» C. Simple Mail Transaction Protocol

Discussion

144.	A subquery is a query (usually enclosed by parentheses) that appears within another SQL data manipulation statement.
A.	True
B.	False
Answer» B. False

Discussion

145.	A searched CASE expression lets you test different conditions instead of comparing a single expression to various values.
A.	Yes
B.	No
Answer» B. No

Discussion

146.	A recursive subprogram is one that calls itself.
A.	True
B.	False
Answer» B. False

Discussion

147.	A RECORD is a collection of data items, which differ from each other in data type, but are logically related.
A.	True
B.	False
Answer» B. False

Discussion

148.	A package cursor is a cursor which you declare in the package specification without an SQL statement.
A.	Yes
B.	No
Answer» B. No

Discussion

149.	A package will have which of these mandatory parts?
A.	Package specification
B.	Package body or definition
C.	Both A & B
D.	None of the above
Answer» D. None of the above

Discussion

150.	A nested cursor is implicitly opened when the containing row is fetched from the parent cursor. The nested cursor is closed in which of the following case(s)?
A.	The nested cursor is explicitly closed by the user
B.	The parent cursor is re-executed
C.	The parent cursor is closed
D.	The parent cursor is canceled
E.	All mentioned above
Answer» F.

Discussion

Explore topic-wise MCQs in Computer Science.

Packages HTF and HTP allow your PL/SQL programs to generate HTML tags.

Oracle predefined errors are not associated with specific error codes.

Oracle-supplied package called DBMS_LOB is used to manipulate the LOB objects.

Only EXISTS can be applied to automatically null collections. If you apply another method to such collections, PL/SQL raises COLLECTION_IS_NULL.

“NO_DATA_FOUND” and “TOO_MANY_ROWS” are the two most common errors found when executing a SELECT statement.

Nested tables can be sparse: you can delete arbitrary elements, rather than just removing an item from the end.

Nested tables are a good choice when

LOB parameters are not permitted in a server-to-server RPC.

LOB locators are values, which specify the location of the large object.

Like all identifiers, the names of constants, variables, and parameters are case sensitive.

Is it possible to define a NOT NULL field in a record?

Is it possible to define a CONSTANT value in a record?

__________ is a numeric expression that must return a value of type PLS_INTEGER,BINARY_INTEGER, or a value implicitly convertible to that datatype.

In which subprogram a RETURN statement does not return a value and so cannot contain an expression?

In which parameter mode Formal parameter acts like an initialized variable?

In which of the following, do you specify the same parameters in the same order as they are declared in the procedure?

In which mode parameter lets you pass values to the subprogram being called? It cannot be assigned a value.

In which binding operation a database value is assigned to a PL/SQL variable or a host variable by the RETURNING clause of an INSERT, UPDATE, or DELETE statement.

In the Restrictions on Record Inserts and Updates, which of the following are not supported?

In PL/SQL, a warning or error condition is called an exception.

In internal exception oracle raises the exception for you implicitly. You still need to declare the exception and handle it, but you don’t need to raise it.

In CASE Expressions, which expression selects a result from one or more alternatives, and returns the result?

How many types of literals are available in PL/SQL?

How many nested IF clauses can be included within an IF clause?

How many bytes does each character in the AL16UTF16 encoding take up?

How many attributes does every explicit cursor and cursor variable have?

From the following PL/SQL Delimiters which symbol is exponentiation operator.

For which of the following can pragma be applied?

For a user-defined exception, SQLCODE returns 1, and SQLERRM returns ___________.

Explicit datatypes, %TYPE and %ROWTYPE, without size specification can be used for parameters in a procedure.

Dynamic SQL enables you to build SQL statements dynamically at runtime.

________ does not correlate with an oracle error, instead, user_define exceptions usually enforce business rules in situations in which an oracle error would not necessarily occur

Cursor attributes are not affected by autonomous transactions.

Constructors are functions that return a new object as its value.

Collection is an ordered group of elements, all of the same type.

Can BOOLEAN datatype be used in functions that are called from SQL statements?

By using which clause, the mode is OUT, so you cannot specify a parameter mode for output bind arguments?

Associative arrays also known as index-by tables.

Arrays in other languages become varrays in PL/SQL.

Any subprogram not in the package specification but coded in the package body is called a ___________ .

An object type can represent any real-world entity.

An Explicit cursor is defined by the program for any query that returns more than one row of data.

Abbreviate SMTP?

A subquery is a query (usually enclosed by parentheses) that appears within another SQL data manipulation statement.

A searched CASE expression lets you test different conditions instead of comparing a single expression to various values.

A recursive subprogram is one that calls itself.

A RECORD is a collection of data items, which differ from each other in data type, but are logically related.

A package cursor is a cursor which you declare in the package specification without an SQL statement.

A package will have which of these mandatory parts?

A nested cursor is implicitly opened when the containing row is fetched from the parent cursor. The nested cursor is closed in which of the following case(s)?