Technology 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 2439
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 2436
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 2435
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 2431
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 2429
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
Q:

Name some of the common tables in CICS and their usage?

Answer

PCT (Program Control Table) - Defines each transaction containing a list of valid transaction identifiers (transid) where each transaction is paired with its matching program.


PPT (Program Processing Table) - Contains a list of valid program names and maps and whether a current version is in the CICS region or needs to be brought in as a new copy.


FCT (File Control Table) - Contains a list of files known to CICS, the dataset name and status (closed/open, enable/disabled)


TCT (Terminal Control Table)- A list of the terminals known to CICS.

Report Error

View answer Workspace Report Error Discuss

0 2424