163 + Mcqs in PL SQL Interview Questions in Computer Science MCQs Page 1 McqOptions

1.	Which of the following cannot be used with associative arrays?
A.	EXTEND
B.	TRIM
C.	Both A & B
D.	None of the above
Answer» D. None of the above

Discussion

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

Discussion

3.	Pragmas are processed at ___________ .
A.	Run time
B.	Compile time
C.	Both A & B
D.	None of the above
Answer» C. Both A & B

Discussion

4.	PL/SQL is completely portable, high-performance transaction processing language that offers which of the following advantages -
A.	Tight Integration with SQL
B.	Better Performance
C.	Higher Productivity,Full Portability,Tight Security
D.	All mentioned above
Answer» E.

Discussion

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

Discussion

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

Discussion

7.	Which collection method Returns the index number that precedes index n in a collection?
A.	PRIOR(n)
B.	LAST
C.	LIMIT
D.	COUNT
Answer» B. LAST

Discussion

8.	PL/SQL stored procedures move application code from the server to the client.
A.	True
B.	False
Answer» C.

Discussion

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

Discussion

10.	Which is a simple or compound symbol that has a special meaning to PL/SQL?
A.	Delimiters
B.	Identifiers
C.	Literals
D.	Comments
Answer» B. Identifiers

Discussion

11.	PL/SQL is a completely portable, high-performance transaction processing language.
A.	True
B.	False
Answer» B. False

Discussion

12.	Which operator tests set membership?
A.	IN Operator
B.	BETWEEN Operator
C.	LIKE Operator
D.	IS NULL Operator
Answer» B. BETWEEN Operator

Discussion

13.	Which subtypes are used to declare fixed-point numbers with a maximum precision of 38 decimal digits?
A.	INTEGER,INT,SMALLINT
B.	DOUBLE PRECISION,FLOAT
C.	DEC,DECIMAL,NUMERIC
D.	None of the above
Answer» D. None of the above

Discussion

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

Discussion

15.	Which of the following has internal components that can be manipulated individually, such as the elements of an array, record, or table?
A.	A Composite
B.	A LOB
C.	A Reference
D.	A Scalar
Answer» B. A LOB

Discussion

16.	Which statement lets you create standalone functions that are stored in an Oracle database?
A.	SQL CREATE PROCEDURE
B.	SQL CREATE FUNCTION
C.	Both A & B
D.	None of the above
Answer» C. Both A & B

Discussion

17.	Which of the following is used to define code that is executed / fired when certain actions or event occur?
A.	Replace
B.	Keyword
C.	Trigger
D.	Cursor
Answer» D. Cursor

Discussion

18.	Which Operator Returns TRUE if a subquery returns at least one row?
A.	EXISTS
B.	IN
C.	IS NULL
D.	LIKE
Answer» B. IN

Discussion

19.	Which parameter acts like a constant inside the subprogram?
A.	IN
B.	OUT
C.	Both A & B
D.	None of the above
Answer» B. OUT

Discussion

20.	The variables or expressions passed from the calling subprogram are -
A.	Actual Parameters
B.	Formal Parameters
C.	Both A & B
D.	None of the above
Answer» B. Formal Parameters

Discussion

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

Discussion

22.	A function called from SQL statements must obey certain rules meant to control side effects.
A.	True
B.	False
Answer» B. False

Discussion

23.	The DBMS_SQL package should be used in which of the following situations?
A.	15. There is an unknown number of input or output variables, such as the number of column values returned by a query, that are used in a dynamic SQL s
B.	The dynamic code is too large to fit inside a 32K bytes VARCHAR2 variable.
C.	Both A & B
D.	None of the above
Answer» D. None of the above

Discussion

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

Discussion

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

Discussion

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

Discussion

27.	Which datatypes can be used with a RECORD Type?
A.	NUMBER,VRCHAR2
B.	%TYPE,OR %ROWTYPE
C.	REF,CURSOR
D.	BOTH A & B
E.	BOTH B & C
Answer» E. BOTH B & C

Discussion

28.	PL/SQL keywords are not case-sensitive.
A.	True
B.	False
Answer» B. False

Discussion

29.	SIGNTYPE lets you restrict an integer variable to the values -1, 0, and 1, which is useful in programming tri-state logic.
A.	True
B.	False
Answer» B. False

Discussion

30.	You use cursor variables to pass query result sets between PL/SQL stored subprograms and various clients.
A.	Yes
B.	No
Answer» B. No

Discussion

31.	PL/SQL stands for -
A.	Programming Language/SQL
B.	Procedural Language/SQL
C.	Portable Language/SQL
D.	None of the above
Answer» C. Portable Language/SQL

