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.

1186

What is an intersect?

1102

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

1109

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?

1095

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?

1011

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 Difference Between Unique and Primary Key Constraints?

1105

How is use pl and sql?

1059

what is the difference between truncate and drop statements? : Sql dba

1124

how do you login to mysql using unix shell? : Sql dba

1079

What does over partition by mean in sql?

978

Why schema is used in sql?

1047

How do I run a pl sql program?

1128

What is join view in sql?

944

What is a natural join?

1070

How do I restart sql?

972

Why indexing is needed?

983

What is example of database?

1056

how to use myisamchk to check or repair myisam tables? : Sql dba

970

What are the possible values that can be stored in a boolean data field?

1000

how to get a list of indexes of an existing table? : Sql dba

958

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