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?

1074

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

1085

Explain the structure of pl/sql in brief.

1080

What is a database event trigger?

1153

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

1123

Define implicit and explicit cursors.

1136

Explain ttitle and btitle.

1116

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

958

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

1138

Show the two pl/sql cursor exceptions.

1183

Explain raise_application_error.

1087

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

1116

What operators deal with null?

1097

What are character functions?

1079

What are the two types of exceptions.

1156

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Are left and right joins the same?

1072

how to dump a table to a file with 'mysqldump'? : Sql dba

1035

How do you update a sql procedure?

1019

Is inner join faster than left join?

1185

What are different types of queries in sql?

1114

Which table is left in join?

973

How do you truncate?

902

What is schema in sql?

941

How do I truncate a sql log file?

1062

Where is sql database stored?

977

Can we use delete in merge statement?

1033

How do I partition a table in sql?

1121

What are the various restrictions imposed on view in terms of dml?

961

how would concatenate strings in mysql? : Sql dba

1080

Why we use joins in sql?

975

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