Tag: databases

Questions Related to databases

The load and index is which of the following?
technology databases

  1. A process to reject data from the data warehouse and to create the necessary indexes

  2. A process to load the data in the data warehouse and to create the necessary indexes

  3. A process to upgrade the quality of data after it is moved into a data warehouse

  4. A process to upgrade the quality of data before it is moved into a data warehouse

Show answer
Correct Option: B

Data transformation includes which of the following?
technology databases

  1. A process to change data from a detailed level to a summary level

  2. A process to change data from a summary level to a detailed level

  3. Joining data from one source into various sources of data

  4. Separating data from one source into various sources of data

Show answer
Correct Option: A

A multifield transformation does which of the following?
technology databases

  1. Converts data from one field into multiple fields

  2. Converts data from multiple fields into one field

  3. Converts data from multiple fields into multiple fields

  4. All of the above

Show answer
Correct Option: D

A star schema has what type of relationship between a dimension and fact table?

technology databases

  1. Many-to-many

  2. One-to-one

  3. One-to-many

  4. All of the above.

Show answer
Correct Option: C

Fact tables are which of the following?
technology databases

  1. Completely demoralized

  2. Partially demoralized

  3. Completely normalized

  4. Partially normalized

Show answer
Correct Option: C

A snowflake schema is which of the following types of tables?
technology databases

  1. Fact

  2. Dimension

  3. Helper

  4. All of the above

Show answer
Correct Option: D

A goal of data mining includes which of the following?

technology databases

  1. To explain some observed event or condition

  2. To confirm that data exists

  3. To analyze data for expected relationships

  4. To create a new data warehouse

Show answer
Correct Option: A

A report output file gets generated when you run "Validate APPS schema" by using the adadmin utility in the Oracle Applications 11i E-Business Suite environment. If the report shows something similar to "GL_CODE_COMBINATIONS table does not exist or is an invalid object", what is the first step that the database administrator (DBA) should take to correct this issue?

technology databases

  1. Run the AD Relink utility and relink the GL product

  2. Use License Manager, and register the GL product.

  3. Run the "Recreate grants and synonyms for APPS schema" task by using the adadmin utility

  4. Run Autopatch, and apply GL latest available patch

  5. Run Rapid Install to reinstall the database components

Show answer
Correct Option: C

Where can you find the Oracle 8.0.6 and iAS files in the Oracle Applications 11i file system?

technology databases

  1. DB

  2. ORA

  3. COMN

  4. FND_TOP

  5. APPL_TOP

Show answer
Correct Option: B

In which three cases is it most effective to run validation on the APPS schema in the Oracle Applications 11i E- Business Suite setup? (Choose three.)

technology databases

  1. before performing an export/import

  2. immediately after an upgrade or applying a maintenance pack

  3. converting to multiple organizations or multiple reporting currencies

  4. after a patch or multiple patches are applied

  5. whenever you receive a run-time error that suggests that a problem is caused by the AD_DDL package

Show answer
Correct Option: D,E