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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

What are indexes, and what are the different types?

3 1241

Explain the concept of normalization.

3 1137

What is a CTE (Common Table Expression), and how is it different from a subquery?

3 1095

What are triggers, and when would you use them?

3 1314

Compare SQL and PL/SQL.

3 794

Do you know the basic structure of PL/SQL?

3 1591

What Is a Trigger? How Do You Use It?

3 1467

What data types does pl/SQL have?

3 1284

Explain the PL/SQL compilation process.

3 1295

Tell me what a package consists of.

3 1229

What are the benefits of using PL/SQL packages?

3 1427

Do you understand the meaning of exception handling?

3 1064

Give me some examples of predefined exceptions.

3 1957

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1099

how do you tune the slow running queries in oracle db , explain the methodology

2072

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

957

Is a view faster than a stored procedure?

903

what is a trigger in mysql? Define different types of trigger. : Sql dba

1012

What is sql procedures and functions?

956

What is set transaction?

990

What is trigger types in sql?

945

What is over () in sql?

894

What is procedure and function?

924

What is difference between pl and sql?

994

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1161

Can we create a trigger on view?

844

What are sql indexes?

938

Does sql profiler affect performance?

942

How can you fetch first 5 characters of the string?

948

explain the advantages and disadvantages of stored procedure? : Sql dba

957

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