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 10879

What is your daily office routine?

Data Vision,

2320

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

Cap Gemini, Data Vision,

2 8971

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

TCS,

1 3492

How did you export data from database to excel file.

TCS,

1 5707

Difference between global and parameter variables?

TCS,

2020

What is extent clause in table space?

TCS,

1 3736

What is the use of time stamp in select statement?

TCS,

1 3933

Which data type doesn't allow null data type?

TCS,

6 9617

What is window clause?

TCS,

1 4331

Can you alter start with clause?

TCS,

1 4645

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 10666

write a query to find 4th max salary

7 8481

How global cursor can be declare with dynamic trigger ?

2272

how view used for security purposes?

Glam India,

3 5946

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do I tune a sql query?

1044

What does plv msg allows you to do?

1181

Difference between truncate, delete and drop commands?

1145

Explain autonomous transaction.

1223

What are the two characteristics of a primary key?

1035

Can a procedure in a package be overloaded?

1104

What is varchar data type in sql?

1142

What is the use of count (*) in sql?

1120

Which join condition can be specified using on clause?

1017

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1053

What is auto increment in sql?

1180

Can we use ddl statements in stored procedure?

1196

What is sharding in sql?

1041

what is a stored procedure? : Sql dba

1192

Define the select into statement.

1114

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