Technical Sample Questions : C |  C++ |  Oracle |  Java | Unix |  Operating Systems |  Data Structure

Oracle Sample Questions ›› Oracle Interview Questions

Technical Sample Questions

Oracle Sample Questions : Oracle Interview Questions

101. What are the types of Notation ?

     Answer: Position, Named, Mixed and Restrictions.

102. What all important parameters of the init.ora are supposed to be increased if you want to increase the SGA size ?

     Answer: In our case, db_block_buffers was changed from 60 to 1000 (std values are 60, 550 & 3500) shared_pool_size was changed from 3.5MB to 9MB (std values are 3.5, 5 & 9MB) open_cursors was changed from 200 to 300 (std values are 200 & 300) db_block_size was changed from 2048 (2K) to 4096 (4K) {at the time of database creation}. The initial SGA was around 4MB when the server RAM was 32MB and The new SGA was around 13MB when the server RAM was increased to 128MB.

103. .If I have an execute privilege on a procedure in another users schema, can I execute his procedure even though I do not have privileges on the tables within the procedure ?

     Answer: Yes

104. What are various types of joins ?

     Answer: Types of joins are:

     • Equijoins
     • Non-equijoins
     • self join
     • outer join

105. What is a package cursor ?

     Answer: A package cursor is a cursor which you declare in the package specification without an SQL statement.The SQL statement for the cursor is attached dynamically at runtime from calling procedures.

106. If you insert a row in a table, then create another table and then say Rollback.In this case will the row be inserted ?

     Answer: Yes.Because Create table is a DDL which commits automatically as soon as it is executed.The DDL commits the transaction even if the create statement fails internally (eg table already exists error) and not syntactically.