Interview Questions

Q:

Define "Correlated Subqueries" ?

Answer

In a SQL Database, a 'correlated subquery' is a kind of sub query yet connected subquery is dependent on another query for a value that is returned. In case of execution, the sub query is executed first and afterwards the correlated query will be executed.

Report Error

View answer Workspace Report Error Discuss

6 2544
Q:

What is factoring?

Answer

Selling the rights to the amounts owing by debtors to a finance company for an agreed amount (which is less than the figure at which they are recorded in the accounting books because the finance company needs to be paid for providing the service).

Report Error

View answer Workspace Report Error Discuss

1 2542
Q:

Why is code optimization important?

Answer

Optimized code tends to run faster and make more efficient use of the system’s resources. Optimized codes are also less susceptible to errors and take lesser space in memory and in file size.

Report Error

View answer Workspace Report Error Discuss

0 2541
Q:

Explain the difference among the EXEC LINK, EXEC XCTL and Cobol II static call statements in CICS?

Answer

- Use a COBOL II CALL statement to invoke a subprogram. This method is transparent to CICS, which sees only the one load module. 


- EXEC LINK is similar to a call; it invokes a separate CICS program and ends with a RETURN to the invoking program


- EXEC XCTL which transfers control to another CICS program and does not get control 


back. 


COBOL II allows for static calls which are more efficient than the LINK instruction which establishes a new run-unit. 

Report Error

View answer Workspace Report Error Discuss

0 2538
Q:

What is a Session?

Answer

A session is a logical object created by the PHP engine to allow you to preserve data across subsequent HTTP requests. Sessions are commonly used to store temporary data to allow multiple PHP pages to offer a complete functional transaction for the same visitor.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2537
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 2536
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 2532
Q:

What is the difference between using copy() and move() function in php file uploading?

Answer

Copy() makes a copy of the file. It returns TRUE on success. It can copy from any source to destination. Move simply Moves the file to destination if the file is valid. While move can move the uploaded file from temp server location to any destination on the server. If filename is a valid upload file, but cannot be moved for some reason, no action will occur.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2530