Interview Questions

Q:

Explain unique Constraint.

Answer

A unique constraint on a column uniquely identifies the record by a combination of one or more fields. Few unique constraint fields can have a NULL value as long as the combination of values is unique.


Example:
create table employee ( id number NOT NULL, dob DATE, professor_id NOT NULL, Name varchar(200) Constraint id_unique UNIQUE(id,dob) );

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 1858
Q:

What is meant by a dedicated computer?

A) Which is assigned one and only one task B) Which is meant for application software
C) Which is used by one person only D) Which uses one kind of software
 
Answer & Explanation Answer: A) Which is assigned one and only one task

Explanation:

What_is_meant_by_a_dedicated_computer1560341069.jpg image

It is a single computer in a network reserved for serving the needs of the network.

Report Error

View Answer Report Error Discuss

0 1857
Q:

What is a PL/SQL Record data type?

Answer

A record data type represents a data type for that row in a database table. It lets u define your own records and not your own fields.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 1857
Q:

How to assign address to the reference?

Answer

ClassName refName = new ClassName();


or


ClassName refName;


refName = new ClassName();

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 1856
Q:

What is a package?

Answer

Package is a collection of related classes and interfaces. package declaration should be first statement in a java class.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

1 1854
Q:

The balance of an account is determined by

A) Sum of credits and debits B) Difference of credits and debits
C) Product of credits and debits D) None of the above
 
Answer & Explanation Answer: B) Difference of credits and debits

Explanation:

The balance of an account is determined by the difference of credits amount and debits amount in the sheet.

Report Error

View Answer Report Error Discuss

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

0 1852
Q:

Devaluation of currency leads to

A) increase in domestic prices B) erratic fluctuations in domestic prices
C) fall in domestic prices D) no impact on domestic prices
 
Answer & Explanation Answer: A) increase in domestic prices

Explanation:
Report Error

View Answer Report Error Discuss

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

1 1851
Q:

What is Sales Order (SO)?

Answer

The Sales Order is a confirmation document sent to the customers before delivering the goods or services. 


Sales Order (SO) can be created once the quote is accepted by your prospective customer and the Purchase Order (PO) is sent by the customer for further processing.

Report Error

View answer Workspace Report Error Discuss

Subject: Marketing and Sales Exam Prep: Bank Exams , CAT
Job Role: Analyst , Bank PO

4 1851