Pearson VUE / PSI Exam center: +917339174555 Hire From Us: +917339173555

Top 101+ Oracle Interview Questions and Answers

Top 101+ Oracle Interview Questions and Answers

Here are the list of most frequently asked Oracle Interview Questions and Answers in technical interviews. These questions and answers are suitable for both freshers and experienced professionals at any level. The questions are for intermediate to somewhat advanced Oracle® professionals, but even if you are just a beginner or fresher you should be able to understand the answers and explanations here we give.

What are Schema Objects?

What is a Table?

What is a View?

What is an Index?

What is a Data file?

What is the difference between UNIQUE or PRIMARY KEY Constraint?

What is PL/SQL ?

What is the basic structure of PL/SQL ?

What is the difference between %ROWTYPE and TYPE RECORD ?

What is a cursor ? Why cursor is required ?

Explain the two types of cursors ?

What is Raise_application_error ?

What is the difference between a PROCEDURE and FUNCTION ?


What is Overloading of procedures ?

What is a package ? What are the advantages of package ?

What is difference between TRUNCATE and DELETE?


What is a join? Explain the different types of joins?

What is a Subquery?

What is correlated sub-query?

Difference between SUBSTR and INSTR?

Explain UNION, MINUS, UNION ALL, INTERSECT?

What are the Usages of SAVEPOINTS?

What is ROWID?

What is PRIMARY KEY, UNIQUE KEY, FOREIGN KEY?

What is ON DELETE CASCADE?

What is difference between CHAR and VARCHAR2? What is maximum SIZE allowed for each type?

How to store the results of a query into a file?

Which two statements about subqueries are true? (Choose two.)

Which three functions can be used to manipulate character, number, or date column values? (Choose three.)

Which statement about a table is true?

What will be returned from SIGN(ABS(NVL(-32,0)))?

Which functions could you use to strip leading characters from a character string. Select two.

All the operators are used in single row subquery except one

All the commands executes in iSQLplus except one

Ascript file which will be executed automatically in iSQLPlus is

A command in iSQL plus is used to give the status of old and new value of variable

All commands are used to save the changes of the transaction except one

A Clause which is used in joining two tables other than equality operator is

A Clause which is the pseudocolumn used to know the current value of the sequence

A Query which is used in top-N analysis is

An operator is used to get and display the redundant records

All the datatypes with respect to Oracle 9i is true except one

What is database?

To select records from the given row?

To check the leap year

To delete duplicate records

To keep latest single record

To select second max salary

To select nth max salary

To select nth min salary

To select top(n) max salaries

To select top(n) min salaries

To select records from particular row(the remaining rows)

to select first n rows

Explain the difference between trigger and stored procedure.

Differences between DATE and TIMESTAMP in Oracle

Create a copy of EMP table without any data?

Delete the 10th record of EMP table?

Find all the departments which have more than 3 employees?

Display the manager who is having maximum number of employees working under him?

Display the name of employees who joined on the same date?

Delete those employees who joined the company 10 years back from today?

Display those employees whose salary is ODD value?

Find out the number of employees whose salary is greater than their manager salary?

Select the count of employees in each dept where count is greater than 3?

Display name of those employees who are getting the highest salary?

What is a transaction ?

What is implicit cursor and how is it used by Oracle ?

Which of the following is not a schema object : Indexes, tables, public synonyms, triggers and packages ?

Is there a PL/SQL Engine in SQL*Plus?

Can one read/write files from PL/SQL?

How can I protect my PL/SQL source code?

Can one use dynamic SQL within PL/SQL? OR Can you use a DDL in a procedure ? How ?

What are the various types of parameter modes in a procedure ?

What are the constructs of a procedure, function or a package ?

Why Create or Replace and not Drop and recreate procedures ?

Can you pass parameters in packages ? How ?

What are the parts of a database trigger ?

What are the various types of database triggers ?

What is the advantage of a stored procedure over a database trigger ?

What are cascading triggers? What is the maximum no of cascading triggers at a time?

What are mutating triggers ?

What are constraining triggers ?

Describe Oracle database's physical and logical structure ?

Can you increase the size of a tablespace ? How ?

What is the use of Control files ?

What is the use of Data Dictionary ?

What are the states of a rollback segment ? What is the difference between partly available and needs recovery ?

What is the maximum no.of columns a table can have ?

Can you pass a parameter to a cursor ?

What are the various types of RollBack Segments ?

What are the disadvantages of SQL ?

When to create indexes ?

How can you avoid indexes ?

What is the difference between a view and a synonym ?

What is the difference between foreign key and reference key ?

What is a package cursor ?

What are snap shots and views

We Provide Best Oracle Training in Chennai at Besant Technologies with Certification & Placement Assistance.For More Details on Oracle Latest Interview books please contact 9962528293.

