logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Database Design Using Normalization See What Others Are Saying!
  • Question

  • When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:


  • Options
  • A. first step.
  • B. second step.
  • C. third step.
  • D. fourth step.

  • Correct Answer
  • second step. 

    • More questions

    • 1. A heterogeneous distributed database is which of the following?

    • Options
    • A. The same DBMS is used at each location and data are not distributed across all nodes.
    • B. The same DBMS is used at each location and data are distributed across all nodes.
    • C. A different DBMS is used at each location and data are not distributed across all nodes.
    • D. A different DBMS is used at each location and data are distributed across all nodes.
      • Discuss
    • 2. Which SQL-92 standard SQL command can be used to change a table name?

    • Options
    • A. RENAME TABLE
    • B. CHANGE TABLE
    • C. ALTER TABLE
    • D. None of the above is correct.
      • Discuss
    • 3. The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. Market basket analysis primarily uses the technique of conditional probabilities.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. A stored procedure is a program that performs some common action on database data and is stored in the database.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. Which of the following columns is(are) are required in a table?

    • Options
    • A. A foreign key
    • B. An alternate key
    • C. A primary key
    • D. A surrogate key.
      • Discuss
    • 8. Packaged data models are meant to be exactly right straight out of the box.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.

    • Options
    • A. the primary key
    • B. any alternate key
    • C. a surrogate key
    • D. a foreign key
      • Discuss
    • 10. Multiple inheritance allows a class to inherit features from more than one superclass.

    • 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.