Applied Database Technologies
Test Questions
Course Introduction
Applied Database Technologies explores the practical concepts, tools, and methodologies used in the design, implementation, and management of modern database systems. Students will gain hands-on experience with relational and NoSQL databases, data modeling, SQL querying, performance optimization, and database security. The course emphasizes real-world applications and the integration of databases within larger software solutions, preparing students to address common challenges in data management and to leverage emerging technologies in database development.
Recommended Textbook
Concepts of Database Management 9th Edition by Joy L. Starks
Available Study Resources on Quizplus
9 Chapters
525 Verified Questions
525 Flashcards
Source URL: https://quizplus.com/study-set/1925 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/38335
Sample Questions
Q1) There is a greater impact of failure in a nondatabase, file-oriented system.
A)True
B)False
Answer: False
Q2) _________________________ describes the large volume of data produced by every digital process, system, sensor, mobile device, and even social media exchange.
Answer: Big data
Q3) Which of the following is considered a disadvantage of a database system?
A) a larger file size
B) data dependence
C) reduced integrity
D) reduced productivity
Answer: A
Q4) If a user is authorized to access database data, the user will always be able to make changes to the data.
A)True
B)False
Answer: False
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/38336
Sample Questions
Q1) To select data from more than one table at the same time, you need to perform a make-table query.
A)True
B)False
Answer: False
Q2) When both criteria must be true for the compound criterion to be true, the _______________ operator is being used.
Answer: AND
Q3) In relational database shorthand, the structure of a relational database is written with the name of the table followed by the columns in the table listed within parentheses.
A)True
B)False
Answer: True
Q4) A(n) ____________________ database is a collection of tables.
Answer: relational
Q5) A ____________________ query in Access allows you to enter criterion when you run the query, as opposed to placing it in the design grid. Answer: parameter
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/38337
Sample Questions
Q1) A compound condition includes either or both of the AND and OR operators.
A)True
B)False
Answer: True
Q2) A WHERE and a HAVING clause cannot be included in the same query.
A)True
B)False
Answer: False
Q3) In a DBMS such as Oracle or SQL Server, the _______________ command reverses changes to a database.
Answer: ROLLBACK
Q4) What command do you use to make changes to existing data in a table?
A) MODIFY
B) CHANGE
C) SELECT
D) UPDATE
Answer: D
Q5) One common restriction placed on table and column names by DBMSs is that names must start with a(n) ____________________.
Answer: letter
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/38338
Sample Questions
Q1) Which rule uses a foreign key in Table B to ensure that the field matches a primary key field in Table A?
A) legal-values integrity
B) structural integrity
C) referential integrity
D) entity integrity
Q2) 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 ____________________.
Q3) A trigger is stored and compiled on the client computer.
A)True
B)False
Q4) Which of the following is a disadvantage of using an index?
A) You can only add an index when the table is created.
B) You can't use indexes with foreign keys.
C) Record retrieval is less efficient.
D) The index must be updated whenever the data in the database changes.
Q5) You use the __________ statement to give users privileges to the database.
Q6) In SQL, you can use the _______________ clause to enforce legal-values integrity.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
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/38339
Sample Questions
Q1) Which normal form has an additional condition that the only determinants the table contains are candidate keys?
A) First
B) Second
C) Third
D) Fourth
Q2) A table is in fourth normal form when it is in third normal form and there are no ________________ dependencies.
Q3) If column B is functionally dependent on column A, you can also say that column B functionally determines column A.
A)True
B)False
Q4) If you convert a collection of tables to an equivalent third normal form collection of tables, what problems do you remove?
A) those arising from multivalued dependencies
B) those arising from functional dependencies
C) those arising from inappropriate null values
D) those arising from incomplete deletions
Q5) A(n) ________________ key is a candidate key not chosen ad the primary key.
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/38340
Sample Questions
Q1) The first substep in representing the user view as a collection of tables is to determine entities and create a table for each.
A)True
B)False
Q2) The crucial issue in making the determination between a single many-to-many-to-many relationship and two (or three) many-to-many relationships is the ____.
A) independence
B) primary key
C) redundancy
D) primary index
Q3) The first step in creating a user view is to normalize the collection of tables.
A)True
B)False
Q4) The simplest way to implement a one-to-one relationship is to treat it as a one-to-many relationship.
A)True
B)False
Q5) How can you attempt to avoid the problem of creating a table that is not in third normal form?
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/38341
Sample Questions
Q1) Explain how a DBMS breaks a deadlock.
Q2) What technique is used to identify the person who is attempting to access the DBMS?
A) encryption
B) authentication
C) authorization
D) viewing
Q3) Which of the following is a federal law that sets a national standard to protect an individual's medical records and other personal health information?
A) FCRA
B) HIPAA
C) FERPA
D) IDEA
Q4) Which process returns the database to a state that is known to be correct?
A) recovery
B) concurrent update
C) encryption
D) batch processing
Q5) Discuss the four ways in which integrity constraints can be handled.
Q6) ____________________ involves maintaining a log of all updates in the database.
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/38342
Sample Questions
Q1) When selecting a DBMS, the only database model choice available to the DBA is the relational model.
A)True
B)False
Q2) Discuss the steps that organizations take to protect their data against hard drive failures and electrical power interruptions or outages.
Q3) To manage problems that arise from using a DBMS, companies appoint a DBA to manage both the database and the use of the DBMS.
A)True
B)False
Q4) When evaluating and selecting a DBMS, in which category is the DBA most concerned with benchmarks?
A) Cost
B) Security
C) Integrity
D) Performance
Q5) In a LAN, support for ____________________ update is very important because many users might be updating the database at the same time.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Database Management Approaches
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/38343
Sample Questions
Q1) Which arrangement of client/server architecture uses thin clients to perform only presentation functions while a single server performs database and business functions?
A) single-tier architecture
B) two-tier architecture
C) three-tier architecture
D) multi-tier architecture
Q2) With respect to the definition of data warehouse, which of the following means that data in a data warehouse represents periodic snapshots of the data, such as at the end of each month?
A) nonvolatile
B) time-variant
C) subject-oriented
D) integrated
Q3) With ____________________ visibility, only the class itself can view or update the value.
Q4) Web pages that display the same content for all Web clients are called ____________________ Web pages.
Q5) To execute the steps in a(n) ____________________, the user sends a message to the object.
To view all questions and flashcards with answers, click on the resource link above. Page 11