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 10686

What is your daily office routine?

Data Vision,

2263

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

Cap Gemini, Data Vision,

2 8839

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

TCS,

1 3407

How did you export data from database to excel file.

TCS,

1 5606

Difference between global and parameter variables?

TCS,

1959

What is extent clause in table space?

TCS,

1 3625

What is the use of time stamp in select statement?

TCS,

1 3836

Which data type doesn't allow null data type?

TCS,

6 9401

What is window clause?

TCS,

1 4237

Can you alter start with clause?

TCS,

1 4560

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 10510

write a query to find 4th max salary

7 8181

How global cursor can be declare with dynamic trigger ?

2200

how view used for security purposes?

Glam India,

3 5778

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Explain the significance of the & and && operators in pl sql.

1002

How do I run a sql script?

1133

Explain the structure of pl/sql in brief.

1080

What are the main features of cursor?

1071

What is recursive join in sql?

1001

How do I debug a stored procedure?

1104

How do I create a sql script?

1093

Whis is not false in primary key?

1449

What is a primary key example?

956

What is fmtonly in sql?

1074

What is varchar used for?

1074

Can primary key be changed?

902

What are different types of statements supported by sql?

1157

What does the file extension accdb stand for?

965

Is record in pl sql?

959

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