Interview Questions

Cursor_Already_Open,  Invalid_Cursor.

EXEC CICS READ

DATASET('FILENAME')

INTO(data-area)

RIDFLD(data-area)

KEYLENGTH(1)

GENERIC

LENGTH(WK-LEN)

END-EXEC.

MAC- Media Access Control .its a unique identifier defined for certain hardware/network adapters

Peoplesoft Database is similar to other database which is used to store data. Peoplesoft database stores data in a table format for system PeopleTools and Application tables. This is independent of the process you use to retrieve that data from PeopleSoft. Inside PeopleSoft database, only three types of tables reside inside the schema: System Catalog tables, PeopleTools tables, and Application data tables. Two of these table types, System Catalog and PeopleTools tables, can be referred to as metadata tables; users make use of Application data tables to store the data they need for their processes.

The Spring IoC is responsible for creating the objects,managing them (with dependency injection (DI)), wiring them together, configuring them, as also managing their complete lifecycle.

Primary key constraint ensures that the column(s) always has a unique value to identify the record.
Example:
Below, the primary key is created for column id with name prim_id.
create table employee ( id number NOT NULL, Name varchar(200) Constraint prim_id primary key(id) );

Amazon web services consist of a component called as Amazon S3 that acts as a input as well used as an output data store. It is used in checking the input and according to that gives the output. The input consists of the web that is stored on Amazon S3 as object and it is update frequently to make the changes in the whole architecture. It is required due to the on demand growing of the data set and to provide persistent storage.

It is virtual table which is defined as a stored procedure based on one or more tables.