151 + Mcqs in PL SQL Interview Questions McqOptions

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

Discussion

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

Discussion

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

Discussion

4.	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

5.	“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

6.	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

7.	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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

13.	__________ 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

14.	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

15.	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

16.	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

17.	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

18.	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

19.	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

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

Discussion

21.	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

22.	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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

28.	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

29.	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

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

Discussion

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

Discussion

32.	________ 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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

37.	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

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

Discussion

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

Discussion

40.	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

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

Discussion

42.	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

43.	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

44.	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

45.	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

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

Discussion

47.	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

48.	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

49.	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

50.	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 Testing Subject.

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)?