Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
33 Cards in this Set
- Front
- Back
- 3rd side (hint)
This tablespace stores important internal structures such as the data dictionary, the system stored procedures, and the system rollback segments.
|
system
|
|
|
Unless you specify otherwise, the SYSTEM tablespace will be used as the default for
|
all database users
|
|
|
is the lowest logical layer of the Oracle data structure. Consists of one or more datafiles
|
tablespace
|
|
|
Tablespaces can hold any one of four types of segments. This type of segment, which is the basic type, can be used to hold tables and clusters.
|
data
|
|
|
Tablespaces can hold any one of four types of segments. This type of segment is used to hold indexes.
|
index
|
|
|
Tablespaces can hold any one of four types of segments. This special type of segment is used to store undo information.
|
rollback
|
|
|
This special type of segment is used to store undo information. This type of segment is used for storing temporary data.
|
temporary
|
|
|
a)what is the name of the graphical utility used to create tablespaces? b)What is the name of the command line utility to create tablespaces?
|
a)oracle storage manager, b)server manager
|
|
|
What's the maxim number of datafiles a tablespace can contain?
|
1022
|
|
|
What kind of parameter specifies how a tablespace is used?
|
storage parameter
|
|
|
this parameter defines the characteristics of the tablespace and how the tablespace grows
|
storage
|
|
|
Can more than one datafile make up a tablespace?
|
yes
|
|
|
Which method of taking a tablespace offline is this? All available datafiles are checkpointed; can occur even if a datafile is unavailable
|
temporary
|
|
|
Which method of taking a tablespace offline is this? Checkpoints all datafiles; all datafiles must be available and functioning properly
|
normal
|
|
|
which form of taking a tablespace offline is this? Datafiles are not checkpointed
|
immediate
|
|
|
this process automatically coalesces tablespaces (defragmenting extents), unless the process has been disabled
|
smon
|
|
|
The ALTER TABLESPACE ADD DATAFILE command creates datafiles in what fashion?
|
parallel
|
|
|
Enter the command to efficiently create datafiles in parallel
|
alter tablespace add datafile
|
|
|
Which parameter is used to take the tablespace offline and defer all writes to the datafiles while backup is taking place?
|
begin backup
|
|
|
Enter the parameter to specify that redo log information is kept on table, index, and partition operations.
|
logging
|
|
|
Enter the command that will bring the cats tablespace offline without checkpointing.
|
alter tablespace cats
offline immediate; |
|
|
This tablespace clause is very important because it is used to specify the initial size and characteristics of the tablespace as well as the future growth of that tablespace.
|
storage
|
|
|
Within the tablespace storage clause, this specifies the size of extents after the second extent (that is, from the third extent on).
|
pctextent
|
|
|
within the tablespace storage clause, what is the default value for the pctincrease? what is the default value for pctincrease relating to rollback segments?
|
50, 0
|
|
|
linked list of available data blocks in the extent that have free space greater than PCTFREE. These are essentially lists of blocks that are available for inserts.
|
freelists
|
By having more than one of these, you can reduce contention on inserts.
|
|
What parameter is used with the OPTIMAL parameter to specify that the rollback segments never shrink?
|
null
|
|
|
Complete the STORAGE clause command to specify the initial size of the extents at 150K.
|
storage initial 150k
|
|
|
The DEFAULT STORAGE clause is used for the creation of?
|
extents
|
|
|
Complete the STORAGE command to specify an initial extent size of 5M, the next extent size of 2M, and the size of all subsequent extents also to be 2M.
|
default storage
initial 5M NEXT 2M PCTIncrease 0 |
|
|
Complete the command to make dogs a read-only tablespace
|
alter tablespace dogs readonly;
|
|
|
What are temporary tablespaces used for?
|
Performing sort operations that cannot fit into memory
|
|
|
is the resource from which the schema objects obtain their space.
|
tablespace
|
Think of this as a file system on a set of disk drives. The space is there and allocated, but is not used until somebody creates a file or saves some data.
|
|
What is the application you use to determine whether I/O balancing is a problem?
|
performance monitor
|
|