Interview Questions

Q:

What are the difference between clustered and a non-clustered index?

Answer

- A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.


- A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2401
Q:

Which function would you use to insert a record into a database?

Answer

The dba_insert() function adds a record to a database.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2401
Q:

Data structure suitable for an application discussed in?

A) procedural design B) architectural design
C) data design D) interface design
 
Answer & Explanation Answer: C) data design

Explanation:
Report Error

View Answer Report Error Discuss

1 2399
Q:

Explain about services in Angular.js ?

Answer

In angular.js services are the singleton objects or functions that are used for carrying out specific tasks.
It holds some business logic and these function can be called as controllers, directive, filters and so on.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

4 2394
Q:

XML preserves white spaces.

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

True, the given statement that xml preserves white spaces is correct.

Report Error

View Answer Workspace Report Error Discuss

1 2392
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 2389
Q:

How can record locking be achieved in those DB2 versions which do not support it?

Answer

It can be done by setting the record length’s size to more than half of the page’s size.

Report Error

View answer Workspace Report Error Discuss

0 2389
Q:

What is the syntax to inherit from a class in C#?

Answer

When a class is derived from another class, then the members of the base class become the members of the derived class. The access modifier used while accessing members of the base class specifies the access status of the base class members inside the derived class.

The syntax to inherit a class from another class in C# is as follows:
class MyNewClass : MyBaseclass

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2386