Interview Questions

Q:

What is the difference between primary key & unique index ?

Answer

Primary key : a relational database constraint. Primary key consists of one or more columns that uniquely identify a row in the table. For a normalized relation, there is one designated primary key.


Unique index: a physical object that stores only unique values. There can be one or more unique indexes on a table.

Report Error

View answer Workspace Report Error Discuss

0 2305
Q:

How do we Tune the BO Reports for Performance Improvement?

Answer

We can tune the report by using index awarness in universe

Report Error

View answer Workspace Report Error Discuss

2 2305
Q:

Explain how a web application works.

Answer

A web application resides in the server and serves the client’s requests over internet. The client access the web page using browser from his machine. When a client makes a request, it receives the result in the form of HTML which are interpreted and displayed by the browser.


A web application on the server side runs under the management of Microsoft Internet Information Services (IIS). IIS passes the request received from client to the application. The application returns the requested result in the form of HTML to IIS, which in turn, sends the result to the client.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET
Job Role: Software Architect

0 2304
Q:

What command would you type in at a command prompt to view the IP address of the remote computer?

Answer

Ping


Netstat

Report Error

View answer Workspace Report Error Discuss

0 2303
Q:

Define Budgetary Control ?

Answer

Budgetary Control is establishment of budgets and the continuous comparison of actual results with the planned results. It computes the variances and after that management takes necessary actions to maintain favorable variations, through revision of the budgets.

Report Error

View answer Workspace Report Error Discuss

Subject: Bank Interview Exam Prep: Bank Exams , CAT
Job Role: Bank Clerk

2 2302
Q:

Why are commercial advertisements made?

A) To convince the viewer to buy a product B) To confuse the viewer about the different products in market
C) To dissuade the viewer from buying a product D) To highlight the flaws of a product
 
Answer & Explanation Answer: A) To convince the viewer to buy a product

Explanation:

Commercial advertisements are created for the purpose of raising the awareness of the public on a company's products or services.

 

* It is very important for a business to have its goods and services known to the public.

 

* It can greatly boost its sales by attracting more csutomers which in effect helps a company grow and become successful.

Report Error

View Answer Report Error Discuss

Filed Under: Advertising and Media
Exam Prep: AIEEE
Job Role: Analyst

0 2301
Q:

Difference between transparent tables and pooled tables

Answer

Transparent tables: Transparent tables in the dictionary has a one-to-one relation with the table in database. Its structure corresponds to single database field. Table in the database has the same name as in the dictionary. Transparent table holds application data.



Pooled tables: Pooled tables in the dictionary has a many-to-one relation with the table in database. Table in the database has the different name as in the dictionary. Pooled table are stored in table pool at the database level.

Report Error

View answer Workspace Report Error Discuss

Subject: ABAP

0 2301
Q:

Oracle SQL developer is an

Answer

Oracle SQL developer is an Oracle Database IDE.

Report Error

View answer Workspace Report Error Discuss

0 2294