Oracle Interview Questions

Oracle Database Questions & Answers 3

61. What constitute an ORACLE Instance ? SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process. 62. What is SGA ? The System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance. 63. What are […]

Oracle Database Questions & Answers 2

What is Network Database link ? Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition. What is Data Block ? ORACLE database’s data is […]

Oracle Questions and Answers (Main Categories)

Oracle General Question & Answers Oracle SQL/PLSQL Question & Answers Oracle Database Question & Answers Oracle Forms Builder Question & Answers Oracle Reports Builder & Answers

Oracle SQL/PLSQL Questions & Answers4

Oracle SQL/PLSQL Questions & Answers: Explain in detail use of OCI in oracle? OCI is an API that provides functions you can use to access the database server and control SQL execution. OCI supports the data types, calling conventions, syntax, and semantics of the C and C++ programming languages. You compile and link an OCI […]

Oracle SQL/PLSQL Questions & Answers3:

Oracle SQL/PLSQL Questions & Answers: Can we design one view on another view? Yes we can design one view on the other view.  What are aggregate functions in Oracle? Aggregate function are using in oracle with group by clause and with having clause. Avg, count, max, min, sum,   How can we sort out our […]

Oracle SQL/PLSQL Questions & Answers2:

Oracle SQL/PLSQL Questions & Answers: What are cursors and how many types of cursors? Cursor is a pointer variable in a memory and use for DML operations. Cursor basically is a private SQL memory area it is also use to improve the performance of the database. There are two types of cursors. 1- Implicit cursor […]

Oracle SQL/PLSQL Questions & Answers:

Oracle SQL/PLSQL Questions & Answers: What is SQL statement? SQL stands for Structured Query Language that is use for updating, deleting and inserting the  information from databases. SQL is an ANSI and ISO standard and is the de-facto standard database query language. Oracle database also support this language. What are database triggers and how many […]

Oracle Reports Builder Questions & Answers

What are the different types of reports? Tabular Master Detail Reports Form Reports Form Letter Reports Mailing Labels Reports Matrix Reports What are Anchors in reports builder? An anchor defines the actual position of an object. Anchors are used to determine the vertical and horizontal positioning of a child object relative to its parent. What […]

Oracle Forms Builder Questions & Answers

Oracle Forms Builder Questions & Answers Oracle Forms Builder Questions & Answers are coming soon…..   Other Related Questions & Answers: Oracle General Question & Answers Oracle SQL/PLSQL Question & Answers Oracle Database Question & Answers Oracle Forms Builder Question & Answers Oracle Reports Builder & Answers

Oracle Database Questions & Answers

 What are the components of Physical database structure of Oracle Database? ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files. What are the components of Logical database structure of ORACLE database? Tablespaces and the Database’s Schema Objects. What […]

Oracle General Question & Answers:

Oracle General Question & Answers:   What is data? Data is a collection of raw, facts and figures that is use in different place we can store anything in database is called data. What is database? Collection of organized data which can easily managed access, understand, and update. What is database management system? Any programming […]