Technology Questions

Recovery/error testing is testing how well a system recovers from crashes, hardware failures, or other catastrophic problems.

COMMIT statements are used to release locks which are required for that unit of work, and then permit a new unit of work. In other words, if COMMITS are not coded in the program and the program has been sent for execution, then while processing, in place of just going back to a few inserts since the nearest commit, the program has to go back to the inserts which were made during the entire run of the program. This extra process takes around twice or thrice the time taken normally.

- The process of combining data from different resources.

- The combined data is provided to the users with unified view.

- Information from different enterprise domains are integrated – known as Enterprise Information Integration.

- Useful for merging information from different technologies among enterprises.

- The sub areas of data integration are 

1. Data Warehousing.

2. Data Migration.

3. Master Data Management.

A collection just like an array is an ordered group of elements of the same type. Each elements position is determined by a unique subscript.

Index by tables:- They are similar to hash arrays that allows to search for subscript values using arbitrary numbers and strings.

They can be declared as:

TYPE type_name IS TABLE OF element_type [NOT NULL]

INDEX BY [BINARY_INTEGER | PLS_INTEGER | VARCHAR2(size_limit)];

INDEX BY key_type;

Example:

TYPE studenttyp IS TABLE OF emp%ROWTYPE

INDEX BY BINARY_INTEGER;

stud_tab studenttyp;

Nested tables:- they hold random number of elements and use sequential numbers as sub scripts.

They can be declared as:

TYPE type_name IS TABLE OF element_type [NOT NULL];

Example: TYPE employee_type IS TABLE OF NUMBER INDEX BY VARCHAR2(64);

Varrays: Holds a fixed number of elements which can be changed in run time. 

They can be declared as:

TYPE type_name IS {VARRAY | VARYING ARRAY} (size_limit) OF element_type [NOT NULL];

Example: TYPE Calendar IS VARRAY(366) OF DATE;

Amazon SQS is a message passing mechanism that is used for communication between different connectors that are connected with each other. It also acts as a communicator between various components of Amazon. It keeps all the different functional components together. This functionality helps different components to be loosely coupled, and provide an architecture that is more failure resilient system.

BDC ----> Batch Data Communication 

Methods of BDC-----> Direct Input method, Batch Input Session method, Call transaction method.

Call Transaction Method: In Call Transaction method we call the transaction in BDC program itself. If we want this program is executed by some one else then we need to expose the code to him. Call Transaction Method Works in Foreground. No Display Mode is equal to Background Processing in call transaction method. Call Transaction Method can handle only one Application at a time. In Call Transaction Method no Log File by Default. We have to design Log File by using BDCMSGCOLL. Call Transaction Method Updates the Database Asynchronously. (Note: Asynchronous updation is Faster than Synchronous)
 
Batch Session Method: On the other hand in batch session method we create a session which can be executed at any time by any authorized person without exposing the code of the program. Session Method works in Background and as well as in Foreground. Session Method can handle Multiple Applications at a time. Session Method holds Log File by Default. Session Method Updates the Database Synchronously.

Marquee tag: Marquee tag is used when we want that some text or content move in the web page whether horizontally or vertically. 

Syntax of Marquee tag: <marquee>content you want to move</marquee>

Attribute of Marquee tag are: bgcolor, direction, height, width, vspace etc.