T) Explain the differences between api & utility mode?
Answer 1: When u load the data into a table in Utility mode all the constraints are disabled & then data is loaded which leads to faster access. During API Mode constraints will be enabled so that the access will be slow. Answer 2: API & UTILITY are two possible interfaces to connect to the db’s to perform certain user specific tasks. These interfaces allow the user to access or use certain functions (provided by the db vendor) to perform operation on db’s. The functionality of each of these interfaces depends on db’s. API has more flexibility but often considered as a slower process as compared to UTILITY mode. Well the trade off is their performance and usage. Answer 3: API mode is more diagnostic purpose for retrieving data from db means like selecting particular fields like retrieving the data relatively according to the constraints. Whenever we select API we will get the option of ablocal expression (ab_exp) every time where ever reco...