Interview Questions

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

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

Read more...

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

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

Read more...

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

Read more...

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

Read more...

Advanced Java Interview Questions

Advanced Java Interview Questions Servlets 1.Define Java Servlet? Ans: A Java Servlet is a simple Java Class, which is dynamically loaded onto Web Server and therefore, enhances the functionality of the Web Server. A Java Servlet is secure and portable as it runs on the Web Server and cannot operate outside its domain. Define Servlet Container? Ans: Servlet Container, sometimes also known as Servlet Engine, is an integrated set of objects that provide runtime environment for java Servlet componenets. In other words, it is [...]

Read more...

JSP Interview Questions and Answers

                                                               JSP Interview Questions 1.What is JSP? JSP is a tag based JEE web technologies to develop web application for providing dynamic response to end user. Compare to Servlet, JSP is used to develop web applications within the less time. JSP is not replacement of Servlet technology. It is one different way [...]

Read more...

Servlet Interview Questions and Answers

                                                           Servlet Interview Questions 1.What is use of JEE? A) JEE stands for Java Enterprise Edition, after adding servlet into java this flavor came into the picture, the main intention of this flavor is to develop following applications like a. Web applications b. Distributed applications c. Enterprise applications. 2.What are the types of web applications? A) Mainly web [...]

Read more...