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 10533

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 8756

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

TCS,

1 3355

How did you export data from database to excel file.

TCS,

1 5529

Difference between global and parameter variables?

TCS,

1918

What is extent clause in table space?

TCS,

1 3525

What is the use of time stamp in select statement?

TCS,

1 3767

Which data type doesn't allow null data type?

TCS,

6 9212

What is window clause?

TCS,

1 4175

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 10374

write a query to find 4th max salary

7 7953

How global cursor can be declare with dynamic trigger ?

2154

how view used for security purposes?

Glam India,

3 5640

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is duration in sql profiler trace?

1030

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2456

Is sql difficult?

1115

Explian rowid, rownum?

968

How do you update a value in sql?

997

Can we use two order by clause in query?

929

What is the difference between python and sql?

944

what is a table in a database ? : Sql dba

1000

How do you write a complex sql query?

1016

what are dynamic queries in t-sql? : Transact sql

974

What is pl sql variable?

945

What is multiple partition?

927

What is schema in sql example?

1106

What is the difference between instead of trigger and after trigger?

957

What is normalisation and its types?

961

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