1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is AUTH_ID and AUTH_USER in pl/sql ?

INDUS,

1678

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

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

CTS,

1 1796

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

Societe Generale,

1 2876

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

Fintellix,

1 2176

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 7368

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 2414

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 1951

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

Fintellix,

1 2261

Whis is not false in primary key?

Fintellix,

966

What is Histogram?

NIIT,

1093

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 2192

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 1625

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

 1051

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

 920

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is difference between pl and sql?

526

How do I view output in sql developer?

566

Explain aggregate functions are available there in sql?

525

Explain the the update statement in sql?

562

What are the sql aggregate functions?

598




What is data types in sql?

527

How to create an array in pl/sql?

566

What is left join in postgresql?

529

what is cursor. write example of it. What are the attributes of cursor.

736

Why is normalization important?

528

what is a composite primary key ? : Sql dba

572

What is coalesce sql?

509

What is clustered index in sql?

580

How to prepare for oracle pl sql certification?

562

explain access control lists. : Sql dba

542

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