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?

1080

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

1089

Explain the structure of pl/sql in brief.

1095

What is a database event trigger?

1159

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

1125

Define implicit and explicit cursors.

1144

Explain ttitle and btitle.

1118

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

962

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

1141

Show the two pl/sql cursor exceptions.

1197

Explain raise_application_error.

1096

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

1127

What operators deal with null?

1107

What are character functions?

1087

What are the two types of exceptions.

1168

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are different types of queries in sql?

1121

What is linq to sql?

1132

What is cascade in sql?

962

Why do we use sqlite?

975

Can we use loop in sql?

968

What is an inner join sql?

1028

what is a field in a database ? : Sql dba

1056

Who is the owner of mysql database?

1057

What is raid? How does it help storage of databases?

1087

What is sql performance tuning?

918

What do you understand by pl/sql cursors?

1087

Can cursors be part of a trigger body?

1641

Which is faster joins or subqueries?

991

Why do we use triggers?

967

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2571

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