Interview Questions

Q:

What CICS command are used to read a VSAM KSDS sequentially in ascending order?

Answer

READNEXT reads the next record from a browse operation for any of the three VSAM files.

Report Error

View answer Workspace Report Error Discuss

0 2063
Q:

What is the difference between primary key & unique index ?

Answer

Primary key : a relational database constraint. Primary key consists of one or more columns that uniquely identify a row in the table. For a normalized relation, there is one designated primary key.


Unique index: a physical object that stores only unique values. There can be one or more unique indexes on a table.

Report Error

View answer Workspace Report Error Discuss

0 2061
Q:

What are PL/SQL cursor exceptions?

Answer

Cursor_Already_Open,  Invalid_Cursor.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2061
Q:

What is a TCP Session?

Answer

the layer that establishes ,manages and terminates the session between two communticating devices

Report Error

View answer Workspace Report Error Discuss

0 2060
Q:

What are layer objects and what do they represent?

Answer

Layer objects are data objects which represent visual content. Layer objects are used by views to render their content. Custom layer objects can also be added to the interface to implement complex animations and other types of sophisticated visual effects.

Report Error

View answer Workspace Report Error Discuss

0 2059
Q:

What are the uses of synonyms?

Answer

- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

1 2059
Q:

Interest is usually associated with

A) doubtful accounts B) bad debts
C) accounts receivable D) notes receivable
 
Answer & Explanation Answer: D) notes receivable

Explanation:

Interest is usually associated with notes receivable.

Report Error

View Answer Report Error Discuss

Filed Under: Bank Interview
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

2 2058
Q:

What do you mean by a tablespace?

Answer

- These are the Logical Storage Units into which a database is divided.
- It is used to group together the related logical structures.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2057