Enter Your PSEUDONYM:            

Question 1:    What is a database?

                         Data about data
                          A relationship between entities
                          A hierarchy of files
                          A large, logical, integrated collection of Data and Metadata
                          A collection of structured programs

Question 2:  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 character
                          The characteristics of a particular object

Question 3:    What is a relationship?

                         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 4:    What is a field?

                         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 5:    Before databases, how was data typically maintained and processed?

                         BASIC operating systems
                          Traditional File Processing Systems
                          Non-procedural Processing Systems
                          Machine Level Processing Systems
                          Assembly Level Processing Systems

Question 6:    A database:

                         is an integrated collection of logically related records or files
                          consolidates records previously stored in separate files into a common pool of data records
                          includes stored data that is independent of the application programs using it
                          All of the above
                          None of the above

Question 7:    What does DBMS stand for?

                         Database Monitoring Systems
                          Database Management Synergies
                          Database Manipulation Systems
                          Database Management Systems
                          Database Manipulation Subsystems

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

                         Application Integration
                          Database tuning
                          Transaction Processing
                          Non-Procedural Access
                          Procedural Language Interface

Question 9:    DBMS query language is designed to:

                         Support information systems professionals in the development of complex application software
                          Support end users that wish to interrogate the database using English-like or natural language commands
                          Provide efficient processing of the database in the batch mode
                          Specify the content, relationships, and structure of a database
                          Support database Development

Question 10:  What is database Interrogation?

                         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:  Which of the following is a DBMS form?

                         Transactional
                          Non-Procedural
                          Interrogatory
                          Cross-referential
                          Network

Question 12:  Which of the following is a relational 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 to allow end users to easily receive information in response to ad hoc requests is the:

                         Hierarchical structure
                          Network structure
                          Relational structure
                          Object-oriented structure
                          hypermedia structure

Question 14:  Which of the following is a feature of an object oriented DBMS?

                         Encapsulation
                          Non-Procedural
                          Inheritance
                          A and B
                          A and C

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 systems
                          Chief information officer

Question 16:  What is a logical 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 17:  What is a Data Dictionary?

                         A directory of stored data and how they are entered
                          A dictionary of business processes
                          A catalog or directory containing metadata
                          A catalog of how businesses interpret user applications
                          A directory of logical intraorganizational schemas

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

                         Operational
                          Hypermedia
                          External
                          Random Access
                          External

Question 19:  Which of the following is describe external 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 of the following is an example of a use of data mining?

                         Performing 'market-basket analysis' to identify new product bundles
                          Finding root causes to quantity data
                          Encouraging customer attrition
                          Discouraging customer cross-selling and profiling
                          Asking coal miners to attend Thanksgiving dinner