WHAT IS THE NAME FOR THE MOST CURRENT VERSION OF THE ERD

QUESTION 1. What is the name for the most current version of the ERD?              (0.25 points)

 

1. SQL
2. Chen model
3. Crow`s Foot notation
4. Date model

 

QUESTION 2. Human beings view data according to its ________ data format.   (0.25 points)

 

1. Logical
2. Structured
3. Physical
4. Outer

 

QUESTION 3. A (n) ________ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.      (0.25 points)

 

1. Business rule
2. Attribute
3. Entity
4. Constraint

 

QUESTION 4. Wider access to well-managed data promotes a(n) ________ view of the organization`s operations and a clearer view of the big picture.  (0.25 points)

 

1. Raw
2. Automatic
3. Integrated
4. Transparent

 

QUESTION 5. The most widely used conceptual model is the ________ model. (0.25 points)

 

1. OO
2. ER
3. Internal
4. Implementation

 

QUESTION 6. A single-user database that runs on a personal computer is called a(n) ________ database.             (0.25 points)

 

1. Workgroup
2. Distributed
3. Enterprise
4. Desktop

 

QUESTION 7. Each row in the relational table is known as an entity ________.   (0.25 points)

 

1. Attribute
2. Model
3. Instance
4. Relationship

 

QUESTION 8. How is an entity represented in an ERD?    (0.25 points)

 

1. Rectangle
2. Diamond
3. Triangle
4. Circle

 

QUESTION 9. Data processing (DP) specialists are in existence because of ________.     (0.25 points)

 

1. The advent of database management systems
2. The increase in the number of computers
3. The need to speed up processing of data
4. The need to track data and produce required reports

 

QUESTION 10. John is working in the customer table and needs to know what customers are located in Florida. To find the information he would ________.            (0.25 points)

 

1. Create a new query
2. Create a new table
3. Create a new form
4. Utilize the Database Wizard

 

QUESTION 11. Which model operates at the lowest level of abstraction?               (0.25 points)

 

1. Conceptual
2. External
3. Internal
4. Physical

 

QUESTION 12. A(n) ________ allows the user to specify what must be done without specifying how it must be done.                (0.25 points)

 

1. Nonprocedural language
2. Procedural language
3. Object-oriented language
4. Script

 

QUESTION 13. What model requires the most detail in its internal model?            (0.25 points)

 

1. Entity relationship
2. Semantic
3. Network
4. Relational

 

QUESTION 14. In response to the increasing complexity of applications, two new data models emerged: the object-oriented data model and the ________ relational data model.  (0.25 points)

 

1. Extended
2. Flat-file
3. Entity
4. Hierarchical

 

QUESTION 15. The hierarchical database model is based on a ________.              (0.25 points)

 

1. Lack of a parent segment
2. Lack of a child segment
3. Tree structure
4. Matrix

 

QUESTION 16. Because all data access programs are subject to change when any of the file`s data storage characteristics change (that is, changing the data type), the file system is said to exhibit ________.       (0.25 points)

 

1. Data independence
2. Data dependence
3. Logical data format
4. Physical data format

 

QUESTION 17. ________ deals with fixing the database after a failure such as a hard disk malfunction.  (0.25 points)

 

1. Access control
2. Security
3. Backup
4. Recovery

 

QUESTION 18. Data ________ is defined as "the condition in which all of the data in the database are consistent with the real-world events and conditions."          (0.25 points)

 

1. Verification
2. Integrity
3. Redundancy
4. Inconsistency

 

QUESTION 19. Database management systems, operating systems, applications and utilities are all examples of ________.                (0.25 points)

 

1. Hardware
2. Computer infrastructure
3. Input and output
4. Software

 

QUESTION 20. What is a benefit of using a DBMS?            (0.25 points)

 

1. It provides full security to data using private/public key encryption.
2. It creates automatic backups.
3. It helps create an environment for end users to have access to more data.
4. It provides seamless Internet access to database data.