IT Operations Management (ITOM) Practice Exam

Loading data from a flat file into a database is accomplished by importing. Importing takes an external file—like a CSV or Excel workbook—and creates records in a database table by mapping columns to fields, converting data types, and applying any necessary constraints as part of the process. This directly accomplishes the task of bringing external data into the database for storage and use. Linking to other databases involves establishing a live connection or pointers to external sources so you can read or query data without copying it into your own database. Data entry screens or forms are used for manual input by users, not for bulk loading external data. Building reports with a query is about retrieving and presenting data, not inserting or loading it into the database.