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?

1117

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

1085

Explain commit, rollback and savepoint.

1050

What are schema-level triggers?

1148

Differentiate between % rowtype and type record.

1387

What does fetching a cursor do?

1130

What does the argument [or replace] do?

1122

what are integrity rules?

1084

What are %type and %rowtype for?

1099

What is a sql profiler?

1062

How to select 10 records from a table?

1204

How many times can we commit in a loop?

1062

What is data manipulation language?

1225

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

1080

Why does %isopen return false for an implicit cursor?

1 1530

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is sql the best database?

1018

Can you load data into multiple tables at once? : aql loader

1116

Explain aggregate functions are available there in sql?

1047

What is sql*loader and what is it used for?

1211

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1390

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

990

How do I enable sql encryption?

1066

Is sql sequential or random?

1081

What is the difference between a primary key and a clustered index?

1033

What is partition by in sql?

1124

How do I view a sql database?

1054

how can we find the number of rows in a table using mysql? : Sql dba

1121

What is trigger and stored procedure in sql?

1089

What is sql comments?

1113

Can we use ddl statements in stored procedure?

1188

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