DBMS Architecute and Database Model

  • ANSI-SPARC Architecture
  • Database Schema/Languages
  • Data Independence and Models
  • Conceptual...
    View Complete Description
    ×

    Topic Summary

    • ANSI-SPARC Architecture
    • Database Schema/Languages
    • Data Independence and Models
    • Conceptual Modeling
    • Relational Data Terminologies
    • Database Relations
    • Properties of Relations
    • Relational Keys
109
Questions
Question Type Legends

Easy

Medium

Difficult

Multiple Choice Questions for DBMS Architecute and Database Model

  • 1 The three level ANSI-SPARC Architecture includes __________, internal and conceptual levels.
    1. logical
    2. physical
    3. application
    4. external

  • 2 If one user wants to view the employee’s hire date in form of (day, month, year), but other user wants to view the same employee’s hire date in the different form like (year, month, day), which one of the three-level architecture represents it?
    1. Internal level
    2. Conceptual level
    3. External level
    4. All of the Above

  • 3 User views are included as part of which schema?
    1. Internal
    2. External
    3. Conceptual
    4. none of the above

  • 4 If A, B and C are attributes in a relation, and A is a primary key, then what type of the dependency is this if B dependent on A as well as C dependent on A?
    1. Full functional dependency
    2. Partial dependency
    3. Transitive dependency
    4. None of the above

  • 5 If a tuple of a parent relation is deleted, referential integrity is lost if there exists a child tuple referencing the deleted parent tuple. In order to maintain the integrity, there are several strategies we can consider which of the following?
    1. CASECADE
    2. PREFERENCE
    3. HIGH PRIORITY
    4. DELETE PARENT TUPLE

  • 6 One goal to eliminate various anomalies in relational database is to:
    1. reduce attributes
    2. increase data
    3. reduce table
    4. reduce storage space

  • 7 There is a relation Student (stID, sName, city), where city and sName attributes may have repeated values, but stID cannot have repeated values, then which one of the following can be a candidate key in the relation:
    1. city attribute
    2. stID attribute
    3. sName attribute
    4. None

  • 8 If one user wants to view the employee’s hire date in form of (day, month, year), but other user wants to view the same employee’s hire date in the different form like (year, month, day), which one of the three-level architecture represents it?
    1. Internal level
    2. Conceptual level
    3. External level
    4. All of the above

  • 9 A Gerund is actually a:
    1. Many-to-Many Relationship
    2. Many-to-One Relationship
    3. One-to-Many Relationship
    4. Always a recursive Relationship

  • 10 Which SQL statement is used to extract data from a database?
    1. Get
    2. Select
    3. Set
    4. Open

  • 11 The number of entities involved in a relationship is called:
    1. Degree of relationship
    2. Level of relationship
    3. Level of entities
    4. Degree of entities

  • 12 Value of the primary key can be:
    1. Null
    2. Repeating
    3. Zero
    4. None

  • 13 Which one is NOT a database design technique?
    1. Normalization
    2. Generalization
    3. ERD
    4. Coherence

  • 14 An attribute that can be further divided into sub attributes is called:
    1. Composite attribute
    2. Combined attribute
    3. Collective attribute
    4. Single Attribute

  • 15 The immunity of conceptual schema to changes in the internal schema is called:
    1. Logical Data Independence
    2. Physical Data Independence
    3. Conceptual Data Independence
    4. None

Contact Us

support@subexpert.com
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn and Evaluate

Follow Us
© 2020 - Subject Expert