Set - 10

Question 91 :

What are the various types of queries ??

Answer :

Normal Queries
Sub Queries
Co-related queries
Nested queries
Compound queries


Question 92 :

What is a transaction ?

Answer :

A transaction is a set of SQL statements between any two COMMIT and ROLLBACK statements.


Question 93 :

What is implicit cursor and how is it used by Oracle ?

Answer :

An implicit cursor is a cursor which is internally created by Oracle. It is created by Oracle for each individual SQL.


Question 94 :

Which of the following is not a schema object : Indexes, tables, public synonyms, triggers and packages ?

Answer :

Public synonyms


Question 95 :

What is PL/SQL?

Answer :

PL/SQL is Oracle's Procedural Language extension to SQL. The language includes object oriented programming techniques such as encapsulation, function overloading, information hiding (all but inheritance), and so, brings state-of-the-art programming to the Oracle database server and a variety of Oracle tools.