logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Introduction to Database See What Others Are Saying!
  • Question

  • The DBMS acts as an interface between what two components of an enterprise-class database system?


  • Options
  • A. Database application and the database
  • B. Data and the database
  • C. The user and the database application
  • D. Database application and SQL

  • Correct Answer
  • Database application and the database 

    • More questions

    • 1. In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?

    • Options
    • A. Complete backup
    • B. Transaction Log
    • C. Differential backup
    • D. None of the above is correct.
      • Discuss
    • 2. Denormalization and clustering can work well to minimize data access time for small records.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. During logical database design, the conceptual data model is transformed into a logical data model which describes the data in terms of a specific data management technology.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. Database administration refers to a function that applies to the entire organization.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:

    • Options
    • A. first step.
    • B. second step.
    • C. third step.
    • D. fourth step.
      • Discuss
    • 8. In UML, a class is represented by a rectangle with three compartments separated by vertical lines.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. An aggregation is a stronger form of association relationship and is represented with a solid diamond at the aggregate end.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.

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