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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

What is AUTH_ID and AUTH_USER in pl/sql ?

INDUS,

2180

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

ICICI,

4 4842

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

CTS,

1 2654

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

Societe Generale,

1 3608

1. Which is an aggregate function? a. Union b. like c. max d. Rank

Fintellix,

1 3025

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

Fintellix,

2 8679

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

Fintellix,

1 3130

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

Fintellix,

1 2705

7. Where would you look for errors from the database design?

Fintellix,

1 3021

Whis is not false in primary key?

Fintellix,

1450

What is Histogram?

NIIT,

1554

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

IBM, Saama Tech,

1 3071

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from ; except this you can't use another select statement. You can use no of variables as per requirement.

1 2494

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1578

What are local and global Indexes and where they are useful.

1435

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do I order by ascending in sql?

1003

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1121

Explain the commit statement.

1151

In pl/sql, what is bulk binding, and when/how would it help performance?

987

what are the performance and scalability characteristics of mysql? : Sql dba

994

How do I trace sql profiler?

967

What is an exception in pl/sql?

1075

What is a constraint? Tell me about its various levels.

1153

What is the difference between pl and sql?

1089

How do you exit in sql?

1104

In what condition is it good to disable a trigger?

1003

What is normalization in a database?

1150

What are all the common sql functions?

1009

What are the ddl commands?

1005

How many types of indexes are there in sql?

977

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