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

What is the use of CSS sprites?

Answer

- A web page with large number of images takes a longer time to load. This is because each image separately sends out a http request.


- The concept of CSS sprite helps in reducing this loading time for a web page by combining various small images into one image. This reduces the numbers of http request and hence the loading time.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2443
Q:

Which input type defines a slider control?

A) type B) source
C) aside D) body
 
Answer & Explanation Answer: A) type

Explanation:

The input type attribute TYPE defines the slider control.

Report Error

View Answer Report Error Discuss

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

1 2442
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 2440
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 2439
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 2436
Q:

What is the advantage of using ADO?

Answer

ADO or Active X Data objects, allows developers to create applications that can interoperate well with other data application services.

Report Error

View answer Workspace Report Error Discuss

0 2433
Q:

Why an app on iOS device behaves differently when running in foreground than in background?

Answer

An application behaves differently when running in foreground than in background because of the limitation of resources on iOS devices.

Report Error

View answer Workspace Report Error Discuss

1 2432