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?

994

What are the uses of merge?

1121

How is a process of pl/sql compiled?

1087

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

1241

Differentiate between syntax and runtime errors.

1122

What is an intersect?

1047

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

1044

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

961

How would you convert date into julian date format?

949

How does rowid help in running a query faster?

1371

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

1029

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

972

In what condition is it good to disable a trigger?

972

When is a declare statement required?

1083

What are the uses of sysdate and user keywords?

1054

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is a field in a database ? : Sql dba

991

What are the different types of database management systems?

952

What is the difference between python and sql?

940

what is sql? : Sql dba

973

What are tuples in sql?

1064

explain the advantages and disadvantages of stored procedure? : Sql dba

960

Can procedure in package be overloaded?

1031

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2415

What is the basic structure of an sql?

1034

What is an alias command?

1007

Is sql better than access?

965

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

1029

Write a sql query to find the names of employees that begin with ‘a’?

954

what is text? : Sql dba

1010

Does a join table need a primary key?

906

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