Interview Questions

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


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


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


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


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


PL SQL Objective Questions 2

When should an alias be used in a CURSOR FOR LOOP? Always Only when virtual columns are used Never When the number of tables are more than one Ans :  2 What can a CURSOR FOR LOOP use? Explicit cursor only Implicit cursor only Explicit or Implicit cursors Cursor variables only Ans : 1 For which of the following statements can a CURRENT OF clause be used? INSERT, DELETE or UPDATE DELETE or UPDATE SELECT or INSERT SELECT or UPDATE Ans :2 How is the Loop index of a CURSOR FOR LOOP declared? It is explicitly declared as [...]


PL SQL Objective Questions 1

What is the name of the cursor written and maintained by a database user? User cursor Explicit cursor Implicit cursor User-defined cursor Ans : 2 What is the syntax of an implicit cursor attribute ISOPEN? %ISOPEN #ISOPEN &ISOPEN ! ISOPEN Ans : 1 What does %FOUND attribute indicate? It indicates that the cursor was found. It indicates that the number of rows that got affected. It indicates whether any rows were affected. It indicates whether any rows were not affected. Ans : 3 When is an implicit cursor used? SELECT or DML statement is run and not associated [...]

PL SQL Mostly asked Interview Questions

PL SQL Mostly Asked Interview Questions

Top PL/SQL Interview Questions What is PL/SQL? What is the basic structure of PL/SQL? What are the components of a PL/SQL Block? What are the data types a available in PL/SQL? Is there a limit on the size of a PL/SQL block? What is the difference between Anonymous blocks and sub programs? Can SQL group functions be used within the procedural statements? How is global variable declared within a nested block? What is the maximum length of an identifier that can be used? What are the different data types [...]


DevOps Interview Questions

DevOps Interview Questions 1. What is Source Code Management? It is a process through which we can store and manage any code. Developers write code, Testers write test cases and DevOps engineers write scripts. This code, we can store and manage in Source Code Management. Different teams can store code simultaneously. It saves all changes separately. We can retrieve this code at any point of time. 2. What are the Advantages of Source Code Management? . Helps in Achieving teamwork . Can work on [...]


AngularJS Interview Questions

AngularJS Interview Questions What is root directive? Can we use angularjs with out ng –app? The root directive in Angular JS  is ng-app. We  declare this directive in the root element of the main html document(index.html) ng-app is called root directive because the angular framework starts execution  of the application from  ng-app. And this  process is called Auto bootstrap` We can run the angular application without ng-app  through manual bootstrap Manual bootstrap: Execution of the Angular application forcefully with out ng-app is called  Manual [...]


New Batches