Question 1 1 out of 1 points
Correct ____ deals with fixing the database after a failure, such as a hard disk malfunction.
Question 1 answers
Selected Answer: Correct Recovery
Question 2 text Question 2 1 out of 1 points
Correct Having fields stored in one location produces data redundancy.
Question 2 answers
Selected Answer: Correct False
Question 3 text Question 3 1 out of 1 points
Correct A(n) computer system refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.
Question 3 answers
Selected Answer: Correct False
Question 4 text Question 4 1 out of 1 points
Correct Data is/are:
Question 4 answers
Selected Answer: Correct raw facts
Question 5 text Question 5 0 out of 1 points
Incorrect Programming in a(n) ____ can be a time-consuming and high-skill activity.
Question 5 answers
Selected Answer: Incorrect AIS
Question 6 text Question 6 1 out of 1 points
Correct Software refers to all the system's physical devices.
Question 6 answers
Selected Answer: Correct False
Question 7 text Question 7 0 out of 1 points
Incorrect Because all data access programs are subject to change when any of the file’s data storage characteristics change, the file system is said to exhibit structural dependence.
Question 7 answers
Selected Answer: Incorrect True
Question 8 text Question 8 1 out of 1 points
Correct A record consists of a ____.
Question 8 answers
Selected Answer: Correct set of one or more fields
Question 9 text Question 9 1 out of 1 points
Correct Data consistency exists when different and conflicting versions of the same data appear in different places.
Question 9 answers
Selected Answer: Correct False
Question 10 text Question 10 1 out of 1 points
Correct The structure of the contents of a database does not need to be designed carefully.
Question 10 answers
Selected Answer: Correct False
Question 11 text Question 11 1 out of 1 points
Correct ____ are the people who run the organization’s daily operations.
Question 11 answers
Selected Answer: Correct End users
Question 12 text Question 12 1 out of 1 points
Correct An ad hoc query is a spur-of-the-moment question.
Question 12 answers
Selected Answer: Correct True
Question 13 text Question 13 1 out of 1 points
Correct Which of the following is not a degree of abstraction as defined by ANSI/SPARC?
Question 13 answers
Selected Answer: Correct Physical
Question 14 text Question 14 1 out of 1 points
Correct Which of the following was NOT produced by the DBTG of CODASYL?
Question 14 answers
Selected Answer: Correct Standard diagrams for database modeling known as ERD
Question 15 text Question 15 0 out of 1 points
Incorrect The ____ model is the relational model’s challenge to the OODM.
Question 15 answers
Selected Answer: Incorrect network
Question 16 text Question 16 0 out of 1 points
Incorrect Which of the following database models is NOT still in use today?
Question 16 answers
Selected Answer: Incorrect ERD
Question 17 text Question 17 1 out of 1 points
Correct Which of the following data models contains the most semantics?
Question 17 answers
Selected Answer: Correct Object-oriented
Question 18 text Question 18 0 out of 1 points
Incorrect The limitations of the hierarchical model are that none of the concepts defined by that model are in use today.
Question 18 answers
Selected Answer: Incorrect True
Question 19 text Question 19 0 out of 1 points
Incorrect Hierarchal databases became popular in the 1980s.
Question 19 answers
Selected Answer: Incorrect True
Question 20 text Question 20 0 out of 1 points
Incorrect The top layer of the hierarchical model is known as the treetop.
Question 20 answers
Selected Answer: Incorrect True
Question 21 text Question 21 1 out of 1 points
Correct In a network database each set is composed of two record types: an owner record and a ____ record.
Question 21 answers
Selected Answer: Correct member
Question 22 text Question 22 0 out of 1 points
Incorrect A relational DBMS is a single data repository in which data independence is maintained.
Question 22 answers
Selected Answer: Incorrect False
Question 23 text Question 23 0 out of 1 points
Incorrect What type of relationship is expressed with the phrase “Student takes Class”?
Question 23 answers
Selected Answer: Incorrect 1:M
Question 24 text Question 24 0 out of 1 points
Incorrect A relational database is a group of ____.
Question 24 answers
Selected Answer: Incorrect field values
Question 25 text Question 25 1 out of 1 points
Correct Using network terminology, a relationship is called a(n) ____.
Question 25 answers
Selected Answer: Correct set
---------------------------------------------------------------------------------
Question 1 0 out of 1 points
Incorrect Metadata provide the description of the data characteristics but do not describe the set relationships that link the data found within the database.
Question 1 answers
Selected Answer: Incorrect True
Question 2 text Question 2 1 out of 1 points
Correct Accurate, relevant, and timely information is the key to good decision making.
Question 2 answers
Selected Answer: Correct True
Question 3 text Question 3 1 out of 1 points
Correct The "information age" refers to:
Question 3 answers
Selected Answer: Correct the production of accurate and relevant information being key to good decision making
Question 4 text Question 4 1 out of 1 points
Correct The ____ manages interaction between the end user and the database.
Question 4 answers
Selected Answer: Correct DBMS
Question 5 text Question 5 1 out of 1 points
Correct Which of the following is considered a data anomaly?
Question 5 answers
Selected Answer: Correct Modification
Question 6 text Question 6 1 out of 1 points
Correct There are three different types of anomalies: update, insertion, and deletion.
Question 6 answers
Selected Answer: Correct True
Question 7 text Question 7 1 out of 1 points
Correct An ad hoc query is a spur-of-the-moment question.
Question 7 answers
Selected Answer: Correct True
Question 8 text Question 8 1 out of 1 points
Correct Which of the following is a limitation of the file system environment?
Question 8 answers
Selected Answer: Correct security features are likely to be inadequate
Question 9 text Question 9 1 out of 1 points
Correct The DBMS serves as an intermediary between the end user and the database.
Question 9 answers
Selected Answer: Correct True
Question 10 text Question 10 1 out of 1 points
Correct A record consists of a ____.
Question 10 answers
Selected Answer: Correct set of one or more fields
Question 11 text Question 11 1 out of 1 points
Correct Database management systems, operating systems, applications, and utilities are all examples of ____.
Question 11 answers
Selected Answer: Correct software
Question 12 text Question 12 1 out of 1 points
Correct Which of the following is NOT a data anomaly?
Question 12 answers
Selected Answer: Correct Correction
Question 13 text Question 13 1 out of 1 points
Correct Each segment in a hierarchical structure is referenced by a path.
Question 13 answers
Selected Answer: Correct True
Question 14 text Question 14 1 out of 1 points
Correct What type of relationship is expressed with the phrase “Painter paints Painting”?
Question 14 answers
Selected Answer: Correct 1:M
Question 15 text Question 15 1 out of 1 points
Correct The network database models have a(n) ____.
Question 15 answers
Selected Answer: Correct owner/member relationship that promotes database integrity
Question 16 text Question 16 0 out of 1 points
Incorrect The developer of the relational model worked for Microsoft.
Question 16 answers
Selected Answer: Incorrect True
Question 17 text Question 17 0 out of 1 points
Incorrect A model is an exact representation of a real-world event.
Question 17 answers
Selected Answer: Incorrect True
Question 18 text Question 18 1 out of 1 points
Correct In the network model, it is possible for a member to exist without an owner.
Question 18 answers
Selected Answer: Correct False
Question 19 text Question 19 1 out of 1 points
Correct Using network terminology, a relationship is called a(n) ____.
Question 19 answers
Selected Answer: Correct set
Question 20 text Question 20 1 out of 1 points
Correct The hierarchical database models ____.
Question 20 answers
Selected Answer: Correct promote database integrity
Question 21 text Question 21 1 out of 1 points
Correct An entity is a person, place, or thing about which data are to be collected and stored.
Question 21 answers
Selected Answer: Correct True
Question 22 text Question 22 0 out of 1 points
Incorrect A relational database model ____.
Question 22 answers
Selected Answer: Incorrect allows trained people to use a good system poorly
Question 23 text Question 23 1 out of 1 points
Correct Which model operates at the lowest level of abstraction?
Question 23 answers
Selected Answer: Correct Physical
Question 24 text Question 24 0 out of 1 points
Incorrect The ____ model adapts a conceptual model to a specific DBMS.
Question 24 answers
Selected Answer: Incorrect entity
Question 25 text Question 25 0 out of 1 points
Incorrect A data model is built out of tables, rows, and columns.
Question 25 answers
Selected Answer: Incorrect True
-------------------------------------------------------------------------------------
Question 1 0 out of 1 points
Incorrect Metadata provide the description of the data characteristics but do not describe the set relationships that link the data found within the database.
Question 1 answers
Selected Answer: Incorrect True
Question 2 text Question 2 1 out of 1 points
Correct Accurate, relevant, and timely information is the key to good decision making.
Question 2 answers
Selected Answer: Correct True
Question 3 text Question 3 1 out of 1 points
Correct The "information age" refers to:
Question 3 answers
Selected Answer: Correct the production of accurate and relevant information being key to good decision making
Question 4 text Question 4 1 out of 1 points
Correct The ____ manages interaction between the end user and the database.
Question 4 answers
Selected Answer: Correct DBMS
Question 5 text Question 5 1 out of 1 points
Correct Which of the following is considered a data anomaly?
Question 5 answers
Selected Answer: Correct Modification
Question 6 text Question 6 1 out of 1 points
Correct There are three different types of anomalies: update, insertion, and deletion.
Question 6 answers
Selected Answer: Correct True
Question 7 text Question 7 1 out of 1 points
Correct An ad hoc query is a spur-of-the-moment question.
Question 7 answers
Selected Answer: Correct True
Question 8 text Question 8 1 out of 1 points
Correct Which of the following is a limitation of the file system environment?
Question 8 answers
Selected Answer: Correct security features are likely to be inadequate
Question 9 text Question 9 1 out of 1 points
Correct The DBMS serves as an intermediary between the end user and the database.
Question 9 answers
Selected Answer: Correct True
Question 10 text Question 10 1 out of 1 points
Correct A record consists of a ____.
Question 10 answers
Selected Answer: Correct set of one or more fields
Question 11 text Question 11 1 out of 1 points
Correct Database management systems, operating systems, applications, and utilities are all examples of ____.
Question 11 answers
Selected Answer: Correct software
Question 12 text Question 12 1 out of 1 points
Correct Which of the following is NOT a data anomaly?
Question 12 answers
Selected Answer: Correct Correction
Question 13 text Question 13 1 out of 1 points
Correct Each segment in a hierarchical structure is referenced by a path.
Question 13 answers
Selected Answer: Correct True
Question 14 text Question 14 1 out of 1 points
Correct What type of relationship is expressed with the phrase “Painter paints Painting”?
Question 14 answers
Selected Answer: Correct 1:M
Question 15 text Question 15 1 out of 1 points
Correct The network database models have a(n) ____.
Question 15 answers
Selected Answer: Correct owner/member relationship that promotes database integrity
Question 16 text Question 16 0 out of 1 points
Incorrect The developer of the relational model worked for Microsoft.
Question 16 answers
Selected Answer: Incorrect True
Question 17 text Question 17 0 out of 1 points
Incorrect A model is an exact representation of a real-world event.
Question 17 answers
Selected Answer: Incorrect True
Question 18 text Question 18 1 out of 1 points
Correct In the network model, it is possible for a member to exist without an owner.
Question 18 answers
Selected Answer: Correct False
Question 19 text Question 19 1 out of 1 points
Correct Using network terminology, a relationship is called a(n) ____.
Question 19 answers
Selected Answer: Correct set
Question 20 text Question 20 1 out of 1 points
Correct The hierarchical database models ____.
Question 20 answers
Selected Answer: Correct promote database integrity
Question 21 text Question 21 1 out of 1 points
Correct An entity is a person, place, or thing about which data are to be collected and stored.
Question 21 answers
Selected Answer: Correct True
Question 22 text Question 22 0 out of 1 points
Incorrect A relational database model ____.
Question 22 answers
Selected Answer: Incorrect allows trained people to use a good system poorly
Question 23 text Question 23 1 out of 1 points
Correct Which model operates at the lowest level of abstraction?
Question 23 answers
Selected Answer: Correct Physical
Question 24 text Question 24 0 out of 1 points
Incorrect The ____ model adapts a conceptual model to a specific DBMS.
Question 24 answers
Selected Answer: Incorrect entity
Question 25 text Question 25 0 out of 1 points
Incorrect A data model is built out of tables, rows, and columns.
Question 25 answers
Selected Answer: Incorrect True1
---------------------------------------------------------------------------
Question 1 1 out of 1 points
Correct There are three different types of anomalies: update, insertion, and deletion.
Question 1 answers
Selected Answer: Correct True
Question 2 text Question 2 1 out of 1 points
Correct Data constitute the building blocks of information.
Question 2 answers
Selected Answer: Correct True
Question 3 text Question 3 0 out of 1 points
Incorrect A DBMS that supports hundreds of users at multiple sites is called a(n) workgroup DBMS.
Question 3 answers
Selected Answer: Incorrect True
Question 4 text Question 4 1 out of 1 points
Correct Where does the DBMS store the definitions of data elements and their relationships?
Question 4 answers
Selected Answer: Correct Data dictionary
Question 5 text Question 5 1 out of 1 points
Correct Structural dependence occurs when access to the file is dependent on its structure.
Question 5 answers
Selected Answer: Correct True
Question 6 text Question 6 1 out of 1 points
Correct Which of the following is NOT a data anomaly?
Question 6 answers
Selected Answer: Correct Correction
Question 7 text Question 7 1 out of 1 points
Correct Which of the following is a limitation of the file system environment?
Question 7 answers
Selected Answer: Correct security features are likely to be inadequate
Question 8 text Question 8 1 out of 1 points
Correct The ____ manages interaction between the end user and the database.
Question 8 answers
Selected Answer: Correct DBMS
Question 9 text Question 9 0 out of 1 points
Incorrect A database system contains all of the following components:
Question 9 answers
Selected Answer: Incorrect software, people, information, procedures
Question 10 text Question 10 1 out of 1 points
Correct Data consistency exists when different and conflicting versions of the same data appear in different places.
Question 10 answers
Selected Answer: Correct False
Question 11 text Question 11 0 out of 1 points
Incorrect Database professionals use the term “islands of data” to label scattered data locations.
Question 11 answers
Selected Answer: Incorrect True
Question 12 text Question 12 0 out of 1 points
Incorrect In a database environment, the DP is promoted to ____.
Question 12 answers
Selected Answer: Incorrect database administrator
Question 13 text Question 13 1 out of 1 points
Correct A relational DBMS is a single data repository in which data independence is maintained.
Question 13 answers
Selected Answer: Correct True
Question 14 text Question 14 1 out of 1 points
Correct Business rules help you determine the relationships that exist between entities.
Question 14 answers
Selected Answer: Correct True
Question 15 text Question 15 0 out of 1 points
Incorrect The ____ model adapts a conceptual model to a specific DBMS.
Question 15 answers
Selected Answer: Incorrect database
Question 16 text Question 16 1 out of 1 points
Correct Because an RDBMS hides the system's complexity from the user/designer, ____.
Question 16 answers
Selected Answer: Correct data management is easier
Question 17 text Question 17 0 out of 1 points
Incorrect The ____ model is the relational model’s challenge to the OODM.
Question 17 answers
Selected Answer: Incorrect hierarchical
Question 18 text Question 18 1 out of 1 points
Correct Successful database design is first and foremost based on ____.
Question 18 answers
Selected Answer: Correct end-user requirements
Question 19 text Question 19 1 out of 1 points
Correct Which of the following data models contains the most semantics?
Question 19 answers
Selected Answer: Correct Object-oriented
Question 20 text Question 20 1 out of 1 points
Correct One of the advantages of the hierarchical model is the ease of maintaining data integrity.
Question 20 answers
Selected Answer: Correct True
Question 21 text Question 21 1 out of 1 points
Correct What type of relationship is expressed with the phrase “Painter paints Painting”?
Question 21 answers
Selected Answer: Correct 1:M
Question 22 text Question 22 0 out of 1 points
Incorrect Each row in the relational table is known as an entity ____.
Question 22 answers
Selected Answer: Incorrect model
Question 23 text Question 23 0 out of 1 points
Incorrect The hierarchical model was the first to define a standard DML and DDL.
Question 23 answers
Selected Answer: Incorrect True
Question 24 text Question 24 0 out of 1 points
Incorrect Which of the following data models contains the least semantics?
Question 24 answers
Selected Answer: Incorrect Relational
Question 25 text Question 25 0 out of 1 points
Incorrect Business rules are policies written in the employee handbook.
Question 25 answers
Selected Answer: Incorrect True
------------------------------------------------------------------------------------
Question 1 1 out of 1 points
Correct Data inconsistency exists when different and conflicting versions of the same data appear in different places.
Question 1 answers
Selected Answer: Correct True
Question 2 text Question 2 1 out of 1 points
Correct The ____ manages interaction between the end user and the database.
Question 2 answers
Selected Answer: Correct DBMS
Question 3 text Question 3 1 out of 1 points
Correct Which of the following is NOT a data anomaly?
Question 3 answers
Selected Answer: Correct Correction
Question 4 text Question 4 0 out of 1 points
Incorrect A raw fact, such as an invoice date, is known as ____.
Question 4 answers
Selected Answer: Incorrect information
Question 5 text Question 5 1 out of 1 points
Correct An operating system is part of the computer’s hardware.
Question 5 answers
Selected Answer: Correct False
Question 6 text Question 6 1 out of 1 points
Correct John is working in the customer table and needs to know what customers are located in Florida. To find the information, he would ____.
Question 6 answers
Selected Answer: Correct create a new query
Question 7 text Question 7 0 out of 1 points
Incorrect Data anomalies exist because a change in any field value can't be made in multiple places.
Question 7 answers
Selected Answer: Incorrect True
Question 8 text Question 8 1 out of 1 points
Correct Accurate, relevant, and timely information is the key to good decision making.
Question 8 answers
Selected Answer: Correct True
Question 9 text Question 9 1 out of 1 points
Correct A logically connected set of one or more fields that describes a person, place, or thing is a(n):
Question 9 answers
Selected Answer: Correct a record
Question 10 text Question 10 0 out of 1 points
Incorrect Metadata provide the description of the data characteristics but do not describe the set relationships that link the data found within the database.
Question 10 answers
Selected Answer: Incorrect True
Question 11 text Question 11 1 out of 1 points
Correct Workgroup databases usually serve up to 100 users.
Question 11 answers
Selected Answer: Correct False
Question 12 text Question 12 0 out of 1 points
Incorrect Activities that make the database perform more efficiently, in terms of storage and access speed, are known as performance ____.
Question 12 answers
Selected Answer: Incorrect upgrades
Question 13 text Question 13 0 out of 1 points
Incorrect The most important advantages of the hierarchical database model are ____.
Question 13 answers
Selected Answer: Incorrect integrity, efficiency, diversity, independence, and simplicity
Question 14 text Question 14 0 out of 1 points
Incorrect The DBTG report contained specifications for a schema and subschema.
Question 14 answers
Selected Answer: Incorrect False
Question 15 text Question 15 1 out of 1 points
Correct The developer of the relational model worked for Microsoft.
Question 15 answers
Selected Answer: Correct False
Question 16 text Question 16 1 out of 1 points
Correct One of the disadvantages of the network model was the lack of structural independence.
Question 16 answers
Selected Answer: Correct True
Question 17 text Question 17 1 out of 1 points
Correct Which of the following data models contains the most semantics?
Question 17 answers
Selected Answer: Correct Object-oriented
Question 18 text Question 18 0 out of 1 points
Incorrect The ____ model adapts a conceptual model to a specific DBMS.
Question 18 answers
Selected Answer: Incorrect database
Question 19 text Question 19 0 out of 1 points
Incorrect The RDBMS ____.
Question 19 answers
Selected Answer: Incorrect allows the user/designer to ignore the logical view of the database
Question 20 text Question 20 1 out of 1 points
Correct Business rules help you determine the relationships that exist between entities.
Question 20 answers
Selected Answer: Correct True
Question 21 text Question 21 0 out of 1 points
Incorrect A data model is built out of tables, rows, and columns.
Question 21 answers
Selected Answer: Incorrect True
Question 22 text Question 22 1 out of 1 points
Correct In a network database each set is composed of two record types: an owner record and a ____ record.
Question 22 answers
Selected Answer: Correct member
Question 23 text Question 23 1 out of 1 points
Correct Relations are related to each other by sharing a common entity characteristic.
Question 23 answers
Selected Answer: Correct True
Question 24 text Question 24 0 out of 1 points
Incorrect A data model represents data structures and their characteristics.
Question 24 answers
Selected Answer: Incorrect False
Question 25 text Question 25 0 out of 1 points
Incorrect The only relationship type supported by the hierarchical model is 1:1.
Question 25 answers
Selected Answer: Incorrect True
-------------------------------------------------------------------------------
Question 1 1 out of 1 points
Correct Which of the following is considered a data anomaly?
Question 1 answers
Selected Answer: Correct Modification
Question 2 text Question 2 1 out of 1 points
Correct Activities that make the database perform more efficiently, in terms of storage and access speed, are known as performance ____.
Question 2 answers
Selected Answer: Correct tuning
Question 3 text Question 3 1 out of 1 points
Correct The DBMS serves as an intermediary between the end user and the database.
Question 3 answers
Selected Answer: Correct True
Question 4 text Question 4 0 out of 1 points
Incorrect A database system contains all of the following components:
Question 4 answers
Selected Answer: Incorrect software, people, information, procedures
Question 5 text Question 5 1 out of 1 points
Correct Workgroup databases usually serve up to 100 users.
Question 5 answers
Selected Answer: Correct False
Question 6 text Question 6 0 out of 1 points
Incorrect A database that is primarily designed to support a company’s day-to-day operations is called a data warehouse.
Question 6 answers
Selected Answer: Incorrect True
Question 7 text Question 7 1 out of 1 points
Correct Data inconsistency exists when different and conflicting versions of the same data appear in different places.
Question 7 answers
Selected Answer: Correct True
Question 8 text Question 8 1 out of 1 points
Correct A logically connected set of one or more fields that describes a person, place, or thing is a(n):
Question 8 answers
Selected Answer: Correct a record
Question 9 text Question 9 1 out of 1 points
Correct A multiuser database that supports a small number of users, or a specific department, is called a workgroup database.
Question 9 answers
Selected Answer: Correct True
Question 10 text Question 10 0 out of 1 points
Incorrect Programming in a(n) ____ can be a time-consuming and high-skill activity.
Question 10 answers
Selected Answer: Incorrect AIS
Question 11 text Question 11 1 out of 1 points
Correct A database that supports only one user at a time is a:
Question 11 answers
Selected Answer: Correct single-user database
Question 12 text Question 12 0 out of 1 points
Incorrect ____ is defined as "the condition in which all of the data in the database are consistent with the real-world events and conditions."
Question 12 answers
Selected Answer: Incorrect data processing
Question 13 text Question 13 1 out of 1 points
Correct What type of relationship is expressed with the phrase “Painter paints Painting”?
Question 13 answers
Selected Answer: Correct 1:M
Question 14 text Question 14 0 out of 1 points
Incorrect A relational database is a group of ____.
Question 14 answers
Selected Answer: Incorrect common fields
Question 15 text Question 15 1 out of 1 points
Correct A data model must represent the ____ world as closely as possible.
Question 15 answers
Selected Answer: Correct real
Question 16 text Question 16 1 out of 1 points
Correct The developer of the relational model worked for Microsoft.
Question 16 answers
Selected Answer: Correct False
Question 17 text Question 17 1 out of 1 points
Correct Data modeling is usually skipped due to time constraints.
Question 17 answers
Selected Answer: Correct False
Question 18 text Question 18 0 out of 1 points
Incorrect Many-to-many relationships are easily represented using a hierarchical model.
Question 18 answers
Selected Answer: Incorrect True
Question 19 text Question 19 1 out of 1 points
Correct Which of the following database models is NOT still in use today?
Question 19 answers
Selected Answer: Correct Network
Question 20 text Question 20 1 out of 1 points
Correct Given its parent/child structure, the hierarchical model yields integrity and consistency; there cannot be ____.
Question 20 answers
Selected Answer: Correct a child without a parent
Question 21 text Question 21 0 out of 1 points
Incorrect The ____ model is the relational model’s challenge to the OODM.
Question 21 answers
Selected Answer: Incorrect hierarchical
Question 22 text Question 22 1 out of 1 points
Correct Successful database design is first and foremost based on ____.
Question 22 answers
Selected Answer: Correct end-user requirements
Question 23 text Question 23 0 out of 1 points
Incorrect The ____ model adapts a conceptual model to a specific DBMS.
Question 23 answers
Selected Answer: Incorrect external
Question 24 text Question 24 1 out of 1 points
Correct Each segment in a hierarchical structure is referenced by a path.
Question 24 answers
Selected Answer: Correct True
Question 25 text Question 25 1 out of 1 points
Correct SQL makes pure ad hoc queries a reality.
Question 25 answers
Selected Answer: Correct True
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Question 1 0 out of 1 points
Incorrect A DBMS that supports hundreds of users at multiple sites is called a(n) workgroup DBMS.
Question 1 answers
Selected Answer: Incorrect True
Question 2 text Question 2 1 out of 1 points
Correct A database that supports data distributed across several different sites is called a(n) centralized DBMS.
Question 2 answers
Selected Answer: Correct False
Question 3 text Question 3 1 out of 1 points
Correct The "information age" refers to:
Question 3 answers
Selected Answer: Correct the production of accurate and relevant information being key to good decision making
Question 4 text Question 4 1 out of 1 points
Correct The DBMS allows you to extrapolate information from your data by using a(n) ____.
Question 4 answers
Selected Answer: Correct query language
Question 5 text Question 5 1 out of 1 points
Correct A single-user database can only support one user at a time.
Question 5 answers
Selected Answer: Correct True
Question 6 text Question 6 1 out of 1 points
Correct ____ are the people who run the organization’s daily operations.
Question 6 answers
Selected Answer: Correct End users
Question 7 text Question 7 1 out of 1 points
Correct Data inconsistency exists when different and conflicting versions of the same data appear in different places.
Question 7 answers
Selected Answer: Correct True
Question 8 text Question 8 1 out of 1 points
Correct SQL is:
Question 8 answers
Selected Answer: Correct a structured query language
Question 9 text Question 9 1 out of 1 points
Correct Of the languages listed below, which is NOTconsidered a3GL?
Question 9 answers
Selected Answer: Correct Query Language
Question 10 text Question 10 1 out of 1 points
Correct The structure of the contents of a database does not need to be designed carefully.
Question 10 answers
Selected Answer: Correct False
Question 11 text Question 11 0 out of 1 points
Incorrect A(n) computer system refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.
Question 11 answers
Selected Answer: Incorrect True
Question 12 text Question 12 0 out of 1 points
Incorrect Data that display data inconsistency are referred to as lacking data cohesion.
Question 12 answers
Selected Answer: Incorrect True
Question 13 text Question 13 1 out of 1 points
Correct Each segment in a hierarchical structure is referenced by a path.
Question 13 answers
Selected Answer: Correct True
Question 14 text Question 14 1 out of 1 points
Correct Hierarchal databases became popular in the 1980s.
Question 14 answers
Selected Answer: Correct False
Question 15 text Question 15 1 out of 1 points
Correct A matrix consisting of a series of a row and column intersection is a table.
Question 15 answers
Selected Answer: Correct True
Question 16 text Question 16 1 out of 1 points
Correct Which of the following is not a degree of abstraction as defined by ANSI/SPARC?
Question 16 answers
Selected Answer: Correct Physical
Question 17 text Question 17 1 out of 1 points
Correct Database models can be grouped into two categories: conceptual models and ____ models.
Question 17 answers
Selected Answer: Correct implementation
Question 18 text Question 18 0 out of 1 points
Incorrect Which model represents the end user’s view of the database?
Question 18 answers
Selected Answer: Incorrect Conceptual
Question 19 text Question 19 1 out of 1 points
Correct The DBTG report contained specifications for a schema and subschema.
Question 19 answers
Selected Answer: Correct True
Question 20 text Question 20 1 out of 1 points
Correct The ____ model is the relational model’s challenge to the OODM.
Question 20 answers
Selected Answer: Correct ERD
Question 21 text Question 21 1 out of 1 points
Correct The top layer of the hierarchical model is known as the treetop.
Question 21 answers
Selected Answer: Correct False
Question 22 text Question 22 1 out of 1 points
Correct The OODM ____.
Question 22 answers
Selected Answer: Correct adds semantic content
Question 23 text Question 23 0 out of 1 points
Incorrect Which of the following requires the most detail in the internal model?
Question 23 answers
Selected Answer: Incorrect Semantic
Question 24 text Question 24 1 out of 1 points
Correct The developer of the relational model worked for Microsoft.
Question 24 answers
Selected Answer: Correct False
Question 25 text Question 25 1 out of 1 points
Correct Using network terminology, a relationship is called a(n) ____.
Question 25 answers
Selected Answer: Correct set
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Question 1 0 out of 1 points
Incorrect ____ is defined as "the condition in which all of the data in the database are consistent with the real-world events and conditions."
Question 1 answers
Selected Answer: Incorrect data processing
Question 2 text Question 2 1 out of 1 points
Correct An ad hoc query is a spur-of-the-moment question.
Question 2 answers
Selected Answer: Correct True
Question 3 text Question 3 1 out of 1 points
Correct A database that supports only one user at a time is a:
Question 3 answers
Selected Answer: Correct single-user database
Question 4 text Question 4 1 out of 1 points
Correct The "information age" refers to:
Question 4 answers
Selected Answer: Correct the production of accurate and relevant information being key to good decision making
Question 5 text Question 5 1 out of 1 points
Correct Structural dependence occurs when access to the file is dependent on its structure.
Question 5 answers
Selected Answer: Correct True
Question 6 text Question 6 1 out of 1 points
Correct A database that is primarily designed to support a company’s day-to-day operations is called a data warehouse.
Question 6 answers
Selected Answer: Correct False
Question 7 text Question 7 1 out of 1 points
Correct A database that supports data distributed across several different sites is called a(n) centralized DBMS.
Question 7 answers
Selected Answer: Correct False
Question 8 text Question 8 1 out of 1 points
Correct Data inconsistency exists when different and conflicting versions of the same data appear in different places.
Question 8 answers
Selected Answer: Correct True
Question 9 text Question 9 1 out of 1 points
Correct Activities that make the database perform more efficiently, in terms of storage and access speed, are known as performance ____.
Question 9 answers
Selected Answer: Correct tuning
Question 10 text Question 10 1 out of 1 points
Correct Data is/are:
Question 10 answers
Selected Answer: Correct raw facts
Question 11 text Question 11 1 out of 1 points
Correct A record consists of a ____.
Question 11 answers
Selected Answer: Correct set of one or more fields
Question 12 text Question 12 0 out of 1 points
Incorrect When the DBMS translates logical requests into commands that physically locate and retrieve the requested information, it is fostering data ____.
Question 12 answers
Selected Answer: Incorrect mining
Question 13 text Question 13 1 out of 1 points
Correct Which of the following is least likely to be a business rule as relates to data modeling?
Question 13 answers
Selected Answer: Correct Casual Fridays take place in the summer.
Question 14 text Question 14 0 out of 1 points
Incorrect Database models were developed to ____.
Question 14 answers
Selected Answer: Incorrect deposit data within a single file
Question 15 text Question 15 1 out of 1 points
Correct One of the advantages of the hierarchical model is the ease of maintaining data integrity.
Question 15 answers
Selected Answer: Correct True
Question 16 text Question 16 1 out of 1 points
Correct A table is a matrix consisting of a series of row and column ____.
Question 16 answers
Selected Answer: Correct intersections
Question 17 text Question 17 0 out of 1 points
Incorrect In response to the increasing complexity of applications, two new data models emerged: the object-oriented data model and the ____ relational data model.
Question 17 answers
Selected Answer: Incorrect hierarchical
Question 18 text Question 18 1 out of 1 points
Correct A data model represents data structures and their characteristics.
Question 18 answers
Selected Answer: Correct True
Question 19 text Question 19 1 out of 1 points
Correct Which model operates at the lowest level of abstraction?
Question 19 answers
Selected Answer: Correct Physical
Question 20 text Question 20 0 out of 1 points
Incorrect Which of the following requires the most detail in the internal model?
Question 20 answers
Selected Answer: Incorrect Entity relationship
Question 21 text Question 21 1 out of 1 points
Correct A model is an exact representation of a real-world event.
Question 21 answers
Selected Answer: Correct False
Question 22 text Question 22 1 out of 1 points
Correct Which of the following data models contains the most semantics?
Question 22 answers
Selected Answer: Correct Object-oriented
Question 23 text Question 23 1 out of 1 points
Correct A data model must represent the ____ world as closely as possible.
Question 23 answers
Selected Answer: Correct real
Question 24 text Question 24 0 out of 1 points
Incorrect In 1975, it was decided that all databases should conform to the SPARC standard.
Question 24 answers
Selected Answer: Incorrect True
Question 25 text Question 25 0 out of 1 points
Incorrect The most important advantages of the hierarchical database model are ____.
Question 25 answers
Selected Answer: Incorrect security, efficiency, diversity, simplicity, and integrity
OK
Question 1 1 out of 1 points
Correct The DBMS serves as an intermediary between the end user and the database.
Question 1 answers
Selected Answer: Correct True
Question 2 text Question 2 1 out of 1 points
Correct An ad hoc query is a ____.
Question 2 answers
Selected Answer: Correct spur-of-the-moment question
Question 3 text Question 3 1 out of 1 points
Correct Structural dependence occurs when access to the file is dependent on its structure.
Question 3 answers
Selected Answer: Correct True
Question 4 text Question 4 1 out of 1 points
Correct Database professionals use the term “islands of data” to label scattered data locations.
Question 4 answers
Selected Answer: Correct False
Question 5 text Question 5 0 out of 1 points
Incorrect The number of users determines whether the DBMS is classified as single-system or multiuser.
Question 5 answers
Selected Answer: Incorrect True
Question 6 text Question 6 0 out of 1 points
Incorrect A database system contains all of the following components:
Question 6 answers
Selected Answer: Incorrect hardware, people, information, procedures
Question 7 text Question 7 1 out of 1 points
Correct There are three different types of anomalies: update, insertion, and deletion.
Question 7 answers
Selected Answer: Correct True
Question 8 text Question 8 1 out of 1 points
Correct An ad hoc query is a spur-of-the-moment question.
Question 8 answers
Selected Answer: Correct True
Question 9 text Question 9 1 out of 1 points
Correct ____ is defined as "the condition in which all of the data in the database are consistent with the real-world events and conditions."
Question 9 answers
Selected Answer: Correct data integrity
Question 10 text Question 10 1 out of 1 points
Correct Data that display data inconsistency are referred to as lacking data cohesion.
Question 10 answers
Selected Answer: Correct False
Question 11 text Question 11 0 out of 1 points
Incorrect Having fields stored in one location produces data redundancy.
Question 11 answers
Selected Answer: Incorrect True
Question 12 text Question 12 1 out of 1 points
Correct Because all data access programs are subject to change when any of the file’s data storage characteristics change, the file system is said to exhibit structural dependence.
Question 12 answers
Selected Answer: Correct False
Question 13 text Question 13 1 out of 1 points
Correct The top layer of the hierarchical model is known as the treetop.
Question 13 answers
Selected Answer: Correct False
Question 14 text Question 14 1 out of 1 points
Correct Which of the following was NOT produced by the DBTG of CODASYL?
Question 14 answers
Selected Answer: Correct Standard diagrams for database modeling known as ERD
Question 15 text Question 15 1 out of 1 points
Correct Because an RDBMS hides the system's complexity from the user/designer, ____.
Question 15 answers
Selected Answer: Correct data management is easier
Question 16 text Question 16 0 out of 1 points
Incorrect In response to the increasing complexity of applications, two new data models emerged: the object-oriented data model and the ____ relational data model.
Question 16 answers
Selected Answer: Incorrect entity
Question 17 text Question 17 1 out of 1 points
Correct One of the disadvantages of the network model was the lack of structural independence.
Question 17 answers
Selected Answer: Correct True
Question 18 text Question 18 1 out of 1 points
Correct A data model is built out of tables, rows, and columns.
Question 18 answers
Selected Answer: Correct False
Question 19 text Question 19 1 out of 1 points
Correct A data model must represent the ____ world as closely as possible.
Question 19 answers
Selected Answer: Correct real
Question 20 text Question 20 1 out of 1 points
Correct One of the advantages of the hierarchical model is the ease of maintaining data integrity.
Question 20 answers
Selected Answer: Correct True
Question 21 text Question 21 0 out of 1 points
Incorrect Which model represents the end user’s view of the database?
Question 21 answers
Selected Answer: Incorrect Physical
Question 22 text Question 22 0 out of 1 points
Incorrect One of the advantages of a relational database model is ____.
Question 22 answers
Selected Answer: Incorrect structural dependence
Question 23 text Question 23 1 out of 1 points
Correct Many-to-many relationships are easily represented using a hierarchical model.
Question 23 answers
Selected Answer: Correct False
Question 24 text Question 24 1 out of 1 points
Correct What type of relationship is expressed with the phrase “Employee manages Store”?
Question 24 answers
Selected Answer: Correct 1:1
Question 25 text Question 25 1 out of 1 points
Correct Hierarchal databases became popular in the 1980s.
Question 25 answers
Selected Answer: Correct False
5678156781678341567248356741657846578167856156165461564715641654654154781567125
Question 1 1 out of 1 points
Correct Database management systems, operating systems, applications, and utilities are all examples of ____.
Question 1 answers
Selected Answer: Correct software
Question 2 text Question 2 1 out of 1 points
Correct A logically connected set of one or more fields that describes a person, place, or thing is a(n):
Question 2 answers
Selected Answer: Correct a record
Question 3 text Question 3 1 out of 1 points
Correct The structure of the contents of a database does not need to be designed carefully.
Question 3 answers
Selected Answer: Correct False
Question 4 text Question 4 1 out of 1 points
Correct A record consists of a ____.
Question 4 answers
Selected Answer: Correct set of one or more fields
Question 5 text Question 5 1 out of 1 points
Correct Workgroup databases usually serve up to 100 users.
Question 5 answers
Selected Answer: Correct False
Question 6 text Question 6 1 out of 1 points
Correct Activities that make the database perform more efficiently, in terms of storage and access speed, are known as performance ____.
Question 6 answers
Selected Answer: Correct tuning
Question 7 text Question 7 1 out of 1 points
Correct The DBMS stores definitions of the data elements and their relationships in a:
Question 7 answers
Selected Answer: Correct data dictionary
Question 8 text Question 8 1 out of 1 points
Correct Another name for a production database is a ____ database.
Question 8 answers
Selected Answer: Correct transactional
Question 9 text Question 9 1 out of 1 points
Correct Data inconsistency exists when different and conflicting versions of the same data appear in different places.
Question 9 answers
Selected Answer: Correct True
Question 10 text Question 10 1 out of 1 points
Correct Database professionals use the term “islands of data” to label scattered data locations.
Question 10 answers
Selected Answer: Correct False
Question 11 text Question 11 1 out of 1 points
Correct Which of the following is considered a data anomaly?
Question 11 answers
Selected Answer: Correct Modification
Question 12 text Question 12 1 out of 1 points
Correct A raw fact, such as an invoice date, is known as ____.
Question 12 answers
Selected Answer: Correct data
Question 13 text Question 13 1 out of 1 points
Correct The most important advantages of the hierarchical database model are ____.
Question 13 answers
Selected Answer: Correct conceptual simplicity, security, independence, integrity, and efficiency
Question 14 text Question 14 0 out of 1 points
Incorrect Which of the following requires the most detail in the internal model?
Question 14 answers
Selected Answer: Incorrect Relational
Question 15 text Question 15 1 out of 1 points
Correct A data model is built out of tables, rows, and columns.
Question 15 answers
Selected Answer: Correct False
Question 16 text Question 16 1 out of 1 points
Correct What type of relationship is expressed with the phrase “Student takes Class”?
Question 16 answers
Selected Answer: Correct M:N
Question 17 text Question 17 1 out of 1 points
Correct Successful database design is first and foremost based on ____.
Question 17 answers
Selected Answer: Correct end-user requirements
Question 18 text Question 18 1 out of 1 points
Correct A matrix consisting of a series of a row and column intersection is a table.
Question 18 answers
Selected Answer: Correct True
Question 19 text Question 19 1 out of 1 points
Correct The hierarchical database models ____.
Question 19 answers
Selected Answer: Correct promote database integrity
Question 20 text Question 20 1 out of 1 points
Correct Which of the following is not a degree of abstraction as defined by ANSI/SPARC?
Question 20 answers
Selected Answer: Correct Physical
Question 21 text Question 21 1 out of 1 points
Correct In the network model, it is possible for a member to exist without an owner.
Question 21 answers
Selected Answer: Correct False
Question 22 text Question 22 1 out of 1 points
Correct Which of the following is least likely to be a business rule as relates to data modeling?
Question 22 answers
Selected Answer: Correct Casual Fridays take place in the summer.
Question 23 text Question 23 0 out of 1 points
Incorrect Which model represents the end user’s view of the database?
Question 23 answers
Selected Answer: Incorrect Internal
Question 24 text Question 24 0 out of 1 points
Incorrect The RDBMS ____.
Question 24 answers
Selected Answer: Incorrect does not manage the details of physical storage
Question 25 text Question 25 1 out of 1 points
Correct One of the advantages of the hierarchical model is the ease of maintaining data integrity.
Question 25 answers
Selected Answer: Correct True
ipod touch iphone ipod gig 8 16 32 64 hack mod modding tune tuning moew chipotle fax
Question 1 1 out of 1 points
Correct Of the languages listed below, which is NOTconsidered a3GL?
Question 1 answers
Selected Answer: Correct Query Language
Question 2 text Question 2 1 out of 1 points
Correct Structural dependence occurs when access to the file is dependent on its structure.
Question 2 answers
Selected Answer: Correct True
Question 3 text Question 3 1 out of 1 points
Correct A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. Which of the following is NOT one of those functions?
Question 3 answers
Selected Answer: Correct Data reports
Question 4 text Question 4 1 out of 1 points
Correct Which of the following is a limitation of the file system environment?
Question 4 answers
Selected Answer: Correct security features are likely to be inadequate
Question 5 text Question 5 1 out of 1 points
Correct A(n) ad hoc query is a spur-of-the-moment question.
Question 5 answers
Selected Answer: Correct True
Question 6 text Question 6 1 out of 1 points
Correct Metadata is:
Question 6 answers
Selected Answer: Correct data about data
Question 7 text Question 7 1 out of 1 points
Correct ____ are the people who run the organization’s daily operations.
Question 7 answers
Selected Answer: Correct End users
Question 8 text Question 8 1 out of 1 points
Correct A ____ system is composed of software, hardware, procedures, and people.
Question 8 answers
Selected Answer: Correct database
Question 9 text Question 9 1 out of 1 points
Correct Activities that make the database perform more efficiently, in terms of storage and access speed, are known as performance ____.
Question 9 answers
Selected Answer: Correct tuning
Question 10 text Question 10 1 out of 1 points
Correct Which of the following is NOT a data anomaly?
Question 10 answers
Selected Answer: Correct Correction
Question 11 text Question 11 1 out of 1 points
Correct A logically connected set of one or more fields that describes a person, place, or thing is a(n):
Question 11 answers
Selected Answer: Correct a record
Question 12 text Question 12 1 out of 1 points
Correct An ad hoc query is a spur-of-the-moment question.
Question 12 answers
Selected Answer: Correct True
Question 13 text Question 13 1 out of 1 points
Correct The limitations of the hierarchical model are that none of the concepts defined by that model are in use today.
Question 13 answers
Selected Answer: Correct False
Question 14 text Question 14 1 out of 1 points
Correct In network database terminology, 1:M relationships are represented using a database table.
Question 14 answers
Selected Answer: Correct True
Question 15 text Question 15 1 out of 1 points
Correct Each segment in a hierarchical structure is referenced by a path.
Question 15 answers
Selected Answer: Correct True
Question 16 text Question 16 0 out of 1 points
Incorrect A way of classifying data models is by degree of ____.
Question 16 answers
Selected Answer: Incorrect unification
Question 17 text Question 17 1 out of 1 points
Correct A(n) ____ model is independent of both hardware and software.
Question 17 answers
Selected Answer: Correct conceptual
Question 18 text Question 18 1 out of 1 points
Correct Using network terminology, a relationship is called a(n) ____.
Question 18 answers
Selected Answer: Correct set
Question 19 text Question 19 1 out of 1 points
Correct Business rules help you determine the relationships that exist between entities.
Question 19 answers
Selected Answer: Correct True
Question 20 text Question 20 1 out of 1 points
Correct Which of the following requires the most detail in the internal model?
Question 20 answers
Selected Answer: Correct Network
Question 21 text Question 21 1 out of 1 points
Correct A matrix consisting of a series of a row and column intersection is a table.
Question 21 answers
Selected Answer: Correct True
Question 22 text Question 22 1 out of 1 points
Correct The top layer of the hierarchical model is known as the treetop.
Question 22 answers
Selected Answer: Correct False
Question 23 text Question 23 1 out of 1 points
Correct The hierarchical database models ____.
Question 23 answers
Selected Answer: Correct promote database integrity
Question 24 text Question 24 0 out of 1 points
Incorrect Which of the following databases does NOT provide structural independence?
Question 24 answers
Selected Answer: Incorrect object oriented
Question 25 text Question 25 1 out of 1 points
Correct A relational DBMS is a single data repository in which data independence is maintained.
Question 25 answers
Selected Answer: Correct True
cheap ram, hardware software free music unlimited download video youtube adbrite adsense oxado commission junction
Question 1 1 out of 1 points
Correct Activities that make the database perform more efficiently, in terms of storage and access speed, are known as performance ____.
Question 1 answers
Selected Answer: Correct tuning
Question 2 text Question 2 1 out of 1 points
Correct Data anomalies exist because a change in any field value can't be made in multiple places.
Question 2 answers
Selected Answer: Correct False
Question 3 text Question 3 1 out of 1 points
Correct John is working in the customer table and needs to know what customers are located in Florida. To find the information, he would ____.
Question 3 answers
Selected Answer: Correct create a new query
Question 4 text Question 4 1 out of 1 points
Correct A(n) ad hoc query is a spur-of-the-moment question.
Question 4 answers
Selected Answer: Correct True
Question 5 text Question 5 1 out of 1 points
Correct The DBMS allows you to extrapolate information from your data by using a(n) ____.
Question 5 answers
Selected Answer: Correct query language
Question 6 text Question 6 1 out of 1 points
Correct Accurate, relevant, and timely information is the key to good decision making.
Question 6 answers
Selected Answer: Correct True
Question 7 text Question 7 1 out of 1 points
Correct Database professionals use the term “islands of data” to label scattered data locations.
Question 7 answers
Selected Answer: Correct False
Question 8 text Question 8 1 out of 1 points
Correct The ____ manages interaction between the end user and the database.
Question 8 answers
Selected Answer: Correct DBMS
Question 9 text Question 9 1 out of 1 points
Correct A logically connected set of one or more fields that describes a person, place, or thing is a(n):
Question 9 answers
Selected Answer: Correct a record
Question 10 text Question 10 1 out of 1 points
Correct Data inconsistency exists when different and conflicting versions of the same data appear in different places.
Question 10 answers
Selected Answer: Correct True
Question 11 text Question 11 1 out of 1 points
Correct A multiuser database that supports a small number of users, or a specific department, is called a workgroup database.
Question 11 answers
Selected Answer: Correct True
Question 12 text Question 12 0 out of 1 points
Incorrect ____ makes a file system extremely cumbersome from a programming and data management perspective.
Question 12 answers
Selected Answer: Incorrect Data independence
Question 13 text Question 13 1 out of 1 points
Correct Which of the following is least likely to be a business rule as relates to data modeling?
Question 13 answers
Selected Answer: Correct Casual Fridays take place in the summer.
Question 14 text Question 14 1 out of 1 points
Correct The ____ model is the relational model’s challenge to the OODM.
Question 14 answers
Selected Answer: Correct ERD
Question 15 text Question 15 1 out of 1 points
Correct The ____ model adapts a conceptual model to a specific DBMS.
Question 15 answers
Selected Answer: Correct internal
Question 16 text Question 16 1 out of 1 points
Correct Data modeling is usually skipped due to time constraints.
Question 16 answers
Selected Answer: Correct False
Question 17 text Question 17 1 out of 1 points
Correct The RDBMS ____.
Question 17 answers
Selected Answer: Correct performs functions provided by the hierarchical and network DBMS system
Question 18 text Question 18 1 out of 1 points
Correct What type of relationship is expressed with the phrase “Student takes Class”?
Question 18 answers
Selected Answer: Correct M:N
Question 19 text Question 19 0 out of 1 points
Incorrect In the network model, an entity can have more than one owner.
Question 19 answers
Selected Answer: Incorrect False
Question 20 text Question 20 0 out of 1 points
Incorrect The hierarchical database model depicts a set of ____ relationships.
Question 20 answers
Selected Answer: Incorrect 1:1
Question 21 text Question 21 1 out of 1 points
Correct A data model must represent the ____ world as closely as possible.
Question 21 answers
Selected Answer: Correct real
Question 22 text Question 22 1 out of 1 points
Correct Each segment in a hierarchical structure is referenced by a path.
Question 22 answers
Selected Answer: Correct True
Question 23 text Question 23 1 out of 1 points
Correct A(n) ____ model is independent of both hardware and software.
Question 23 answers
Selected Answer: Correct conceptual
Question 24 text Question 24 1 out of 1 points
Correct Which of the following database models is NOT still in use today?
Question 24 answers
Selected Answer: Correct Network
Question 25 text Question 25 1 out of 1 points
Correct What type of relationship is expressed with the phrase “Employee manages Store”?
Question 25 answers
Selected Answer: Correct 1:1
Question 1 1 out of 1 points
Correct There are three different types of anomalies: update, insertion, and deletion.
Question 1 answers
Selected Answer: Correct True
Question 2 text Question 2 1 out of 1 points
Correct In a database environment, the DP is promoted to ____.
Question 2 answers
Selected Answer: Correct systems administrator
Question 3 text Question 3 1 out of 1 points
Correct ____ are the people who run the organization’s daily operations.
Question 3 answers
Selected Answer: Correct End users
Question 4 text Question 4 1 out of 1 points
Correct Which of the following is a benefit of using a DBMS?
Question 4 answers
Selected Answer: Correct They help create an environment for end users to have access to more data
Question 5 text Question 5 1 out of 1 points
Correct A single-user database can only support one user at a time.
Question 5 answers
Selected Answer: Correct True
Question 6 text Question 6 1 out of 1 points
Correct Another name for a production database is a ____ database.
Question 6 answers
Selected Answer: Correct transactional
Question 7 text Question 7 1 out of 1 points
Correct Accurate, relevant, and timely information is the key to good decision making.
Question 7 answers
Selected Answer: Correct True
Question 8 text Question 8 1 out of 1 points
Correct A DBMS that supports hundreds of users at multiple sites is called a(n) workgroup DBMS.
Question 8 answers
Selected Answer: Correct False
Question 9 text Question 9 0 out of 1 points
Incorrect A(n) fourth-generation programming language requires the programmer to specify both what must be done and how it is to be done.
Question 9 answers
Selected Answer: Incorrect True
Question 10 text Question 10 1 out of 1 points
Correct John is working in the customer table and needs to know what customers are located in Florida. To find the information, he would ____.
Question 10 answers
Selected Answer: Correct create a new query
Question 11 text Question 11 1 out of 1 points
Correct Data anomalies exist because a change in any field value can't be made in multiple places.
Question 11 answers
Selected Answer: Correct False
Question 12 text Question 12 1 out of 1 points
Correct Data constitute the building blocks of information.
Question 12 answers
Selected Answer: Correct True
Question 13 text Question 13 1 out of 1 points
Correct What modern development has dramatically changed the direction database technology was moving in?
Question 13 answers
Selected Answer: Correct The Internet
Question 14 text Question 14 1 out of 1 points
Correct The hierarchical model was the first to define a standard DML and DDL.
Question 14 answers
Selected Answer: Correct False
Question 15 text Question 15 1 out of 1 points
Correct The ____ model adapts a conceptual model to a specific DBMS.
Question 15 answers
Selected Answer: Correct internal
Question 16 text Question 16 1 out of 1 points
Correct The only relationship type supported by the hierarchical model is 1:1.
Question 16 answers
Selected Answer: Correct False
Question 17 text Question 17 0 out of 1 points
Incorrect A data model is built out of tables, rows, and columns.
Question 17 answers
Selected Answer: Incorrect True
Question 18 text Question 18 1 out of 1 points
Correct A table is a matrix consisting of a series of row and column ____.
Question 18 answers
Selected Answer: Correct intersections
Question 19 text Question 19 1 out of 1 points
Correct The most important advantages of the hierarchical database model are ____.
Question 19 answers
Selected Answer: Correct conceptual simplicity, security, independence, integrity, and efficiency
Question 20 text Question 20 1 out of 1 points
Correct Business rules are policies written in the employee handbook.
Question 20 answers
Selected Answer: Correct False
Question 21 text Question 21 1 out of 1 points
Correct SQL makes pure ad hoc queries a reality.
Question 21 answers
Selected Answer: Correct True
Question 22 text Question 22 1 out of 1 points
Correct In a network database each set is composed of two record types: an owner record and a ____ record.
Question 22 answers
Selected Answer: Correct member
Question 23 text Question 23 0 out of 1 points
Incorrect Which of the following data models contains the least semantics?
Question 23 answers
Selected Answer: Incorrect Network
Question 24 text Question 24 1 out of 1 points
Correct Data modeling is usually skipped due to time constraints.
Question 24 answers
Selected Answer: Correct False
Question 25 text Question 25 1 out of 1 points
Correct The network database models have a(n) ____.
Question 25 answers
Selected Answer: Correct owner/member relationship that promotes database integrity
No comments:
Post a Comment