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?

1079

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.

1093

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?

1140

Show the two pl/sql cursor exceptions.

1194

Explain raise_application_error.

1092

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.

1167

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are sql data types?

1024

What are database links used for?

1046

Is not equal in sql?

1010

what are aggregate and scalar functions? : Sql dba

1057

Can we alter stored procedure?

987

how to enter numeric values as hex numbers? : Sql dba

1064

Can sql developer connect to db2?

1047

What are the basic sql commands?

1091

What is plpgsql language?

1063

What is foreign key in sql with example?

933

what is union, minus and interact commands? : Sql dba

1185

what are enums used for in mysql? : Sql dba

1170

How do I find duplicates in two columns?

1167

How do I add a database to sql?

1125

What is rollback?

1112

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