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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Does sql*plus also have a pl/sql engine?

1039

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1040

Explain the structure of pl/sql in brief.

1044

What is a database event trigger?

1086

Write the alter statement to enable all the triggers on the t.students table.

1069

Define implicit and explicit cursors.

1076

Explain ttitle and btitle.

1058

Can instead of triggers be used to fire once for each statement on a view?

897

Can 2 queries be executed simultaneously in a distributed database system?

1084

Show the two pl/sql cursor exceptions.

1110

Explain raise_application_error.

1044

Show how functions and procedures are called in a pl/sql block.

1043

What operators deal with null?

1031

What are character functions?

1043

What are the two types of exceptions.

1108

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3518

What is the difference between clustered and non-clustered index in sql?

959

What is data manipulation language?

1137

what are the type of locks ? : Sql dba

901

Can we create view in stored procedure?

910

What is flag in sql?

985

What is the difference between execution of triggers and stored procedures?

1053

What is an escape character in sql?

983

What is partition in sql query?

950

What is dcl in sql?

907

What are reports usually used for?

969

Is sql sequential or random?

983

What is percent sign in sql?

1215

Can we call procedure in select statement?

976

Can delete statement be rollbacked?

933

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