Database Management Exam 1 (Daniel Power)

What is a drawing of the high-level entities for an organization and the relationships among them called? A) Conceptual data model. B) External data model. C) Logical data model.

A) Conceptual data model.

Which of the following is NOT a limitation of an ER model? A) ER models are mostly created as a separate time consuming activity. B) ER models are less helpful with pre-existing information sources. C) ER models assume the data is in a relational structure. D) ER models are not suitable for multidimensional databases.

A) ER models are mostly created as a separate time consuming activity.

What are the two primary types of conceptual data models? A) Enterprise, project. B) Entity-relationship, logical. C) Logical, physical. D) Relational, entity-relationship.

A) Enterprise, project.

What does SQL stand for? A) Structured Query Language. B) Sequential Query Language. C) Structured Question Language. D) Sequential Question Language.

A) Structured Query Language.

Bottom-up modeling usually creates data models from existing data structures forms, fields on application screens, or reports. A) True. B) False.

A) True.

What are major capabilities of a general-purpose DBMS? A) Data storage, retrieval and update. B) Privacy control services. C) Transaction support. D) A and C. E) All of the above.

E) All of the above.

Which of these is NOT a reason why projects fail? A) Blamestorming. B) Project team is technically incompetent. C) Users too involved in the project. D) Scope creep.

A) Blamestorming.

What is a data flow diagram? A) A data flow diagram (DFD) is a graphical representation of the "flow" of data through an information system B) A context diagram is the bottom level data flow diagram that contains many process nodes. C) DFDs are pictures of the movement of data between internal data entities and an information system. D) a and c. E) All of the above.

A) A data flow diagram (DFD) is a graphical representation of the "flow" of data through an information system

When is it more appropriate to use flat files than a DBMS? A) Applications that have no need for multiple-user access to data. B) Many concurrent queries are expected. C) Simple, well-defined database applications that change often. D) When there are no time requirements.

A) Applications that have no need for multiple-user access to data.

In which of the following situations should an associative entity be considered? A) Associate entity can have meaning independent of other entities. B) Both entities are independent or strong entities. C) Relationship between two entities is one to many. D) When using the UML modelling standard.

B) Both entities are independent or strong entities.

What is the concept of cardinality in a data model? A) Cardinality describes the optional or required relationship between two entities. B) Cardinality describes how many instances of one entity are associated with another entity. C) Cardinality describes the number of strong/weak relationships. D) Cardinality names the roles in the relationship.

B) Cardinality describes how many instances of one entity are associated with another entity.

What is a relational database? A) Data in different files/tables is connected through the use of linked records. B) Data in different files/tables is connected by using common data elements or a key field. C) Stores normalized data linked by primary keys . D) Structures data in a hierarchy of records using primary and foreign key fields.

B) Data in different files/tables is connected by using common data elements or a key field.

What are the 3 server-side components of an Oracle database architecture? A) Data, Database, Oracle environment. B) Database, Oracle instance, server process. C) Data, Database, SQL Developer.

B) Database, Oracle instance, server process.

SQL is unique to Oracle databases. A) True. B) False.

B) False.

What is the purpose of the SQL WHERE clause? A) Limits the column data that are returned. B) Limits the row data that are returned. C) Both A and B are correct. D) Neither A nor B is correct.

B) Limits the row data that are returned.

What data model documents the structure of the data? A) Physical data model. B) Logical data model. C) Conceptual data model. D) Strategic data model.

B) Logical data model.

What problem(s) did E. F. Codd's relational model solve? A) Flat files were very inefficient when storing data sets because of redundancy. B) Navigational databases were very inefficient when storing "sparse" data sets where some of the data for any one record could be left empty. C) Network databases were slow to search and query. D) Network and Hierarchical databases were hard coded with pointers that made them difficult to change and hence resulted in poor performance.

B) Navigational databases were very inefficient when storing "sparse" data sets where some of the data for any one record could be left empty.

What is a difference between SQL*Plus and Oracle Developer? A) Oracle Developer uses a command line interface. B) Oracle SQL Developer is a graphical version of SQL*Plus. C) SQL*Plus is an IDE and Oracle Developer is not. D) SQL*Plus and Oracle Developer were developed by different companies.

