Don't let the Lockdown slow you Down - Enroll Now and Get 3 Course at 24,999/- Only.

Explore Now!

Contact Us

Interview Questions

Home  Blogs  Interview Questions  Top 101+ Oracle Interview Questions and Answers in 2021

How can i help you today?

Stella 9 minutes ago

Top 101+ Oracle Interview Questions and Answers in 2021

1

Oracle Interview Questions and Answers

Oracle Interview Questions and Answers provided here are appropriate for both freshers and experienced candidates. By going through this
questionnaire, anyone must be able to recognize the questions and explanations provided. All these questions will surely enable you to prepare for
technical interviews and online tests which is conducted at the time of campus placement. The content of this questions includes the topics on Schema,

Data File, Overloading, Oracle Instance, Tablespace, DML, Oracle programming, Operators, Query Types, Oracle SQL functions, Oracle Data Types,
and many more.


Referring to the below question and answers, you will be able to get more knowledge on basic and advanced level concepts. Roles which can excel using
this material are Oracle Developers, Oracle Technical Consultant, Application Developer, Principal Consultant, Oracle DBA Lead and so on.

Q1. What are Schema Objects? 

Schema objects are tables, views, sequences, synonyms, indexes,databases triggers, procedures, functions, packages.

Q2. What is a Table? 

Q3. What is a View? 

Q4. What is an Index? 

Q5. What is a Data file? 

Q6. What is the difference between UNIQUE or PRIMARY KEY Constraint? 

Q7. What is PL/SQL ? 

Q8. What is the basic structure of PL/SQL ? 

Q9. What is the difference between %ROWTYPE and TYPE RECORD ? 

Q10. What is a cursor ? Why cursor is required ? 

Q11. Explain the two types of cursors ? 

Q12. What is Raise_application_error ? 

Q13. What is the difference between a PROCEDURE and FUNCTION ? 

How can i help you today?
Q14. What is Overloading of procedures ? 
Stella 9 minutes ago

Q15. What is a package ? What are the advantages of package ? 

1

Q16. What is difference between TRUNCATE and DELETE? 

Q17. What is a join? Explain the different types of joins? 

Q18. What is a Subquery? 

Q19. What is correlated sub-query? 

Q20. Difference between SUBSTR and INSTR? 

Q21. Explain UNION, MINUS, UNION ALL, INTERSECT? INTERSECT returns all commmon rows selected by both queries. 

Q22. What are the Usages of SAVEPOINTS? 

Q23. What is ROWID? 

Q24. What is PRIMARY KEY, UNIQUE KEY, FOREIGN KEY? 


Q25. What is ON DELETE CASCADE? 

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

Q27. How to store the results of a query into a file? 

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

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

Q30. Which statement about a table is true? 

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

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

Q33. All the operators are used in single row subquery except one 

Q34. All the commands executes in iSQLplus except one 

Q35. Ascript file which will be executed automatically in iSQLPlus is 

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

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

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

Q39. A Clause which is the pseudocolumn used to know the current value of the sequence 


Q40. A Query which is used in top-N analysis is How can i help you today?


Stella 9 minutes ago

Q41. An operator is used to get and display the redundant records 

1
Q42. All the datatypes with respect to Oracle 9i is true except one 

Q43. What is database? 

Q44. To select records from the given row? 

Q45. Explain the difference between trigger and stored procedure. 

Q46. Differences between DATE and TIMESTAMP in Oracle 

Q47. Create a copy of EMP table without any data? 

Q48. Delete the 10th record of EMP table? 

Q49. Find all the departments which have more than 3 employees? SELECT D.DNAME, COUNT (E.ENAME) FROM EMP E, DEPT D WHERE 

D.DEPTNO=E.DEPTNO GROUP BY DNAME HAVING COUNT (EMPNO) > 3;

Display the manager who is having maximum number of employees working under him?

Q50. Display the name of employees who joined on the same date? 

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

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

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

Q54. What is a transaction ? 

Q55. What is implicit cursor and how is it used by Oracle ? 

Q56. Which of the following is not a schema object : 

Q57. Is there a PL/SQL Engine in SQL*Plus? 

Q58. Can one read/write files from PL/SQL? 

Q59. How can I protect my PL/SQL source code? 

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

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

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

Q63. Why Create or Replace and not Drop and recreate procedures ? 

Q64. Can you pass parameters in packages ? How ? 



Q65. What are the parts of a database trigger ? How can i help you today?


