Technology Questions

- A process is an execution of a program, while a Thread is a single execution sequence within a process.

- A process can contain multiple threads. A Thread is sometimes called a lightweight process.

Answer: A, B, E

The name of an ABAP program can be between 1 and 30 characters long.

The following symbols and signs must not be used in program names:
Period (.), comma (,), space ( ), parentheses (), apostrophe (‘), inverted commas ("), equals sign (=), asterisk
(*), accented characters or German umlauts (à, é, ø, ä, ß, and so on), percentage signs (%), or underscores (_).

Use SELECT DISTINCT ..... in DB2 query

The DISTINCT keyword can be used to return only distinct (different) values.

Syntax:

     SELECT DISTINCT column1,column2

      FROM table_name;

The Asynchronous Transfer Mode or ATM is a connection technology that works by transmitting data into organized 53 bytes (small) packages through a physical environment with a high efficiency. Packing data into small cells reduces transportation delay so the speeds reached by this technology are very high; it can reach even 10 Gb per second.

We use SQLPASSTHROUGH options when we need applications to access data both in the front-end and back-end data servers with a single connection. SQL statements that cannot be executed in the solidDB front-end server are passed over to the back end. 

SQLPASSTHROUGH mode can be set as per session or per transaction. The connection between the front end and back end is made with a back-end compatible ODBC driver which is loaded dynamically in solidDB server.

• An Interpreter is a program that reads in as input a source program, along with data for the program, and translates the source program step by step.

The Java interpreter decodes each lines bytecode and runs a series of machine instructions for that bytecode. The JVM takes the byte code and generates machine code. The byte code is compiled to machine code, and the machine code is executed.

Oracle check constraint is used to ensure that before inserting the data in the database, it is validated and checked for the condition.
Example:
Below, the constraint is that the id has to be between 0 and 1000.
create table employee ( id number check (id between 0 and 1000), Name varchar(200) );

The following are the ways of initiating a CICS transaction.

1. By entering Transaction Id

2. By Start command

3. By Return Trans Id (as in pseudo - conversation)

4. By Registering Tran ID in plt so that it will be automaticaly dusring CICS start

5. By ATI (Automatic task initiation)

6.PF & PA keys as defined in PCT