Practice test

Data representation - Test Set 2

Review 20 exam-focused questions with detailed explanations, then start the interactive test when you are ready.

20 questions

Questions and explanations

  1. Question 1

    Which of the following is not a type of DBMS model?
    1. Microsoft
    2. Object-oriented
    3. Relational
    4. Hierarchical
    View explanation

    Sign In to See Explanations. Sign Up Here

  2. Question 2

    In which of the following models does the DBMS store data in the form of rows and columns?
    1. Hierarchical model
    2. Relational model
    3. Network model
    4. Object-oriented model
    View explanation

    Sign In to See Explanations. Sign Up Here

  3. Question 3

    Which of the following is not a type of database?
    1. Relational
    2. Object-relational
    3. Object-SQL
    4. Object-oriented
    View explanation

    Sign In to See Explanations. Sign Up Here

  4. Question 4

    Which of the following is the most commonly used DBMS model?
    1. Hierarchical model
    2. Object-oriented model
    3. Network model
    4. Relational model
    View explanation

    Sign In to See Explanations. Sign Up Here

  5. Question 5

    Which of the following is not a type of relationship in a relational database?
    1. None-to-one
    2. Many-to-many
    3. One-to-many
    4. One-to-one
    View explanation

    Sign In to See Explanations. Sign Up Here

  6. Question 6

    Which of the following is not a DBMS type?
    1. Hierarchical
    2. Linear
    3. Relational
    4. Object-Oriented
    View explanation

    Sign In to See Explanations. Sign Up Here

  7. Question 7

    Which type of relationship exists when a single record in one table is related to multiple records in another table?
    1. One-to-one
    2. Many-to-many
    3. One-to-many
    4. Many-to-one
    View explanation

    Sign In to See Explanations. Sign Up Here

  8. Question 8

    Which of the following is not a property of a relational database?
    1. Data is stored in tables
    2. Data can be accessed using SQL
    3. Data can be retrieved using simple queries
    4. Data is stored in an unstructured manner
    View explanation

    Sign In to See Explanations. Sign Up Here

  9. Question 9

    Which of the following is a disadvantage of the hierarchical database model?
    1. Scalability issues
    2. Complex relationships between data
    3. Redundancy of data
    4. High performance
    View explanation

    Sign In to See Explanations. Sign Up Here

  10. Question 10

    In Entity Relationship diagram of database management system, when attribute is single valued then __________ is used in diagram.
    1. double dotted lines
    2. single line
    3. dotted single line
    4. dotted line
    View explanation

    Sign In to See Explanations. Sign Up Here

  11. Question 11

    In Entity Relationship model of database, ________ describe the components of an entity.
    1. relationship
    2. cardinality
    3. attributes
    4. degree
    View explanation

    Sign In to See Explanations. Sign Up Here

  12. Question 12

    What is a foreign key in a relational database?
    1. Key that links one table to another
    2. A unique identifier
    3. Key used to create a table
    4. None of the above
    View explanation

    Sign In to See Explanations. Sign Up Here

  13. Question 13

    What is a primary key?
    1. A key used to connect two tables
    2. A key used to select data from a table
    3. A key that stores primary data
    4. A key that uniquely identifies a record
    View explanation

    Sign In to See Explanations. Sign Up Here

  14. Question 14

    What is a composite key in DBMS?
    1. A key used in a foreign table
    2. A primary key formed by a combination of more than one column
    3. A key that stores composite data
    4. A key formed by joining multiple tables
    View explanation

    Sign In to See Explanations. Sign Up Here

  15. Question 15

    What is a NULL value in SQL?
    1. A value that has been explicitly set to zero
    2. A default value assigned to a column
    3. A value that is missing or undefined
    4. A value that is empty but exists in the database
    View explanation

    Sign In to See Explanations. Sign Up Here

  16. Question 16

    In DBMS, what is a schema?
    1. A blueprint of the database structure
    2. A type of query
    3. A temporary table
    4. None of the above
    View explanation

    Sign In to See Explanations. Sign Up Here

  17. Question 17

    Which of the following types of schema represents the conceptual design of a database?
    1. External schema
    2. Logical schema
    3. Physical schema
    4. Internal schema
    View explanation

    Sign In to See Explanations. Sign Up Here

  18. Question 18

    A logical schema is _____________.
    1. the entire database
    2. describes how data is actually stored on disk
    3. a standard way of organising information into accessible part
    4. All of the above
    View explanation

    Sign In to See Explanations. Sign Up Here

  19. Question 19

    What is the correct order of data storage hierarchy in a database?
    1. Database > File > Record > Field
    2. Field > Record > File > Database
    3. File > Database > Record > Field
    4. Record > Field > File > Database
    View explanation

    Sign In to See Explanations. Sign Up Here

  20. Question 20

    Which of the following represents the highest level in the database storage hierarchy?
    1. Table
    2. Field
    3. Database
    4. Record
    View explanation

    Sign In to See Explanations. Sign Up Here