Enter Your PSEUDONYM:          

Question 1:    What is data resource management?

                         Managing an organization's data resources to meet the data needs of their software programs
                          Managing an organization's data resources to meet the information needs of their business stakeholders
                          Managing an organization's data resources to coordinate data with hardware capacity
                          Managing an organization's data resources to coordinate corporate data with departmental needs
                          Managing an organization's data resources to fulfill EDP potential

Question 2:   What is metadata?

                         Data about data
                          A relationship between entities
                          A hierarchy of data relationships
                          Pseudodata which is generated from actual data
                          Data which is stored in the fields of a record

Question 3:    What is the smallest element in a database?

                         An entity
                          A file
                          A character
                          rely on structured programming
                          are non-procedural languages

Question 4:    Which one of the following places the common data elements in order from smallest to largest?

                         Character, record, field, database, file
                          Character, field, record, file, database
                          Character, field, record, database, file
                          Character, file, record, field, database
                          Character, record, file, field, database

Question 5:    What is a record?

                         The characteristic of an entity
                          A person, place, object or event
                          A group of related characters
                          A group of related entities
                          A collection of attributes that describe an entity

Question 6:    Which of the following was a problem with traditional file processing systems?

                         Data Independence
                          Data Integration
                          Single Applications
                          Data Efficiency
                          All were problems

Question 7:    A database is composed of:

                         information only
                          procedures that act on information
                          two-dimensional tables or files
                          information and the logical structure of the information
                          user and managerial information

Question 8:    A system which integrates the use and storage of data in an information system is called a:

                         Database management system
                          Distributed processing system
                          Management information system
                          Telecommunications system
                          Transaction System

Question 9:    Which of the following is a major DBMS function?

                         Application consolidation
                          Database Independence Interaction
                          Transaction Processing
                          Non-Procedural Access
                          Database Interrogation

Question 10:  What is database development?

                         The capability of a DBMS to report information from the database in response to end users' requests
                          Defining and organizing the content, relationships and structure of the data needed to build a database
                          The use of built-in software development tools to develop custom applications
                          Updating a database continually to reflect new business transactions and other events
                          Physical design of database functions

Question 11:   What is Application Development?

                         The capability of a DBMS to report information from the database in response to end users' requests
                          Defining and organizing the content, relationships and structure of the data needed to build a database
                          The use of built-in software development tools to develop custom applications
                          Updating a database continually to reflect new business transactions and other events
                          Physical design of database functions

Question 12:   Which of the following is NOT a DBMS form??

                         Relational
                          Sequential
                          Hierarchical
                          Multidimensional
                          Network

Question 13:  Which of the following is a network DBMS??

                         Data elements within the database are viewed as stored in the form of simple tables
                          Data can be sequentially accessed
                          Data can be accessed by one of several paths because any record can be related to any number of other records
                          Relationships between records form a treelike structure
                          Uses multi-dimensional structures to organize data and express the relationships between data

Question 14:   The database model that uses a series of two-dimensional tables or files to store information is the ________________ model. This database model has become the most popular database structure models, as it is used by most microcomputer DBMS packages:

                         Hierarchical structure
                          Network structure
                          Relational structure
                          Object-oriented structure
                          Hypermedia structure

Question 15:   What is encapsulation?

                         Automatically creating new objects by replicating the characteristics of one or more existing objects
                          Relationships between members all exhibit similar attributes
                          Data values and operations that can be performed on them are stored as a unit
                          Multiple attributes are contained by the same procedure
                          The same attribute may be acted upon by multiple procedures

Question 16:   What is data planning?

                         Defining information needs of end users in a business process
                          Expressing all information requirements
                          Translating the conceptual model of a DBMS into the data model
                          Developing an enterprise model that defines the basic business process of the enterprise
                          Determining the data storage structure and access methods

Question 17:  What is a physical schema?

                         How data are to be stored and accessed on the storage devices of a computer system
                          The data elements and relationships among them
                          The data values and operations that are performed on an entity
                          The relationships between non-communicating entities
                          The intrarelationships between entity attributes

Question 18:   What is the difference between logical and physical views?

                         Logical views show the needed data elements and relationships while physical views show the organization and location of data
                          Logical views show the organization and location of data whilr physical views show the needed data elements and relationships
                          Logical views are based on metaphysical conceptualizations while physical views are existential
                          Logical views are organizationally based while physical views are structurally based
                          None of the above

Question 19:  Which of the following is describe operational databases?

                         Consist of hyperlinked pages of multimedia
                          Store detailed data needed to support the business processes and operations of a company
                          Databases that are replicated and distributed to network servers at a variety of sites
                          Contain information available from the World Wide Web
                          Large database that stores data that have been extracted from the various databases

Question 20:  Which statement most accurately describes the concept of a data warehouse?

                         Databases that hold subsets of data from a data warehouse
                          Databases that focus on specific aspects of a company
                          Databases that are used for commercial purposes
                          A and B
                          B and C