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 2464
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 2461
Q:

We can modify an existing Company from

A) Company Info > Alter B) Gateway of Tally > Modify Company
C) Company Info > Alter Company D) All of the above
 
Answer & Explanation Answer: A) Company Info > Alter

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer

1 2459
Q:

Difference between transparent tables and pooled tables

Answer

Transparent tables: Transparent tables in the dictionary has a one-to-one relation with the table in database. Its structure corresponds to single database field. Table in the database has the same name as in the dictionary. Transparent table holds application data.



Pooled tables: Pooled tables in the dictionary has a many-to-one relation with the table in database. Table in the database has the different name as in the dictionary. Pooled table are stored in table pool at the database level.

Report Error

View answer Workspace Report Error Discuss

Subject: ABAP

0 2459
Q:

The interest-rate effect suggests that

A) an increase in the price level will increase the demand for money, reduce interest rates, and decrease consumption and investment spending B) an increase in the price level will increase the demand for money, increase interest rates, and decrease consumption and investment spending
C) a decrease in the supply of money will increase interest rates and reduce interest-sensitive consumption and investment spending D) an increase in the price level will decrease the demand for money, reduce interest rates, and increase consumption and investment spending
 
Answer & Explanation Answer: B) an increase in the price level will increase the demand for money, increase interest rates, and decrease consumption and investment spending

Explanation:

The interest-rate effect suggests that an increase in the price level will increase the demand for money, increase interest rates, and decrease consumption and investment spending.

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 2457
Q:

HTML 5 provides drag and drop facility. How do you make an image draggable?

Answer

To make an image draggable, the draggable attribute is set to true:


<img draggable="true">

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2456
Q:

Can a class be declared as protected?

Answer A class can't be declared as protected. only methods can be declared as protected.
Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2452
Q:

What major challenges and problems did you face? How did you handle them?

Answer

As a manager, the tough decisions I make involve layoffs. Before making those hard decisions, I always think particularly about what is best for my employees and the business. While I do not relish making those kinds of decisions, I do not shy away from this part of my job. Two years ago, I had to let some employees go due to the monetary climate. This was a tough decision that was ultimately necessary for the good of the organization and everyone working for the company.

Report Error

View answer Workspace Report Error Discuss

Subject: Communication

7 2448