PL/SQL Interview Questions and Answers

0 votes

Q: Can The Size Of The Parameter Passed To The Procedure Be Restricted In The Procedure Definition?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: What Does The Replace Option Indicates In The Procedure Definition?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Explain what Is A Procedure? Can It Be Stored In The Database?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Give The Basic Block Structure Of A Subprogram ?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

+1 vote

Q: Explain what Is The Difference Between The Code Syntax Of An Anonymous Block And Named Subprogram Block?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Explain what Is The Basic Difference Between Procedure And Function?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Explain what are The Two Different Types Of Subprograms In Pl/sql?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Explain what Is An Anonymous Block?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Explain what Is A Subprogram? Explain what are Its Advantages?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Which Column In The User.triggers Data Dictionary View Shows That The Trigger Is A Pl/sql Trigger?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Write The Alter Statement To Enable All The Triggers On The T.students Table ?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Explain what are Conditional Predicates?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

+1 vote

Q: Is It Possible To Include An Insert Statement On The Same Table To Which The Trigger Is Assigned?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Can Instead Of Triggers Be Used To Fire Once For Each Statement On A View?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Is It Possible To Define An Exception Within A Trigger?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: What Does The Base_object_type Column Shows In The User.triggers Data Dictionary View?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Is It Possible To Create Startup Or Shutdown Trigger For On-schema?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Can Cursors Be Part Of A Trigger Body?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Can A Select Statement Fire A Trigger?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Is It Possible To Pass Parameters To Triggers?

asked Mar 18, 2021 in PL/SQL by sharadyadav1986

0 votes

Q: Does User-triggers Have Entry For Triggers With Compilation Errors?

asked Mar 15, 2021 in PL/SQL by Robindeniel

0 votes

Q: How Can You View The Errors Encountered In A Trigger?

asked Mar 15, 2021 in PL/SQL by Robindeniel

0 votes

Q: Does A User_objects View Have An Entry For A Trigger?

asked Mar 15, 2021 in PL/SQL by Robindeniel

0 votes

Q: Are Ddl Triggers Fired For Ddl Statements Within A Pl/sql Code Executed Using The Dbms.sql Package?

asked Mar 15, 2021 in PL/SQL by Robindeniel

0 votes

Q: Do Triggers Have Restrictions On The Usage Of Large Datatypes, Such As Long And Long Raw?

asked Mar 15, 2021 in PL/SQL by Robindeniel

0 votes

Q: Explain what Is The Difference Between Alter Trigger And Drop Trigger Statements?

asked Mar 15, 2021 in PL/SQL by Robindeniel

0 votes

Q: Can A Commit Statement Be Executed As Part Of A Trigger?

asked Mar 15, 2021 in PL/SQL by Robindeniel

0 votes

Q: Can A View Be Mutating? If Yes, Then How?

asked Mar 15, 2021 in PL/SQL by Robindeniel

0 votes

Q: Can Triggers Stop A Dml Statement From Executing On A Table?

asked Mar 15, 2021 in PL/SQL by Robindeniel

0 votes

Q: Explain what Is The Meaning Of Disabling A Trigger?

asked Mar 15, 2021 in PL/SQL by Robindeniel

Page:

1
2
3
4
5
6
next »

...