Oracle Interview Questions – Part 22

Q.What is PL/SQL? PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching. Q.What are the components of OEM? (for DBA) Oracle Enterprise Manager (OEM) has the following components: . Management Server (OMS): Middle tier server that handles communication with the intelligent agents. The OEM […]

Oracle Interview Questions – Part 21

Q.What is the difference between foreign key and reference key ? Foreign key is the key i.e. attribute which refers to another table primary key. Reference key is the primary key of table referred by another table. Q.What are the advantages of Oracle ? Portability : Oracle is ported to more platforms than any of […]

Oracle Interview Questions – Part 20

Q.Can Check constraint be used for self referential integrity? How? Yes. In the CHECK condition for a column of a table, we can reference some other column of the same table and thus enforce self referential integrity. Q.What are the min. extents allocated to a rollback extent? Two Q.What is the significance of the & […]

Oracle Interview Questions – Part 19

Q.What is the difference between boiler plat images and image items? Boiler plate Images are static images (Either vector or bit map) that you import from the file system or database to use a graphical elements in your form, such as company logos and maps. Image items are special types of interface controls that store […]

Oracle Interview Questions – Part 18

Q.How can a cross product be created? By selecting the cross products tool and drawing a new group surrounding the base group of the cross products. Q.What is a display item? Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the […]

Oracle Interview Questions – Part 17

Q.What is Ove? rloading of procedures? The Same procedure name is repeated with parameters of different datatypes and parameters in different positions, varying number of parameters is called overloading of procedures. e.g. DBMS_OUTPUT put_line Q.What is the Oracle Intelligent Agent? (for DBA) The Oracle Intelligent Agent (OIA) is an autonomous process that needs to run […]

Oracle Interview Questions – Part 16

Q.What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves? Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events. Q.What tuning indicators can one use? (for DBA) The following high-level tuning […]

Oracle Interview Questions – Part 15

Q.What is Execution Plan? The combinations of the steps the optimizer chooses to execute a statement is called an execution plan. Q.Can one resize tablespaces and data files? (for DBA) One can manually increase or decrease the size of a datafile from Oracle 7.2 using the command. ALTER DATABASE DATAFILE ‘filename2′ RESIZE 100M; Because you […]

Oracle Interview Questions – Part 12

Q.What are OPEN_FORM,CALL_FORM,NEW_FORM? diff? CALL_FORM : It calls the other form. but parent remains active, when called form completes the operation , it releases lock and control goes back to the calling form. When you call a form, Oracle Forms issues a savepoint for the called form. If the CLEAR_FORM function causes a rollback when […]

Oracle Interview Questions – Part 10

Q.What are the OOPS concepts in Oracle? Oracle does implement the OOPS concepts. The best example is the Property Classes. We can categorize the properties by setting the visual attributes and then attach the property classes for the objects. OOPS supports the concepts of objects and classes and we can consider the property classes as […]