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.