Oracle Interview Question and Answers

31. What are the differences between stored procedures and triggers?
  A stored procedures are compiled collection of programs or SQL statements that live in the database. A stored procedure can access and modify data present in many tables. Also a stored procedure is not associated with any particular database object. But triggers are event-driven special procedures which are attached to a specific database object.
32. What must be installed with ODBC on the client in order for it to work with Oracle?
  SQLNET and PROTOCOL (for example: TCPIP adapter) layers of the transport programs.
33. What are the different file extensions that are created by oracle reports?
  Rep file and Rdf file.
34. what is trigger?
  Triggers are special kind of stored procedures that get executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table.
35. Explain the difference between a data block, an extent and a segment?
  A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database object.
Page 7 of 12 123456 789101112