Interview Questions

Q:

What is a Trigger? Explain Types of PL/SQL Triggers.

Answer

A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database. The trigger is mostly used for maintaining the integrity of the information on the database.


Syntax:


CREATE OR REPLACE TRIGGER [Trigger Name] [Before / After / Instead Of]


ON [schema].[table]


<PL/SQL subprogram>


 


Types of PL/SQL triggers : 


> Row trigger          - The trigger fires for each ROW affected.


> Statement trigger - The trigger is fired once when the condition is matched


> Before and After trigger - The BEFORE trigger run the trigger action before the insert, update or delete statement. The AFTER trigger runs the trigger action after the insert, update or delete statement is executes.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

1 2438
Q:

Why is the main() method declared static?

Answer

main() method is called by the JVM even before the instantiation of the class, hence it is declared as static.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2434
Q:

What is innovation in marketing?

Answer

Innovation is generally considered a process that brings together various novel ideas in a way that they have an impact on society. It differs from invention in that innovation refers to the use of a better and, as a result, novel idea or method, whereas invention refers more directly to the creation of the idea or method itself. Innovation differs from improvement in that innovation refers to the notion of doing something different rather than doing the same thing better.


 

Report Error

View answer Workspace Report Error Discuss

0 2433
Q:

What is PHP?

Answer

PHP: Hypertext Preprocessor is open source server-side scripting language that is widely used for web development. PHP scripts are executed on the server. PHP allows writing dynamically generated web pages efficiently and quickly. The syntax is mostly borrowed from C, Java and perl. PHP is free to download and use.


 

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2433
Q:

What is the return type of the main() method?

Answer Main() method doesn't return anything hence declared void.
Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2430
Q:

What is CICS?

Answer

Customer Information Control System (CICS) is an online transaction processing monitor from IBM that acts as an interface between the operating system and application programs to provide rapid high-volume online transaction processing.

Report Error

View answer Workspace Report Error Discuss

0 2428
Q:

How to read and write a file using javascript?

Answer

I/O operations like reading or writing a file is not possible with client-side javascript. However , this can be done by coding a Java applet that reads files for the script. 

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2428
Q:

What do you accomplish by GROUP BY ... HAVING clause?

Answer

GROUP BY partitions the selected rows on the distinct values of the column on which you group by. HAVING selects GROUPs which match the criteria specified

Report Error

View answer Workspace Report Error Discuss

0 2425