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 10509

What is your daily office routine?

Data Vision,

2216

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

Cap Gemini, Data Vision,

2 8740

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

TCS,

1 3340

How did you export data from database to excel file.

TCS,

1 5521

Difference between global and parameter variables?

TCS,

1906

What is extent clause in table space?

TCS,

1 3503

What is the use of time stamp in select statement?

TCS,

1 3745

Which data type doesn't allow null data type?

TCS,

6 9175

What is window clause?

TCS,

1 4166

Can you alter start with clause?

TCS,

1 4474

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 10360

write a query to find 4th max salary

7 7899

How global cursor can be declare with dynamic trigger ?

2146

how view used for security purposes?

Glam India,

3 5613

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do we use distinct statement? What is its use?

976

What is bulk collect in pl sql?

1019

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

1047

What is field delimiter?

989

Is sql a scripting language?

923

What are the different ddl commands in sql?

1065

What is a call statement? Explain with an example.

951

How do I remove sql plus from windows 10?

1023

Is sql pronounced sequel or sql?

1212

What are the 3 types of behavioral triggers?

1182

What are the different parts of a package?

1041

What are sql triggers used for?

956

What are functions in sql?

899

What is record data type?

858

Explain the difference between drop and truncate commands in sql?

962

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