This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Exam
Name___________________________________ TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false.
1) The structure and content of a database depends entirely on how users view their business activity. 1) 2) A spreadsheet is used to store data with multiple themes. 2) 3) The purpose of a database is to keep track of things that involve a single theme. 3) 4) A database is a self-describing collection of integrated records. 4) 5) A database is best described as a collection of tables which are not related to each other. 5) 6) A group of similar rows or records is called a field. 6) 7) Special data that describes the structure of a database is called metadata. 7) 8) A key is a column or group of columns that identifies a unique row in a table. 8) 9) Every table in a database must have a key associated with it. 9) 10) Databases that carry their data in the form of tables and that represent relationships without using
foreign keys are called relational databases. 10) 11) The format of metadata depends on the software product that is processing the database. 11) 12) A DBMS is a software that helps to manage the operating system. 12) 13) Most organizations develop their own DBMS software in order to obtain control over the data. 13) 14) MySQL is an open-source DBMS package which is license-free for most database applications. 14) 15) To modify an existing table, the developer opens the metadata form for that table and adds a new
row of metadata. 15) 16) In order to read, insert, modify, or delete data, applications have to call upon the DBMS in a
standardized way. 16) 17) SQL is an international standard language for processing a database. 17) 18) SQL cannot be used to create databases and database structures. 18) 19) One of the functions of a DBMS is to provide tools to assist in the administration of the database. 19) 1 20) One of the developmental tasks of the database administrator is to develop a system to record and
manage resolution of problems. 20) 21) Managing the impact of database structure changes on applications and users is an operational
task of the database administrator. 21) 22) DBMS can be used to set up security systems involving user accounts, passwords, permissions,
and limits for processing the database. 22) 23) A database application is a collection of forms, reports, queries, and application programs that
process a database. 23) 24) A database must have only one application though the application can have one or more users. 24) 25) In order to find the data one is looking for in the DBMS, one has to type in the keyword into a
query form. 25) 26) Application programs process logic that is specific to a given business need. 26) 27) Lost-update problem can be resolved by implementing multi-user database processing. 27) 28) Some type of locking must be used to coordinate the activities of users who know nothing about
one another in order to prevent the lost-update problem. 28) 29) Microsoft's SQL Server is an example of a personal DBMS product. 29) 30) Microsoft Access is both a DBMS and an application development product. 30) 31) A data model describes the data whereas a database explains the relationships among data that
will be stored in the database. 31) 32) The entity-relationship data model is a tool for evaluating the existing data models. 32) 33) In data models, physical objects are represented as entities whereas logical constructs and
transactions are represented as attributes. 33) 34) Attributes are used to describe characteristics of the entity. 34) 35) An identifier is an attribute or a group of attributes whose value is associated with one and only
one entity instance. 35) 36) Entities in a database model can have relationships to each other. 36) 37) In an entity-relationship diagram, the entities are represented by a single triangle and the
relationships are represented by lines. 37) 38) A line in an E-R diagram is used to represent the attributes of the entities. 38) 2 39) The crow's-foot notation of an E-R diagram shows the maximum number of entities that can be
involved in a relationship. 39) 40) Minimum cardinalities are a measure of the constraints on number of entities required in the
relationship. 40) 41) A crow's foot notation would indicate the minimum cardinality of a relationship. 41) 42) 1:N, N:M, and 1:1 are common examples of minimum cardinalities. 42) 43) The small oval on an entity in an E-R diagram means that the relationship must have an entity of
that type. 43) 44) Optimization is the process of converting a poorly structured table into two or more
well-structured tables. 44) 45) Inconsistent changes in attributes would lead to data integrity problems. 45) 46) A table that has data integrity problems will produce incorrect and inconsistent information. 46) 47) The data integrity problem can occur only if data are duplicated. 47) 48) The data integrity problem cannot be eliminated by removing the duplicated data. 48) 49) The general goal of normalization is to construct tables such that every table has a single topic or
theme. 49) 50) Normalization is critical when designing a database and it is the only criterion for evaluating
database designs. 50) 51) A foreign key is essential in relationship databases to represent the relationship between two tables. 51) 52) The accuracy of a database design is not dependent on the corresponding data model. 52) 53) Users are the final judges as to what data the database should contain and how the records in that
database should be related to one another. 53) 54) The easiest time to change the database structure is immediately before the data modeling stage. 54) 55) Data aggregators obtain data from public and private sources and store and process it in
sophisticated ways. 55) MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
56) A ________ is a self-describing collection of integrated records.
A) file system
B) grid network
C) storage folder 3 D) database 56) 57) A byte is a ________.
A) collection of numerals
C) character of fields 57) B) collection of records
D) character of data 58) In a database system, a ________ is the smallest piece of data.
C) record D) byte 59) Bytes are grouped into columns, which in turn are grouped into ________.
C) records D) files 60) A collection of similar records is called a(n)________.
C) file D) array 58) 59) 60) 61) Columns in a database are grouped into records and such records are called ________.
D) rows 61) 62) In a relational database, a collection of similar records is called a(n) ________.
C) table 62) D) application 63) A ________ is a column or group of columns that identifies a unique row in a table.
D) record 63) 64) Columns that belong to a different table than the one in which they reside are called ________.
A) relational files
B) foreign keys
C) parallel records
D) operational records 64) 65) Which of the following is the formal name used to represent tables in a relational database?
D) relation 65) 66) Metadata are ________.
A) data that describe data
C) error logs of databases 66) B) codes used in machine language
D) data on the main server 67) Which of the following is a program used to create, process, and administer a database?
A) Database application
B) Operating system
D) DBMS 67) 68) Which of the following is an example of a database product?
C) ERP software 68) D) SQL Server 69) Identify the open source DBMS product that is license-free for most applications.
A) MS Access
B) SQL Server
D) Oracle 69) 70) SQL is a(n) ________.
A) operating system
C) query language 70) B) programming language
D) database system 4 71) SQL stands for ________.
A) Structured Query Language
C) Standard Question Language B) Standard Query Language
D) Structured Question Language 71) 72) Which of the following is a developmental task of a database administrator?
A) conducting training
B) managing configuration change
C) validating the data model
D) managing security 72) 73) Identify an adaptation task of a database administrator.
A) managing the DBMS
B) managing configuration change
C) monitoring backup procedures
D) monitoring database performance 73) 74) DBMS functions such as backing up database data, adding structures to improve the performance
of database applications, and removing data that are no longer wanted or needed can be called
D) administrative 74) 75) A ________ is a collection of forms, reports, queries, and programs that process a database.
A) query environment
B) database platform
C) database query
D) database application 75) 76) ________ are used to read, insert, modify, and delete data.
A) Data tables
B) Data entry columns
C) Data entry forms
D) Data rows 76) 77) ________ in a database application show data in a structured context.
C) Queries 77) D) Reports 78) Brenda wants to find a particular report containing sales analyses of the second and third quarter.
After accessing the DBMS, she should type in the keyword into a ________ form to locate what she
is looking for.
D) data 78) 79) ________ process logic that is specific to a given business need.
A) Data aggregators
B) Database queries
C) Application programs
D) Data models 79) 80) A hospital is using a software to analyze treatment regimen and recovery times. The software
relates the dosages, regularity, and therapeutic procedures to the time taken by patients segmented
across age- and illness-groups. This software is an example of a(n) ________.
A) data network
B) operating system
C) application program
D) data mining application 80) 81) An important use of application programs is to ________.
A) generate data that describe data
B) control a computer's resources
C) enable database processing over the Internet
D) perform memory swapping to enhance the computer's performance 81) 5 82) The ________ problem is unique to a multi-user database environment.
A) data redundancy
B) network conflict
C) entity collision
D) lost-update 82) 83) DBMS products are broadly classified into ________.
A) independent DBMS and relational DBMS
B) internal DBMS and external DBMS
C) enterprise DBMS and personal DBMS
D) relational DBMS and operational DBMS 83) 84) A(n) ________ DBMS is designed to process large organizational and workgroup databases.
D) procedural 84) 85) Which of the following types of DBMS is designed for smaller and simpler database applications?
A) strategic DBMS
B) structural DBMS
C) personal DBMS
D) object-oriented DBMS 85) 86) ________ is an example of a personal DBMS.
A) Microsoft Access
C) Oracle 86) B) Microsoft SQL
D) IBM DB2 87) Which of the following is an example of an enterprise DBMS?
A) MS Access
C) SQL Server D) FoxPro 87) 88) A ________ describes the data and relationships that will be stored in the database.
A) data application
C) data model
D) data aggregator 88) 89) UML stands for ________.
A) Unified Modeling Language
C) Unicode Markup Language 89) B) Unicode Modeling Language
D) Unified Markup Language 90) A person, place, or object would be represented in a database application as a(n) ________.
D) class 90) 91) Entities have ________ that describe the characteristics of the entity.
C) attributes D) codes 91) 92) Each entity in a database has a unique attribute called ________.
B) public key
C) index field D) foreign key 92) 93) Which of the following is true of N:M relationships?
A) More than one entity is allowed on each side of the relationship.
B) The number of entities on each side cannot be different.
C) They are also called one-to-many relationships.
D) They are common examples of minimum cardinalities.
93) 94) In an entity-relationship diagram, a line between two entities represents a ________.
B) foreign key
D) cardinality 94) 6 95) Minimum cardinalities are ________.
A) the lowest possible data attributes in an entity
B) the attributes identified with only one entity
C) minimum requirements on the number of entities
D) crow's feet notations showing the least number of relationships
96) Constraints on the number of entities are called ________ cardinalities.
C) restrictive 95) D) specific 96) 97) If a student is allowed to have multiple majors and advisors are assigned to handle multiple
students, it would be an example of a ________ relationship.
D) 1:N 97) 98) In an entity-relationship diagram, a(n) ________ on a line means that at least one entity type of that
type is required.
A) triangular block
B) small oval
D) vertical bar 98) 99) Which of the following formations, found on a line in an entity-relationship diagram, would mean
that the entity is optional?
B) small oval
C) double line
D) vertical bar 99) 100) ________ is the process of converting a data model into tables, relationships, and data constraints.
A) Data warehousing
B) Data mining
C) Database design
D) Database aggregation 100) 101) The database design team transforms entities into tables and expresses relationships by defining
C) foreign keys
D) cardinalities 101) 102) ________ is the process of converting a poorly structured table into two or more well-structured
D) Normalization 102) 103) Different accounting names exist for an entity in different rows of a database table. This would lead
to a(n) ________.
A) normalized database
B) data integrity problem
C) standardization problem
D) attribute conflict 103) 104) The data integrity problem can occur only if ________.
A) the data are duplicated
B) there are complex relationships
C) there are multiple administrators
D) the database is large 104) 105) Every table in a normalized database has ________.
A) specialized query formats
C) a redundant database 105) B) a single theme
D) duplicated data models 7 106) Identify the first step in transforming a data model into a relational database design.
A) creating foreign keys
B) representing the data relationships
C) normalizing the data and files
D) creating a table for each entity 106) 107) When using the relational model to represent data, one must ________.
A) have more than ten tables in the model
B) add a foreign key to one of the two tables
C) establish only N:M relationships between tables
D) use metadata instead of foreign keys 107) 108) ________ are the final judges as to what data the database should contain and how the records in
that database should be related to one another.
D) Administrators 108) 109) Which of the following is true about the database development process?
A) Changing a relationship from 1:N to N:M is simply a matter of changing the notations.
B) User review of the data model is avoided as it is not helpful in data modeling.
C) A database is a model of how the developers view their business world.
D) The database structure cannot be changed during the data modeling stage. 109) 110) Certain firms obtain data from public and private sources and store and process it in sophisticated
ways. Such firms are called ________.
A) data aggregators
C) data incubators
D) analytics firms 110) ESSAY. Write your answer in the space provided or on a separate sheet of paper.
111) What is the purpose of a database?
112) Describe a database and the various elements of a database.
113) Describe a DBMS and its functions. List some of the popular DBMS softwares.
114) List the various database administration tasks. Provide examples.
115) What are application programs and what are their functions?
116) Explain the different types of DBMS products.
117) Describe the elements of a data model. Provide examples.
118) How does normalization resolve the data integrity problem?
119) Explain the role of users in the database development process.
120) Explain the functioning of data aggregators. 8 ...
View Full Document
This note was uploaded on 01/13/2012 for the course BCIS 3610 taught by Professor Sherry during the Spring '11 term at University of Texas.
- Spring '11