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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

how to write utl file pkg in SQL

Oracle,

1 6644

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 7422

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

Oracle, TCS, Tecnics,

4 19942

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

Scope International,

4 17605

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

Scope International,

3 9888

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 10828

Write a query to get last 10 records from the table.

iNautix,

12 27186

how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?

1 4252

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

Aspire,

1 6323

IF i write before / after insert / update trigger and i do rollback what will happen?

KPIT,

5 11895

I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

3 6492

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 5442

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

Wipro,

5 9761

sql query to get zero records from a table having n no of records

CTS,

8 26181

How do we tune the code?

2 6109

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is cursor explain with example?

1027

What are reports usually used for?

1081

Which are the different case manipulation functions in sql?

1075

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4096

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1052

What does dml mean?

1041

What are the types of keys?

1061

How many triggers can be applied on a table?

985

How do I count duplicates in sql?

1175

how to use myisamchk to check or repair myisam tables? : Sql dba

1015

what is subquery? : Sql dba

1187

What is bulk collect in pl sql?

1155

Does normalization improve performance?

1101

Can we use join in subquery?

1146

what is commit? : Sql dba

1122

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