Database Security and Privacy Exam Review
Course Introduction
Database Security and Privacy explores the principles, practices, and technologies used to protect data stored in modern database systems against unauthorized access, misuse, and breaches. The course covers fundamental topics such as authentication, authorization, access control models, encryption techniques, and auditing within relational and NoSQL environments. Students examine threats and vulnerabilities unique to database systems, as well as compliance with data protection regulations and privacy-preserving mechanisms. Emphasis is placed on real-world case studies, risk assessment, secure database design, and best practices for maintaining data integrity and confidentiality throughout the data lifecycle.
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 external schema contains a subset of the conceptual schema relevant to a particular group of users.
A)True
B)False
Answer: True
Q2) The systems development life cycle is the traditional methodology used to develop, maintain, and replace information systems.
A)True
B)False
Answer: True
Q3) The traditional methodology used to develop, maintain and replace information systems is called the:
A) Enterprise Resource Model.
B) Systems Development Life Cycle.
C) Unified Model.
D) Systems Deployment Life Cycle.
Answer: B
To view all questions and flashcards with answers, click on the resource link above.
Page 3
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) What are some of the guidelines for good data names of objects in general?
Answer: Data names always should:
1. Relate to the business, not technical characteristics. Student would be a good name but not filest023
2. Be meaningful so that the name tells what the object is about
3. Be unique
4. Be readable
5. Be composed of words taken from an approved list
6. Be repeatable
7. Follow a standard syntax
Q2) A time stamp is a time value that is associated with a data value.
A)True
B)False
Answer: True
Q3) Which of the following is NOT a good characteristic of a data name?
A) Relates to business characteristics
B) Readable
C) Repeatable
D) Relates to a technical characteristic of the system
Answer: D
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) Mapping existing data to new data in a packaged data model is useful for developing migration plans.
A)True
B)False
Answer: True
Q2) Subtypes at the lowest level of a hierarchy do not inherit attributes from their ancestors.
A)True
B)False
Answer: False
Q3) Subtypes should be used when:
A) there are attributes that apply to some but not all instances of an entity type.
B) supertypes relate to objects outside the business.
C) the instances of a subtype do not participate in a relationship that is unique to that subtype.
D) a recursive relationship is needed.
Answer: A
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) An identifier assigned to an associative entity is also called a cross-relation key. A)True
B)False
Q2) An anomaly is a type of flaw in the database server.
A)True
B)False
Q3) Explain what a candidate key is and how it might be used.
Q4) All values that appear in a column of a relation must be taken from the same domain.
A)True
B)False
Q5) The columns of a relation can be interchanged without changing the meaning or use of the relation.
A)True
B)False
Q6) Discuss the types of integrity constraints.
6
Q7) View integration is the process of merging relations together. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
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) A requirement to begin designing physical files and databases is:
A) normalized relations.
B) physical tables created.
C) implementation complete.
D) all datatypes determined.
Q2) Discuss why physical database design is a foundation for compliance with regulations on financial reporting.
Q3) A method to allow adjacent secondary memory space to contain rows from several tables is called:
A) cluttering.
B) clustering.
C) concatenating.
D) compiling.
Q4) Explain the differences between sequential and indexed file organizations.
Q5) A key is a data structure used to determine the location of rows in a file that satisfy some condition.
A)True
B)False
Q6) Discuss how data integrity can be controlled.
Q7) Why would you want to override automatic query optimization?
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) Adding the DISTINCT keyword to a query eliminates duplicates.
A)True
B)False
Q2) The views are created by executing a CREATE VIEW SQL command.
A)True
B)False
Q3) When creating a table, it is not important to consider foreign key-primary key mates.
A)True
B)False
Q4) SQL is both an American and international standard for database access.
A)True
B)False
Q5) The SQL command ________ defines a logical table from one or more tables or views.
A) create table
B) alter table
C) create view
D) create relationship
Q6) What three clauses are contained in most SQL retrieval statements?
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) In SQL, a(n) ________ subquery is a type of subquery in which processing the inner query depends on data from the outer query.
A) correlated
B) paired
C) natural
D) inner
Q2) The ________ operator is used to combine the output from multiple queries into a single result table.
A) INTERSECT
B) DIVIDE
C) COLLATE
D) UNION
Q3) Explain how to combine queries using the UNION clause.
Q4) User-defined data types:
A) are not allowed in any DBMS.
B) are only allowed in Oracle.
C) can have defined functions and methods.
D) can be used once in a system.
Q5) What is the difference between a trigger and a routine?
Q6) When is it better to use a subquery over using a join?
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) Business rules logic includes such activities as data validation and identification of processing errors.
A)True
B)False
Q2) Which of the following is NOT a disadvantage of stored procedures?
A) Writing stored procedures takes more time than writing an application in Visual Basic or PowerBuilder.
B) Decreases in network traffic are realized.
C) Stored procedures are proprietary and not easy to move from one RDBMS to another.
D) Each client must be loaded with the application to be used at that location.
Q3) ________ facilitates the ability of applications to query relational data along with associated structured data.
A) XPath
B) XQuery
C) XSLT
D) SOAP
Q4) Explain how middleware is used in a two-tier application.
Q5) Explain what stored procedures are and how they are used.
To view all questions and flashcards with answers, click on the resource link above. Page 10
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) A separate data warehouse causes more contention for resources in an organization.
A)True
B)False
Q2) Multidimensional OLAP (MOLAP) tools use variations of SQL and view the database as a relational database, in either a star schema or other normalized or denormalized set of tables.
A)True
B)False
Q3) ________ is an ill-defined term applied to databases where size strains the ability of commonly used relational DBMSs to manage the data.
A) Mean data
B) Small data
C) Star data
D) Big data
Q4) A dependent data mart is filled from the enterprise data warehouse and its reconciled data.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) What are some of the errors and inconsistencies in data that the cleansing process is looking to rectify?
Q2) Data quality is important for all of the following reasons EXCEPT:
A) it minimizes project delay.
B) it aids in making timely business decisions.
C) it provides a stream of profit.
D) it helps to expand the customer base.
Q3) The process of partitioning data according to predefined criteria is called aggregation.
A)True
B)False
Q4) The best place to improve data entry across all applications is:
A) in the users.
B) in the level of organizational commitment.
C) in the database definitions.
D) in the data entry operators.
Q5) Application integration is achieved by coordinating the flow of event information between business applications.
A)True
B)False
Page 12
To view all questions and flashcards with answers, click on the resource link above.
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) There are four main types of NoSQL database data models that include key-value stores, document stores, wide-column stores, and graph databases. Provide an example of a NoSQL database management system for each model.
Q2) The Hadoop Distributed File System (HDFS) is the foundation of a ________ infrastructure of Hadoop.
A) relational database management system
B) DBBMS
C) Java
D) data management
Q3) The NoSQL model that incorporates 'column families' is called a:
A) key-value score.
B) document store.
C) wide-column store.
D) column-SQL database.
Q4) ________ includes the value of speed in a NoSQL database.
A) Velocity
B) Vigilant
C) Verified
D) Variety
Q5) Describe the Five Vs of Big Data.
To view all questions and flashcards with answers, click on the resource link above. Page 13
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) Open-source software always comes with complete documentation.
A)True
B)False
Q2) A DBMS may perform checkpoints automatically or in response to commands in user application programs.
A)True
B)False
Q3) Specifications for transactions do not need to be reviewed quickly.
A)True
B)False
Q4) A transaction that terminates abnormally is called a(n) ________ transaction.
A) terminated
B) aborted
C) completed
D) deleted
Q5) The role of database administration is typically a more hands-on, physical involvement with the management of databases.
A)True
B)False
Q6) What is a journalizing facility?
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) All of the following are disadvantages of data replication EXCEPT:
A) storage requirements.
B) reduced network traffic at prime time.
C) cost of updating.
D) complexity.
Q2) Local autonomy means that data are not accessible from remote sites.
A)True
B)False
Q3) Which of the following characterizes homogeneous environments?
A) Contains simple pathways
B) Same DBMS used at all locations
C) Some users require only local access
D) Cross-linked systems easily communicate
Q4) What are some of the advantages and disadvantages of a distributed database?
Q5) The overriding principle in distributed database design is that data should be stored at one central site.
A)True
B)False
Q6) Describe the range of distributed database environments.
Q7) Discuss the different types of data replication.
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) Which of the following is a reason for using an object-oriented design?
A) The analysis model is not formal enough to be implemented in a programming language.
B) The actual system is not adapted to the environment in which the system will actually be implemented.
C) Documentation is provided.
D) Traditional ERD is preferred.
Q2) An association role is the end of an association where it connects to a class.
A)True
B)False
Q3) A state represents how an object acts.
A)True
B)False
Q4) Object-oriented model objects differ from E-R models because:
A) OO store data.
B) OO allow data types.
C) OO objects exhibits behavior.
D) OO stores information.
Q5) What is the difference between an abstract class and a concrete class?
Q6) What is encapsulation?
To view all questions and flashcards with answers, click on the resource link above. Page 16