Set - 10

Question 86 :

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.


Question 87 :

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


Question 88 :

What are various types of joins ?

Answer :

Equijoins, Non-equijoins, self join, outer join


Question 89 :

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.


Question 90 :

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.