Which one is not the output of the LOAD utility

  1. Loaded table or partition

  2. Discard file of rejected records

  3. Summary report of errors encountered

  4. Updated system catalog table stats


Correct Option: D
Explanation:

To answer this question, the user needs to be familiar with the LOAD utility in database systems.

The LOAD utility is used to load data from external files into database tables. It is commonly used for bulk inserts of large amounts of data.

Now, let's go through each option to determine which one is not an output of the LOAD utility:

A. Loaded table or partition: This is a valid output of the LOAD utility. When the LOAD utility is successful, it loads data from external files into database tables or partitions.

B. Discard file of rejected records: This is a valid output of the LOAD utility. When the LOAD utility encounters records that cannot be loaded into the target table or partition, it writes those records to a discard file.

C. Summary report of errors encountered: This is a valid output of the LOAD utility. When the LOAD utility encounters errors while loading data, it generates a summary report of those errors.

D. Updated system catalog table stats: This is not an output of the LOAD utility. The LOAD utility is used for inserting data into tables, not updating system catalog table stats. The job of updating system catalog statistics falls under the responsibility of the database management system.

Therefore, the answer is:

The Answer is: D

Find more quizzes: