Wednesday, April 21, 2010

Oracle PL/SQL Interview Questions-4

What is SQL Integrity?

How packaged procedures and functions are called from the following? a. Stored procedure or anonymous block b. an application program such a PRC *C, PRO* COBOL c. SQL *PLUS

What is SQL Deadlock?

Give the structure of the procedure ?

What is Mutating SQL Table?

What are the return values of functions SQLCODE and SQLERRM ?

The most important DDL statements in SQL are?

Operators used in SELECT statements are?

SELECT statements in SQL?

What are the PL/SQL Statements used in cursor processing ?

The SELECT INTO Statement is most often used to create backup copies of tables or for archiving records?

The Update Statement in SQL.

What is the Delete Statements in SQL?

How to sort the rows in SQL?

The IN operator may be used if you know the exact value you want to return for at least one of the columns.

how to create table with in the procedure or function?

what is overloading procedure or overloading function ?

what is HASH join?

what is SCALAR Queries?

what is the use of HASH, LIST partitions?

<> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?
 
cursor types? explain with example programs?

                                                     Next>>