SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

What are database links used for?

1046

What are the uses of merge?

1167

How is a process of pl/sql compiled?

1160

Is it possible to create the following trigger: before or after update trigger for each row?

1286

Differentiate between syntax and runtime errors.

1183

What is an intersect?

1102

What is the difference between alter trigger and drop trigger statements?

1107

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1013

How would you convert date into julian date format?

1004

How does rowid help in running a query faster?

1416

Can triggers stop a dml statement from executing on a table?

1093

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1024

In what condition is it good to disable a trigger?

1010

When is a declare statement required?

1138

What are the uses of sysdate and user keywords?

1103

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the use of partition by in sql?

994

What is #table in sql?

1098

what is user defined functions? : Sql dba

1031

What is numeric function sql?

1059

Does oracle roll back the transaction on an error?

1013

What do you understand by pl/sql records?

1018

Does truncate release storage space?

1075

In pl/sql, what is bulk binding, and when/how would it help performance?

994

how is exception handling handled in mysql? : Sql dba

1080

Is ms sql traffic encrypted?

922

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4280

What are synonyms in sql?

971

What is a column in a table?

1124

How do sql triggers work?

1040

What is difference between stored function and application function?

1199

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