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

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

52.	PL/SQL Exception message consists of -
A.	Type of Exception
B.	An Error Code
C.	A message
D.	All mentioned above
Answer» E.

Discussion

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

Discussion

54.	The keyword All is a shorthand way to refer to all warning messages.
A.	Yes
B.	No
Answer» B. No

Discussion

55.	The values of any IN OUT parameters are copied before the subprogram is executed.
A.	Yes
B.	No
Answer» B. No

Discussion

56.	PL/SQL provides a feature to handle the Exceptions which occur in a PL/SQL Block known as exception Handling.
A.	True
B.	False
Answer» B. False

Discussion

57.	Which Exception is also known as Oracle named exception handler?
A.	Predefined Exception
B.	Internal Exception
C.	User defined Exception
D.	None of the above
Answer» B. Internal Exception

Discussion

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

59.	The constructs of a procedure, function or a package are ________ .
A.	Variables and Constants
B.	Cursors
C.	Exceptions
D.	All mentioned above
Answer» E.

Discussion

60.	Which collection types is also known as index-by tables, lets you look up elements using arbitrary numbers and strings for subscript values?
A.	Associative arrays
B.	Nested tables
C.	Varrays
D.	None of the above
Answer» B. Nested tables

Discussion

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

62.	Assigning a value to a collection element can cause exceptions, such as
A.	If the subscript is NULL or is not convertible to the right datatype, PL/SQL raises the predefined exception VALUE_ERROR. Usually, the subscript must
B.	If the subscript refers to an uninitialized element, PL/SQL raises SUBSCRIPT_BEYOND_COUNT.
C.	If the collection is atomically null, PL/SQL raises COLLECTION_IS_NULL.
D.	All mentioned above
Answer» E.

Discussion

63.	Which of the following retains duplicate rows in the result of a query or in an aggregate expression?
A.	ALL
B.	DISTINCT
C.	PRIOR
D.	None of the above
Answer» B. DISTINCT

Discussion

64.	Which operations cannot be performed on cursor expressions?
A.	BIND
B.	EXECUTE
C.	Both A & B
D.	None of the above
Answer» D. None of the above

Discussion

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

66.	PL/SQL has two types of subprograms, procedures and functions. Which subprogram is used to compute a value?
A.	Procedure
B.	Function
C.	Both A & B
D.	None of the above
Answer» C. Both A & B

Discussion

67.	Which is a procedural extension of Oracle- SQL that offers language constructs similar to those in imperative programming languages?
A.	PQL
B.	Advanced SQL
C.	PL/SQL
D.	SQL
Answer» D. SQL

Discussion

68.	Which of the following combines the data manipulating power of SQL with the data processing power of Procedural languages?
A.	PQL
B.	Advanced SQL
C.	PL/SQL
D.	SQL
Answer» D. SQL

Discussion

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

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

71.	Which of the following are the advantages of PL/SQL Packages?
A.	Modularity
B.	Easier Application Design
C.	Information Hiding
D.	Added Functionality,Better Performance
E.	All mentioned above
Answer» F.

Discussion

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

73.	Which PL/SQL warning categories gives Messages for conditions that do not have an effect on performance or correctness, but that you might want to change to make the code more maintainable, such as unreachable code that can never be executed?
A.	PERFORMANCE
B.	SEVERE
C.	INFORMATIONAL
D.	All mentioned above
Answer» D. All mentioned above

Discussion

74.	Which keyword and parameter used for declaring an explicit cursor?
A.	constraint
B.	cursor_variable_declaration
C.	collection_declaration
D.	cursor_declaration
Answer» E.

Discussion

75.	Which of the following declares an instance of an object type?
A.	record_declaration
B.	procedure_declaration
C.	object_declaration
D.	None of the above
Answer» D. None of the above

Discussion

76.	Which is a schema object that groups logically related PL/SQL types, items, and subprograms?
A.	Package Declaration
B.	Object_type declaration
C.	Procedure declaration
D.	None of the above
Answer» B. Object_type declaration

Discussion

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

78.	Which internal exception is raised when a program references a nested table or varray element using an index number larger than the number of elements in the collection.
A.	NO_DATA_FOUND
B.	COLLECTION_IS_NULL
C.	SUBSCRIPT_OUTSIDE_LIMIT
D.	SUBSCRIPT_BEYOND_COUNT
Answer» E.

Discussion

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

80.	To call a subprogram directly, users must have the EXECUTE privilege on that subprogram. By granting the privilege, you allow a user to -
A.	Call the subprogram directly
B.	Compile functions and procedures that call the subprogram
C.	Both A & B
D.	None of the above
Answer» D. None of the above

Discussion

81.	Which error occurs while the program is running and cannot be detected by the PL/SQL compiler?
A.	Syntax error
B.	Runtime error
C.	Both A & B
D.	None of the above
Answer» C. Both A & B

Discussion

82.	Which is a database object that groups logically related PL/SQL types, objects and subprograms?
A.	Package
B.	Module
C.	Body
D.	Name
Answer» B. Module

Discussion

83.	Which collection exception is raised when a subscript designates an element that was deleted, or a nonexistent element of an associative array?
A.	NO_DATA_FOUND
B.	COLLECTION_IS_NULL
C.	SUBSCRIPT_BEYOND_COUNT
D.	SUBSCRIPT_OUTSIDE_LIMIT
Answer» B. COLLECTION_IS_NULL

Discussion

