Technology Questions

There are three types of constructor in C++. They are Default constructor, Parameterized constructor, Copy constructor.

Row Level Trigger :
Row Level Trigger is fired each time row is affected by Insert, Update or Delete command. If statement doesn’t affect any row, no trigger action happens.

Statement Level Trigger :
This kind of trigger fires when a SQL statement affects the rows of the table. The trigger activates and performs its activity irrespective of number of rows affected due to SQL statement.

Use the LISTCAT command.

A binary tree with n nodes has exactly n+1 null nodes

It is an MVS message that indicates the presence of a duplicate catalogue in the database. This problem can be fixed by removing one of the entries and then adding a new one.

If an error occurs in program, then only exception object is created otherwise, It will not be created. So it’s expensive to use in the program.

Oracle HTTP Server is the Web server component of Oracle Database. It is based on the Apache HTTP Server. It is robust and reliable server due to following features:

- Provide high availability infrastructure integration with Oracle Process Manager and Notification Server (OPMN), for process management, death detection and failover for Oracle HTTP Server processes.

- Provide Dynamic Monitoring Services (DMS) metrics that give runtime performance statistics for Oracle HTTP Server processes.

- Enable securing of transactions with Secure Sockets Layer (SSL) technology.

- Execute Perl scripts in the same process as the Oracle HTTP Server, or as CGI script.