Stella 9 minutes ago

Q66. What are the various types of database triggers ? 

1
Q67. What is the advantage of a stored procedure over a database trigger ? 

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

Q69. What are mutating triggers ? 

Q70. What are constraining triggers ? 

Q71. Describe Oracle database’s physical and logical structure ? 

Q72. Can you increase the size of a tablespace ? How ? 

Q73. What is the use of Control files ? 

Q74. What is the use of Data Dictionary ? 

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

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

Q77. Can you pass a parameter to a cursor ? 

 Q78. What are the various types of RollBack Segments ? 

Q79. What are the disadvantages of SQL ? 

Q80. When to create indexes ? 

Q81. How can you avoid indexes ? 

Q82. What is the difference between a view and a synonym ? 

Q83. What is the difference between foreign key and reference key ? 

Q84. What is a package cursor ? 

Q85. 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 8099 770 770.

Next 

Search
Top Categories 

How can i help you today?

Blogs (504)
Stella 9 minutes ago
General (385)

Interview Questions (90) 1

Job Opening in Bangalore (9)

Job Opening in Chennai (15)

Recent Post

IT Salary in India

Infosys System Engineer Salary 2022 in India

Capgemini Salary for Freshers

Accenture Salary for Freshers

Wipro Freshers Salary


Trending Courses

AWS Training
 g

Python Training

AngularJS Training

Artificial Intelligence

Data Science Training

DevOps Training

Machine Learning

Selenium Training

Ethical Hacking Course

Digital Marketing Training

Master Program

Big Data Masters Program

Data Science Masters Program

Cloud Masters Program

DevOps Masters Program

Software Testing Masters Program

Business Intelligence Masters Program

Full Stack Master Program

Freshers Masters Program

Watch Placed Students Review


 More videos

Related Blogs:

WordPress Interview Questions and Answers IBM WMQ Interview Questions and Answers Data Science with Python Intervie


Interview Questions 
Interview Questions 
Interview Questions

Wordpress Interview Questions and Answers Wordpress IBM WMQ Interview Questions and Answers for beginners and Data Science with Python Interview Q
Interview Questions and answers for beginners and... experts. List of frequently asked IBM... beginners and experts. List...

Students Zone Follow Us!

Blog
Internship
Tutorials
Video Reviews
Online Training Reviews
Reviews
Interview Questions
    
Online Training
Placed Students List

Company

About Us
Services
Branches
Contact Us
Careers
Corporate Training
Become an Instructor
Franchise Opportunities
Hire Talent
Privacy Policy
Cookie Policy

Terms of Use
Terms & Conditions
Refund/Cancellation Policy

Top Online Courses

AWS Online Training

DevOps Certification Training Course
Python Online Training
Selenium Online Training
Data Science Online Training

Data Science with Python Online Training

Machine Learning Online Training
Power BI Online Training
Azure Online Training
Full Stack Developer Online Training

Artificial Intelligence Online Training

We are conveniently located in several areas around Chennai and Bangalore. If you are staying or looking training in any of these areas, Please get in touch with our career counselors to find your
nearest branch.

Areas in Chennai which are nearer to us are Adambakkam, Adyar, Alandur, Arumbakkam, Ashok Nagar, Besant Nagar, Chengalpet, Chitlapakkam, Choolaimedu, Chromepet, Ekkaduthangal,
Guindy, Jafferkhanpet, K.K. Nagar, Kodambakkam, Kottivakkam, Koyambedu, Madipakkam, Mandaveli, Medavakkam, Mylapore, Nandambakkam, Nandanam, Nanganallur, Neelangarai,
Nungambakkam, Palavakkam, Palavanthangal, Pallavaram, Pallikaranai, Pammal, Perungalathur, Perungudi, Poonamallee, Porur, Pozhichalur, Saidapet, Santhome, Selaiyur, Sholinganallur,
Singaperumalkoil, St. Thomas Mount, T. Nagar, Tambaram, Teynampet, Thiruvanmiyur, Thoraipakkam, Urapakkam, Vadapalani, Valasaravakkam, Vandalur, Velachery, Virugambakkam, West
Mambalam.

PS: We assure that traveling 10 - 15mins additionally will lead you to the best training institute which is worthy of your money and career.

© 2022 BDreamz Global Solutions Private Limited. All Rights Reserved. The certification names are the trademarks of their respective owners. All trademarks are properties of their respective
owners. View Disclaimer.