For each of the cache modifications that we could perform, select whether it will increase, decrease, have no effect, or have an unknown effect on the parameter. • An unknown effect means that it could either decrease or increase the parameter in question. • No effect also includes marginal or very little effect • When answering for multilevel caching, answer based on the caching system as a whole. Improvement Increase Cache Size (C) Increase Associativity(K) Increase Block Size(b) Use Multilevel Caching Hit Rate [Select] [Select] [Select] [Select] Cache Access Time [Select] [Select] [Select] [Select] < < Average Memory Access Time [Select] [Select] [Select] [Select] < <

Find the location of the sales department using SQL. EMP Table:   Field                            ------------------------------- -------- ------------------------------------------------------------------------ EMPNO                                                ENAME                                                   JOB                                                                  MGR                                                     HIREDATE                      SAL                            COMM                        DEPTNO                                                                                               DEPT Table: Field           DEPTNO                                       DNAME                                        LOC

Please summarise data input field selection criteria. What conditions would allow breaking these rules?

What is the best way to track the information requests?

If there is a problem at your place of work, please list and briefly explain the five steps you plan to take to fix it.\

where 'Where clause' used ?

List the location name and location ID where the location ID is 1400, 1500, or 1800. Use INoperator. Do not use OR operator.

Oracle provides a function for calculating the number of days between your birthday and the current date.

Please detail the processes involved in converting and switching over the data.

When should single quotation marks be used in a WHERE clause?