SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Does sql*plus also have a pl/sql engine?

550

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

597

Explain the structure of pl/sql in brief.

607

What is a database event trigger?

575

Write the alter statement to enable all the triggers on the t.students table.

650

Define implicit and explicit cursors.

612

Explain ttitle and btitle.

656

Can instead of triggers be used to fire once for each statement on a view?

526

Can 2 queries be executed simultaneously in a distributed database system?

628

Show the two pl/sql cursor exceptions.

595

Explain raise_application_error.

629

Show how functions and procedures are called in a pl/sql block.

575

What operators deal with null?

593

What are character functions?

616

What are the two types of exceptions.

617


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is the difference between delete and truncate commands? : Sql dba

518


What is java sql drivermanager?

534


How delete all data from table in sql?

556


What is schema in sql?

503


How to know the last executed procedure?

579






What is difference between left and right outer join?

505


What is a schema sql?

516


What is gpt format?

495


what is offset-fetch filter in tsql? : Transact sql

522


Can a key be both primary and foreign?

496


How to combine two stored procedures in sql?

580


how to fetch alternate records from a table? : Sql dba

580


What is pl sql quora?

630


what are the advantages and disadvantages of views in a database? : Sql dba

522


How do I truncate a word?

508