Introduction to Databases Exam Review
Course Introduction
Introduction to Databases provides students with a fundamental understanding of database systems, focusing on data modeling, relational database concepts, and the use of database management systems (DBMS). The course covers topics such as entity-relationship modeling, normalization, Structured Query Language (SQL), and database design principles. Students will learn how to create, manage, and query relational databases while also gaining exposure to database security, transaction management, and emerging trends in data storage. Hands-on exercises and projects enable students to apply theoretical knowledge to real-world scenarios, preparing them for further study or careers involving data management and analysis.
Recommended Textbook
Modern Database Management 12th Edition by Jeffrey A. Hoffer
Available Study Resources on Quizplus
14 Chapters
1469 Verified Questions
1469 Flashcards
Source URL: https://quizplus.com/study-set/1058 Page 2
Chapter 1: The Database Environment and Development Process
Available Study Resources on Quizplus for this Chatper
116 Verified Questions
116 Flashcards
Source URL: https://quizplus.com/quiz/20934
Sample Questions
Q1) The most common way to support a group of individuals who work together on a project or group of similar projects is with a two-tier client/server database.
A)True
B)False
Answer: True
Q2) The relational data model is no longer popular in the 21 century.
A)True
B)False
Answer: False
Q3) The failure to implement a strong database administrative function is the most common source of database failures in organizations.
A)True
B)False
Answer: True
Q4) The conceptual schema is always technology specific.
A)True
B)False
Answer: False
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Modeling Data in the Organization
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20935
Sample Questions
Q1) An attribute that must have a value for every entity (or relationship) instance is a(n):
A) composite attribute.
B) required attribute.
C) optional attribute.
D) multivalued attribute.
Answer: B
Q2) It is desirable that no two attributes across all entity types have the same name.
A)True
B)False
Answer: True
Q3) The logical representation of an organization's data is called a(n):
A) database model.
B) entity-relationship model.
C) relationship systems design.
D) database entity diagram.
Answer: B
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Enhanced E-R Model
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20936
Sample Questions
Q1) Creating a data model from a packaged data model requires much more skill than creating one from scratch.
A)True
B)False
Answer: False
Q2) Given the following entities, which of the choices below would be the most complicated? Automobile: VIN, EngineSize, NumberOfDoors, NumberOfPassengers, FuelType, Transmission
SUV: VIN, EngineSize, NumberOfPassengers, NoWheelDrive, FuelType, Transmission Truck: VIN, EngineSize, NoWheelDrive, FuelType, Transmission, Payload
A) Define one vehicle entity type to hold all entities.
B) Define a separate entity type for each entity.
C) Define a supertype called vehicle and make each of the entities subtypes.
D) Keep only the Truck entity type.
Answer: A
Q3) Subtypes at the lowest level of a hierarchy do not inherit attributes from their ancestors.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Logical Database Design and the Relational Model
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20937
Sample Questions
Q1) The entity integrity rule states that:
A) no primary key attribute can be null.
B) referential integrity must be maintained across all entities.
C) each entity must have a primary key.
D) a primary key must have only one attribute.
Q2) An identifier assigned to an associative entity is also called a cross-relation key.
A)True
B)False
Q3) A candidate key is an attribute, or combination of attributes, that uniquely identifies a row in a relation.
A)True
B)False
Q4) Which of the following are properties of relations?
A) Each attribute has the same name.
B) No two rows in a relation are identical.
C) There are multivalued attributes in a relation.
D) All columns are numeric.
Q5) Discuss the two possible scenarios when mapping an associative entity.
Q6) Discuss the types of integrity constraints.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Physical Database Design and Performance
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20938
Sample Questions
Q1) Discuss why physical database design is a foundation for compliance with regulations on financial reporting.
Q2) How are missing values generally handled in database management systems?
Q3) One method to handle missing values is to substitute an exact value.
A)True
B)False
Q4) Discuss three possible opportunities for denormalization.
Q5) Requirements for response time, data security, backup and recovery are all requirements for physical design.
A)True
B)False
Q6) Explain what a tablespace is and how it is used.
Q7) A pointer is a field of data that can be used to locate a related field or record of data. A)True
B)False
Q8) In a sequential file, the records are stored in sequence according to a primary key value.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Introduction to SQL
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20939
Sample Questions
Q1) Explain the three classes of SQL commands and when they would be used.
Q2) A catalog is the structure that contains object descriptions created by a user. A)True
B)False
Q3) When creating tables, it's important to decide which columns will allow null values before the table is created.
A)True
B)False
Q4) What result set is returned from the following query? Select Customer_Name, telephone
From customers
Where city in ('Boston','New York','Denver');
A) The Customer_Name and telephone of all customers
B) The Customer_Name and telephone of all customers living in either Boston, New York or Denver
C) The Customer_Name and telephone of all customers living in Boston and New York and Denver
D) The Customer_Name of all customers living in Boston, New York or Denver
Q5) What is a materialized view, and when would it be used?
Q6) What are some of the advantages and disadvantages to an SQL standard?
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Advanced SQL
Available Study Resources on Quizplus for this Chatper
107 Verified Questions
107 Flashcards
Source URL: https://quizplus.com/quiz/20940
Sample Questions
Q1) Dynamic SQL:
A) is used to generate appropriate SQL code on the fly as an application is processing.
B) is quite volatile.
C) is not used widely on the Internet.
D) creates a less flexible application.
Q2) A correlated subquery is executed once for each iteration through the outer loop.
A)True
B)False
Q3) An equi-join is a join in which one of the duplicate columns is eliminated in the result table.
A)True
B)False
Q4) EXISTS takes a value of false if the subquery returns an intermediate result set.
A)True
B)False
Q5) What is the difference between a trigger and a routine?
Q6) What can be done with Persistent Stored Modules?
To view all questions and flashcards with answers, click on the resource link above.
Page 9
Chapter 8: Database Application Development
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20941
Sample Questions
Q1) Service-oriented architectures (SOA) are:
A) a set of tiers designed to serve each other.
B) a collection of services that communicate with each other in some manner.
C) architecture designed for the military.
D) architecture designed for Schools of Accountancy (SOA).
Q2) XQuery can be used to transform XML into:
A) XPath.
B) XQuery.
C) XMILL.
D) XHTML.
Q3) ________ is a language used to transform complex XML documents and also to create HTML pages from XML documents.
A) HTML
B) XSLT
C) SGI
D) WSL
Q4) Two-tier architectures are much more scalable than three-tier architectures.
A)True
B)False
Q5) Discuss some of the key benefits of three-tier applications.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Data Warehousing
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20942
Sample Questions
Q1) For performance reasons, it may be necessary to define more than one fact table for a star schema.
A)True
B)False
Q2) A separate data warehouse causes more contention for resources in an organization.
A)True
B)False
Q3) What are some approaches to handling slowly changing dimensions?
Q4) Rotating the view of a multidimensional database for a particular data point is called data:
A) cubing.
B) drill-down.
C) dicing.
D) pivoting.
Q5) When multiple systems in an organization are synchronized, the need for data warehousing increases.
A)True
B)False
Q6) Explain what the star schema is.
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Data Quality and Integration
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20943
Sample Questions
Q1) There are six major steps to ETL.
A)True
B)False
Q2) What is data transformation?
Q3) Dirty data saves work for information systems projects.
A)True
B)False
Q4) What are the record-level data transformation functions?
Q5) All of the following are tasks of data cleansing EXCEPT:
A) decoding data to make them understandable for data warehousing applications.
B) adding time stamps to distinguish values for the same attribute over time.
C) generating primary keys for each row of a table.
D) creating foreign keys.
Q6) A technique using pattern recognition to upgrade the quality of raw data is called:
A) data scrounging.
B) data scrubbing.
C) data gouging.
D) data analysis.
Q7) What are the key steps in a data quality program?
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Big Data and Analytics
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20944
Sample Questions
Q1) An organization that requires a sole focus on performance with the ability for keys to include strings, hashes, lists, and sorted sets would select ________ database management system.
A) Access
B) Excel Spreadsheet
C) Neo4j
D) Redis
Q2) Describe conceptually how big data differs from traditional relational database management systems.
Q3) HP HAVEn integrates HP technologies with open source big data technologies.
A)True
B)False
Q4) Application of statistical and computational methods to predict data events is: A) predictive analytics.
B) descriptive analytics.
C) prescriptive analytics.
D) comparative analytics.
Q5) Server logs are considered a big data variety data type. A)True
B)False
13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: Data and Database Administration
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/20945
Sample Questions
Q1) The restore/rerun technique involves reprocessing the day's transactions against the backup copy of the database.
A)True
B)False
Q2) What are the most important security features for data management software?
Q3) Exclusive locks allow other transactions to read but not update a record or other resource.
A)True
B)False
Q4) Databases are generally the property of a single department within an organization.
A)True
B)False
Q5) Concurrent transactions need to be processed in isolation so that they do not interfere with each other.
A)True
B)False
Q6) Loss of data integrity does not impact the quality of data in a database. A)True
B)False
Page 14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Distributed Databases
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/20946
Sample Questions
Q1) A(n) ________ is a database stored on multiple computers in multiple locations that are NOT connected by a data communications link.
A) distributed database
B) decentralized database
C) unlinked database
D) data repository
Q2) Failure transparency is a design goal for distributed databases that guarantees that all the actions associated with a transaction are either committed or none of them are committed.
A)True
B)False
Q3) When separate copies of data are stored at each of two or more sites, it is called replication.
A)True
B)False
Q4) What is data replication?
Q5) A transaction manager is an algorithm that coordinates updates or aborts them.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Object-Oriented Data Modeling
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20947
Sample Questions
Q1) When an operation may apply to two or more classes in different ways, this is known as polymorphism.
A)True
B)False
Q2) Each role has a duplicity, which indicates how many objects participate in a given relationship.
A)True
B)False
Q3) What is the purpose of a constructor operation?
Q4) An association role is the end of an association where it connects to a class.
A)True
B)False
Q5) ________ means that the same operation can apply to two or more classes in different ways.
A) Polymorphism
B) Inheritance
C) Combined operations
D) Checkpoint
Q6) What is polymorphism?
Q7) What is the difference between an abstract class and a concrete class?
To view all questions and flashcards with answers, click on the resource link above. Page 16