Explore topic-wise InterviewSolutions in .

RUN VERIFY.

Run VERIFY.

They are DEFINE CLUSTER, DATA and INDEX.

They are DEFINE CLUSTER, DATA and INDEX.

IDCAMS the access method SERVICES UTILITY is ASSOCIATED with VSAM.

IDCAMS the access method services utility is associated with VSAM.

FILE STATUS PROVIDE INFORMATION about each I/O OPERATION for the file.

File Status provide information about each I/O operation for the file.

ACCESS can be SEQUENTIAL, RANDOM or DYNAMIC.

ACCESS can be SEQUENTIAL, RANDOM or DYNAMIC.

The ORGANIZATION for KSDS is INDEXED.

The ORGANIZATION for KSDS is INDEXED.

PRIMARY KEY values must be UNIQUE and alternate key values need not be unique.

Primary key values must be unique and alternate key values need not be unique.

Free space is RESERVED WITHIN the data component of a KSDS to ACCOMMODATE insertion of new RECORDS.

Free space is reserved within the data component of a KSDS to accommodate insertion of new records.

A path is a FILE that allows you to access a file by ALTERNATE INDEX. The path provides an ASSOCIATION between the AIX and the base CLUSTER.

A path is a file that allows you to access a file by alternate index. The path provides an association between the AIX and the base cluster.

An ALTERNATE INDEX is a file that ALLOWS access to a VSAM dataset by a key other than the primary ONE.

An alternate index is a file that allows access to a VSAM dataset by a key other than the primary one.

The catalog contains the NAMES of all datasets, VSAM and non-VSAM. It is USED to access these datasets.

The catalog contains the names of all datasets, VSAM and non-VSAM. It is used to access these datasets.

A cluster is the combination of the INDEX, sequence set and data portions of the DATASET. The operating system gives program access to the cluster, that is to all parts of the dataset SIMULTANEOUSLY.

A cluster is the combination of the index, sequence set and data portions of the dataset. The operating system gives program access to the cluster, that is to all parts of the dataset simultaneously.

A GROUP of CONTROL INTERVALS MAKES up a control AREA.

A group of control intervals makes up a control area.

RECORDS are STORED in the ORDER in which they are INCLUDED in the FILE.

Records are stored in the order in which they are included in the file.

A CONTROL interval is the unit of information that VSAM transfers between VIRTUAL and auxiliary STORAGE.

A control interval is the unit of information that VSAM transfers between virtual and auxiliary storage.

ENTRY SEQUENCED datasets (ESDS), Key sequenced datasets (KSDS), RELATIVE record dataset (RRDS) and Linear dataset (LDS).

Entry sequenced datasets (ESDS), Key sequenced datasets (KSDS), Relative record dataset (RRDS) and Linear dataset (LDS).

SELECT COUNT(*) FROM TAB QUERY is USED to count the NUMBER of rows in a table.

SELECT COUNT(*) FROM TAB query is used to count the number of rows in a table.

When we use ALTER STATEMENT for ADDING a NEW column then it will be added at the end of the table.

When we use ALTER statement for adding a new column then it will be added at the end of the table.

We can DECLARE a CURSOR either i WORKING Storage SECTION or in PROCEDURE Division also.

We can declare a cursor either i Working Storage Section or in Procedure Division also.

SQLCODE -818 is a TIMESTAMP MISMATCH of LOAD module and bind timestamp BUILT from DBRM.

SQLCODE -818 is a timestamp mismatch of load module and bind timestamp built from DBRM.

If a user is not AUTHORIZED to access DB2 objects, he will face SQLCODE -922.

If a user is not authorized to access DB2 objects, he will face SQLCODE -922.

At the time of deadlock or timeout you will FACE SQLCODE -911.

At the time of deadlock or timeout you will face SQLCODE -911.

When you will TRY to INSERT or update a RECORD with DUPLICATE key then you will face SQLCODE = -803.

When you will try to insert or update a record with duplicate key then you will face SQLCODE = -803.

BIND STEP CONVERTS all the SQL statements into executable form in COBOL-DB2 program.

Bind step converts all the SQL statements into executable form in COBOL-DB2 program.

REVOKE STATEMENT is used to take away the PERMISSIONS from a DATABASE.

REVOKE statement is used to take away the permissions from a Database.

Primary KEYS are OPTIONAL and we can define them in CRETAE TABLE & ALTER TABLE STATEMENTS.

Primary keys are optional and we can define them in CRETAE TABLE & ALTER TABLE statements.

A table can have only ONE PRIMARY KEY.

A table can have only one primary key.

DROP TABLE table-name is the SYNTAX to DELETE a table from DATABASE.

DROP TABLE table-name is the syntax to delete a table from database.

DELETE * FROM table-name is the SYNTAX to delete all the ROWS from a table.

DELETE * FROM table-name is the syntax to delete all the rows from a table.

CHAR DATA type maximum SIZE is of 254 BYTES.

Char data type maximum size is of 254 bytes.

VARCHAR DATA TYPE maximum size is of 4046 BYTES.

Varchar data type maximum size is of 4046 bytes.

SPUFI stands for SQL PROCESSOR Using FILE INPUT

SPUFI stands for SQL Processor Using File Input

An INDEXED is STORED in B-tree FORMAT.

An indexed is stored in B-tree format.

A PARTITIONED table SPACE MUST have a CLUSTERED INDEX.

A partitioned table space must have a clustered index.

We can have only ONE CLUSTERING INDEX for a table.

We can have only one clustering index for a table.

This STATEMENT is incorrect as SQL statements MUST be coded in Area B. 

This statement is incorrect as SQL statements must be coded in Area B. 

DB2 optimizer is USED to SELECT the ACCESS paths & to process the SQL QUERIES.

DB2 optimizer is used to select the access paths & to process the SQL queries.

DATE data TYPES take 4 bytes and default is 'YYYY-MM-DD'

DATE data types take 4 bytes and default is 'YYYY-MM-DD'

TIMESTAMP data TYPE takes 10 BYTES and DEFAULT is YYYY-MM-DD:HH:MM:SS-NNNNNN

TIMESTAMP data type takes 10 bytes and default is YYYY-MM-DD:HH:MM:SS-NNNNNN

Check the VALUE of SQLERRD to KNOW how many ROWS GOT updated after an update STATEMENT.

Check the value of SQLERRD to know how many rows got updated after an update statement.

In BIND STEP we SPECIFY the ISOLATION LEVEL.

In Bind step we specify the isolation level.

LOCKING can be APPLIED on EITHER of these − PAGE, table and table SPACE.

Locking can be applied on either of these − Page, table and table space.

System SERVICES component HANDLES DB2 startup and SHUTDOWN.

System services component handles DB2 startup and shutdown.

DATABASE SERVICES component is responsible for execution of SQL STATEMENTS and it MANAGES buffer POOL also.

Database services component is responsible for execution of SQL statements and it manages buffer pool also.

LOCKING services are provided by Locking services component which is KNOWN as Internal Resource LOCK Manager (IRLM) and manages concurrency issues and dead locks.

Locking services are provided by Locking services component which is known as Internal Resource Lock Manager (IRLM) and manages concurrency issues and dead locks.

S9(4) COMP is the PICTURE clause of a null INDICATOR.

S9(4) COMP is the picture clause of a null indicator.