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 10699

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

Tech Mahindra,

4 10088

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 19012

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

HCL, Nyros, Oracle,

18 48219

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

Polaris,

1 7969

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

CTS,

3 17396

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

5 8607

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

iGate,

7 15072

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

6 13120

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 6767

why should required for Indexed by table in pl/sql

3 7802

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 19601

why use cursors?

Oracle,

5 13028

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

Oracle,

8 14169

what is oracle sql,pl/sql with interfaces

TCS,

2 8510

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is index example?

1043

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

1007

How do you bind variables in pl sql?

1156

Why having clause is used in sql?

1018

What is a rank in sql?

1003

Why is a trigger used?

989

Cite the differences between execution of triggers and stored procedures?

1135

Explain the types of joins in sql?

1070

What is the purpose of design view?

1072

What is sql dialect?

1172

What is use of package in pl sql?

1067

How do I run a sql query in pgadmin 4?

999

How is indexing done in search engines?

1021

What schema means?

939

How do I view tables in sql developer?

1007

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