Question 91 :
What are the various types of queries ??
Question 92 :
What is a transaction ?
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 ?
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 ?
Question 95 :
What is PL/SQL?
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.