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

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

102.	Which of the following results are true, when a ROLLBACK statement is issued to the database, the transaction has ended?
A.	All work done by the transaction is undone, as if it hadn't been issued.
B.	Any locks acquired by the transaction are released.
C.	Both A & B
D.	None of the above
Answer» D. None of the above

Discussion

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

104.	To process most dynamic SQL statements, you use the EXECUTE IMMEDIATE statement. To process a multi-row query (SELECT statement), which of these statements would you use?
A.	OPEN-FOR
B.	FETCH
C.	CLOSE
D.	All mentioned above
Answer» E.

Discussion

105.	Which of the following is handled with the help of exception-handling section in an PL/SQL block. For eg, SELECT INTO statement, which does not return any rows.
A.	A runtime error
B.	A syntax error
C.	Both A & B
D.	None of the above
Answer» B. A syntax error

Discussion

106.	Subprograms let you extend the PL/SQL language. Which subprogram acts like new expressions and operators?
A.	Procedures
B.	Functions
C.	Both A & B
D.	None of the above
Answer» C. Both A & B

Discussion

107.	Which of the following is a group of related data items stored in fields, each with its own name and datatype?
A.	A Record
B.	A Collection
C.	Both A & B
D.	None of the above
Answer» B. A Collection

Discussion

108.	In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
A.	%ROWCOUNT
B.	%FOUND
C.	%NOTFOUND
D.	%ISOPEN
Answer» C. %NOTFOUND

Discussion

109.	You can use the RETURNING BULK COLLECT INTO clause with the EXECUTE IMMEDIATE statement to store the results of which statements in a set of collections?
A.	INSERT
B.	UPDATE
C.	DELETE
D.	All mentioned above
Answer» E.

Discussion

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

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

Discussion

112.	Which of the following are used for displaying output on a web page?
A.	HTF
B.	HTP
C.	Both A & B
D.	None of the above
Answer» D. None of the above

Discussion

113.	PL/SQL Expressions are constructed using.
A.	Operands
B.	Operators
C.	Both A & B
D.	None of the above
Answer» D. None of the above

Discussion

114.	Use the ROWID datatype only for backward compatibility with old applications. For new applications, use the UROWID datatype.
A.	True
B.	False
Answer» B. False

Discussion

115.	How many bytes does each character in the UTF8 encoding take up?
A.	1
B.	2
C.	3
D.	All mentioned above
Answer» E.

Discussion

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

Discussion

117.	Which datatype is not allowed in the definition of PL/SQL record?
A.	A Collection
B.	A Scalar
C.	Both A & B
D.	None of the above
Answer» B. A Scalar

Discussion

118.	Which type of cursor is automatically declared by Oracle every time an SQL statement is executed?
A.	An Implicit
B.	An Explicit
C.	Both A & B
D.	None of the above
Answer» B. An Explicit

Discussion

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

Discussion

120.	You can use the BULK COLLECT INTO clause with the FETCH statement to store values from each column of a cursor in a separate collection.
A.	True
B.	False
Answer» B. False

Discussion

121.	For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is raised when no rows satisfy the SELECT criteria?
A.	TOO_MANY_ROWS
B.	NO_DATA_FOUND
C.	VALUE_ERROR
D.	DUP_VAL_ON_INDEX
Answer» C. VALUE_ERROR

Discussion

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

123.	Which datatypes make it practical to write PL/SQL programs to do number-crunching, for scientific applications involving floating-point calculations.
A.	BINARY_FLOAT
B.	BINARY_DOUBLE
C.	Both A & B
D.	None of the above
Answer» D. None of the above

Discussion

124.	To handle raised exceptions, you write separate routines called exception handlers.
A.	Yes
B.	No
Answer» B. No

Discussion

125.	What are the different datatypes that can be defined in a PL/SQL block?
A.	Scalar
B.	Composite
C.	Reference
D.	LOB
E.	All mentioned above
Answer» F.

Discussion

126.	With PL/SQL, it is very simple to issue a query, retrieve each row of the result into a %ROWTYPE record, and process each row in a loop.
A.	True
B.	False
Answer» B. False

Discussion

127.	The BINARY_INTEGER and PLS_INTEGER datatypes are not identical.
A.	True
B.	False
Answer» C.

Discussion

128.	Which attribute returns NULL?
A.	%FOUND
B.	%ISOPEN
C.	%NOTFOUND
D.	%ROWCOUNT
Answer» B. %ISOPEN

Discussion

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

130.	The AUTONOMOUS_TRANSACTION pragma changes the way a subprogram works within a transaction.
A.	True
B.	False
Answer» B. False

Discussion

131.	Subprograms are named PL/SQL blocks that can be called with a set of parameters.
A.	True
B.	False
Answer» B. False

Discussion

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

133.	The comparison methods are used for comparing objects. How many ways are available for comparing objects?
A.	4
B.	1
C.	2
D.	5
Answer» D. 5

Discussion

134.	Which methods implement some internal logic for comparing two objects? For example, a rectangle is bigger than another rectangle if both its sides are bigger.
A.	Order method
B.	Map method
C.	Both A & B
D.	None of the above
Answer» B. Map method

Discussion

