Interview Questions

Q:

What type of Joins have you used?

Answer

The knowledge of Joins is a MUST for every interviewee. Most SQL programmers have used inner join and  outer join[left/right]; but the catch point here is to also mention cross join and self-join.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 2566
Q:

If I call performSelector:withObject:afterDelay: – is the object retained?

Answer

Yes the object is retained. It creates a timer that calls a selector on the current threads run loop. It may not be 100% precise time-wise as it attempts to dequeue the message from the run loop and perform the selector.

Report Error

View answer Workspace Report Error Discuss

0 2565
Q:

Which payment type can help you stick to a budget?

A) Payday loans B) Cash advances
C) Debit cards D) Credit cards
 
Answer & Explanation Answer: C) Debit cards

Explanation:

There are two payment types that will help you stick to your budget.

1. Cash
2. Debit Card

The amount in the debit card is the only amount you can spend to stay within budget.

These method work because once you spend your money, you are done. You don’t have anything else to spend.

 

Credit cards, payday loans, and cash advances are all loans on future income. When you use a credit card, there is always just a little bit more you can spend. These types do not help you budget properly. In fact, these types encourage you to spend beyond your means and be out of budget.

Report Error

View Answer Report Error Discuss

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

1 2563
Q:

What are the advantages and disadvantages of 3G?

Answer

Advantages of 3G:

- Overcrowding is relieved in existing systems with radio spectrum
- Bandwidth, security and reliability are more
- Provides interoperability among service providers
- Availability of fixed and variable rates
- Support to devices with backward compatibility with existing networks
- Always online devices – 3G uses IP connectivity which is packet based
- Rich multi media services are available

Disadvantages of 3G:

- The cost of cellular infrastructure , upgrading base stations is very high
- Needs different handsets.
- Roaming and data/voice work together has not yet been implemented
- Power consumption is high
- Requires closer base stations and are expensive
- Spectrum-license costs, network deployment costs and handset subsidies subscribers are tremendous.

Report Error

View answer Workspace Report Error Discuss

0 2563
Q:

How can you send an email message from an ASP.NET Web page?

Answer

You can use the System.Net.Mail.MailMessage and the System.Net.Mail.SmtpMail classes to send an email in your Web pages. In order to send an email through your mail server, you need to create an object of the SmtpClient class and set the server name, port, and credentials.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2561
Q:

The Accounting period cycle of NSE is

A) Monday to next Friday B) Wednesday to next Tuesday
C) Wednesday to next Wednesday D) Tuesday to next Wednesday
 
Answer & Explanation Answer: B) Wednesday to next Tuesday

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

Which command displays memory usage in linux?

A) Top B) Free
C) Buffer D) Swap
 
Answer & Explanation Answer: B) Free

Explanation:

Free command displays memory usage in linux.

Report Error

View Answer Report Error Discuss

3 2554
Q:

What is a DB2 plan?

Answer

An application plan or package is generated by the bind to define an access path. 

Report Error

View answer Workspace Report Error Discuss

0 2553