A database index is a data structure that improves the speed of operations in a table. Indices can be created using one or more columns, providing the basis for both rapid random lookups and efficient ordering of access to records. The disk space required to store the index is typically less than the storage of the table (since indices usually contain only the key-fields according to which the table is to be arranged, and excludes all the other details in the table), yielding the possibility to store indices into memory from tables that would not fit into it. In a relational databasean index is a copy of part of a table. Some databases extend the power of indexing by allowing indices to be created on functions or expressions. For example, an index could be created on upper(last_name), which would only store the uppercase versions of the last_name field in the index. Another option sometimes supported is the use of "filtered" indices, where index entries are created only for those records that satisfy some conditional expression. A further aspect of flexibility is to permit indexing on user-defined functions, as well as expressions formed from an assortment of built-in functions.

To sort a result, use an ORDER BY clause.
The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if any).
ORDER BY [col1],[col2],.[coln]; Tells DBMS according to what columns it should sort the result. If two rows will have the same value in col1 it will try to sort them according to col2 and so on.
GROUP BY [col1],[col2],.[coln]; Tells DBMS to group (aggregate) results with same value of column col1. You can use COUNT(col1), SUM(col1), AVG(col1) with it, if you want to count all items in group, sum all values or view average.

 NO

How empowered are employees? How much of the company's money can your people (including the ones with single-digit pay grades) spend on their own recognizance to satisfy a customer or address a workprocess issue?

Be honest. The interviewer wants to know if they can keep you happy. It's important to know if you're willing to make some sacrifices to get your career on the right track. Your degree of motivation is an important selection criteria for you and them.

motivation is recognizing the inner needs, urges & beliefs of people and fulfilling those needs in order to satisfy the person........ it motivates the person to perform better......
there are some very famous theories of motivation like maslow's need hierarchy, mcgregor theory, X & Y theory etc......... Maslow's need hierarchy is the most famous one..... i just give you a brief about that:

Every person has five types of needs......

physiological needs
psychological needs(safety needs)
social needs
esteem needs(achieving status in society)
self recognition needs(A sense of achievement)

one has to identify these needs of people, and by fulfilling them...... motivation comes....