B) Oracle SQL Developer is a graphical version of SQL*Plus.

What occurs during the systems planning stage of the SDLC? A) Conceptual model developed. B) Organization objectives established and analysis of data needs. C) Physical data model developed. D) Desired features and operations described in data.

B) Organization objectives established and analysis of data needs.

Which of the following is not a characteristic or property of metadata? A) Data definitions. B) Processing logic. C) Relationships in the data structure. D) Rules or constraints.

B) Processing logic.

How are operations primarily performed on the data in an Oracle database? A) Using commands. B) Using SQL statements. C) Using Query by Example (QBE).

B) Using SQL statements.

What is a conceptual data model? A) A conceptual data model (CDM) is an abstract form of data model. It specifies general entities in an i9nformation system. B) A conceptual data model is a detailed description of a business's data entities and informational needs. C) A conceptual data model is a high-level description of informational needs for the design of a database. It shows entities and relationships among them. D) a and b. E) All of the above.

C) A conceptual data model is a high-level description of informational needs for the design of a database. It shows entities and relationships among them.

What are the three models or schemas in the three-tier ANSI-SPARC architecture? A) Client, application server, and database server. B) Conceptual, logical, physical. C) Conceptual, external and internal.

C) Conceptual, external and internal.

What causes program-data dependence? A) Data depend on the programs and applications that use them. B) Data descriptions are stored on a centralized file server. C) Data descriptions are stored with each application program. D) Programs depend upon the data they use.

C) Data descriptions are stored with each application program.

Which of the following is NOT a major advantage of using a Database Management System (DBMS)? A) Improved ability to enforce standards. B) Improved data consistency. C) Local control over the data. D) Minimal data redundancy.

C) Local control over the data.

SQL is tied very closely with which database model? A) Hierarchical. B) Network. C) Relational.

C) Relational.

An RDBMS contains a description of its own structure, what is this characteristic of a database called? A) Documented. B) Metadata enhanced. C) Self-describing. D) Structured.

C) Self-describing.

During the traditional Systems Development Life Cycle (SDLC), when are logical and physical data models commonly developed? A) Integration and Testing. B) Planning and Preliminary Analysis. C) Systems Design.

C) Systems Design.

What is the term for a logical description of some portion of the database needed by a person or application to perform a task? A) Conceptual schema. B) Internal schema. C) User view. D) Working data model.

C) User view.

How are relationships typically named in an ERD? A) With a common noun, e.g. marriage. B) With phrases, e.g. is-the-owner-of. C) With a verb. e.g. owns.

C) With a verb. e.g. owns.

Using Chen's notation, how is a relationship between two entities shown? A) A line connecting the two entities. B) A circle between the two entities. C) A line connecting with a transitive verb to describe the relationship. D) A diamond between the two entities.

D) A diamond between the two entities.

What is (are) a common benefit from data models? A) Increased compatibility. B) Reduction in costs. C) More responsive to change. D) All of the above.

D) All of the above.

What is a major strength of the SDLC? A) Rigid structure. B) Systems defined up front. C) More time spent in development. D) More control.

D) More control.

What is SQL? A) A standard language for database management systems. B) SQL stands for Specialized Query Language. C) SQL is a declarative, procedural, set-oriented language. D) SQL is a specialized language for updating, deleting, and requesting data from databases.

D) SQL is a specialized language for updating, deleting, and requesting data from databases.

What is data? A) Data can be any character, text, words, number, pictures, sound, or video. B) Data are elemental facts, numbers or character strings — not information. C) Data is meaningful information including reports and charts. D) a and b. e) All of the above.

D) a and b.

What is a database management system? A) A database management system (DBMS) is a software system for creating and managing databases. B) A DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data. C) A database management system (DBMS) is a collection of programs that enable data management. D) a and c. E) All of the above.

E) All of the above.

Which of the following is a reason for failed database project? A) Users failed to provide complete requirements. B) Users were not involved in the development process. C) Executive management did not seem interested in seeing the project through. D) A and B. E) All of the above.

E) All of the above.