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?

1065

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

1019

Explain commit, rollback and savepoint.

989

What are schema-level triggers?

1094

Differentiate between % rowtype and type record.

1289

What does fetching a cursor do?

1079

What does the argument [or replace] do?

1073

what are integrity rules?

1021

What are %type and %rowtype for?

1050

What is a sql profiler?

1015

How to select 10 records from a table?

1153

How many times can we commit in a loop?

1010

What is data manipulation language?

1183

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

1033

Why does %isopen return false for an implicit cursor?

1 1441

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is error ora-12154: tns:could not resolve the connect identifier specified?

1064

What type of database is cloud sql?

1092

who introduced sql?

1007

Can we create table in function?

960

how to shut down the server with 'mysqladmin'? : Sql dba

1004

Is vs as in pl sql?

982

What is cursor in pl sql with examples?

1031

What is the command used to fetch the first 5 characters of a string?

1206

what is blob? : Sql dba

1140

How many sql commands are there?

1112

Can we insert delete data in view?

944

How many types of normalization are there?

955

Difference between truncate, delete and drop commands?

1080

What are the rules to be applied to nulls whilst doing comparisons?

1321

What are the triggers associated with image items?

1034

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