Besant Technologies – Chennai & Bangalore Branch Locations

Besant Technologies - Velachery Branch
Plot No. 119, No.8, 11th Main road, Vijaya nagar,
Velachery, Chennai - 600 042
Tamil Nadu, India
Landmark - Reliance Digital Opposite Street
+91-996 252 8294 / 996 252 8293

Besant Technologies - Tambaram Branch
No.2A, 1st Floor, Duraisami Reddy Street,
West Tambaram, Chennai - 600 045
Tamil Nadu, India
Landmark - Near By Passport Seva
+91-996 250 4283

Besant Technologies - OMR Branch
No. 5/318, 2nd Floor, Sri Sowdeswari Nagar,
OMR, Okkiyam Thoraipakkam, Chennai - 600 097
Tamil Nadu, India
Landmark - Behind Okkiyampet Bus Stop,
+91-887 038 4333

Besant Technologies - Porur Branch
No. 180/84, 1st Floor, Karnataka Bank Building
Trunk Road, Porur,
Chennai - 600 116
Tamilnadu, India
Land Mark: Opposite to Gopalakrishna Theatre
+91-755 022 6990

Besant Technologies - Anna Nagar Branch
Plot No:1371, 28th street kambar colony,
I Block, Anna Nagar ,
Chennai - 600 040
Tamil Nadu, India
Landmark - Behind Reliance Fresh
+91-984 025 8377

Besant Technologies - T.Nagar Branch
Old No:146/2- New No: 48,
Habibullah Road,T.Nagar,
Chennai - 600 017
Tamil Nadu, India
Landmark - Opposite to SGS Sabha
+91-887 038 4333

Besant Technologies - Thiruvanmiyur Branch
22/67, 1st Floor,
North mada street, Kamaraj Nagar
Thiruvanmiyur, Chennai 600041
Tamil Nadu, India
Landmark - Above Thiruvanmiyur ICICI Bank
+91-984 025 8377

Besant Technologies - Siruseri Branch
No. 4/76, Ambedkar Street,
OMR Road, Egatoor, Navallur,
Siruseri, Chennai 600130
Tamil Nadu, India
Landmark - Near Navallur Toll Gate, Next to Yamaha Showroom
+91-7338 810 550

Besant Technologies - Maraimalai Nagar Branch
No.37, Ground Floor,
Thiruvalluvar Salai,
Maraimalai Nagar,Chennai 603209
Tamil Nadu, India
Landmark - Near to Maraimalai Nagar Arch
+91-979 123 7373

Besant Technologies - BTM Layout Branch
No 2, Ground floor,
29th Main Road, Kuvempu Nagar,BTM Layout 2nd Coming from Silkboard, take left at AXA company signal,
Stage, Bangalore - 560 076
Karnataka, India
Landmark - Next to OI Play School
+91-762 494 1772 / 74

Besant Technologies - Marathahalli Branch
No. 43/2, 2nd Floor, VMR Arcade,
Varthur Main Road, Silver Springs Layout,
Munnekollal, Marathahalli, Bengaluru - 560037
Karnataka, India
Landmark - Near Kundalahalli Gate Signal
+91-910 812 6341

Besant Technologies - Rajaji Nagar Branch
No. 309/43, JRS Ecstasy, First Floor,
59th Cross, 3rd Block, Bashyam Circle,
Rajaji Nagar, Bangalore - 560 010
Karnataka, India
Landmark - Near Bashyam Circle
+91- 734 916 0004

Besant Technologies - Jaya Nagar Branch
No. 2nd Floor,1575,11th Main Road,
4th T-Block, Pattabhirama Nagar, Jaya Nagar,
Bangalore-560041
karnataka, India
Land Mark: Opposite to Shanthi Nursing Home
+91-733 783 7626

Besant Technologies - Kalyan Nagar Branch
No.513, 4th Cross Rd
2nd Block, HRBR Layout, Kalyan Nagar,
Bangalore-560043
karnataka, India
Land Mark: Opposite to kalayan nagar Axis Bank
+91-979 144 0888

Besant Technologies - Electronic City Branch
No. 7, 3rd Floor, Ganga Enclave,
Neeladri Road, Karuna Nagar, Doddathoguru Village,
Electronics City Phase 1, Electronic City,
Bangalore - 560100, karnataka, India
Land Mark: Adjacent to HDFC Bank and State Bank Of India
+91-782 392 2180

Besant Technologies - Indira Nagar Branch
No.54, 1st Floor,
5th Main kodihalli,
Bengaluru, Karnataka 560008, India
Landmark: Behind Leela Palace Hotel,
+91-910 812 6339

Besant Technologies - HSR Layout Branch
Plot No. 2799 & 2800, 27th Main,
1st Sector, HSR Layout,
Bengaluru, Karnataka 560102, India
+91-733 783 7626

Quick Enquiry