Interview Questions

- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.

Marketing Research Process is a systematic method for planning and executing market research projects to inform business decisions.

The 5 Step Marketing Research Process :

1. Define the Problem or Opportunity
2. Develop Your Research Plan
3. Collect Relevant Data and Information
4. Analyze Data and Report Findings
5. Take Action.

Basically Load, Stress and Performance Testing are the same. However, Load testing is the test to check the users’ response time of number of users of any one scenario of the application whereas Performance Testing is the test to check the user response time for multiple scenario of the same application.

Payroll Transaction is nothing but the calculation of salary for a month / week / day of an individual / group of employees depends upon the attendance / variable inputs / other benefits / salary component and generate the reports for IT / Statutory / PT payments.

- A status occurs when image copy on a table needs to be taken

- The table is available only for queries and can not be updated

- COPY PENDING status can be removed by taking away the image copy or by using REPAIR utility

Use Case: A use case is a description of the process which is performed by the end user for a particular task. Use case contains a sequence of step which is performed by the end user to complete a specific task or a step by step process that describe how the application and end user interact with each other. Use case is written by the user point of view.

Use case Testing: the use case testing uses this use case to evaluate the application. So that, the tester can examines all the functionalities of the application. Use case testing cover whole application, tester performs this testing in step by step process to complete one task

Chmod() is used for changing permissions on a file.

Syntax:

Chmod(file, mode)

Mode here specifies the permissions as follows:

The first number is always zero

The second number specifies permissions for the owner

The third number specifies permissions for the owner's user group

The fourth number specifies permissions for everybody else

Possible values (to set multiple permissions, add up the following numbers)

1 = execute permissions

2 = write permissions

4 = read permissions

Example:

// everything for owner, read for owner's group

chmod("test.txt",0740);

Fractional reserve banking is the practice whereby a bank accepts deposits, makes loans or investments, but is required to hold reserves equal to only a fraction of its deposit liabilities. Fractional reserve banking is a banking system in which only a fraction of bank deposits are backed by actual cash on hand and are available for withdrawal. This is done to expand the economy by freeing up capital that can be loaned out to other parties.