To optimize queries, use simple columns or literals as operands in a conditional expression and avoid the use of conditional expressions with ____ whenever possible.

Related MCQs

• What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 7 columns respectively?
• When creating a database, in order to optimize performance, put high-usage tables in their own ____.
• The DBMS processes queries in three phases; the first is ____.
• What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 20 rows respectively?
• Which of the following is used to get all the columns of a table ?
• Which of the following is the operation that is used if we are interested in only certain attributes or columns of a table?
• Some of the columns of a relation are at different sites is which of the following?
• For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
• A distributed database can use which of the following strategies?
• Given the functional dependencies X →W; X→Y; Y→Z and Z→PQ Which of the following doesn’t hold well?