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 10536

What is your daily office routine?

Data Vision,

2224

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

Cap Gemini, Data Vision,

2 8757

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

TCS,

1 3356

How did you export data from database to excel file.

TCS,

1 5530

Difference between global and parameter variables?

TCS,

1918

What is extent clause in table space?

TCS,

1 3526

What is the use of time stamp in select statement?

TCS,

1 3768

Which data type doesn't allow null data type?

TCS,

6 9215

What is window clause?

TCS,

1 4177

Can you alter start with clause?

TCS,

1 4489

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 10380

write a query to find 4th max salary

7 7957

How global cursor can be declare with dynamic trigger ?

2155

how view used for security purposes?

Glam India,

3 5644

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is sql better than excel?

1073

Can we rollback delete command?

947

What are system versioned tables?

976

How does rowid help in running a query faster?

1377

How to know the last executed procedure?

1041

How do I pipe the output of one isql to another?

951

What is varchar sql?

1067

how many sql dml commands are supported by 'mysql'? : Sql dba

1068

When is the explicit cursor used ?

990

What are field types?

946

How is a process of pl/sql compiled?

1094

what are the different type of normalization? : Sql dba

978

What is the maximum number of rows in sql table?

966

What are sql objects?

1030

what is 'mysqlshow'? : Sql dba

981

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