FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATABASE ADMINISTRATION AND SECURITY

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A(n) ____ is a logical storage area in Oracle.
A
audit log
B
datafile
C
schema
D
tablespace
Explanation: 

Detailed explanation-1: -A segment is a space allocated for a specific logical storage structure within a tablespace.

Detailed explanation-2: -Logical Storage Hierarchy At the finest level of granularity, Oracle Database stores data in data blocks. One logical data block corresponds to a specific number of bytes of physical disk space, for example, 2 KB. Data blocks are the smallest units of storage that Oracle Database can use or allocate.

Detailed explanation-3: -Logical storage refers to the storage resources provided by Data ONTAP that are not tied to a physical resource.

Detailed explanation-4: -A LUN is the identifier name for a logical unit of storage. A unit can be based on a volume, partition, RAID set or other storage entity. A LUN provides a logical abstraction layer between the physical drive and the applications that access data on that drive.

Detailed explanation-5: -Logical structures are created and recognized by the Oracle database server and are not known to the operating system. The primary logical structure in a database, a tablespace, contains physical files.

There is 1 question to complete.