Database Management Systems Exam
Review
Course Introduction
Database Management Systems is a comprehensive course that delves into the design, implementation, and management of databases essential to modern applications. Students will explore fundamental concepts such as data models, relational algebra, normalization, and query languages like SQL. The course covers database architecture, transaction management, indexing, and security, while also addressing contemporary topics such as distributed databases and NoSQL systems. Through hands-on projects and practical assignments, students will gain experience in schema design, data manipulation, and database administration, equipping them with the skills necessary to manage large volumes of data efficiently and securely in real-world scenarios.
Recommended Textbook
Concepts of Database Management 7th Edition by Philip J. Pratt
Available Study Resources on Quizplus
9 Chapters
524 Verified Questions
524 Flashcards
Source URL: https://quizplus.com/study-set/1914 Page 2
Chapter 1: Introduction to Database Management
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38174
Sample Questions
Q1) Eliminating redundancy is always possible when using a database approach.
A)True
B)False
Answer: False
Q2) A database has ____ if the data in it satisfies all established integrity constraints.
A)redundancy
B)integrity
C)data independence
D)database design
Answer: B
Q3) Storing the same data in more than one place is called ____.
A)data independence
B)data integrity
C)redundancy
D)security
Answer: C
Q4) In an E-R diagram,the ____________________ at the end of a line indicates the "many" part of the one-to-many relationship between two entities.
Answer: dot
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: The Relational Model 1: Introduction, QBE, and Relational Algebra
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38175
Sample Questions
Q1) Provide a definition for the term relation.
Answer: A relation is a two-dimensional table in which:
1. The entries in the table are single-valued; that is,each location in the table contains a single entry.
2. Each column has a distinct name
3. All values in a column are values of the same attributes
4. The order of columns is immaterial
5. Each row is distinct
6. The order of rows is immaterial
Q2) A query that changes data is a(n) ____ query.
A)addition
B)update
C)update.
D)select
Answer: C
Q3) In Access,you can add all fields from a table to the design grid by double-clicking the ____________________ in the table's field list.
Answer: asterisk
*
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Relational Model 2: SQL
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/38176
Sample Questions
Q1) The rules for naming tables and columns are the same in every version of SQL.
A)True
B)False
Answer: False
Q2) How does the format for dates in queries in Access differ from other implementations of SQL?
Answer: In Access,you place number signs around the date (for example,#11/15/2013#). In other programs,you enter the day of the month,a hyphen,the three-character abbreviation for the month,a hyphen,and the year,all enclosed in single quotation marks (for example,'15-NOV-2013').
Q3) Fields will appear in the query results in the order in which they are listed in the SELECT clause.
A)True
B)False Answer: True
Q4) Most relational DBMSs use a version of SQL as a data manipulation language.
A)True
B)False Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: The Relational Model 3: Advanced Topics
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38177
Sample Questions
Q1) Access has a tool called the ____________________,which allows you to easily print detailed documentation concerning any table,query,report,form,or other object in the database.
Q2) A stored procedure is placed on a client computer.
A)True
B)False
Q3) To create the primary key clause for the Customer table on the CustomerNum field,the correct statement is ____.
A)PRIMARY KEY (CustomerNum)
B)PRIMARY KEY (Customer,CustomerNum)
C)KEY (CustomerNum)
D)PRIMARY (CustomerNum)
Q4) Essentially,setting the value in a given field to ____ is similar to not entering a value in it at all.
A)0
B)nil
C)blank
D)null
Q5) Explain what is meant by a null value. Is a null value the same as a value of zero?
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Database Design 1: Normalization
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38178
Sample Questions
Q1) The conversion of an unnormalized table to first normal form requires the removal of
A)determinants
B)interrelation constraints
C)nonkey columns
D)repeating groups
Q2) ____ normal form has an additional condition that the only determinants the table contains are candidate keys.
A)First
B)Second
C)Third
D)Fourth
Q3) The possibility of data dependence is one of the four categories of update anomalies.
A)True
B)False
Q4) In a table with columns A,B,and C,there is a(n) ____________________ dependence of column B on column A if each value for A is associated with a specific collection of values for B and,further,this collection is independent of any values for C.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Database Design 2: Design Method
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/38179
Sample Questions
Q1) A set of requirements that is necessary to support the operations of a particular database user is known as a(n) ____.
A)user view
B)user snapshot
C)user window
D)user system
Q2) A(n) ____ is a system-generated primary key that is usually hidden from users.
A)logical key
B)surrogate key
C)natural key
D)artificial key
Q3) The second step in creating a user view is to identify all keys in the tables.
A)True
B)False
Q4) An entity that depends on another entity for its own existence is called a weak entity.
A)True
B)False
Q5) Explain the difference between a minimum cardinality of zero and a minimum cardinality of one.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Dbms Functions
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38180
Sample Questions
Q1) One strategy to manage deadlocks is to let them occur and then have the DBMS detect and break any deadlock.
A)True
B)False
Q2) The more important it is to avoid redoing work,the more often you should make backups.
A)True
B)False
Q3) Concentric update occurs when multiple users make updates to the same database at the same time.
A)True
B)False
Q4) The technique for identifying the person who is attempting to access the DBMS is known as ____.
A)encryption
B)authentication
C)authorization
D)viewing
Q5) Discuss the four ways in which integrity constraints can be handled.
Q6) Discuss the advantages and disadvantages of timestamping.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Database Administration
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/38181
Sample Questions
Q1) Discuss the steps that organizations take to protect their data against hard drive failures and electrical power interruptions or outages.
Q2) The ____________________ strictly controls the production system.
Q3) Which of the following DBMS evaluation categories does the following question relate to: Does the vendor of the DBMS supply printed or online training manuals and how good are the manuals?
A)Portability
B)Performance
C)Cost
D)Documentation and training
Q4) The DBA is responsible for DBMS maintenance,data dictionary management,and training.
A)True
B)False
Q5) A configuration of several computers connected together that allow users to share a variety of hardware and software resources is known as a(n)
Q6) With just two exceptions,the DBA grants access and update privileges to the production system only to authorized users. What are the exceptions?
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Database Management Approaches
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/38182
Sample Questions
Q1) The ____________________ symbol in a class diagram indicates whether other classes can view or update the value in the attribute.
Q2) A file server stores the files required by the users on a network.
A)True
B)False
Q3) ____ refers to the association of an operation to actual program code.
A)Attaching
B)Matching
C)Linking
D)Binding
Q4) Because the clients and the server perform different functions and can run two different operating systems,there is an arrangement of client/server architecture known as ____.
A)single-tier architecture
B)two-tier architecture
C)three-tier architecture
D)four-tier architecture
Q5) Explain the difference between a Web page,a Web server,and a Web client.
Q6) What are the advantages of distributed databases?
Page 11
Q7) On a class diagram,a(n) ____________________ symbol precedes each attribute.
To view all questions and flashcards with answers, click on the resource link above.