Relational Database Design Exam
Questions
Course Introduction
Relational Database Design explores the foundational principles and best practices for modeling, structuring, and implementing databases using the relational model. Students will learn about entity-relationship diagrams, normalization techniques for minimizing data redundancy, integrity constraints, and the use of Structured Query Language (SQL) for database definition and manipulation. The course emphasizes the design process from conceptualization to logical and physical implementation, preparing students to create efficient, reliable, and scalable database systems suitable for diverse applications in modern information environments.
Recommended Textbook
Concepts of Database Management 8th Edition by Philip J. Pratt
Available Study Resources on Quizplus
9 Chapters
525 Verified Questions
525 Flashcards
Source URL: https://quizplus.com/study-set/1756
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/34985
Sample Questions
Q1) Programs created with Visual Basic,Java,Perl,PHP,or C++ can access the database directly,rather than having to access it through the DBMS.
A)True
B)False
Answer: False
Q2) A(n)____ is the computer counterpart to an ordinary paper file you might keep in a file cabinet or an accounting ledger.
A) database
B) spreadsheet
C) data file
D) attribute
Answer: C
Q3) Sharing data is one advantage of database processing.
A)True
B)False
Answer: True
Q4) Eliminating ____________________ not only saves space but also makes the process of updating data much simpler.
Answer: redundancy
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: The Relational : Introduction, QBE, and Relational Algebra
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34986
Sample Questions
Q1) In a relation,the order of rows is important.
A)True
B)False
Answer: False
Q2) In an AND criterion,the overall criterion is true if either of the individual criteria is true.
A)True
B)False
Answer: False
Q3) A column whose value uniquely identifies a given row in the table is the secondary key.
A)True
B)False
Answer: False
Q4) To list the records in a query's results in a particular order,you need to ____________________ the records.
Answer: sort
Q5) Columns in a table are often called ____________________.
Answer: fields attributes
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Relational : SQL
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/34987
Sample Questions
Q1) Many versions of SQL other than Access use the ____________________ as a wildcard to represent any individual character.
Answer: underscore underscore (_) _ (underscore)
Q2) The two tables involved in a union must have the same structure,or be ____________________.
Answer: union compatible
Q3) To use a wildcard,include the ____ operator in the WHERE clause. A) LIKE B) AS C) BETWEEN D) UNION
Answer: A
Q4) For each pair of tables to be joined,a condition must be included indicating how the tables are related.
A)True B)False
Answer: True
Page 5
To view all questions and flashcards with answers, click on the resource link above.
Chapter 4: The Relational : Advanced Topics
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34988
Sample Questions
Q1) Within relational model systems on both mainframes and personal computers,the main mechanism for increasing the efficiency with which data is retrieved from the database is the ____________________.
Q2) In Access,you can restrict the legal values accepted by a field by entering an appropriate ____________________ that data entered in the field must follow.
Q3) One advantage of using views is that they provide data dependence. A)True B)False
Q4) The ____ command will create an application program's or individual user's picture of the database.
A) CREATE INDEX
B) SELECT INDEX
C) SELECT VIEW
D) CREATE VIEW
Q5) The following command will enable Jones to retrieve data from the Customer table,but not to take any other action: GRANT SELECT ON Customer Jones ; A)True B)False
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/34989
Sample Questions
Q1) By splitting relations to achieve third normal form tables,you create the need to express interrelation constraints.
A)True
B)False
Q2) A column B is ____________________ on another column A if each value for A in the database is associated with exactly one value of B.
Q3) A(n)____________________ is a condition that involves two or more relations.
Q4) A table that is in first normal form may contain problems that will require you to restructure it.
A)True
B)False
Q5) Partial dependencies are dependencies on only a portion of the ____.
A) nonkey column
B) first column or attribute
C) primary key
D) index
Q6) Any column or collection of columns that determines another column is called a(n)
Q7) Discuss what normal forms are and list the most common normal forms.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
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/34990
Sample Questions
Q1) On an E-R diagram,____________________ entities have rounded corners.
Q2) In IDEF1X,the ____ is the symbol for category.
A) square
B) rectangle
C) diamond
D) circle
Q3) A design that supports all user views is called a constructive design.
A)True
B)False
Q4) An entity that exists to implement a many-to-many relationship is called a(n)____.
A) composite entity
B) complex entity
C) complicated entity
D) circular entity
Q5) You can recognize entity subtypes by the fact the primary key is also a(n)____________________.
Q6) The first step in creating a user view is to normalize the tables.
A)True
B)False
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Dbms Functions
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34991
Sample Questions
Q1) Discuss the advantages and disadvantages of timestamping.
Q2) Explain how a database is updated using batch processing.
Q3) ____________________ occurs when the DBMS exchanges all updated data between the master database and a replica.
Q4) ____ denies access by other users to data while the DBMS processes one user's updates to the database.
A) Batch processing
B) Biometrics
C) Journaling
D) Locking
Q5) In two-phase locking,the second phase is the shrinking phase.
A)True
B)False
Q6) ____ integrity implies that the value entered for any field should be consistent with the data type for that field.
A) Data type
B) Legal value
C) Format
D) Secondary
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/34992
Sample Questions
Q1) Tables with indexes allow faster searches,but slow performance on ____.
A) insertions
B) deletions
C) updates
D) selects
Q2) Which of the following DBMS evaluation categories does the following question relate to: Does the DBMS allow partial copies and how does the DBMS handle updates to the same data from two or more replicas?
A) Backup and recovery
B) Security
C) Integrity
D) Replication and distributed databases
Q3) ____________________ help means that if a user is having trouble and asks for help,the DBMS will provide assistance for the particular feature being used at the time the user asks for help.
Q4) Discuss the steps that organizations take to protect their data against hard drive failures and electrical power interruptions or outages.
Q5) What is a hot site?
Q6) What is the DBA's role with regard to access privileges?
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/34993
Sample Questions
Q1) Each digital document on the Web is called a ____.
A) Web server
B) Web browser
C) client
D) Web page
Q2) A ____ is a subject-oriented,integrated,time-variant,nonvolatile collection of data in support of management's decision-making process.
A) data warehouse
B) thin client
C) back-end processor
D) fat client
Q3) In ____ systems,data and actions are encapsulated.
A) relational
B) object-oriented
C) network
D) parallel
Q4) A(n)_________________________ is a DBMS capable of supporting and manipulating distributed databases.
Q5) Explain the difference between a Web page,a Web server,and a Web client.
Q6) What are the advantages of a client/server system?
Page 11
To view all questions and flashcards with answers, click on the resource link above.