Database Administration
Final Exam Questions
Course Introduction
Database Administration focuses on the principles and practices required to manage, maintain, and secure database systems within an organizational environment. This course covers topics such as database architecture, installation, configuration, performance tuning, backup and recovery, user management, and security measures. Students will gain hands-on experience with popular database management systems, learn how to automate routine administrative tasks, and develop skills for troubleshooting and optimizing database operations. Emphasis is also placed on industry best practices and the role of a database administrator in supporting enterprise applications and ensuring data integrity and availability.
Recommended Textbook
Database Systems Introduction to Databases and Data Warehouses 1st Edition by Nenad Jukic
Available Study Resources on Quizplus
10 Chapters
752 Verified Questions
752 Flashcards
Source URL: https://quizplus.com/study-set/3126 Page 2
Chapter 1: Introduction
Available Study Resources on Quizplus for this Chatper
57 Verified Questions
57 Flashcards
Source URL: https://quizplus.com/quiz/61941
Sample Questions
Q1) End users can vary in:
A)Their level of technical sophistication
B)The amount of data they need
C)The frequency with which they access the database system
D)All of the above.
Answer: D
Q2) Conceptual data modeling is another term for requirements visualization.
A)True
B)False
Answer: True
Q3) Metadata is a subset of data that is most recently entered. A)True
B)False Answer: False
Q4) Information that is collected in database systems can be used,in general,for two purposes: an operational purpose and a transactional purpose.
A)True
B)False Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Database Requirements and ER Modeling
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61942
Sample Questions
Q1) According to the Eaglerun Trucking Dispatcher ER diagram,each driver owns a truck.
A)True
B)False
Answer: False
Q2) Which of the following is true according to the ABC Retailer ER diagram?
A)We cannot keep track of promotions that are not associated with multiple products
B)We must keep track of promotions that are not associated with any products
C)We can keep track of promotions that are not associated with any products
D)We cannot keep track of promotions that are not associated with any products
Answer: D
Q3) Every ER notation uses the same rule for placement of cardinality constraints in the relationships of the ER diagram.
A)True
B)False
Answer: False
Q4) What is an identifying relationship?
Answer: An identifying relationship in an ER diagram is a relationship between a weak entity and its owner entity.
To view all questions and flashcards with answers, click on the resource link above.
4
Chapter 3: Relational Database Modeling
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61943
Sample Questions
Q1) If in the GENERIC ERD the Symbol 1 is >| and the Symbol2 is ||,then the number of columns in the relational schema resulting from mapping the GENERIC ERD is 5.
A)True
B)False
Answer: True
Q2) Two columns of two different tables in the same relational database can have the same names.
A)True
B)False
Answer: True
Q3) If in the GENERIC ERD the Symbol 1 is >| and the Symbol2 is ||,then the number of optional columns in the relational schema resulting from mapping the GENERIC ERD is 0. A)True
B)False
Answer: True
Q4) What is a foreign key?
Answer: A foreign key is a column in a relation that refers to a primary key column in another (referred)relation.
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Update Operations, update Anomalies, and Normalization
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61944
Sample Questions
Q1) When does a full key functional dependency occur?
Q2) Functional dependency OwnerName --> Make exists in the table VEHICLE. A)True
B)False
Q3) Table STUDENT is in 1NF.
A)True
B)False
Q4) Changing the name of owner O2,Pat to Patrick in the table VEHICLE will cause an occurrence of a modification anomaly.
A)True
B)False
Q5) If A,B,C,and D are columns of the table whose composite primary key is A,B while C and D are nonkey columns then C --> D is a transitive functional dependency.
A)True
B)False
Q6) Normalizing table VEHICLE to 3NF will result in two separate tables. A)True B)False
Q7) List the types of update anomalies? Page 6
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 5: SQL
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61945
Sample Questions
Q1) Show the CREATE TABLE statements for the table VEHICLE (assume that non-primary key columns can be optional. )
Q2) What is the purpose of DDL statements?
Q3) Which of the following queries on table STUDENT will return three values as a result?
A)SELECT name FROM student WHERE class != 'Sophomore';
B)SELECT name FROM student;
C)SELECT DISTINCT name FROM student;
D)SELECT class FROM student;
Q4) What is the purpose of DML statements?
Q5) What is determined by the WHERE condition in the SELECT statement?
Q6) What is a correlated query and how is it used in conjunction with the EXISTS operator?
Q7) Write an SQL query on the table STUDENT that lists records (all columns)for all freshman students.
Q8) What is a view?
Q9) Write an SQL query for HAPPY INSURANCE database that will for each area display the area ID,area name,and average rating for all agents in the area.
Q10) When can the NOT operator be used?
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 6: Database Implementation and Use
Available Study Resources on Quizplus for this Chatper
55 Verified Questions
55 Flashcards
Source URL: https://quizplus.com/quiz/61946
Sample Questions
Q1) Show the CREATE TABLE statements for HAPPY INSURANCE database for the table AGENT (assume that non-primary key columns can be optional)with the user defined constraint specifying that the agent rating must be between 50 and 150.
Q2) Which of the following describes the consistency data quality characteristic?
A)The degree to which all the required data is present in the data collection
B)The extent to which the data properly conforms to and matches up with the other data
C)The extent to which data correctly reflects the real world instances it is supposed to depict
D)The extent to which the data conforms to its specified format
Q3) If a DBMS enforces in the HAPPY INSURANCE database a DELETE RESTRICT option on the referential integrity constraint between AREA and AGENT,and a DELETE CASCADE between AGENT and CLIENT,the first record in the table AGENT can be deleted.
A)True
B)False
Q4) What is a report?
Q5) Describe the update set-to-null option (for implementing a referential integrity constraint).
To view all questions and flashcards with answers, click on the resource link above.
Page 9
Chapter 7: Data Warehousing Concepts
Available Study Resources on Quizplus for this Chatper
48 Verified Questions
48 Flashcards
Source URL: https://quizplus.com/quiz/61947
Sample Questions
Q1) In contrast to a narrow constituency of operational data,analytical data is used by a widespread set of users.
A)True
B)False
Q2) Show an example data set organized in two different ways illustrating the difference between the application-oriented and subject-oriented organization of data.
Q3) The design and creation of data warehouse front-end applications can take place in parallel with data warehouse creation.
A)True
B)False
Q4) Summarized operational data is typically physically stored,while summarized analytical data is typically derived (calculated)rather than physically stored.
A)True
B)False
Q5) Describe the data warehouse deployment step.
Q6) Operational databases are referred to as subject-oriented.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 8: Data Warehouse and Data Mart Modeling
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/61948
Sample Questions
Q1) The ________ slowly changing dimension approach involves creating a previous and current column in the dimension table for each column where changes are anticipated.
A)Type 1
B)Type 2
C)Type 3
D)Type 0
Q2) Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS database,if we created an aggregated fact table that contains data about daily prescribed quantities of each medication per each doctor,such an aggregated table would have ________ records in the fact table.
A)2
B)3
C)4
D)5
Q3) Dimensional modeling can be employed as a relational data modeling technique. A)True
B)False
Q4) What does granularity of a fact table describe?
Q5) What is a snowflake model?
11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Data Warehouse Implementation and Use
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/61949
Sample Questions
Q1) The word online in the term OLAP refers to the use of the Internet or other networks.
A)True
B)False
Q2) In the case of so-called active data warehouses,the loads occur in ________ that happen continuously,ensuring that the data in the data warehouse is updated close to real time (enabling analysis of the latest data).
A)Dimensional modeling actions
B)OLAP actions
C)OLTP actions
D)Micro batches
Q3) OLAP/BI tools are designed for the analysis of dimensionally modeled data.
A)True
B)False
Q4) What enables direct lookup of values in the fact table in a multidimensional cube?
Q5) What is a first load?
Q6) What is a refresh cycle?
Q7) What is an executive dashboard?
Q8) What is the multidimensional database model?
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Overview of Dbms Functionalities and Database Administration
Available Study Resources on Quizplus for this Chatper
42 Verified Questions
42 Flashcards
Source URL: https://quizplus.com/quiz/61950
Sample Questions
Q1) What is the purpose of the COMMIT command?
Q2) The application development component is a part of every DBMS package. A)True B)False
Q3) What is a complete mirrored backup?
Q4) What is update failure?
Q5) What is a single-user DBMS?
Q6) What is the purpose of the data definition component of a DBMS?
Q7) Regular monitoring helps the DBA recognize instances when maintenance activities are needed.
A)True B)False
Q8) The data definition component is a part of every DBMS package. A)True B)False
Q9) The DCL commands are used by the business end users of a database system. A)True B)False Page 13
Q10) What is the difference between accidental misuse and malicious data updates?
Q11) What is the purpose of the data administration component of a DBMS?
To view all questions and flashcards with answers, click on the resource link above. Page 14