ITEC Final Exam Questions with complete Solutions

ITEC Final Exam Questions with
complete Solutions

Database - ANSWERSa collection of organized data that allows access, retrieval, and use of data



table - ANSWERSa set of data arranged in rows and columns



records - ANSWERSa collection of fields that appear as a row in a database or table



field - ANSWERSSet to hold a specific type of data



Data type in field - ANSWERSNumerical, non-numeric, alpha-numeric



Primary Key - ANSWERSThe field selected as a unique identifier for the database.



Single user database - ANSWERSA database that supports only one user at a time.



Database hierarchy - ANSWERScharacters - data - fields - records - file - database



Database Management System - ANSWERSconsists of a group of programs that manipulate the
database and provide an interface between the database and the user or the database and
application programs.



Relational database model - ANSWERStables are linked through a common field