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?

1001

What are the uses of merge?

1123

How is a process of pl/sql compiled?

1094

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

1251

Differentiate between syntax and runtime errors.

1129

What is an intersect?

1054

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

1052

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

967

How would you convert date into julian date format?

953

How does rowid help in running a query faster?

1377

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

1037

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

980

In what condition is it good to disable a trigger?

975

When is a declare statement required?

1091

What are the uses of sysdate and user keywords?

1060

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

how would you get the current date in mysql? : Sql dba

926

What are different joins used in sql?

1015

Does a join table need a primary key?

908

What are the set operators in sql?

1036

Can you upgrade sql express to full sql?

1008

What do you understand by exception handling in pl/sql?

978

what is the command line end user interface - mysql? : Sql dba

932

What is the most restrictive isolation level? : Transact sql

1037

How to read xml file in oracle pl sql?

868

What is rtm in testing?

1052

What are pl sql data types?

963

what is a constraint? Tell me about its various levels. : Sql dba

945

What are the sql aggregate functions?

1070

what is 'mysqlimport'? : Sql dba

984

What is date functions?

973

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