logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Database Redesign See What Others Are Saying!
  • Question

  • Changing cardinalities in a database is:


  • Options
  • A. a common database design task.
  • B. a rare database design task, but does occur.
  • C. a database design task that never occurs.
  • D. is impossible to do, so a new database must be constructed and the data moved into it.

  • Correct Answer
  • a common database design task. 

    • More questions

    • 1. Which of the following is not considered to be a basic element of an enterprise-class database system?

    • Options
    • A. Users
    • B. Database applications
    • C. DBMS
    • D. COBOL programs
      • Discuss
    • 2. Which of the following is not true about indexes?

    • Options
    • A. Indexes are created to enforce uniqueness on columns.
    • B. Indexes are created to enable fast retrieval by column values.
    • C. Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.
    • D. Indexes are created with the ALTER TABLE command.
      • Discuss
    • 3. A relation is in 5NF when multivalued dependencies are isolated in their own relation.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. An OLE DB rowset is equivalent to a cursor.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Some organizations take the stand that no application should ever employ the true name of a table.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .

    • Options
    • A. dirty data
    • B. inconsistent data
    • C. non-integrated data
    • D. a "wrong format" problem
      • Discuss
    • 7. A servlet is a Java program that is invoked via HTTP on the Web server.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. There should be one condition within the WHERE clause for each pair of tables being joined.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. A ________ is a stored program that is attached to a table or a view.

    • Options
    • A. pseudofile
    • B. embedded SELECT statement
    • C. trigger
    • D. None of the above is correct.
      • Discuss
    • 10. An ID-dependent entity is an entity whose identifier is a composite identifier where no portion of the composite identifier is an identifier of another entity.

    • Options
    • A. True
    • B. False
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.