135.	Which of the following is not a schema object?
A.	Packages
B.	Indexes
C.	Public Synonyms
D.	Triggers
Answer» D. Triggers

Discussion

136.	Which package lets PL/SQL programs read and write operating system (OS) text files?
A.	UTL_HTTP
B.	UTL_FILE
C.	UTL_SMTP
D.	None of the above
Answer» C. UTL_SMTP

Discussion

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

138.	You can pass parameters to procedures or functions in a package.
A.	True
B.	False
Answer» B. False

Discussion

139.	Which statements execute a sequence of statements multiple times?
A.	EXIT
B.	LOOP
C.	Both A & B
D.	None of the above
Answer» C. Both A & B

Discussion

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

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

Discussion

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

Discussion

143.	Which of the following is used to declare a record?
A.	%ROWTYPE
B.	%TYPE
C.	Both A & B
D.	None of the above
Answer» B. %TYPE

Discussion

144.	PL/SQL provides many powerful functions to help you manipulate data. These built-in functions fall into which of these following categories?
A.	Error reporting,Character, Datatype conversion
B.	Number,Date,Object reference
C.	Miscellaneous
D.	All mentioned above
Answer» E.

Discussion

145.	What is the advantage of using the %ROWTYPE datatype?
A.	It is useful to retrieve an entire row from a table. If you do not use the %ROWTYPE datatype, then you have to declare variables for each column separ
B.	It can be used even if data type of the table columns is not known.
C.	It ensures that data type of the variable changes dynamically if the underlying table is altered.
D.	All mentioned above
E.	Both A & B
Answer» E. Both A & B

Discussion

146.	Which of the following is an explicit numeric, character, string, or BOOLEAN value not represented by an identifier?
A.	Delimiters
B.	Literals
C.	Comments
D.	None of the above
Answer» C. Comments

Discussion

147.	Which Package lets you use database triggers to alert an application when specific database values change?
A.	DBMS_OUTPUT
B.	DBMS_ALERT
C.	DBMS_PIPE
D.	All mentioned above
Answer» C. DBMS_PIPE

Discussion

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

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

Discussion

150.	The LOB objects can be stored in-line or out-of-line. The in-line storage means that objects are stored.
A.	Along with the row
B.	Outside the row
C.	Both A & B
D.	None of the above
Answer» B. Outside the row

Discussion

Explore topic-wise MCQs in Computer Science Mcqs.

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.

Which of the following results are true, when a ROLLBACK statement is issued to the database, the transaction has ended?

A package will have which of these mandatory parts?

To process most dynamic SQL statements, you use the EXECUTE IMMEDIATE statement. To process a multi-row query (SELECT statement), which of these statements would you use?

Which of the following is handled with the help of exception-handling section in an PL/SQL block. For eg, SELECT INTO statement, which does not return any rows.

Subprograms let you extend the PL/SQL language. Which subprogram acts like new expressions and operators?

Which of the following is a group of related data items stored in fields, each with its own name and datatype?

In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?

You can use the RETURNING BULK COLLECT INTO clause with the EXECUTE IMMEDIATE statement to store the results of which statements in a set of collections?

Nested tables are a good choice when

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

Which of the following are used for displaying output on a web page?

PL/SQL Expressions are constructed using.

Use the ROWID datatype only for backward compatibility with old applications. For new applications, use the UROWID datatype.

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

Cursor attributes are not affected by autonomous transactions.

Which datatype is not allowed in the definition of PL/SQL record?

Which type of cursor is automatically declared by Oracle every time an SQL statement is executed?

Associative arrays also known as index-by tables.

You can use the BULK COLLECT INTO clause with the FETCH statement to store values from each column of a cursor in a separate collection.

For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is raised when no rows satisfy the SELECT criteria?

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

Which datatypes make it practical to write PL/SQL programs to do number-crunching, for scientific applications involving floating-point calculations.

To handle raised exceptions, you write separate routines called exception handlers.

What are the different datatypes that can be defined in a PL/SQL block?

With PL/SQL, it is very simple to issue a query, retrieve each row of the result into a %ROWTYPE record, and process each row in a loop.

The BINARY_INTEGER and PLS_INTEGER datatypes are not identical.

Which attribute returns NULL?

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

The AUTONOMOUS_TRANSACTION pragma changes the way a subprogram works within a transaction.

Subprograms are named PL/SQL blocks that can be called with a set of parameters.

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

The comparison methods are used for comparing objects. How many ways are available for comparing objects?

Which methods implement some internal logic for comparing two objects? For example, a rectangle is bigger than another rectangle if both its sides are bigger.

Which of the following is not a schema object?

Which package lets PL/SQL programs read and write operating system (OS) text files?

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

You can pass parameters to procedures or functions in a package.

Which statements execute a sequence of statements multiple times?

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

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

Oracle predefined errors are not associated with specific error codes.

Which of the following is used to declare a record?

PL/SQL provides many powerful functions to help you manipulate data. These built-in functions fall into which of these following categories?

What is the advantage of using the %ROWTYPE datatype?

Which of the following is an explicit numeric, character, string, or BOOLEAN value not represented by an identifier?

Which Package lets you use database triggers to alert an application when specific database values change?

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

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

The LOB objects can be stored in-line or out-of-line. The in-line storage means that objects are stored.