BCIS Quiz 5

  1. In a data model, a(n) ________ is something that a user wants to track.

    A) byte
    B) record
    C) entity
    D) primary key
  2. Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.

    A) adaptation
    B) recovery
    C) operation
    D) development
  3. A ________ is a collection of forms, reports, queries, and programs that process a database.

    A) data model
    B) database application
    C) data field
    D) database design
    Database application
  4. From among the following, identify the open source DBMS product.

    A) Oracle Database
    B) MySQL
    C) Access
    D) DB2
  5. Which of the following types of DBMS products is designed for smaller and simpler database applications?

    A) personal DBMS
    B) strategic DBMS
    C) object-oriented DBMS
    D) enterprise DBMS
    Personal DBMS
  6. Which of the following is a nonrelational data store developed by Amazon?

    A) Dynamo
    B) Bigtable
    C) Cassandra
    D) SharePoint
  7. A(n) ________ is a program used to create, process, and administer a database.

    A) DBMS
    B) data mart
    C) KMS
    D) operating system
  8. ________ is an example of a personal DBMS.

    A) DB2
    B) Access
    C) SQL Server
    D) Oracle Database
  9. When you modify or delete data present in a database, you are ________.

    A) creating a new database
    B) forming a data model
    C) processing the database
    D) simplifying the data structure
    Processing the database
  10. In a database, when data items disagree with one another, this leads to a(n) _______.

    A) crow's-foot paradigm
    B) data integrity problem
    C) adaptation conflict
    D) lost-update problem
    Data integrity problem
  11. Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, percentage completed, and employee name. These aspects that Brad wants to track are called ________.

    A) primary keys
    B) entities
    C) identifiers
    D) records
  12. A ________ is a request for data from a database.

    A) command
    B) query
    C) report
    D) data entry
  13. Which of the following data elements is placed higher than records in the data hierarchy?

    A) file
    B) character
    C) byte
    D) field
  14. A(n) ________ DBMS is designed to process large organizational and workgroup databases.

    A) process
    B) enterprise
    C) personal
    D) operational
  15. A data integrity problem will occur only if ________.

    A) data are duplicated
    B) there are complex relationships
    C) the database is very large
    D) there are multiple administrators
    Data are duplicated
  16. Which of the following is a nonrelational data store developed by Google?

    A) Cassandra
    B) SharePoint
    C) Bigtable
    D) Dynamo
  17. Which of the following is the smallest data element in a database?

    A) byte
    B) field
    C) file
    D) record
  18. A primary key used in a database is a _______.

    A) character or byte that represents fields or columns
    B) group of tables or files formed to identify a unique field or row
    C) group of rows that are formed to identify a unique table or file
    D) column or group of columns that dentifies a unique row in a table
    Column or group of columns that identifies a unique row in a table
  19. Which of the following is a valid observation of MySQL?

    A) It is a closed-source database product.
    B) It is license-free for most applications.
    C) It is offered by Oracle.
    D) It is yet to be widely adopted.
    It is license-free for most application
  20. The purpose of a(n) ________ is to keep track of things.

    A) database
    B) storage folder
    C) cloud
    D) application software
  21. Which of the following is an example of an enterprise DBMS?

    A) Access
    B) Paradox
    C) SQL Server
    D) FoxPro
    SQL Server
  22. Which of the following is true about the database development process?

    A) Changing a relationship from 1:N to N:M is simply a matter of changing the notations.
    B) A database is a model of how the developers view their business world.
    C) User review of the data model is avoided as it is not helpful in data modeling.
    D) The database structure cannot be changed during the data modeling stage.
    Changing a relationship from 1:N to N:M is simply a matter of changing the notations
  23. Entities in a data model have ________ that describe the characteristics of the entity.

    A) characters
    B) codes
    C) primary keys
    D) attributes
  24. A database design team transforms entities into tables and expresses relationships by defining ________.

    A) cardinalities
    B) attributes
    C) departments
    D) foreign keys
    Foreign keys
  25. Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. After accessing the DBMS, she should type the keyword into a ________ form to obtain the information that she wants.

    A) report
    B) query
    C) reference
    D) data entry
  26. Identify the first step in transforming a data model into a relational database design.

    A) normalizing the data and files
    B) representing the data relationships
    C) creating foreign keys
    D) creating a table for each entity
    Creating a table for each entity
  27. A ________ describes the data and relationships that will be stored in a database.

    A) data aggregator
    B) query model
    C) data model
    D) data application
    Data model
  28. Which of the following database administration tasks is related to adaptation?

    A) monitoring backup procedures
    B) monitoring database performance
    C) conducting training for users
    D) managing configuration changes in systems
    Managing configuration changes in systems
  29. ________ is the process of converting a data model into tables, relationships, and data constraints.

    A) Data mining
    B) Database aggregation
    C) Database design
    D) Database querying
    Database design
  30. When using the relational model to represent data, one must ________.

    A) have more than ten tables in the model
    B) add a foreign key to one of the tables
    C) establish only N:M relationships between tables
    D) use metadata instead of foreign keys
    Add a foreign key to one of the tables
  31. In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required.

    A) vertical bar
    B) arrow
    C) small oval
    D) triangular block
    Vertical bar
  32. A student management system allows students to have multiple majors and advisers are assigned to handle multiple students and courses. This is an example of a(n) ________ relationship.

    A) N:M
    B) M:1
    C) 1:1
    D) 1:N
  33. An organization buys a proprietary database application to be used by a small workgroup of five people. This is an example of a(n) ________ DBMS.

    A) enterprise
    B) personal
    C) open source
    D) interenterprise
  34. The database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task.

    A) development
    B) operational
    C) adaptation
    D) recovery
  35. A data model is a ________.

    A) set of programs to retrieve data
    B) repository of unprocessed data
    C) logical representation of database data
    D) collection of isolated databases
    Logical representation of database data
  36. Every table in a normalized database has ________.

    A) maximum cardinality
    B) single theme
    C) specialized query format
    D) duplicated data model
    Single theme
  37. Which of the following is true of N:M relationships?

    A) They are common examples of minimum cardinalities.
    B) They can have more than one entity on each side of the relationship.
    C) They are also called one-to-many relationships.
    D) The number of entities on each side must be equal.
    They can have more than one entity on each side of the relationship
  38. Which of the following is a nonrelational data store developed by Facebook?

    A) Dynamo
    B) Cassandra
    C) SharePoint
    D) Bigtable
  39. ________ forms are used to read, insert, modify, and delete data.

    A) Reporting
    B) Query
    C) Data entry
    D) Request
    Data entry
  40. Metadata are ________.

    A) data that describe data
    B) data stored on the main server
    C) error logs of databases
    D) encrypted data transmissions
    Data that describes data
  41. The rows in a database are called ________.

    A) files
    B) records
    C) tables
    D) fields
  42. Which of the following is an example of a database management system?

    A) Access
    B) MS Excel
    C) Unix
    D) Ubuntu
  43. The forked lines on the right side of a line on an diagram that indicates a 1:N relationship between two entities is referred to as ________.

    A) crow's feet
    B) maximum cardinality
    C) minimum cardinality
    D) Kerberos
  44. An administrator should create ________ before developing a database design.

    A) query model
    B) data aggregator
    C) data model
    D) data application
    Data model
  45. Which of the following is a developmental task of database administration?

    A) creating and staffing the DBA function
    B) conducting training for users
    C) monitoring backup procedures
    D) managing configuration changes in systems
    Creating and staffing the DBA function
  46. Minimum cardinalities in an E-R diagram refer to the minimum number of entities required in a(n) ________.

    A) attribute
    B) relationship
    C) database
    D) department
  47. ________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

    A) Users
    B) Administrators
    C) Designers
    D) Developers
Card Set
BCIS Quiz 5