Explain The Difference Between Condition & Filter?

⟩ Explain the difference between condition & filter?

Conditions: these retrievals the data based on the condition (universe level)Filter: it brings the data and filter; performance will be slow (report level)

Filters - are used to restrict the number of rows in the output.

Conditions - It wont reduce the Number of Rows, but you can show up data based on some validations.

For Eg: select cust_id from customer where cust_name like 'A%'

Filter is Cust_name like 'A%'.

Condition is also applied at report level.

Is this answer helpful?
0 Yes | 0 No

177 views

JIT (Just-In-Time) inventory control is an approach to inventory control, which stipulates that materials should arrive just, as they are needed, in the production process. Which of the following would generally not be associated with a successful JIT program, for the purpose of inventory control? a) Well-organized receiving and handling of materials purchased from suppliers b) Strong management commitment c) Suppliers located in diverse and distant locations d) High quality of materials purchased from suppliers e) Dependable and long-lasting relationships with suppliers and customers.

Identify the sequence of different steps in controlling I. Measurement of performance. II. Comparison of actual and standard. III. Analysis of causes of deviation. IV. Actual performance. V. Corrective action plan. a) (III), (IV), (V), (I), (II) b) (II), (III), (IV), (V), (I) c) (I), (II), (IV), (III), (V) d) (IV), (I), (II), (III), (V) e) (V), (IV), (III), (II), (I).

Immoral management not only ignores ethical concerns, but also actively opposes ethical behavior. Organizations with immoral management is/are characterized by I. Total concern for company profits only. II. Laws are regarded as hurdles to be removed. III. Less inclination to minimize expenditure. a) Only (I) above b) Only (II) above c) Both (I) and (II) above d) Both (I) and (III) above e) All (I), (II) and (III) above.

The behavioral approach of management thoughts can be classified into I. Bureaucratic management. II. Group influences. III. Hawthorne studies. IV. Contingency theory. a) Both (I) and (II) above b) Both (I) and (III) above c) Both (II) and (III) above d) (I), (II) and (III) above e) (II), (III) and (IV) above.

Two factor theory of motivation provides useful insights into the relationship between individual and situational or hygiene factors. Which of the following is a hygiene factor? a) Achievement b) Interpersonal relations c) Recognition d) Challenging work e) Increased responsibility.

The fact that 70-80 percent of a manager's time is taken up by his interactions with others, highlights the need for effective communication for successful management. Which of the following strategies is not likely to improve communication effectiveness? a) Avoiding non-verbal cues b) Using simple, unambiguous language c) Using active listening techniques d) Using appropriate and consistent nonverbal cues e) Using the feedback loop in the communication process.

Using the BCG matrix requires considering which of the following factors? a) Types of risk associated with product development b) Threats that economic conditions can create in future c) Social factors d) Market shares and growth of markets in which products are selling e) Political pressures.

By studying the various approaches to management analysis, we can understand the concept of management and have a better understanding of managerial functions. Which approach to management emphasizes managing people by understanding their individual psychological needs? a) Empirical approach b) Decision theory approach c) Management science approach d) Interpersonal behavior approach e) Contingency approach

Tell me which of the following would not be an accurate depiction of the differences between strategic and tactical planning? a) Strategic planning is developed mainly by upper-level management and tactical planning is generally developed by lower-level management b) Facts for strategic planning are generally easier to gather than facts for tactical planning c) Strategic plans generally contain less details than tactical plans d) Strategic plans generally cover a longer period of time than tactical plans e) Managers who are engaged in the development of strategic plans tend to work in more uncertainty than those managers engaged in the development of tactical plans.

Proctor & Gamble (P&G) makes fourteen different laundry soap products and completely dominates the laundry detergent market. Through constant changes in packaging, it is trying to influence the perception of customers that its products are unique. Which of the following generic strategies is P&G using? a) Cost leadership b) Differentiation c) Focus d) Globalization e) Niche strategy.

Question and Answer:

Home Business Development Officer