logo

CuriousTab

CuriousTab

Discussion

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

  • When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 

    • More questions

    • 1. Concurrency control is important for which of the following reasons?

    • Options
    • A. To ensure data integrity when updates occur to the database in a multiuser environment
    • B. To ensure data integrity when updates occur to the database in a single-user environment
    • C. To ensure data integrity while reading data occurs to the database in a multiuser environment
    • D. To ensure data integrity while reading data occurs to the database in a single-user environment
      • Discuss
    • 2. User views are included as part of which schema?

    • Options
    • A. Internal
    • B. Conceptual
    • C. External
    • D. None of the above.
      • Discuss
    • 3. Which of the following is an ordered collection of elements of the same type?

    • Options
    • A. Set
    • B. Bag
    • C. List
    • D. Dictionary
      • Discuss
    • 4. The fact that the same operation may apply to two or more classes is called what?

    • Options
    • A. Inheritance
    • B. Polymorphism
    • C. Encapsulation
    • D. Multiple classification
      • Discuss
    • 5. The benefits of object-oriented modeling are which of the following?

    • Options
    • A. The ability to tackle more challenging problems
    • B. Reusability of analysis, design, and programming results
    • C. Improved communication between users, analysts, etc.
    • D. All of the above.
      • Discuss
    • 6. 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
    • 7. 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
    • 8. 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
    • 9. Market basket analysis primarily uses the technique of conditional probabilities.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. 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

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.