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 insert record in table A and these record should update in table B by using Trigger.How to achieve this.

Saama Tech, TCS,

4 10857

What is your daily office routine?

Data Vision,

2315

which will default fire first statement level trigger or row level trigger

Cap Gemini, Data Vision,

2 8945

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

TCS,

1 3474

How did you export data from database to excel file.

TCS,

1 5695

Difference between global and parameter variables?

TCS,

2009

What is extent clause in table space?

TCS,

1 3723

What is the use of time stamp in select statement?

TCS,

1 3924

Which data type doesn't allow null data type?

TCS,

6 9583

What is window clause?

TCS,

1 4316

Can you alter start with clause?

TCS,

1 4632

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

JPMorgan Chase,

3 10649

write a query to find 4th max salary

7 8450

How global cursor can be declare with dynamic trigger ?

2268

how view used for security purposes?

Glam India,

3 5915

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do you know if a relationship is 2nf?

991

What are the various levels of constraints?

1167

Explain polymorphism in pl/sql.

1168

what is try_catch block in procedure

1804

What is posting?

1080

What is column?

1027

What is insert command in sql?

1184

What is meant by <> in sql?

1023

What do you understand by pl/sql records?

1058

How to fetch alternate records from a table?

1303

how to include comments in sql statements? : Sql dba

994

what is the syntax used for partition in tsql? : Transact sql

1058

How many row comparison operators are used while working with a subquery?

1069

What is the limitation on the block size of pl/sql?

1032

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

5237

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