WorksheetsOracle ch5
Total questions: 20
Worksheet time: 10mins
What operation cannot be applied to a tablespace after creation?
Convert from dictionary extent management to local extent management.
Convert from manual segment space management to automatic segment space management.
Change the name of the tablespace.
Reduce the size of the datafile(s) assigned to the tablespace.
All the above operations can be applied.
When the database is in mount mode, what views must be queried to find what datafiles and tablespaces make up the database?
DBA_DATA_FILES
DBA_TABLESPACES
DBA_TEMP_FILES
V$DATABASE
V$DATAFILE
When the database is in mount mode, what views must be queried to find what datafiles and tablespaces make up the database?
DBA_TABLESPACES
DBA_TEMP_FILES
V$DATABASE
V$DATAFILE
V$TABLESPACE
A tablespace is a logical container that allows you to manage groups of data files, the physical files on disk that consume space?
True
False
Tablespaces only exist?
While the database is in nomount stage
While the database is in mount stage
While the database is up and running
While the database is close
What are the incorrect statements related to the aspects of the database administrator (DBA) from tablespaces?
Assign specific space quotas for database users
Control operating system privileges
Perform partial database backup or recovery operations
Allocate data storage across devices to improve performance
An extent is a set of non-consecutively numbered Oracle blocks within one datafile?
True
False
What is the wrong statement related to Segments, Extents and Blocks?
Data is stored in segments
Every segment has one or more extents
Every extent has one or more segments
Storage is allocated by Extent
When a table is created, a segment is created to hold its data?
True
False
What is the tablespace name that is not created when executing CREATE DATABASE Command?
SYSTEM
SYSAUX
UNDO
TEMP
USERS
What is the tablespace name that is not created when executing CREATE DATABASE Command?
SYSTEM
SYSAUX
UNDO
TEMP
HRTS
When you Create a new tablespace, the database space will?
Be enlarged
Be squeezed
No change in space
All the other options
What is the correct statement related to Undo tablespace?
Users can get their own quota on it
Cannot contain any other objects
Server process uses it to sort data
Server process check it as a part of data dictionary
What is the initialization parameter that hasn’t any relation with controlling OMF?
DB_CREATE_FILE_DEST
DB_CREATE_ONLINE_LOG_DEST_N
DB_RECOVERY_FILE_DEST
MEMORY_TARGET
What are the two tablespaces that you can’t rename?
SYSTEM
SYSAU
USERS
EXAMPLE
INVENTORY
What is the action of the following SQL statement: SQL> alter database datafile 'c:\dbfile\o19c\users01.dbf' resize 1g;
Resize the mentioned datafile to be 2G
Resize the tablespace SYS to be 1G
Resize the tablespace to be 1G
Resize the mentioned datafile to be 1G
What is the limitation of OMF?
DBA is limited to one directory for the placement of data files
There is no limitation
DBA doesn’t know where the data are located
DBA must apply some commands in a specific time
What is the wrong statement related to the content of a container database?
Contains a root container
Contains a seed database
Contains Only one pluggable database
May contain Many pluggable databases
You can issue transactions against the seed PDB (PDB$SEED)?
True
False
The Flashback Database feature is:
Turned on and off via a privileged connection to the root container
Turned on and off via the PDB level
Can’t be turned on and off
Can be turned on via root level and off via PDB level
