Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 8717

What is your daily office routine?

Data Vision,

1639

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

Cap Gemini, Data Vision,

2 6950

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

TCS,

1 2490

How did you export data from database to excel file.

TCS,

1 4319

Difference between global and parameter variables?

TCS,

1262

What is extent clause in table space?

TCS,

1 2478

What is the use of time stamp in select statement?

TCS,

1 2758

Which data type doesn't allow null data type?

TCS,

6 6811

What is window clause?

TCS,

1 3064

Can you alter start with clause?

TCS,

1 3508

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 7983

write a query to find 4th max salary

7 5217

How global cursor can be declare with dynamic trigger ?

1530

how view used for security purposes?

Glam India,

3 4046


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the usage of nvl function?

432


Do stored procedures prevent sql injection?

385


How do I truncate a word?

371


What problem one might face while writing log information to a data-base table in pl/sql?

405


How to convert comma separated string to array in pl/sql?

377






Why join is faster than subquery?

418


Write a query to find the names of users that begin with "um" in sql?

364


How to select 10 records from a table?

483


what is the difference between nested subquery and correlated subquery?

389


Why stored procedure is better than query?

356


How many triggers can be applied to a table?

445


What is compiled query?

355


What is difference between procedure and trigger?

349


How do you change a value in sql?

404


How to add a column ‘salary’ to a table employee_details?

423