Interview Questions

Q:

Define PL/SQL sequences and write syntax for a sequence

Answer

A sequence is a database object that is used to generate sequential number.


CREATE SEQUENCE seqname [increment] [minimum value][maximum value][start][cache][cycle]               Nextval and currval lets us get the next value and current value from the sequence.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2539
Q:

What is the difference between UNION and UNION ALL?

Answer

UNION selects only distinct values whereas UNION ALL selects all values and not just distinct ones

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2539
Q:

What is mesh network?

Answer

A network in which there are multiple network links between computers to provide multiple paths for data to travel.

Report Error

View answer Workspace Report Error Discuss

Subject: Network Administration
Job Role: IT Trainer

0 2538
Q:

Which describes how media and networks interact?

Answer

Media and networks are connected in such a way that the consumer receives the effective information. Media goes into different networks.

Report Error

View answer Workspace Report Error Discuss

0 2535
Q:

How do you pass a variable by value?

Answer Just like in C++, put an ampersand in front of it, like $a = &$b
Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2535
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 2531
Q:

Explain the concept of states in ASP.NET.

Answer

State is quite an innovative concept in Web development because it eliminates the drawback of losing state data due to reloading of a Web page. By using states in a Web application, you can preserve the state of the application either at the server or client end. The state of a Web application helps you to store the runtime changes that have been made to the Web application. For example, as already described earlier, a change in the data source of the Web application might be initiated by a user when he/she selects and saves some products in the shopping cart.

If you are not using states, these changes are discarded and are not saved. You may think that the whole concept of storing states is optional. However, under certain circumstances, using states with applications is imperative. For example, it is necessary to store states for Web applications, such as an e-commerce shopping site or an Intranet site of a company, to keep track of the requests of the users for the items they have selected on the shopping site or the days requested for vacation on the Intranet site.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2531
Q:

The income and substitution effects account for

A) the upward sloping curve B) the downward sloping curve
C) Both A & B D) None of the above
 
Answer & Explanation Answer: B) the downward sloping curve

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 2528