Question 1

Each ____ belongs to one schema object.

Accepted Answer

Segments are the schema objects in a database, such as tables and indexes, and each segment belongs to one schema object.

Question 2

____ contain the names and locations of all the datafiles and redo log files.

Accepted Answer

Control files contain the names and locations of all datafiles and redo log files. Redo log files contain a record of changes made to the database, redo log groups are collections of redo log files, and archive log files are copies of redo log files that have been archived for backup and recovery purposes.

Question 3

You can look at the ____ parts of an Oracle database within the operating system

Accepted Answer

The physical parts of an Oracle database can be viewed within the operating system. These include datafiles, control files, redo logs, and archived redo logs, which are all stored in the file system of the operating system. Logical and metadata parts of the database are not directly viewable in the operating system. The server component of the database is a separate software process and is not a part of the database files themselves.

Question 4

Each index has one index segment.

Accepted Answer

Each index can have multiple index segments, which can be spread across different physical storage locations. These segments are used to store different portions of the index, and each segment can be independently accessed by the database system.

Question 5

The ____ is made up of database files,control files,and redo log files.

Accepted Answer

The database consists of multiple components including database files, control files, and redo log files. Tablespace and datafile are subsets of the database, and an instance is the collection of memory and background processes used to access and manage the database.

Question 6

The ____ is made up of the memory (SGA)and the background processes.

Accepted Answer

The instance is made up of the memory (SGA) and the background processes. The database consists of physical files (datafiles) stored on disk and logical structures (tablespaces) used to organize the data.

Question 7

The freelist is the same as the free space in a datafile.

Accepted Answer

The freelist is a mechanism used in databases to keep track of available space for inserting new records, whereas free space in a datafile refers to the unallocated space within the file that is not currently being used to store data.

Question 8

A(n)____ is a contiguous group of data blocks that are assigned to a segment.

Accepted Answer

A segment is composed of multiple extents. A contiguous group of data blocks that are assigned to a segment is called an extent. Therefore, the best choice is D. A table is a logical database object that stores data in rows and columns, a tablespace is a logical storage container for segments, and a schema object is a collection of database objects (such as tables, views, etc.) that are associated with a particular schema. These choices are not the best fit for the given statement.

Question 9

A(n)____ is the smallest of the logical units.

Accepted Answer

The smallest logical unit in a database is a database block which is used to store and retrieve data. A segment is a set of database blocks allocated for a specific object, an extent is a set of contiguous database blocks used to store specific types of data, and a schema object is a logical structure used to organize and define database objects. Therefore, the best choice is B) database block.

Question 10

You may only perform one task per ALTER TABLESPACE command.

Accepted Answer

The ALTER TABLESPACE command is used to modify the storage characteristics of a tablespace in a database. However, it can only be used to perform one task at a time. For example, you cannot use a single ALTER TABLESPACE command to add data files and resize existing ones at the same time. Each task must be performed separately using its own ALTER TABLESPACE command.

Question 11

____ contain redo entries that record changes to the database to allow recovery of changed data.

Accepted Answer

Redo log files contain redo entries that record changes to the database. These redo logs enable recovery of changed data by rolling forward changes made to the database. The other options (B, C, and D) are not specifically related to redo entries and recovery of changed data.

Question 12

The extent management mode can be changed using the ALTER TABLESPACE command.

Accepted Answer

The answer of The extent management mode can be changed...

Question 13

The biggest issue with using locally managed tablespaces is one of performance.

Accepted Answer

Locally managed tablespaces are generally considered more efficient and have better performance compared to dictionary-managed tablespaces because they reduce contention for the data dictionary and improve space management.

Question 14

Index segments are allowed in temporary tablespaces.

Accepted Answer

The answer of Index segments are allowed in temporary tablespaces....

Question 15

Dropping a temporary tablespace is the same as dropping a permanent tablespace.

Accepted Answer

The answer of Dropping a temporary tablespace is the same...

Question 16

A ____ is a physical file on the computer.

Accepted Answer

A datafile is a physical file on the computer that stores data in a database. Metadata is information about the structure and characteristics of the data, a table is a logical structure that organizes data in rows and columns, and a tablespace is a logical storage unit made up of one or more datafiles.

Question 17

In Oracle 10g,segments are created automatically when they are needed.

Accepted Answer

Oracle 10g automatically creates segments when they are needed, such as when a new table or index is created.

Question 18

A(n)____ is the largest logical object.

Accepted Answer

A tablespace is the largest logical object in many database management systems, serving as a logical container for segments like tables, indexes, and other database objects. It groups related logical structures together.

Question 19

The primary purpose of a read-only tablespace is to make large amounts of static data available to the database without having to slow down the database backup and recovery or the need for logging and checkpointing.

Accepted Answer

A read-only tablespace allows for fast access to large amounts of static data while reducing the overhead of database backup, recovery, logging, and checkpointing. The data in a read-only tablespace cannot be modified, making it ideal for data that does not change frequently.

Question 20

All critical errors need to be sent to the trace files.

Accepted Answer

Critical errors can be logged in various places depending on the system's configuration, including trace files, error logs, event viewers, or monitoring systems, not exclusively to trace files.

Quiz 5: Basic Storage Concepts and Settings