ITE014 MOD 1.2 (PART 1)

What is the database model shown in the picture?

• Flat File Model
• Hierarchical Model
• Relational Model
• Network Model
• Object-Oriented Model

Extents

• the smallest logical storage unit of a database
• level of logical database storage above an extent
• protects the database in case of an instance failure
• a logical unit of database storage space allocation made up of contiguous data blocks

What is the database model shown in the picture?

• Flat File Model
• Hierarchical Model
• Relational Model
• Network Model
• Object-Oriented Model

Oracle Database stores data logically in

• Segments
• Rows
• Tablespaces
• Columns

What is the database model shown in the picture?

• Flat File Model
• Hierarchical Model
• Relational Model
• Network Model
• Object-Oriented Model

a very essential function of relational databases

• Data storage
• Control files
• Data blocks
• Data integrity

What is the database model shown in the picture?

• Flat File Model
• Hierarchical Model
• Relational Model
• Network Model
• Object-Oriented Model

Oracle Database

• ensure the consistency of the data that is stored as records
• a small binary file associated with only one database
• allocates logical space for all data in the database
• used to represent the data requirements of a business, regardless of the type of database that is used, and even in the absence of one.

a software that controls storage, organization, and retrieval of data

• Database Management System (DBMS)
• Oracle
• Control Panel
• File manager

a centralized and structured set of data stored on a computer system

• Normalization
• Information
• Data
• Database