Discussion

32.	Which statement chooses from a sequence of conditions, and executes a corresponding statement?
A.	CASE Statement
B.	CLOSE Statement
C.	COMMIT Statement
D.	None of the above
Answer» B. CLOSE Statement

Discussion

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

Discussion

34.	Which statement associates a cursor variable with a multi-row query, executes the query, and identifies the result set?
A.	OPEN-FOR
B.	FETCH
C.	CLOSE
D.	All mentioned above
Answer» B. FETCH

Discussion

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

Discussion

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

Discussion

37.	The CLOSE statement enables a cursor variable and makes the associated result set undefined.
A.	True
B.	False
Answer» C.

Discussion

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

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

40.	Varrays are a good choice when -
A.	The number of elements is known in advance.
B.	The elements are usually all accessed in sequence.
C.	Both A & B
D.	None of the above
Answer» D. None of the above

Discussion

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

42.	A collection method is a built-in function or procedure that operates on collections and is called using dot notation.
A.	True
B.	False
Answer» B. False

Discussion

43.	Which datatype is used to store large blocks of character data in the database, in-line or out-of-line? Both fixed-width and variable-width character sets are supported.
A.	BLOB
B.	CLOB
C.	BFILE
D.	NCLOB
Answer» C. BFILE

Discussion

44.	Which of the following returns the current value in a specified sequence.
A.	CURRVAL
B.	NEXTVAL
C.	Both A & B
D.	None of the above
Answer» B. NEXTVAL

Discussion

45.	Which of the following provides a way for your program to select multiple rows of data from the database and then process each row individually.
A.	PL/SQL Cursors
B.	PL/SQL Trigger
C.	PL/SQL Select
D.	PL/SQL Process
Answer» B. PL/SQL Trigger

Discussion

46.	When building up a single SQL statement in a string, do not include any semicolon at the end.
A.	Yes
B.	No
Answer» B. No

Discussion

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

Discussion

48.	Which operators combine the results of two queries into one result?
A.	Set operator
B.	Row Operator
C.	Both A & B
D.	None of the above
Answer» B. Row Operator

Discussion

49.	The subprogram is called through a database link or as an external procedure.
A.	True
B.	False
Answer» B. False

Discussion

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

Explore topic-wise MCQs in Computer Science Mcqs.

Which of the following cannot be used with associative arrays?

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

Pragmas are processed at ___________ .

PL/SQL is completely portable, high-performance transaction processing language that offers which of the following advantages -

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

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

Which collection method Returns the index number that precedes index n in a collection?

PL/SQL stored procedures move application code from the server to the client.

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

Which is a simple or compound symbol that has a special meaning to PL/SQL?

PL/SQL is a completely portable, high-performance transaction processing language.

Which operator tests set membership?

Which subtypes are used to declare fixed-point numbers with a maximum precision of 38 decimal digits?

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

Which of the following has internal components that can be manipulated individually, such as the elements of an array, record, or table?

Which statement lets you create standalone functions that are stored in an Oracle database?

Which of the following is used to define code that is executed / fired when certain actions or event occur?

Which Operator Returns TRUE if a subquery returns at least one row?

Which parameter acts like a constant inside the subprogram?

The variables or expressions passed from the calling subprogram are -

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

A function called from SQL statements must obey certain rules meant to control side effects.

The DBMS_SQL package should be used in which of the following situations?

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

Arrays in other languages become varrays in PL/SQL.

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

Which datatypes can be used with a RECORD Type?

PL/SQL keywords are not case-sensitive.

SIGNTYPE lets you restrict an integer variable to the values -1, 0, and 1, which is useful in programming tri-state logic.

You use cursor variables to pass query result sets between PL/SQL stored subprograms and various clients.

PL/SQL stands for -

Which statement chooses from a sequence of conditions, and executes a corresponding statement?

An object type can represent any real-world entity.

Which statement associates a cursor variable with a multi-row query, executes the query, and identifies the result set?

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

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

The CLOSE statement enables a cursor variable and makes the associated result set undefined.

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

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

Varrays are a good choice when -

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

A collection method is a built-in function or procedure that operates on collections and is called using dot notation.

Which datatype is used to store large blocks of character data in the database, in-line or out-of-line? Both fixed-width and variable-width character sets are supported.

Which of the following returns the current value in a specified sequence.

Which of the following provides a way for your program to select multiple rows of data from the database and then process each row individually.

When building up a single SQL statement in a string, do not include any semicolon at the end.

A recursive subprogram is one that calls itself.

Which operators combine the results of two queries into one result?

The subprogram is called through a database link or as an external procedure.

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.