Interview Questions

An index is a object which is used to improve performance during retrieval of records.

CREATE [UNIQUE] INDEX index_name 

ON employee[emp_id, emp_name,dept_id]

[COMPUTE STATISTICS]

The UNIQUE keyword is used when combined values of the index should be unique.

The COMPUTE STATISTICS during the creation of index optimizes the plan of execution of the SQL statement and improves performance.

Executing more than one program simultaniously.(i.e at time)

Ex:

Windows media player  is a program

Internet explorer(IE) is another program executing both the programs  at a time is called multi tasking.

The C++ programming technique allows defining user defined datatypes through structure. The

syntax to declare structure is as follows:

struct student

{

char name[100]

char address[250]

};

It depends on the type of business that demands a cloud setup. Suppose if the subscription on a public cloud for an application that is to be deployed on OS images is proving to be more costly then to buy some new datacenters and maintain them. Then obviously the a private cloud has to be setup instead of a public cloud. This public clouds follow utility billing methodology as electricity bill for example.

Dashboards are real-time business intelligence interfaces. They allow a huge amount of data to be read in a single interface in order to analyse the success or failure of the business or project in question

Managerial Accounting is also called as Management accounting or Cost accounting. It is the process of identifying, measuring, analyzing, interpreting, and communicating information to managers of an organization. Then that managers use the provisions of accounting information in order to better inform themselves before they decide matters within their organizations, which aids their management and performance of control functions.