DBMS Quizzy Fo Shizzy

76 Questions | Total Attempts: 75

SettingsSettingsSettings
DBMS Quizzy Fo Shizzy - Quiz

Questions and Answers
  • 1. 
    If DeptCode and DeptName are both non-key columns in a table and, given that logically the Deptname can be obtained if one knows the DeptCode, this is an example of a(n)  ______ dependancy.
    • A. 

      Partial

    • B. 

      Derived

    • C. 

      Transitive

    • D. 

      Inverse

    • E. 

      Relational

  • 2. 
    If EmployeeAge and EmployeeDateOfBirth are both non-key columns in a table and, given that logically the EmployeeAge can be obtained if one knows the EmployeeDateOfBirth, this is an example of a(n) _____ dependency.
    • A. 

      Inverse

    • B. 

      Transitive

    • C. 

      Derived

    • D. 

      Partial

    • E. 

      Relational

  • 3. 
    A relational table has a primary key consisting of ProductNumber. On each row, non-key attributes WareHouseNumber and the warehouse address information are also found. That is, each row in the table will contain data about a product stored in a warehouse. If the last product in a particular warehouse is removed from the database, it results in the loss of all the information of the warehouse where it is located. This is an example of a(n) ______ anomaly.
    • A. 

      Redundancy

    • B. 

      Insertion

    • C. 

      Deletion

    • D. 

      Modification

    • E. 

      None of the above

  • 4. 
    A relational table has a primary key consisting of WareHouseNumber and ProductNumber. That is, each row in the table will contain data about a product stored in a warehouse. One of the columns is ProductDescription. If a product description changes, multiple rows will have to be changed assuming that the product is stored in more than one warehouse. This is an example of a(n) ____ anomaly.
    • A. 

      Redundancy

    • B. 

      Insertion

    • C. 

      Deletion

    • D. 

      Modification

    • E. 

      None of the above

  • 5. 
    A relational table has a primary key consisting of VIN and EngineCode. That is, each row in the table will contain data about a particular automobile and its engine. If a new engine is designed and built, it could not be added to the database unless it was placed in a particular automobile. This is an example of a(n) ______ anomaly.
    • A. 

      Redundancy

    • B. 

      Insertion

    • C. 

      Deletion

    • D. 

      Modification

    • E. 

      None of the above

  • 6. 
    A Medical Clinic table contains one row per clinic. Each row contains attributes about all the doctors working in the clinic. This violates ____ normal form.
    • A. 

      1st

    • B. 

      2nd

    • C. 

      3rd

    • D. 

      4th

    • E. 

      None of the above

  • 7. 
    A CoursesTaught table has a primary key combining both a Course code and an Instructor code. If Instructor name is an attribute of this table, it would violate _____ normal form.
    • A. 

      1st

    • B. 

      2nd

    • C. 

      3rd

    • D. 

      4th

    • E. 

      None of the above

  • 8. 
    DeptCode and DeptName are both non-key columns in a table. Given that logically the DeptName can be obtained if one knows the DeptCode, this would violate ____ normal form.
    • A. 

      1st

    • B. 

      2nd

    • C. 

      3rd

    • D. 

      4th

    • E. 

      None of the above

  • 9. 
    EmployeeAge and EmployeeDateOfBirth are both non-key columns in a table. Given that the EmployeeAge can be obtained if one knows the EmployeeDateOfBirth, this would violate ____ normal form.
    • A. 

      1st

    • B. 

      2nd

    • C. 

      3rd

    • D. 

      4th

    • E. 

      None of the above

  • 10. 
    Select the FALSE statement
    • A. 

      A table must have at least one column

    • B. 

      In most commercial DBMS products, the maximum number of rows in a table is unlimited or very large

    • C. 

      A table must have a least one row

    • D. 

      Rows in a table are considered to be unsorted

    • E. 

      In many commercial DMBS products, the maximum number of columns in a table is limited to 255

  • 11. 
    In a relational database, is a synonym for column is 
    • A. 

      Row

    • B. 

      Tuple

    • C. 

      Table

    • D. 

      Attribute

    • E. 

      Record

  • 12. 
    The order of columns in a relational table (is)
    • A. 

      Based on the value of the foreign key

    • B. 

      Optimized by the database engine

    • C. 

      Based on the value of the primary key

    • D. 

      Changes as data is inserted and deleted

    • E. 

      Left to right as defined when the table is created

  • 13. 
    In a "one-to-many" relationship between two tables, foreign keys are stored in ____ tables
    • A. 

      Either parent or child depending on the nature of the relationship

    • B. 

      Parent

    • C. 

      Special key

    • D. 

      Child

  • 14. 
    You need to insert a new product in a Product table but the classification (a grouping such as "stationary") into which this product fits is yet to be determined. What would likely be entered for the classification code assuming it is a three position character field?
    • A. 

      Nothing

    • B. 

      N/A

    • C. 

      Three spaces

    • D. 

      High values

    • E. 

      000 (three zeros)

  • 15. 
    A primary key created from two or more columns is referred to as a(n) ____ primary key
    • A. 

      Qualitative

    • B. 

      Composite

    • C. 

      Value added

    • D. 

      Non unique

    • E. 

      Indexed

  • 16. 
    The term "surrogate" is usually associated with
    • A. 

      Foreign keys

    • B. 

      Cross table relationships

    • C. 

      Indexes

    • D. 

      Primary keys

    • E. 

      File systems

  • 17. 
    In a "one-to-many" relationship between two tables, foreign keys are stored in ____ tables.
    • A. 

      Either parent or child depending on the nature of the relationship

    • B. 

      Special key

    • C. 

      Parent

    • D. 

      Child

  • 18. 
    A "thing" such as a Fixed Asset would likely be considered a(n) ___ in a relational model
    • A. 

      Value

    • B. 

      Entity

    • C. 

      Field

    • D. 

      Columns

    • E. 

      Attribute

  • 19. 
    Based on this diagram, select the false statement
    • A. 

      An employee may be working on several projects

    • B. 

      A project may have more than one employee working on it

    • C. 

      An employee may not be working on a project

    • D. 

      An employee may be working on just one project

    • E. 

      A project may have only one employee working on it

  • 20. 
    This diagram is an example of which type of ERD
    • A. 

      Key based ERD

    • B. 

      Context ERD

    • C. 

      Full Attribute ERD

    • D. 

      This is not one of the defined ERD diagrams

    • E. 

      Foreign Key ERD

  • 21. 
    What is a key attribute
    • A. 

      This central entity in an ERD

    • B. 

      A property that uniquely describes an entity

    • C. 

      Any property that is a Primary Key or a Foreign Key

    • D. 

      The most common property of an entity

    • E. 

      Any property that describes an entity

  • 22. 
    SQL provides
    • A. 

      Data selection and retrieval

    • B. 

      Data definition

    • C. 

      Data integrity

    • D. 

      Access control

    • E. 

      All of the above

  • 23. 
    An application that uses SQL is portable from one DBMS to another
    • A. 

      Rarely, since there are so many standards and levels of compliance

    • B. 

      Usually, but will likely require significant changes

    • C. 

      Never, since SQL is unique to IBM

    • D. 

      Always, since SQL is standardized

    • E. 

      Usually, with minor modifications required

  • 24. 
    SQL is a(n)
    • A. 

      OO language ilke Java

    • B. 

      Language designed for relational databases

    • C. 

      Database engine

    • D. 

      Programming language unique to Microsoft

    • E. 

      3rd generation language like COBOL

  • 25. 
    What is the maximum size of a table name?
    • A. 

      20

    • B. 

      30

    • C. 

      50

    • D. 

      200

Back to Top Back to top