Tag: technology

Both are measures

Order count is the measure, Team Size is the dimension

Team size is the measure, Order Count is the measure

None of the above

True

False

an attribute of a fact which quailifies as a dimension

stored in the fact table

has no surrogate keys

has fixed values that cannot be generated outside the fact

import the database from the last export

restore all the members in the group from the last backup

drop the lost member from the database and then add a new member to the group

restore all the database files from the backup and then perform a complete recovery

restore all the database files from the backup and then perform an incomplete recovery

You do not need to restore all the data files.

You do not need to open the database with the RESETLOGS operation

You do not need to perform a full backup after the RESETLOGS operation.

You do not need to recover all the data files to the same system change number (SCN).

when you need to disable the index usage

when you need to move the index to another tablespace

when you need to enable index monitoring

none of the above

clear the redo log group

perform redo log file import

perform an incomplete recovery

perform a redo log recovery using Recovery Manager (RMAN)

shut down the database and open the database in the NOARCHIVELOGmode

You do not need to restore all the data files.

You do not need to open the database with the RESETLOGS operation

You do not need to perform a full backup after the RESETLOGS operation.

You do not need to recover all the data files to the same system change number (SCN).

data file

password file

archivelog file

temporary file

online redo log file

The database is in mount state.

One of the tablespaces is offline.

One of the tablespaces is read only.

The database operates in ARCHIEVELOG mode.

The database operates in NOARCHIEVELOG mode.