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?

1126

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

1131

Explain the structure of pl/sql in brief.

1135

What is a database event trigger?

1205

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

1168

Define implicit and explicit cursors.

1202

Explain ttitle and btitle.

1159

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

1004

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

1186

Show the two pl/sql cursor exceptions.

1251

Explain raise_application_error.

1141

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

1178

What operators deal with null?

1152

What are character functions?

1136

What are the two types of exceptions.

1217

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is an exception in PL/SQL? What are the two types of exceptions?

1391

what is difference between delete and truncate commands? : Sql dba

1165

What is the difference between cross join and natural join?

1064

Does pl sql work in mysql?

1032

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2549

Does view contain data?

1077

How does stored procedure reduce network traffic?

1062

What is sql procedures and functions?

1070

Are subqueries faster than joins?

1072

What is a primary key sql?

1087

Does normalization improve performance?

1099

What is a sql trace file?

1081

Can primary key be changed?

950

What are the methods of filing?

985

What are the constraints available in sql?

1083

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