SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What are instead of triggers?

595

What is the meaning of disabling a trigger?

619

What is the difference between database trigger and stored procedure?

527

difference between anonymous blocks and sub-programs.

598

Explain the uses of control file.

582

How can the performance of a trigger be improved?

566

How can you view the errors encountered in a trigger?

518

Explain autonomous transaction.

614

Can a view be mutating? If yes, then how?

553

Explain mutating table error.

619

Can cursors be part of a trigger body?

1084

What is the importance of sqlcode and sqlerrm?

819

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

594

Explain spool.

652

Differentiate between sga and pga.

639


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

explain the difference between bool, tinyint and bit. : Sql dba

501


Can variables be used in sql statements?

531


Explain the components of sql?

567


Is record in oracle pl sql?

507


How to add new employee details in an employee_details table with the following details

617






What is time based sql injection?

466


Can a table contain multiple foreign key’s?

542


what is sql in mysql? : Sql dba

544


What is the file extension for sql database?

495


How to select all records from the table?

581


Is grant a ddl statement?

434


Which are the different character-manipulation functions in sql?

525


How many triggers can be applied to a table?

577


What is offset in sql query?

565


What is foreign key sql?

526