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 9975

What is your daily office routine?

Data Vision,

2017

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

Cap Gemini, Data Vision,

2 8328

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

TCS,

1 3094

How did you export data from database to excel file.

TCS,

1 5121

Difference between global and parameter variables?

TCS,

1708

What is extent clause in table space?

TCS,

1 3143

What is the use of time stamp in select statement?

TCS,

1 3441

Which data type doesn't allow null data type?

TCS,

6 8474

What is window clause?

TCS,

1 3863

Can you alter start with clause?

TCS,

1 4214

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 9936

write a query to find 4th max salary

7 7042

How global cursor can be declare with dynamic trigger ?

1982

how view used for security purposes?

Glam India,

3 5131


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is java sql drivermanager?

794


What is the difference between clustered and non-clustered index in sql?

770


Does user triggers have entry for trigger with compilation errors?

841


What is pl sql code?

800


what is bdb (berkeleydb)? : Sql dba

805


What is sql partition function?

843


What is row_number () in sql?

777


What are the types of queries in sql?

785


what is a relationship and what are they? : Sql dba

798


Explain clause in sql?

787


what is oltp (online transaction processing)? : Sql dba

774


Can you selectively load only those records that you need? : aql loader

826


what happens if null values are involved in expressions? : Sql dba

784


What is embedded sql what are its advantages?

730


What is trigger with example?

785