PL/SQL Interview Questions
Accenture PL/SQL Interview Questions
What are different types of queries
Write a correlated sub query and explain how it works
What are different type of statements
What TCL do
What is difference between stored procedure and function
How you handle errors
What is %type and %row type
What are different types of cursors
How implicit cursor works
What are different type of triggers
Write a pl/sql block for trigger at the time of insertion for inserting old and new values auditing table.
What are different types of joins
What self join do
Write an example and explain about self join
Write an example for left outer join and how output comes
What is difference between in and = operator
What is package
Tell some advantages of packages
What are collections in pl/sql
What are pointers in c
How you connect to data base
some more interview questions asked in scope
Difference between cursor for loop and for loop, which is faster?
In proc and PL/SQL, which is faster?
Which is best method to kill the process (unix or oracle)?
Difference between c shell, bourn shell, k shell?
What is inode?
How to search two patterns using grep pattern?
Difference between ls and find?
Difference between view and snapshot?
Difference between function and procedure?
Why we cannot use DDL commands in procedure?
Difference between global variable and static global variable?
How to access variable of nested procedure?
If we have both user exception and system exception, which will be handled first?
Difference between anonymous block and normal block?
Can we create snapshot for another schema?
How to access table from another database?
Dell PL/SQL Interview Questions
Select * from a where hiredate+60 < sysdate; (here hiredate is non-unique index, so query scanning index range or full table scanning.
Have you worked on explain plan, how to tune sql query
Can you write pivot query?
Which exception rise in bulk collect and forall processing
What are analytical functions?
What is dbms_profiler do?
Difference between sql *loader and external table, explain requirements for that
Have you ever worked on partitions, explain Virtual column based partitioning
what is nvl and nvl2 function and examples
Explain about TK-proof , syntax of TK-proof
Merge statement syntax
Partition Exchange(One table have 5 partitions like P1...P5, I want to move P5 partition insert into another Table)?
Difference between 10g and 11g
ITC Infotech PL/SQL Interview Questions
How many lines of code you wrote every day in your project.
How many tables in your database, which table having highest columns in your database and highest records
Suppose you have 80 laks records in table, i want to update 50 records on table, which method you will approach to update the records?
Have you ever created tables, tell me 3 differences between primary key and unique key.
Have you ever worked on bulk collect, usage of bulk collect and forall.
How to tune package, how can we see the output, which logic taking more time to execute?
How to tune sql statement, explain the steps
Have you ever worked on partitions, why should we go to partitions?
Have you ever worked on indexes, what is the default index? Why we can create a Function based index?
Have you created Materialized view, what is it?
What is the difference between view and materialized view?
Difference between import/export and sql loader
What is conventional path and direct path, which is the faster?
What is the requirement you have used import/export?
What are the functions you have worked on every day? What is the usage of decode?
Have you ever worked on Analytical functions?
Clover Infotech PL/SQL Interview Questions
Tell me about yourself and what are the responsibilities in your project.
What is the difference between procedure and function
Can we return 2 values through function,i want return empno and sal how to design a function.
I have a package with 2 procedures and declared one procedure in specification only second procedure not declared in specification, package body compiled or not?
What is the use of forward declaration and if you can use in package can we call procedure outside package.
Difference between primary and unique and i am retrieving unique column, that time unique column firing or not?
Difference between nvl and nvl2
How many types of exceptions
Explain pragma types, pragma exception_init and pragma serially_reusable
Difference between bulk collect and forall, suppose i am inserting 10000 records due to some issue few records are not inserted, how to find which records are not inserted, which method you follow to find.
How many types of collection and methods
What are the exceptions raised in collections.
Have you worked on analytical functions?
Difference between rank and dense rank
I have a package with number of logics inside package but package is slow down due to some logic, how to find which query taking more time after finding the query how to tune a query.
Difference between truncate and delete, why truncate faster rather than delete.
Difference between view and materialized view
What is correlated subquery?
What is complex query and have you ever work on that.
Difference between btree and bitmap index
Explain composite data type, tell me the syntax.
Explain briefly about sql loader
Capgemini PL/SQL Interview Questions
PL/SQL Interview Questions for 3.8 years’ Experience
Differencebetween Char and Varchar2.
What is Trunc function where we can use it.
What is Round function and Sign function.
What INSTRING AND SUB STRING.
Difference between Translate and Decode.
Difference between Delete and Truncate.
Which is faster Case or Decode.
What are pseudo columns in oracle
What is Implicit and Explicit cursor.
Difference between Primary key and Unique.
Difference between procedure and function.
Can we use Out parameter in Function.
Can we use return statement in procedure.
If we use out parameter in function and also use return statement , function return 2 values or one value.
What is advantages of Packages.
I have a package with 2 procedures and same name with different signature it is possible.
How many types of trigger, instead of trigger.
What is mutating table, how to resolve the error.
What are pragma exception types.
Tell me how to delete duplicate rows on a table.
I have a table and create a row level trigger on a table, i deleted 10 records,how many times records are deleted(raised another question now rows deleted what happens)
HCL PL/SQL Interview Questions
HCL Interview Questions for 4.2 Years Experience
1. Explain briefly NVL, NVL2, NULL IF functions
2. I have a table and created a two indexes on two columns but i want create 3rd index how can u create a index
3. Difference between View AND Materialized View, i have created a Materialized View after then rename a one column on base table,Materialized View updated or not.
4. Explain procedure,function,package
5. what are challenges you faced in your environment
6. How many types of triggers,explain briefly
7. What is mutating trigger
8. I wrote a pl/sql block for insert and update on table, one statement was failed how to know which statement filed, what type of exception you raised
9. Package advantages
10. what is stand alone procedure
11. difference between 11g and 12c in oracle
12. Explain briefly about cursors
13. Write a syntax for Bulk collect and Bulk bind
14. What are collection types
15. Difference between group function and Atlantical function
16. How many arguments we can pass IN operator
17. Difference between IN and EXITS
18. What is pragma exception init
19. How to debug a procedure
20. Performance tuning
21 purpose of Global temporary table
22. Advantages of MATERIALIZED View
23. Where you can use with clause
MBT PL/SQL Interview Questions
Oracle
Difference between procedure and funtion?
How procedures and functions are called?
What is meant by trigger?
What is two-phase commit?
Ans).prepare phase
Execution phase. I distributed system database.
Can we give commit for procedure and function?
Yes
Can we give commit for the tiggers?
No
What is dns.ora?
How will u connect to the server from ur pc?
Connect: server uid
Passwd:******
Difference between dedicated server and distributed server?
What is view?
What is materialized view?
What is the difference between view and materialized view?
Hr
Tell me about urself?
Tell me about projects?
How will u get the work?
What are ur responsibilities?
Technical
Tell me about your self
Define transaction.
Transaction is a logical unit of work.
What is index?
Index is a database object which is used to fast reterival of data.
How does index form internally?
Based on rowid.
What are pseudo columns?
Pseudo columns are those which does not exists physically but they will perform some expression evaluation
What is a partition
Large table are divided into small tables depending on condition
Range
Hash
List
Define view
View is a logical representation of data
Can we update a view?
Yes
What is autonomous transaction
Explain about exception propagation
How to find to which database you have connected?
Select * from global_name;
How to connect to different database?
Using database links
What is database link?
It is one way commnincation
Link b/w one db to another db.
What do you know about materialized view?
Have you ever used dynamic sql statements in your project?
Some 3 queries? (nth max sal, query on group by and select dup records)
Do you know about rollup and cube?
Then asked some questions on project for 5 min.
Hr
Asked about the project and team members and the organization structure
To whom do you report? (what is his name)
Tell me some of your team members names?
Tell about your family background
What is your ctc (cost to company)
What is your expected salary
And some other general questions and some funny questions.that’s it all the best.
What is the 3rd normal form
Each non key column must depend on nothing but the key. If a column depends on column that are not part of the key split those columns into new table.
What’s the difference between the table level constraints and row level constraints.
The table level constraint is part of the table definition. An integrity constraint defined at table level can impose rules on any columns in the table whereas column level constraint being a part of the column definition can be imposed only on the column level on which it is defined.
SONY PL/SQL Interview Questions
Introduce about your self.
Tell me about your project.
For what purpose you are used pro*c in your project.
What is a package, advantages and disadvantages of packages?
What is a procedure and function.
Display the duplicate records in table.
What is meant by overloading.
What is meant by one time procedure.
What is meant by function purity levels.
What is meant by for update clause.
What is meant by dynamic sql.
What are the types of exceptions in pl/sql.
What is meant by raise_application_error.
What is meant by utl_File.
What are the exceptions are there in utl_file.
What is the structure of varchar.
What is the structure of sqlca.
What is meant by whenever statement.
How to embeded the pl/sql block in proc.
How can you declare the cursor in proc.
What is meant by ps command in unix.
How to search the pattern.
How to search a file in particular directory.
What is meant by normalization.
How many types of triggers can be created on a table .
Ans: 12 types of triggers can be created on a table
Before insert/update/delete for each row
After insert/update/delete for each row
Before insert/update/delete for each statement
After insert/update/delete for each statemen
GE PL/SQL Interview Questions
Tell me about u r self, educational details and u r projects
Tell me about ur current project.
How will rate yourself in PRO*C, SQl,PL/SQL and UNIX
I have 10,000 records,. The record length is 70 characters? How will insert at a time 500 records into a database
After inserting 500 records, unexpectedly the program was aborted? Again we run the program. From which position the records are inserted into a database.
How do you know the how many records are processed in PRO*C
Explain sqlca structure
What is the maximum error message length returned by sqlcode.sqlerrm.sqlerrmc?
If I Want to display the error message, which is more than 70 character? How to obtain it?
Until runtime I don’t know the table name, to select a query. Which method u should follow?
I had one varchar variable. I assign a value to that character arrary arr. Is it sufficient?
How handles errors in PRO*C
How to compile u r PRO*C program
How to compile the C program
How to run programs
Do u know the oracle architecture
What is meant by oracle instance
What is inline view? What are the advantages
What is package? What are the advantages
Till now how many packages u r written
Some columns having indexes. How to know which columns having indexes in a table
What is index? Types of index? What is the advantages of bit-map index?
How do u optimize u r query?
How to know the cost of the query?
What is a trigger?
Have u use instead of triggers
How many types of joins u know?
What is meant my outer join? Can write one sample query?
What is full join? Tell me one example?
what is grep? How to find blank lines in a file?
What is find?
What are the other command u know?
what are the major significant you achieve in u r experience?
U r PL gave a compliant on you to your PM? What u do?
Have u prepared any documentation?
Matrix PL/SQL Interview Questions
11g features
What are main advantages of 10g then other version(9i)
Syntax of collection
Write a query to display even/odd number from a table.
What is the exception; write syntax on user defined exception.
How many types of sub queries in oracle.
Syntax of correlated sub query.
Write syntax to execute procedure or function in sql.
What are sql functions?
Disadvantage of triggers.
Diff %type and %row type.
What cascade constrains.
What is in line view.
How to retrieve 3rd max sal
Write syntax indian time and time 12 hours and 24 hours.
Index types
Wipro PL/SQL InterviewQuestions
SQL and PL/SQL
Difference between truncate and delete.
write a query to find second max salary.
SELECT SAL SECONFD FROM EMP WHERE SAL NOT IN(SELECT MAX(SAL) FIRST FROM EMP);
write a query to delete duplicate rows.
DELETE FROM EMP WHERE ROWID <>(SELECT MAX(ROWID) FROM EMP B WHERE EMPNO=B.EMPNO);
difference between procedure and function.
what is package.how to call the function.
PACKAGE.FUNCTION-NAME
UNIX
In a text file containing orange and apple.i want number of occurrences.
GREP –N ORANGE APPLE FILE NAME
how to delete recently created 10 days files.
FIND . –TYPE F -ATIME +10 –EXEC RM {};\
how du you know which process is running in u r system.
LOGICA PL/SQL Interview Questions
What is your daily activites in project?
What is sga?
What is pga?
What is tablespace?
What is extent clause in tablespace?
What is datasets?
What is datablocks?
What is temparery table?
Which sitivation are you worked temparery table?
What are the datatypes in sql?
What are the char datatypes?
Diff b/w char & varchar2?
What is timestamp returns?default size of timestamp?
What is defaults timestamp format like 12 or 24?
Do you know any character datatype without char,varchar2?
Do you know any number datatype without number & integer?
Tell me some pl/sql datatypes?
Do you have create table column's with boolean datatype?
Why boolean datatype is not possible to create a table column?
What is data modeling?
What is constraint? What are types of constraints?
Diff b/w primary key & unique key?
What are the master & detail table?
Which will fire first constraint or trigger?
Which format are you used build a sql query?
What is blob/bfile?
What is clob?
What is the use of timestamp in select statements?
Which datatype does not allows 'null' values?
Diff b/w whare,having & group by clause?
What is row fragmentation?
Can you drop all columns in a table used alter command?
Can you modify a null column to not null column, if table has some data?
What are functions there in sql?
What is lower(),upper(),& initcap()?
What are the substr() & instr()?
What are date functions?
what is the conversion functions?
what is diff b/w nvl,nvl2,&nullif()?
diff b/w rank() & dense_rank()?
what is er modeling?
what is join? Types of joins?what is outer join?
what is psudeo columns?
what is in_line view's?
what is window clause?
diff b/w exist & in?
what is sequence? Can you alter startwith clause?
can you create synonym same name of object?
diff b/w view and synonym?
Second round interview questions
can you create synonym on procedure,package,functions?
what is index? Types of indexes?
can you create index on index?
what is raise_statement? How to declate it?
what is dbms_utility?
can you use out parameter in functions?
what is pragma_autonomous_tranctions?
Birlasoft PL/SQL Interview Questions
What is the use of package
What is module overloading?
What are composite data types.
What is the use of record. Why we use record.
What is the difference b/w pl/sql record and pl/sql table.
What is collection?
Difference b/w nested tables and varrays.
What is isolation table?
What are dead locks.
What are shared locks and implicit locks.
How many types of cursors we use.
What is the ref cursor and how to send unlimited data to front end.
Syntax of sql *loader.
How to get the data from database to unix environment
How to control module over loading
TCS PL/SQL Interview Questions
What are the environments in your company?
How to know which version is currently runing in your database?
Do you have any experience in data modeling?
How to disable all triggers in a table?
How many triggers are you created?
How many triggers created on one table?
Which will fire default first statement level or row level trigger?
What is bulkcollect? And any restrictions in bulkcollect?
What is the use of limit clause in bulkcollect?
How to debugg your code?
How to trace error handling?
How to find which line error was raised?
What are the methods there in save exceptions?
What is functional based index? Write syntax?
How to update complex view?
Can you alter procedure with in package?
Is it possible to open cursor which is in package in another procrdure?
What is substr()&instr()?
Difference between case and decode?
Can you use sysdate in check constraints? If no, why?
Difference between column level constraints & table level constraints?
What is optimizer?
What is nested_loop join?
What is pivot operater?
Tell me some oracle 10g features?
What is m_view?
What is master & detail tables?
What is sqlcode and sqlerrm?
Diff b/w procedure & packages?
What are the dis_adv of packages
CSS PL/SQL Interview Questions
Tell me about your self
What is index?
How does index form internally?
What are pseudo columns?
What are exceptions? How to handle expections in PL/SQL?
Explain about exception propagation?
What is autonomous transaction?
What is trigger? Have you ever used it?
Define view
Can we update a view?(what are the conditions)?
if I have created view from two tables by taking all the columns in the table now is it possible to update that view?( ans : NO)
then I have to compulsory update that view how to do that(ans: by using instead of triggers).
What is instead of triggers?
what is syntax of case?
Difference between procedure and functions?
What is a package and what are its advantages?
What are the Sqlca structure elements?
Then asked on project for 5 to 10 min.
asked two queries
select duplicate records from a emp table?
Select Nth maximum salary from emp table?
SELECT * FROM EMP WHERE ROWID NOT IN(SELECT MIN(ROWID) FROM EMP GROUP BY EMPNO);
SELECT A.* FROM EMP A WHERE &N=(SELECT COUNT(DISTINCT(SAL)) FROM EMP B WHERE A.SAL<=B.SAL);
Why PL/SQL
Why package?
Why Triggers while you are having Constraints
Types of Triggers and Mutating Triggers
Examples for statement level and row level triggers
Bulk-fetch and bulk binding
What are the options that you use while pre-compiling a Pro*C program and why?
All about cursors
What is the need of Error Handling in PL/SQL and how will you do it
Explain Method 4 in paper
Write queries for deletion of duplicate records and nth max salary
Search and Replace in UNIX
Find syntax
Grep syntax
Copy all the fields from the result of ls –l command into different host variables and insert them into a database object
Describe materialized view
I/O redirection
Why Locks and different types of locks
Autonomous transaction
Referential Constraint
3i-infotech PL/SQL Interview Questions
Explain about yourself and it experience?
What are the environments are you worked?
You have any experience in production?
You have any experience in unix?
What is dual? It is database object?
How many column's and row's contains dual table?
Select '1'+1 from dual; what is output?
Select * from emp where comm in (null);
Comm=null; what is output?
How to count no of records in table without count?
What is height sal whthout using max()?
Select only those employee information who are earning same salary?
How to find last inserted records from table?
Select 'vik'||null||'ram' from dual? What is output?
I have table, in column data is 'su@re#sh$', now i want to my output is 'suresh'? How to retrive?
How to retrive top 3 salaries from each departments?
Can you update complex view? If no, why?
How to know oracle use my index or not?
When should rebuild one an index?
Tell me some errors?
Tell me some restrictions on cursor variables?
What is context swithcing?
What is bulk collect?
What is nullif()?
What is mutating error?
What are the module's , you are working?
Which will fire default first statement level or row level trigger?
What is bulkcollect? And any restrictions in bulkcollect?
What is the use of limit clause in bulkcollect?
How to debugg your code?
How to trace error handling?
How to find which line error was raised?
What are the methods there in save exceptions?
What is functional based index? Write syntax?
How to update complex view?
Can you alter procedure with in package?
Is it possible to open cursor which is in package in another procrdure?
What is substr()&instr()?
Difference between case and decode?
Can you use sysdate in check constraints? If no, why?
Difference between column level constraints&table level constraints?
What is optimizer?
What is nested_loop join?
What is pivot operater?
Tell me some oracle 10g features?
What is m_view?
What is master & detail tables?
What is sqlcode and sqlerrm?
Diff b/w procedure & packages?
What are the dis_adv of packages?
CSC PL/SQL Interview Questions
Tell me about your self
What is index?
How does index form internally?
What are pseudo columns?
What are exceptions? How to handle expections in PL/SQL?
Explain about exception propagation?
What is autonomous transaction?
What is trigger? Have you ever used it?
Define view
Can we update a view?(what are the conditions)?
If I have created view from two tables by taking all the columns in the table now is it possible to update that view?( ans : NO)
Then I have to compulsory update that view how to do that(ans: by using instead of triggers).
What is instead of triggers?
What is syntax of case?
Difference between procedure and functions?
What is a package and what are its advantages?
How to call procedure in Pro*C
Have you ever used dynamic Sql statements in your project (methods in Pro*C)?
How to handle exceptions in Pro*C
What are the Sqlca structure elements?
How do you handle/trap errors in Pro*C?
Then asked on project for 5 to 10 min.
Asked two queries
Select duplicate records from a emp table?
Select Nth maximum salary from emp table?
SELECT * FROM EMP WHERE ROWID NOT IN(SELECT MIN(ROWID) FROM EMP GROUP BY EMPNO);
SELECT A.* FROM EMP A WHERE &N=(SELECT COUNT(DISTINCT(SAL)) FROM EMP B WHERE A.SAL<=B.SAL);
Polaris PL/SQL Interview Questions
Tell me about yourself
What is your front end
How to pass data to java
Diff b/w procedure and function
Can we use all kind of function in function
What is trigger and trigger types
Do you know about analytical queries
About partions and pivot operator
Pivot queries involve transposing rows into columns (pivot) or columns into rows (unpivot) to generate results in crosstab format. Pivoting is a common technique, especially for reporting, and it has been possible to generate pivoted resultsets with sql for many years and oracle versions. However, the release of 11g includes explicit pivot-query support for the first time with the introduction of the new pivot and unpivot keywords. These are extensions to the select statement and we will explore the syntax and application of these new features in this article.
Pivot
We will begin with the new pivot operation. Most developers will be familiar with pivoting data: it is where multiple rows are aggregated and transposed into columns, with each column representing a different range of aggregate data. An overview of the new syntax is as follows:
What are joins
Can we use join more than one table
Diff b/w implicit and explicit
What is materialized view
I want to create a mv on another database and refresh periodically it is possible
What is tunning
What is hint
Do you know sql *loader
What is your roles and responsibility?
How to communicate to your pm?
Select count(1) from dual;,what is output?
How to delete duplicate record's from table without distinct clause?
How to retrieve second height salary from table?
Diff b/w primary key & unique key?
Diff b/w procedure & package?
Which is better procedure or package?
What is cursor?types of cursor? And diff b/w cursors?
What is exception? Types of exceptions?
Tell me some user_defined exceptions with error codes?
What is sqlcode and sqlerr?
What is ref_cursor? Type of ref_cursors and diff b/w?
How give privilege a one procedure in package?
What is %type & %rowtype? What is main use?
How to improvee performence?
What is bulk collect? What is use of limit clause in bulk collect?
What is forall?
What is merge statement? Give me syntax?
What is view? Use of view's?
What is nocopy clause?where it is used?
What are the environments are there in your company?
How to connect your database?
What are the shartcut of compile & execution of programes in sql developer tool?
Are faced any trouble in your project?
What are the module's , you are working?
Which will fire default first statement level or row level trigger?
What is bulkcollect? And any restrictions in bulkcollect?
What is the use of limit clause in bulkcollect?
How to debugg your code?
How to trace error handling?
How to find which line error was raised?
What are the methods there in save exceptions?
What is functional based index? Write syntax?
How to update complex view?
Can you alter procedure with in package?
Is it possible to open cursor which is in package in another procrdure?
What is substr()&instr()?
Difference between case and decode?
Can you use sysdate in check constraints? If no, why?
Difference between column level constraints & table level constraints?
What is optimizer?
What is nested_loop join?
What is pivot operater?
Tell me some oracle 10g features?
What is m_view?
What is master & detail tables?
What is sqlcode and sqlerrm?
Diff b/w procedure & packages?
What are the dis_adv of packages?
IBM PL/SQL Interview Questions
Tell me about your project and client
What is difference between procedure and function?
Function can have out parameter
Difference truncate and delete
Can we use where condition with truncate
Can you explain the truncate and delete with trigger
Can we use truncate and delete command to disable the referential integrity constraint
How did you export the data from database to excel file
How many types of functions in UTL_FILE package
What function you are using to load the data in UTL_FILE package
How many types of trigger
How many max triggers you will declare
What is instead of trigger?
We have two duplicate rows, how will you delete only one row
How will you display rownum?
Select column_name from table_name where rownum=10, it will display the result, (tell me reason)
Select column_name from table_name where rownum<=10, it will diplay the result
What is implicit and explicit cursor?
What is exception?
How many types of exception
Can we have more than one exception?
What are predefined exceptions?
Do you know TOO_MANY ROWS, when that exception will occur and NO_DATA FOUND
How to catch any type of exception
Can we commit in trigger
What is autonomous transaction?
What is view
Can we delete a record in view
Can we delete a record more than one table
Can we write trigger on view
You are working on oracle 10g, 10g features
Do you have use any debugging tool
Do you know global variable, difference between global variable and parameter variable
Do you know about cascading triggers
Capgemini PL/SQL Interview Questions
What is your roles and responsibility?
How to communicate to your pm?
Select count(1) from dual;,what is output?
How to delete duplicate records from table without distinct clause
How to retrieve second height salary from table?
Diff b/w primary key & unique key?
Diff b/w procedure & package?
Which is better procedure or package?
What is cursor?types of cursor? And diff b/w cursors?
What is exception? Types of exceptions?
Tell me some user_defined exceptions with error codes?
What is sqlcode and sqlerr?
What is ref_cursor? Type of ref_cursors and diff b/w?
How give privilege a one procedure in package?
What is %type & %rowtype? What is main use?
How to improvee performence?
What is bulk collect? What is use of limit clause in bulk collect?
What is forall?
What is merge statement? Give me syntax?
What is view? Use of view's?
What is nocopy clause?where it is used?
What are the environments are there in your company?
How to connect your database?
What are the shartcut of compile & execution of programes in sql developer tool?
Are faced any trouble in your project?
What are the module's , you are working?
Which will fire default first statement level or row level trigger?
What is bulkcollect? And any restrictions in bulkcollect?
What is the use of limit clause in bulkcollect?
How to debugg your code?
How to trace error handling?
How to find which line error was raised?
What are the methods there in save exceptions?
What is functional based index? Write syntax?
How to update complex view?
Can you alter procedure with in package?
Is it possible to open cursor which is in package in another procrdure?
What is substr()&instr()?
Difference between case and decode?
Can you use sysdate in check constraints? If no, why?
Difference between column level constraints & table level constraints?
What is optimizer?
What is nested_loop join?
What is pivot operater?
Tell me some oracle 10g features?
What is m_view?
What is master & detail tables?
What is sqlcode and sqlerrm?
Diff b/w procedure & packages?
What are the dis_adv of packages?
HCL PL/SQL Interview Questions
What is meant by procedures?
It is stored sub program which is used to perform some action.
What is mean by functions?
It is stored sub program which is used to compute an expression
What is the difference between procedures and functions?
What is meant by packages?
Package is an object which Is used to group the sub programs, variables ,collections ,constants ,cursors
What is meant by triggers?
Trigger is a stored procedure which will fire when ever an event occur.
What is meant by exception and what are the types of exceptions?
Exception is an error handling mechanism in pl/sql .
There are 2 types of exceptions
Pre defined.
User defined.
What is meant by cursor and how many types of cursors are there?
Cursor is a name given to a private sql area.
There are 2 types of cursors.
Implicit
Explicit.