Tag: technology

Questions Related to technology

I want to see number of orders against team size of the team processing the orders. Which is the fact and which is the dimension?

technology enterprise content management

  1. Both are measures

  2. Order count is the measure, Team Size is the dimension

  3. Team size is the measure, Order Count is the measure

  4. None of the above

Show answer
Correct Option: B

Any numerical field in the business model is always a measure, and a measure is always a numerical field.

technology enterprise content management

  1. True

  2. False

Show answer
Correct Option: B

A degenerate dimension is:

technology enterprise content management

  1. an attribute of a fact which quailifies as a dimension

  2. stored in the fact table

  3. has no surrogate keys

  4. has fixed values that cannot be generated outside the fact

Show answer
Correct Option: A,B

In your DB -multiplexed online redo log files,one of the members in a group is lost due to media failure? You wud..
technology databases

  1. import the database from the last export

  2. restore all the members in the group from the last backup

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

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

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

Show answer
Correct Option: C

Which statement regarding an incomplete recovery is true?(Oracle 10g)

technology databases

  1. You do not need to restore all the data files.

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

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

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

Show answer
Correct Option: C

In which scenarios would you rebuild an index?
technology databases

  1. when you need to disable the index usage

  2. when you need to move the index to another tablespace

  3. when you need to enable index monitoring

  4. none of the above

Show answer
Correct Option: B

A redo log file is corrupted while the database is open;You would ..
technology databases

  1. clear the redo log group

  2. perform redo log file import

  3. perform an incomplete recovery

  4. perform a redo log recovery using Recovery Manager (RMAN)

  5. shut down the database and open the database in the NOARCHIVELOGmode

Show answer
Correct Option: A

Which statement regarding an incomplete recovery is true(10g)?
technology databases

  1. You do not need to restore all the data files.

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

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

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

Show answer
Correct Option: C

Which file is not supported with RMANBACKUP command?
technology databases

  1. data file

  2. password file

  3. archivelog file

  4. temporary file

  5. online redo log file

Show answer
Correct Option: E

Which condition in your database forces you to perform only consistent backups?
technology databases

  1. The database is in mount state.

  2. One of the tablespaces is offline.

  3. One of the tablespaces is read only.

  4. The database operates in ARCHIEVELOG mode.

  5. The database operates in NOARCHIEVELOG mode.

Show answer
Correct Option: E