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 10495

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

Tech Mahindra,

4 9900

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 18700

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

HCL, Nyros, Oracle,

18 47600

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

Polaris,

1 7885

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

CTS,

3 17251

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

5 8457

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

iGate,

7 14865

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

6 12908

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 6680

why should required for Indexed by table in pl/sql

3 7679

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 19194

why use cursors?

Oracle,

5 12831

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

Oracle,

8 13890

what is oracle sql,pl/sql with interfaces

TCS,

2 8368

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is transaction control language (tcl)?

1130

where are cookies actually stored on the hard disk? : Sql dba

1026

Explain raise_application_error.

1088

Is there any restriction on the use of union in embedded sql?

1152

Can a view be mutating? If yes, then how?

1021

how to create a new table in mysql? : Sql dba

983

How do I filter in sql profiler?

990

What is sqlca in db2?

948

How do I view a view in sql?

947

Define SQL and state the differences between SQL and other conventional programming Languages?

1206

What is the difference between a database and a relational database?

1094

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1035

What are joins in sql?

1041

Is sqlite thread safe?

1040

What is java sql package?

1088

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