Interview Questions

Q:

What is a sub query? What are its various types?

Answer

- Sub Query also termed as Nested Query or Inner Query is used to get data from multiple tables.
- A sub query is added in the where clause of the main query.

There can be two types of subqueries:
a.) Correlated sub query :
- It can reference column in a table listed in the from list of the outer query but is not as independent as a query.
b.) Non-Correlated sub query :
- Results of this sub query are submitted to the main query or parent query.
- It is independent like a query

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2199
Q:

What are encryption functions in PHP?

Answer

CRYPT(), MD5()

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2199
Q:

Can HTML 5 get the geographical position of a user?

Answer

- Yes, HTML 5 can get the location of a user with the use of Geolocation API.


- Use getCurrentPosition() method to get the user’s current position.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2196
Q:

Which of the following topologies has the highest reliability?

A) Mesh B) Ring
C) Bus D) Star
 
Answer & Explanation Answer: A) Mesh

Explanation:

In the mesh topology, each computer is connected to the other with a separate physical link in a network. It is most reliable topology as the network does not get down in case one of the nodes is failed.

Report Error

View Answer Report Error Discuss

1 2195
Q:

The interest-rate effect suggests that

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

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

0 2195
Q:

What is Payroll Journal?

Answer

A payroll journal is like a payroll register. It has salary, bonuses, commission in other words earnings, any deductions such as 401k, fsa etc, state and income taxes etc.
It shows the gross salary less any deductions "Net pay" for the period.

Report Error

View answer Workspace Report Error Discuss

0 2194
Q:

How can we know the number of days between two given dates using php?

Answer

<?php
$tomorrow = mktime(0, 0, 0, date("m") , date("d")+1, date("Y"));
$lastmonth = mktime(0, 0, 0, date("m")-1, date("d"), date("Y"));
echo ($tomorrow-$lastmonth)/86400;
?>

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2194
Q:

What is difference between HTML and HTML5?

Answer

The differences between HTML and HTML5 are:


- Document of HTML is very large as compare to the HTML5.


- Audio and Video tags are not present in HTML whereas HTML5 contains audio and video tags.


- Vector technology is not integral part of HTML whereas HTML5 Vector technology is the integral part of it.


- HTML supported by all old browsers whereas HTML5 is supported by new browser.


- In HTML web sockets are not available whereas in HTML5 Full duplex communication channel is present.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2192