Author - NareshIT_Hr

PL SQL Practice Test 12

Where can a Varray be stored? At package or at the schema level. PL/SQL block or at the schema level. PL/SQL block or at the package level. PL/SQL block or package or at the schema level Ans : 4 Which of the following collections can be stored in the database? Associative array and Varray Varray and nested table Associative array and nested table Associative array, Varray and nested table Ans : 2 Which of the following collections have an initialized status as empty? Associative array Varray Nested table Records Ans : 1 What does DELETE (m,n) do [...]

Read more...

PL SQL Practice Test 11

What are the types of composite datatypes? Records and Nested table Collections and BOOLEAN Collections, PLS_INTEGER and BOOLEAN Collections and Records Ans : 4 Which of the following statement is true for a collection? In a collection, the internal components always have the same data type. In a collection, the internal components always have different data type In a collection, the internal components may have same data type or different datatype. All collection except records have the same datatype. Ans : 1 How are the elements of a collection variable accessed? variable_name[index] variable_name(index) index variable_name{index} Ans [...]

Read more...

PL SQL Practice Test 10

Which is not a type of trigger? DDL DML DCL Database Ans :  3 Which prefixes are available to Oracle triggers? : new only : old only Both: new and : old Neither: new nor :old Ans : 3  Triggers ________ enabled or disabled Can be  Cannot be Ought to be Always Ans : 1 What are the after triggers?  Triggers generated after a particular operation These triggers run after an insert, update or delete on a table These triggers run after an insert, views, update or delete on a table Both b and c Ans : 2 Which of the following is [...]

Read more...

PL SQL MCQ Questions 9

Which of the following is used to define code that is fired when certain actions or event occur? Replace Keyword Trigger Cursor Ans : 3  ………………….. are used to recreate if trigger already exists. Cursor Trigger Keywords Replace Ans : 4 For which trigger timing can you reference the NEW and OLD qualifiers? Statement and Row Statement only Row only Oracle Forms trigger Ans : 4 Which of the following is not a benefit of a database trigger? Enforcing referential integrity Event logging and storing information on table access Allowing invalid transactions Generating some derived column values automatically Ans : 3 Does the [...]

Read more...

PL SQL MCQ Questions 8

Which statement is package specification or body of a stored subprogram? Package Specification only requires recompilation Package body only requires recompilation Both package & body requires recompilation Both package & body does not require recompilation. Ans : 1 The packaged procedure that makes data in form permanent in the Database is Post Post form Commit form None of the above Ans :  3 Which of the following do not execute multiple PL/SQL programs simultaneously? Oracle Advanced Queuing DBMS_JOB DBMS_SQL Pipelined Functions Ans : 3 Which package can you use to output values and messages stored procedures? DBMS_DISPLAY DBMS_OUTPUT DBMS_LIST DBMS_DESCRIBE Ans : [...]

Read more...

PL SQL Practice Test 7

In a stored procedure, when specifying a string parameter should use which of these ? Char varchar2 TEXT REAL Ans : 2 A Stored Procedure is a Sequence of SQL or PL/SQL statements to perform specific function Stored in compiled form in the database Can be called from all client environments All of the above Ans : 4 Which of the following is true ,Creating a procedure have compile errors.? The line numbers reported match the line numbers you see in your text editor. SQL*Plus will automatically show the errors to you. To see [...]

Read more...
PL-SQL-Objective-Questions-NareshIT

PL SQL Practice Test 6

Whenever compiler implicitly converts the data type of the actual to formal parameter? When pass by reference Always, when pass by any method It never converts implicitly and has to be explicitly done by user When pass by value Ans : 4 What are the two different types of values for a parameter? Default and System given Default and user given System given and user given Compile time and run time values Ans : 2 What happens data type of the actual parameter is not  same as formal parameter? An error is [...]

Read more...

PL SQL MCQ Questions 5

Which collection exception is raised when a subscript exceeds in a collection? VALUE_ERROR COLLECTION_IS_NULL SUBSCRIPT_BEYOND_COUNT SUBSCRIPT_OUTSIDE_LIMIT Ans : 3 Which exception is raised when a nonexistent element of an associative array? NO_DATA_FOUND COLLECTION_IS_NULL SUBSCRIPT_BEYOND_COUNT SUBSCRIPT_OUTSIDE_LIMIT Ans : 1 In which subprogram a RETURN statement does not return a value ? In Procedures In Functions Both A & B None of the above Ans : 1 Which part of a subprogram heading is optional? Name of the subprogram Declaration part of a subprogram Parameters Exception handling part Ans : 3 Which of the following is not a subprogram? Procedure Function Package Anonymous PL/SQL block Ans :  3 Attend Free Demo [...]

Read more...

PL SQL MCQ Questions 4

What are internally defined exceptions? The Oracle ORA errors Exceptions which are already defined in the STANDARD package Exceptions defined by a user Any error that occurs in PL/SQL Ans : 1 How can a user defined exception be raised? Using RAISE statement only Using RAISE statement or RAISE_APPL_ERROR function Using INVOKE statement or RAISE statement Using RAISE statement or RAISE_APPLICATION_ERROR procedure Ans : 4 Which of the following exception is globally available? Internal, User-defined and Pre-defined exceptions Pre-defined exceptions only Internal and pre-defined exceptions User defined exceptions only Ans : 2 What happens after an exception [...]

Read more...

PL/SQL Multiple Choice Questions 3

Can you use %RowCount as a parameter to a cursor? Yes No None of the above Depends upon Ans :  1 How is it possible to fetch a current row from a cursor without using ROWID? Where HAVING WHERE CURRENT OF None of the above Ans : 3 How many types of ref-cursor? One Two Zero Five Ans : 2 What are exceptions in PL/SQL? Runtime errors Runtime warnings Compile time errors Compile time warnings Ans : 1 PL/SQL Exception message consists of -? Type of Exception An Error Code A message All mentioned above Ans : 4 Attend Free Demo and Learn   SQL SERVER ONLINE TRAINING   by Real-Time [...]

Read more...