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 […]