SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What are database links used for?

580

What are the uses of merge?

708

How is a process of pl/sql compiled?

584

Is it possible to create the following trigger: before or after update trigger for each row?

710

Differentiate between syntax and runtime errors.

626

What is an intersect?

641

What is the difference between alter trigger and drop trigger statements?

592

Is it possible to include an insert statement on the same table to which the trigger is assigned?

549

How would you convert date into julian date format?

578

How does rowid help in running a query faster?

955

Can triggers stop a dml statement from executing on a table?

603

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

587

In what condition is it good to disable a trigger?

541

When is a declare statement required?

657

What are the uses of sysdate and user keywords?

609


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How many clustered indexes can be created on a table?

577


What is multiple columns?

562


what does it mean to have quoted_identifier on? : Sql dba

657


What are the types of index in sql?

524


Are stored procedures faster than queries?

512






Why is the cursor important?

521


What type of join is sql join?

516


What are stuff and replace function?

561


What does closing a cursor do?

752


What is embedded sql in db2?

499


Is pl sql still used?

498


How to write a query to show the details of a student from students table whose

531


How is pl sql different from sql?

525


Does google use sql?

500


What is row_number () in sql?

529