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 10716

What is your daily office routine?

Data Vision,

2266

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

Cap Gemini, Data Vision,

2 8860

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

TCS,

1 3419

How did you export data from database to excel file.

TCS,

1 5627

Difference between global and parameter variables?

TCS,

1966

What is extent clause in table space?

TCS,

1 3635

What is the use of time stamp in select statement?

TCS,

1 3853

Which data type doesn't allow null data type?

TCS,

6 9430

What is window clause?

TCS,

1 4247

Can you alter start with clause?

TCS,

1 4562

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 10534

write a query to find 4th max salary

7 8223

How global cursor can be declare with dynamic trigger ?

2210

how view used for security purposes?

Glam India,

3 5792

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

how many values can the set function of mysql take? : Sql dba

986

What is sequence in sql?

1011

Which is faster view or stored procedure?

944

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1031

What is the purpose of the partition table?

1049

What is the benefit of foreign key?

1022

what are the limitations of identity column? : Transact sql

1108

What is set serveroutput on in pl sql?

1293

What do you understand by pl/sql records?

1018

What is mdf ldf and ndf?

999

Why truncate is used in sql?

1003

How do I remove all records from a table?

1072

What is left join example?

947

Can you inner join the same table?

991

Why we use cross join?

952

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