Interview Questions

Fact is key performance indicator to analyze the business.From the additive values, which are used to analyse the business by using report generation. Dimension is used to analyze the fact, are the non-additive ( text format) values, Which are used to drill down reports.Without dimension there is no meaning for fact. Measure is the quantity of data we create to process.

The purpose of this question is to see if you already have some experience of working at a call center. If so, tell the interviewer about your experiences and what you learnt there. If you do not have a work experience, don’t panic, stay calm and say “I don’t have a first hand experience of working at a call center but this is what I know about them and I look forward to work for one.” 

a nonmatching index scan if ACCESSTYPE = 1

Aggregate functions in SQL are used to perform calculation on data. These functions are inbuilt in SQL and return a single value.

SUM( )

SUM function returns the sum or addition of all NOT NULL values of a column. For e.g. I have a Table employee with the fields id, name, salary and I want the sum of all salaries, I can use SUM function as shown
SELECT SUM(emp_salary) from employee;
Hence, if my column emp_salary has values 20,000, 22,000, 21,000; the output will be 63,000

AVG( )

 
AVG function returns the average of all NOT NULL values of a column. For e.g. I have a Table employee with the fields id, name, salary and I want the average of all salaries, I can use AVG function as shown
SELECT AVG(emp_salary) from employee;
Hence, if my column emp_salary has values 20,000, 22,000, 21,000; the output will be 21,000

COUNT( )

COUNT function returns the number of rows or values of a table. For e.g. I have a Table employee with the fields id, name, salary and I want the count of all rows, I can use COUNT function as shown
SELECT COUNT(*) from employee;

Max ( ) and Min ( )

MAX function returns the largest value of a column in a table. For e.g. I have a Table employee with the fields id, name, salary and I want the maximum salary of an employee, I can use MAX function as shown
SELECT MAX(emp_salary) from employee;
Hence, if my column emp_salary has values 20,000, 22,000, 21,000; the output will be 22,000

MIN function returns the smallest value of a column in a table. For e.g. I have a Table employee with the fields id, name, salary and I want the minimun salary of an employee, I can use MIN function as shown
SELECT MIN(emp_salary) from employee;
Hence, if my column emp_salary has values 20,000, 22,000, 21,000; the output will be 20,000

- The maximum data rate supported by a GSM system is 9.6 kbps.
- However there are extensions to GSM standard to improve throughput.
- GPRS is one of the extended GSM service.
- The extended standards of GSM allows theoretical data rates on the order of 114 Kbit/s, but with throughput closer to 40Kbit/s in practice.

Reply I agree with Your answer and I am so sorry you've got been disappointed. Let's find a solution to work this out. statement let's thrusting you and the person as a group working together to solve the issue.

Ribbon is the term used as a replacement to the menu bar and toolbars in the older Microsoft Office versions. Under the ribbon, file menu items and toolbar buttons were grouped according to their functionality. It made these functions much accessible on the main interface, with the most commonly used buttons being shown instantly.