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 9180

What is your daily office routine?

Data Vision,

1775

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

Cap Gemini, Data Vision,

2 7601

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

TCS,

1 2721

How did you export data from database to excel file.

TCS,

1 4610

Difference between global and parameter variables?

TCS,

1422

What is extent clause in table space?

TCS,

1 2734

What is the use of time stamp in select statement?

TCS,

1 3007

Which data type doesn't allow null data type?

TCS,

6 7448

What is window clause?

TCS,

1 3341

Can you alter start with clause?

TCS,

1 3771

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 9167

write a query to find 4th max salary

7 5973

How global cursor can be declare with dynamic trigger ?

1721

how view used for security purposes?

Glam India,

3 4464


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is difference between table and view?

492


What is sql resultset?

505


Can we use join in subquery?

548


What is your daily office routine?

1775


Can we rollback delete command?

487






Why we use stored procedure instead of query?

513


Can we perform dml on view?

530


How to process query result in pl/sql?

537


Name some usages of database trigger?

536


How to select random rows from a table?

495


How can I change database name in sql?

500


What is sharding in sql?

533


What is a database? Explain

571


What is the difference between delete and truncate commands?

491


what is csv? : Sql dba

545