Highlighted text? Practice this concept. Highlighted passages and figures open related questions.
Practice related questions (1)Progress & bookmarks
Current section
2-1-5 Data Storage
p. 266
Practice this section 1 linked exam question with default filters
Progress
Not marked complete
Related questions in this lesson 1
Original INSERT statement syntax1p. 266
2-1-5 Data Storage
Data storage is the process of inserting data in a table. (While it should be included in data manipulation, it is explained in data definition as preparation for using the database.) There are two methods of storing data in a table. Generally, method 1) is suitable for small amounts of data while method 2) is more efficient for large amounts of data.
- 1) Storing data in units of tuples (i.e., records)
INSERT statement is used for storing data in units of tuples (i.e., records).
ex05: Store tuple (K11, English I) in the “Subject” table.
- 2) Using data storage program
A data storage program is prepared in the host language system beforehand, or the data storage program that is available in the utility program is used.
Section progress
Original chapter exercises
Original chapter exercises →New FE Textbook Vol.1 · IT Fundamentals · First Edition, April 2015