84.	Which keyword is used instead of the assignment operator to initialize variables?
A.	NOT NULL
B.	DEFAULT
C.	%TYPE
D.	%ROWTYPE
Answer» C. %TYPE

Discussion

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

86.	Which of the following is used for reading and writing operating-system files?
A.	UTL_FILE
B.	UTL_HTTP
C.	UTL_SMTP
D.	None of the above
Answer» B. UTL_HTTP

Discussion

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

Discussion

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

Discussion

89.	When creating a function, in which section will you typically find a return key word?
A.	Header Only
B.	Declarative
C.	Executable and Header
D.	Executable and exception handling
Answer» D. Executable and exception handling

Discussion

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

91.	You can use the BULK COLLECT INTO clause with the EXECUTE IMMEDIATE statement to store values from each column of a query's result set in a separate collection.
A.	Yes
B.	No
Answer» B. No

Discussion

92.	PL/SQL programs are written as lines of text using a specific set of characters.
A.	Upper- and lower-case letters A .. Z and a .. z
B.	Numerals 0 .. 9
C.	Symbols ( ) + - * / < > = ! ~ ^ ; : . ' @ % , " # $ & _ \| { } ? [ ]
D.	Tabs, spaces, and carriage returns
E.	All mentioned above
Answer» F.

Discussion

93.	What is the maximum number of triggers that can apply to a single table?
A.	14
B.	10
C.	12
D.	16
Answer» D. 16

Discussion

94.	Which of the following returns all distinct rows selected by either query?
A.	INTERSECT
B.	MINUS
C.	UNION
D.	UNION ALL
Answer» D. UNION ALL

Discussion

95.	Which of the following has a return type in its specification and must return a value specified in that type?
A.	Function
B.	Procedure
C.	Package
D.	None of the above
Answer» B. Procedure

Discussion

96.	Which statements are used to control a cursor variable?
A.	OPEN-FOR
B.	FETCH
C.	CLOSE
D.	All mentioned above
Answer» E.

Discussion

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

98.	Which datatypes are PL/SQL-only datatypes that are more efficient than the SQL datatypes NUMBER or INTEGER for integer arithmetic?
A.	PLS_INTEGER
B.	BINARY_INTEGER
C.	Both A & B
D.	None of the above
Answer» D. None of the above

Discussion

99.	Which of the following returns the current error message text?
A.	SQLERRM
B.	SQLCODE
C.	Both A & B
D.	None of the above
Answer» B. SQLCODE

Discussion

100.	When implementing methods using PL/SQL, you cannot call a base or supertype object method with the super keyword or an equivalent method in a derived object.
A.	True
B.	False
Answer» B. False

Discussion

Explore topic-wise MCQs in Computer Science Mcqs.

Abbreviate SMTP?

PL/SQL Exception message consists of -

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

The keyword All is a shorthand way to refer to all warning messages.

The values of any IN OUT parameters are copied before the subprogram is executed.

PL/SQL provides a feature to handle the Exceptions which occur in a PL/SQL Block known as exception Handling.

Which Exception is also known as Oracle named exception handler?

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

The constructs of a procedure, function or a package are ________ .

Which collection types is also known as index-by tables, lets you look up elements using arbitrary numbers and strings for subscript values?

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

Assigning a value to a collection element can cause exceptions, such as

Which of the following retains duplicate rows in the result of a query or in an aggregate expression?

Which operations cannot be performed on cursor expressions?

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

PL/SQL has two types of subprograms, procedures and functions. Which subprogram is used to compute a value?

Which is a procedural extension of Oracle- SQL that offers language constructs similar to those in imperative programming languages?

Which of the following combines the data manipulating power of SQL with the data processing power of Procedural languages?

________ 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

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

Which of the following are the advantages of PL/SQL Packages?

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

Which PL/SQL warning categories gives Messages for conditions that do not have an effect on performance or correctness, but that you might want to change to make the code more maintainable, such as unreachable code that can never be executed?

Which keyword and parameter used for declaring an explicit cursor?

Which of the following declares an instance of an object type?

Which is a schema object that groups logically related PL/SQL types, items, and subprograms?

For which of the following can pragma be applied?

Which internal exception is raised when a program references a nested table or varray element using an index number larger than the number of elements in the collection.

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

To call a subprogram directly, users must have the EXECUTE privilege on that subprogram. By granting the privilege, you allow a user to -

Which error occurs while the program is running and cannot be detected by the PL/SQL compiler?

Which is a database object that groups logically related PL/SQL types, objects and subprograms?

Which collection exception is raised when a subscript designates an element that was deleted, or a nonexistent element of an associative array?

Which keyword is used instead of the assignment operator to initialize variables?

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

Which of the following is used for reading and writing operating-system files?

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

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

When creating a function, in which section will you typically find a return key word?

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

You can use the BULK COLLECT INTO clause with the EXECUTE IMMEDIATE statement to store values from each column of a query's result set in a separate collection.

PL/SQL programs are written as lines of text using a specific set of characters.

What is the maximum number of triggers that can apply to a single table?

Which of the following returns all distinct rows selected by either query?

Which of the following has a return type in its specification and must return a value specified in that type?

Which statements are used to control a cursor variable?

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

Which datatypes are PL/SQL-only datatypes that are more efficient than the SQL datatypes NUMBER or INTEGER for integer arithmetic?

Which of the following returns the current error message text?

When implementing methods using PL/SQL, you cannot call a base or supertype object method with the super keyword or an equivalent method in a derived object.