| Other SQL PLSQL Interview Questions |
|| Asked @
|What is the difference between CHAR and VARCHAR2? If
VARCHAR2 serves the uses of CHAR why CHAR is still used and
not been discarded yet?
|Find out the 3rd highest salary?
|I have one Excel file with 1,50,000 Records. Now I need to
load that whole file into Oracle Database with same columns
in Excel sheet .
I need PLSQL Procedure or used by SQL PLUS
|What is Highwatermark?
|What are the different types of joins and explain them
|what is bulk bind
|Whatis yhe use of cursor ? how cursor allocate context area
for executing the sql statement?
|what is global table
|If I have a table T with 4 rows & 2 columns A & B. A has
values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL
query which can Swap the values of A & B for all records.
(Do not use a sub-query)
|what is mean by forward declaration and where we'll use it.
|why use cursors?
|In a Distributed Database System Can we execute two queries
simultaneously ? Justify ?
|For more SQL PLSQL Interview Questions Click Here |