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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

How can triggers be used for the table auditing?

1069

Is it possible to create startup or shutdown trigger for on-schema?

1029

Explain commit, rollback and savepoint.

999

What are schema-level triggers?

1101

Differentiate between % rowtype and type record.

1301

What does fetching a cursor do?

1087

What does the argument [or replace] do?

1081

what are integrity rules?

1025

What are %type and %rowtype for?

1052

What is a sql profiler?

1023

How to select 10 records from a table?

1157

How many times can we commit in a loop?

1017

What is data manipulation language?

1187

Can you call pl/sql package functions from within a fast formula?

1039

Why does %isopen return false for an implicit cursor?

1 1453

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is sql easier than java?

1010

Explain the uses of a database trigger?

1043

how to include character strings in sql statements? : Sql dba

1071

Is a foreign key always unique?

942

Explain the purpose of %type and %rowtype data types?

928

Is sql scripting language?

1051

What is attribute indicator in pl sql?

1013

What are different types of sql commands?

1117

How to move files from one directory to another in pl sql?

1193

What is procedure in pl sql?

1043

What are the different types of dbmss?

1013

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1048

How to load data with sql*loader?

1048

Can we use having without group by in sql?

982

what is the syntax used for partition in tsql? : Transact sql

1014

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