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 10688

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 8845

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

TCS,

1 3409

How did you export data from database to excel file.

TCS,

1 5610

Difference between global and parameter variables?

TCS,

1960

What is extent clause in table space?

TCS,

1 3628

What is the use of time stamp in select statement?

TCS,

1 3840

Which data type doesn't allow null data type?

TCS,

6 9408

What is window clause?

TCS,

1 4238

Can you alter start with clause?

TCS,

1 4562

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 10517

write a query to find 4th max salary

7 8184

How global cursor can be declare with dynamic trigger ?

2202

how view used for security purposes?

Glam India,

3 5779

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What do you mean by dbms? What are its different types?

1009

Which is better cte or subquery?

1026

Can sql function call stored procedure?

1013

Are null values same as that of zero or a blank space?

1020

How do sql databases work?

989

Can procedure in package be overloaded?

1078

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1093

What are the syntax and use of the coalesce function?

1192

What is basic structure of pl sql?

1066

Is oracle and sql same?

1006

what are the different tables present in mysql? : Sql dba

980

What is meant by temporal data?

961

what are sequences

1737

Who is the owner of mysql database?

1053

What normalization means?

963

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