logo

CuriousTab

CuriousTab

Discussion


Home Technical Questions Database Comments

  • Question
  • The load and index is which of the following?


  • Options
  • A. A process to reject data from the data warehouse and to create the necessary indexes
  • B. A process to load the data in the data warehouse and to create the necessary indexes
  • C. A process to upgrade the quality of data after it is moved into a data warehouse
  • D. A process to upgrade the quality of data before it is moved into a data warehouse

  • Correct Answer
  • A process to load the data in the data warehouse and to create the necessary indexes 


  • Database problems


    Search Results


    • 1. A benefit of the three-tier architecture is which of the following?

    • Options
    • A. New modules can be built to support specific business needs
    • B. Performance improves for compiled SQL statements
    • C. Results in a thinner client and database server
    • D. All of the above.
    • Discuss
    • 2. A transaction for which all committed changes are permanent is called:

    • Options
    • A. atomic.
    • B. consistent.
    • C. isolated.
    • D. durable.
    • Discuss
    • 3. In the relational model, relationships between relations or tables are created by using:

    • Options
    • A. composite keys.
    • B. determinants.
    • C. candidate keys.
    • D. foreign keys.
    • Discuss
    • 4. An entity is a thing in the real world with an independent existence.

    • Options
    • A. TRUE
    • B. FALSE
    • Discuss
    • 5. Which of the following describes a relational database?

    • Options
    • A. It retrieves data related to its queries
    • B. It provides a relationship between floats
    • C. It provides a relationship between integers
    • D. It consists of separate tables or related data
    • Discuss
    • 6. To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

    • Options
    • A. ONLY
    • B. DISTINCT
    • C. UNIQUE
    • D. SINGLE
    • Discuss
    • 7. The ODBC Level 1 API contains which of the following functions?

    • Options
    • A. Browse possible connections and data sources only
    • B. Connect to data sources with driver-specific information only
    • C. Process a scrollable cursor only
    • D. Both 1 and 3 above are in the OBDC Level 1 API.
    • Discuss
    • 8. Cloud computing uses Server virtualization.

    • Options
    • A. TRUE
    • B. FALSE
    • Discuss
    • 9. Cloud computing is not suited for situations

    • Options
    • A. where complex legacy systems have to be ported
    • B. characterized by limited-time tasks
    • C. involving offloading of expensive computing tasks
    • D. with no existing regulatory compliance issues
    • Discuss
    • 10. A data dictionary is a special file that contains

    • Options
    • A. The width of all fields in all files
    • B. The data type of all fields in all file
    • C. The name of all fields in all files
    • D. All of the above
    • Discuss


    Comments

    There are no comments.

Enter a new Comment