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...
Give an example of a transaction processing system (other than a banking system) that you have interacted with, for which you had an intuitive expectation that the serial order was the commit order.
What will be an ideal response?
Access will calculate exactly what you tell it to calculate, even if you make logical errors in the calculation
Indicate whether the statement is true or false
The Quick Access Toolbar gives you one-click access to commonly executed tasks such as saving a file or undoing recent actions.
Answer the following statement true (T) or false (F)
One good method for ensuring consistent paragraph styles in all documents of the book is to do what?
What will be an ideal response?