Interview Questions

You should have recorded in your cash books all amounts you?ve actually received and payments you?ve actually made. However, the cash books may be incomplete as your bank may have put extra transactions through your account, such as:

bank fees or interest charges
direct debits (payments) and direct credits (receipts).
Doing a regular bank reconciliation will allow you to:

take into account any extra transactions your bank puts through your account, and
check and record any errors or omissions.
By regularly doing a bank reconciliation (say monthly) you can be more confident that your records contain all the information you need to prepare your income tax return and activity statements.

reconciliation- This is a statement prepared to find the reason for difference in any two balance.
eg 1)bank reconciliation is prepared to find the reason of difference between the passbook & cash book balance
2)Stock reconciliation is prepared to the reason of difference between the physical balance & book balance or to find the stock balance as on certain date.
etc

This command is used when a large processing of data has occurred. If any large amount of deletions, any modifications, or Bulk Copy into the tables has occurred, it has to update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly.

LSMW is widely used by EDI programmers. EDI Programmers connect the SAP system to Non SAP system. During this Data migration is a necessity. When data migrates from source to destination the destination code is differrent from the source code. So what LSMW does is 

* Converts the data in to batch files

* Then converts the batch files in to source code batch files 

* And then mirgates data. Standard Interfaces like BAPI or Idoc are used in this process.

A prompt box allows the user to enter input by providing a text box.

Star schema: A highly de-normalized technique. A star schema has one fact table and is associated with numerous dimensions table and depicts a star.

Snow flake schema: The normalized principles applied star schema is known as Snow flake schema. Every dimension table is associated with sub dimension table.

Differences:

- A dimension table will not have parent table in star schema, whereas snow flake schemas have one or more parent tables.

- The dimensional table itself consists of hierarchies of dimensions in star schema, where as hierarchies are split into different tables in snow flake schema. The drilling down data from top most hierarchies to the lowermost hierarchies can be done.

There are many algorithms that can be used to analyze the database to check the maintenance of all the data sets that are already present. The different types of cluster models include as follows:

- Connectivity models: these are the models that connect one cluster to another cluster. This includes the example of hierarchical clustering that is based on the distance connectivity of one model to another model. 

- Centroid models: these are the models that are used to find the clusters using the single mean vector. It includes the example of k-means algorithm.

- Distribution models: it includes the specification of the models that are statistically distributed for example multivariate normal distribution model.

- Density models: deals with the clusters that are densely connected with one another in the regions having the data space. 

- Group models: specifies the model that doesn’t provide the refined model for the output and just gives the grouping information

Node.js uses a single threaded model with event looping.

- Web browser functions are to provide the resources or information to the user when asked by them. 

- It processes the user inputs in the form of URL like https://www.google.com in the browser and allows the access to that page. 

- URL is used to identify the resources and fetch them from the server and displays it to the client. 

- It allows the user to interact with the web pages and dynamic content like surveys, forms, etc. 

- It also allows the user to navigate through the complete web page and see its source code in the HTML format. 

- It provides security to the data and the resources that are available on the web that is by using the secure methods.