Operators - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: How to use %LIKE operator? Answer: LIKE operator is used to compare a character, string, or CLOB value to a pattern. Case is significant. LIKE returns the Boolean value TRUE if the patterns match or FALSE if they do not match. The patterns matched by LIKE can include two special-purpose characters called … [Read more...]
Packages & Triggers – ORACLE PL/SQL Chapter Wise Interview Questions
Packages & Triggers - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: What is a package spec and package body? Why the separation? Answer: Spec declares public constructs. Body defines public constructs, additionally declares and defines Private constructs Separation helps make development easier Dependency is simplified. You can modify body without … [Read more...]
Joins – ORACLE PL/SQL Chapter Wise Interview Questions
Joins - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: What are various types of joins? Answer: Types of joins are: Equijoins Non-equijoins Self join Outer join Question 2: What is a Join and explain different types of joins. Answer: Joins are used in queries to explain how different tables are related. Joins also let you select data from a … [Read more...]
Sequence-Index – ORACLE PL/SQL Chapter Wise Interview Questions
Sequence-Index - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: What is a sequence? Answer: A database object that offers high-speed access to an integer value Guaranteed to be unique (within that sequence). Used commonly to generate Primary key values Question 2: How does one get the value of a sequence into a PL/SQL variable? Answer: select … [Read more...]
Procedures & Functions – ORACLE PL/SQL Chapter Wise Interview Questions
Procedures & Functions - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: What are the constructs of a procedure, function or a package? Answer: The constructs of a procedure, function or a package are: variables and constants cursors exceptions Question 2: What is the advantage of a Stored Procedure over a Database Trigger? Answer: We have … [Read more...]
Cursors – ORACLE PL/SQL Chapter Wise Interview Questions
Cursors - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors? Answer: Cursors allow row-by-row processing of the resultsets. Types of cursors: Static, Dynamic, Forward-only, Keyset-driven. Disadvantages of cursors: Each time you fetch a row from … [Read more...]
Execution Control Statements – ORACLE PL/SQL Chapter Wise Interview Questions
Execution Control Statements - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: What Are the Execution Control Statements in Oracle? Answer: PL/SQL supports three groups of execution control statements: IF Statements - Conditionally executes a block of statements. CASE Statements - Selectively executes a block of statements. LOOP Statements - Repeatedly … [Read more...]
Datatypes – ORACLE PL/SQL Chapter Wise Interview Questions
Datatypes - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: How Many Categories of Data Types are there in PL/SQL? Answer: PL/SQL data types are grouped into 4 categories: Scalar Data Types: A scalar data type holds a single value. Composite Data Types: A composite data type has internal components, such as the elements of an array. LOB Data Types: A … [Read more...]
Exception Handling – ORACLE PL/SQL Chapter Wise Interview Questions
Exception Handling - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: What is RAISE_APPLICATION_ERROR? Answer: It is a built in function. - This enables you to specified user defined error messages. Syntax: RAISE_APPLICATlON_ERROR(errnum, ’errmsg ’). errnum:it indicates an error number that contains any value between - 20,000 to -20,999. Question 2: What is … [Read more...]
ORACLE PL/SQL Chapter Wise Interview Questions – DDL-DML
ORACLE PL/SQL Chapter Wise Interview Questions - DDL-DML Question 1: What is DDL? Answer: Data definition language (DDL) statements enable you to perform these tasks: Create, alter, and drop schema objects Grant and revoke privileges and roles Analyze information on a table, index, or cluster Establish auditing options Add comments to the data … [Read more...]