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 10719

What is your daily office routine?

Data Vision,

2271

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

Cap Gemini, Data Vision,

2 8867

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

TCS,

1 3421

How did you export data from database to excel file.

TCS,

1 5629

Difference between global and parameter variables?

TCS,

1968

What is extent clause in table space?

TCS,

1 3638

What is the use of time stamp in select statement?

TCS,

1 3853

Which data type doesn't allow null data type?

TCS,

6 9446

What is window clause?

TCS,

1 4249

Can you alter start with clause?

TCS,

1 4567

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 10537

write a query to find 4th max salary

7 8232

How global cursor can be declare with dynamic trigger ?

2210

how view used for security purposes?

Glam India,

3 5795

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what are rollup and cube in t-sql? : Transact sql

1099

How is indexing done in search engines?

982

How many primary keys can a table have?

1009

What is the difference between sum and count in sql?

986

Is it possible to update views?

959

how is myisam table stored? : Sql dba

1056

What is the reports view in oracle sql developer?

994

Does pl/sql support create command?

1110

How can you fetch first 5 characters of the string?

1018

How to check if a column is nullable before setting to nullable?

1128

What are its different types of dbms?

1007

Whis is not false in primary key?

1457

What does an inner join do?

1183

How do you write a complex sql query?

1082

What does data normalization mean?

968

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