SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is AUTH_ID and AUTH_USER in pl/sql ?

INDUS,

851

----> 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 1268

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

CTS,

1 729




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

Societe Generale,

1 1553

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

Fintellix,

1 951

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,

1 1765

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 1116

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 818




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

Fintellix,

1 1114

Whis is not false in primary key?

Fintellix,

337

What is Histogram?

NIIT,

425

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 364

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.

382

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

238

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

251


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

What are the uses of merge?

1


Show how functions and procedures are called in a pl/sql block.

3


table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2240


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1


Which data dictionary views have the information on the triggers that are available in the database?

1






How can you view the errors encountered in a trigger?

1


How can we debug in PL/SQL?

7


what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1


What is Materialized View? In What Scenario we Use Materialized View?

6982


Explain ttitle and btitle.

1


Explain the uses of database trigger.

1


Whis is not false in primary key?

337


What packages(if any) has oracle provided for use by developers?

3965


How would you reference column values before and after you have inserted and deleted triggers?

1


Could you please provide oca (oracle 10g) dumps for my certification ?

3525