A.Powerful client-side processing

B.Aggregation functions such as AVG()

C.Variables to break up complex statements

D.Flow control logic

E.Creation of column tables

A.Increase in use of mobile devices

B.Move transactional processing and analysis to separate servers for better scalability

C.Massive growth in data volume

D.Increasing connectivity of people and devices

A.The filter is applied on the result set of a query.

B.The filter is applied on the table before the query is executed.

C.It is applied before a table join is executed.

D.It reduces the result set of data.

E.It is defined on the runtime in the SQL query.

A.When you have to report on facts with matching dimensions

B.When referential integrity is assured

C.When you have to report on all dimensions to confirm if there are matching facts or not.

D.When you have to report on all posted facts

A.Wild cards* and? Are supported for text columns but not string columns

B.Non-physical columns, such as calculated columns, are not search-relevant

C.If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only one of the tables.

D.The NOT (-) operator can only be specified directly after the OR operator