Enter Your PSEUDONYM:            

Question 1:    The concept of data resource management involves the management of an organization's:

                         Data resources and its people
                          Data resources and its information technology
                          Data resources and its information systems functions
                          Data resources
                          Data Processing personnel

Question 2:    What is an entity?

                         The manner in which objects interact with each other
                          A collection of unrelated fields
                          A person, place, object or event
                          A group of related character
                          The characteristics of a particular object

Question 3:    What is an attribute?

                         The manner in which objects interact with each other
                          A collection of unrelated fields
                          A person, place, object or event
                          A group of related characters
                          The characteristics of a particular object

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 file?

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

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

                         Data Independence
                          Lack of Data Integration
                          Data Redundancy
                          Data-Program Dependence
                          Data Input Errors

Question 7:    What is the database management approach?

                         Establishment of multiple independent applications that promote redundancy
                          Consolidation of data records into one database that can be accessed by many different applications
                          A Software interface between users and databases
                          A and B
                          A and C

Question 8:    Which of the following is a DBMS component?

                         Application Integration
                          Database tuning
                          Transrelational Processing
                          Networked Interfaces
                          All of the above

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

                         Database Development
                          Database Maintenance
                          Application Development
                          Automated Access
                          Non-procedural development

Question 10:  What is database Maintenance?

                         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:  A graphic method of representing entity classes and their relationships is:

                         A query-by-example tool
                          An entity-relationship diagram
                          An intersection relation diagram
                          A flowchart
                          A hierarchy chart

Question 12:  Which of the following is a hierarchical 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 13:  This database model which is the best suited for structured, routine types of transaction processing is the:

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

Question 14:  This database model consists of data values describing the attributes of an entity, and the operations that can be performed upon the data:

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

Question 15:  The function in an organization that is responsible for the more technical aspects of managing the information contained in organizational databases is:

                         Chief data officer
                          Chief executive officer
                          Data administration
                          Database administration
                          Chief information officer

Question 16:  Which statement best describes the process of database administration?

                         Responsible for the proper use of database management technology
                          Responsible for developing and maintaining the organization's data dictionary
                          Responsible for designing and monitoring the performance of databases and enforcing standards for database use and security
                          All of the above apply to database administration function
                          None of the above apply to database administration function

Question 17:  The logical structure of information in a database is contained in the

                         Data dictionary
                          Data manipulation subsystem
                          Data administration subsystem
                          Data definition subsystem
                          Data monitoring subsystem

Question 18:  Which of the following are types of databases?

                         Operational
                          Non-procedural
                          External
                          A and B
                          A and C

Question 19:   Which of the following is describe distributed 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?
                         Stores detailed data needed to support the operations of the entire organization
                          Stores data and information extracted from selected operational and external databases
                          Stores data from current and previous years that has been extracted from the various operational and management databases of an organization
                          Is a database for local workgroups and departments
                          Stores programs needed to support the operations of the entire organization