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 10718

What is your daily office routine?

Data Vision,

2268

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

Cap Gemini, Data Vision,

2 8864

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 3637

What is the use of time stamp in select statement?

TCS,

1 3853

Which data type doesn't allow null data type?

TCS,

6 9437

What is window clause?

TCS,

1 4247

Can you alter start with clause?

TCS,

1 4563

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 10535

write a query to find 4th max salary

7 8227

How global cursor can be declare with dynamic trigger ?

2210

how view used for security purposes?

Glam India,

3 5793

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What do you mean by stored procedures?

1014

what is the use of set statement in tsql? : Transact sql

1011

How do you modify a trigger?

926

Can we perform dml in function?

1067

What is mutating trigger?

1019

How do you write a complex sql query?

1077

Which one is better subquery or joins?

1062

Is primary key clustered index?

949

What is data manipulation language?

1187

what are date and time data types in mysql? : Sql dba

971

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

952

Why do we use sqlite?

974

Does view store data in sql?

962

What is meant by temporal data?

969

List and explain the different types of join clauses supported in ansi-standard sql?

1356

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