Oracle database consists of logical and physical database structures. Describe each of the following concepts and state to which structure they belong:
(a) Schema;
(b) Data block;
(c) Redo log file.
(a) Schema - Schema is a collection of database objects (e.g. tables, views, sequences, etc.), owned by a database user and has the same name as the name of the owner. Schema is a logical database structure.
(b) A data block is the smallest unit of storage that oracle can use or allocate. A data block size should be a multiple of the operating system's block size. A data block is a logical data structure.
(c) A Redo log file is a physical data structure that is used to record all changes made to the data for recovery purposes. Every Oracle database has a set of two or more Redo log files.
You might also like to view...
Value after increase is calculated by using this formula:
A) base * percent for new value. B) base percent + percent of increase. C) base / percent for new value. D) base percent * percent of increase.
Most laptops and portable systems come with ______ ports to support Fast or Gigabit Ethernet
a. DB-9 b. BNC c. RJ-45 d. RJ-11