SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

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)

5 10519

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

Tech Mahindra,

4 9935

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

Ebix, Hewitt,

11 18760

i want to display 1 to 10 numbers using one select statement.

HCL, Nyros, Oracle,

18 47674

how to debugg a procedure or package using dbms_output.put_line in plsql

Polaris,

1 7896

how can we find the select statement is indexed or not?

CTS,

3 17274

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 8487

Please let me know if UNION ALL and Natural Join does the same operation and are same...

iGate,

7 14903

With out using count() function. How to the find total number of rows in a table?

6 12938

why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.

2 6691

why should required for Indexed by table in pl/sql

3 7697

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

UST,

11 19246

why use cursors?

Oracle,

5 12854

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

Oracle,

8 13928

what is oracle sql,pl/sql with interfaces

TCS,

2 8394

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1158

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2113

How do I start sql profiler?

997

What will you get by the cursor attribute sql%notfound?

1075

What is sequence in sql?

1022

What is aggregate function in sql?

1040

What does select * from mean in sql?

3240

In a distributed database system, can we execute two queries simultaneously?

1092

What is the difference between count 1 and count (*) in a sql query?

996

What is recursive stored procedure?

1099

Which operator is used in query for pattern matching?

1089

What is a procedure in pl sql?

1211

What are keys in sql?

1000

How do I partition a table in sql?

1131

What is the difference between microsoft access and sql?

1024

For More Un-Answered { SQL PLSQL } Questions Click Here