Interview Questions

Q:

Mention 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.


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

How do you change the session time-out value?

Answer

The session time-out value is specified in the web.config file within sessionstate element.You can change the session time-out setting by changing value of timeout attribute of sessionstate element in web.config file.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET
Job Role: Software Architect

0 2287
Q:

A website main page is called

A) start page B) bookmark
C) search page D) browser page
 
Answer & Explanation Answer: A) start page

Explanation:

A website main page is called as start page or home page.

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

How can you configure Wi-Fi network and what are Wi-Fi Protocols?

Answer

Basically there are many standards of Wi-Fi in the industry but some popular of them are 802.11a, 802.11b, 802.11g/n. With the support of these Wi-Fi protocols we can communicate/interact among the devices at the speed of 5Ghz to 2.4Ghz dual band communication.

If we have Wi-Fi nic card so firstly we have to install their drivers and after installation if we have Wi-Fi access point then we can see the signal strength in the right corner below just open that and find the access point to connect, if access point is configured with the security, type the key to connect and enjoy the service.

Wi-Fi is technically referred to as the 802.11 protocol. Over time, Wi-Fi has improved, giving rise to different variations of the protocol.

802.11a – This version operates at 54Mbps. It is considered as the favorite wireless LAN protocol for IP telephony.

Report Error

View answer Workspace Report Error Discuss

0 2286
Q:

What are transaction isolation levels supported by Oracle?

Answer

Oracle supports 3 transaction isolation levels: 


- Read committed (default)


- Serializable transactions


- Read only

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

1 2285
Q:

Difference between Swing and Awt ?

Answer

AWT are heavy-weight componenets. Swings are light-weight components. Hence swing works faster than AWT.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2283
Q:

What is the difference between the functions unlink and unset?

Answer

unlink()-deletes the given file from the file system.
unset() -makes a variable undefined.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2281
Q:

What is meant by index cardinality?

Answer

The number of distinct values for a column is called index cardinality. DB2's RUNSTATS utility analyzes column value redundancy to determine whether to use a tablespace or index scan to search for data.

Report Error

View answer Workspace Report Error Discuss

0 2279