Database Administration Practice Exam
Course Introduction
Database Administration provides an in-depth exploration of the principles, techniques, and best practices involved in managing and maintaining database systems. The course covers topics such as installation and configuration of database management systems, backup and recovery strategies, performance tuning, security management, user access control, and automation of routines. Students will learn to ensure data integrity, availability, and reliability, while also gaining practical skills in monitoring and troubleshooting database environments. Emphasis is placed on both theoretical concepts and hands-on experience with widely used database platforms to prepare students for real-world administrative roles.
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) In an entity-relationship (E-R) diagram,rectangles represent entities and lines represent relationships between connected entities.
A)True
B)False
Answer: True
Q2) A good DBMS provides integrity constraints,which are features that let you change the structure of the database without changing the programs that access the database. A)True
B)False
Answer: False
Q3) A group of people in charge of a database within an organization is often called the ____________________.
Answer: DBA database administration database administration (DBA) DBA (database administration)
Q4) The problem of inconsistency in data is a direct result of ____________________.
Answer: redundancy
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) A relational database handles entities,attributes,and relationships by storing each entity in its own table.
A)True
B)False
Answer: True
Q2) With ____________________,users ask their questions by entering column names and other criteria using an on-screen grid,and data that appears on the screen in tabular form.
Answer: QBE
Query-By-Example
Q3) A relation is essentially just a two-dimensional table.
A)True
B)False
Answer: True
Q4) A ____ query creates a new table using the query results.
A)make-table
B)new-table
C)create-table
D)merge-table
Answer: A
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) In SQL,you use the SORT BY clause to display results in a desired order.
A)True
B)False
Answer: False
Q2) Discuss the restriction concerning the structure of two tables involved in a union.
Answer: The two tables involved in a union must have the same structure,or be union compatible; in other words,they must have the same number of fields and their corresponding fields must have the same data types. If,for example,the first field in one table contains customer numbers,the first field in the other table also must contain customer numbers.
Q3) You can use the GROUP BY clause and the ORDER BY clause in the same SELECT statement.
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) A stored procedure is placed on a client computer.
A)True
B)False
Q2) The following command will enable Jones to retrieve data from the Customer table,but not to take any other action: GRANT SELECT ON Customer TO Jones ;
A)True
B)False
Q3) The semicolon at the end of a MySQL command is called a(n)
Q4) Which of the following statement fragments will only allow a CreditLimit of $7,500,$10,000,or $15,000?
A)(CreditLimit IN (7500,10000,15000))
B)CHECK ((7500,10000,15000))
C)CHECK (CreditLimit LIKE (7500,10000,15000))
D)CHECK (CreditLimit IN (7500,10000,15000))
Q5) The following command will revoke the ability to retrieve Customer records from user Jones:
REVOKE GRANT ON Customer FROM 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/38178
Sample Questions
Q1) What is the difference between a table in second normal form and one in third normal form?
Q2) A column is a nonkey attribute when it is not part of the primary key.
A)True
B)False
Q3) By splitting relations to achieve third normal form tables,you create the need to express interrelation constraints.
A)True
B)False
Q4) By splitting relations to achieve third normal form tables,you create the need to express a(n) ____________________ constraint,a condition that involves two or more relations.
Q5) Any column or collection of columns that determines another column is called a(n) ____________________.
Q6) Converting to third normal form always avoids the problems related to dependencies.
A)True
B)False
Q7) Describe the procedure for converting a table to the third normal form.
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/38179
Sample Questions
Q1) A weak entity corresponds to the term ____________________.
Q2) A column that you create for an entity to serve solely as the primary key and that is visible to users is called a(n) ____.
A)synthetic key
B)surrogate key
C)artificial key
D)natural key
Q3) In IDEF1X,the ____ is the symbol for category.
A)square
B)rectangle
C)diamond
D)circle
Q4) Foreign keys allow you to create relationships among tables and enforce certain types of ____________________ constraints in a database.
Q5) What type of information should be included on a survey form in order for it to be considered valuable to the design process?
Q6) ____________________ refers to the number of items that must be included in a relationship.
Q7) On an E-R diagram,____________________ entities have rounded corners.
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/38180
Sample Questions
Q1) ____ 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
Q2) ____ identify users by physical characteristics such as fingerprints,voiceprints,handwritten signatures,and facial characteristics.
A)Passwords
B)Visualizations
C)Econometrics
D)Biometrics
Q3) After a DBMS detects a deadlock,the ____ should break the deadlock.
A)first user
B)second user
C)database administrator
D)DBMS
Q4) A user's ____________________ specify what kind of access the user has to objects 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/38181
Sample Questions
Q1) Changing the database design to improve the performance is called ____ the design.
A)tending
B)focusing
C)tuning
D)modifying
Q2) After the DBMS is purchased,the ____ has primary responsibility for installation and maintenance.
A)IT manager
B)DBA
C)CEO
D)user
Q3) What can the DBA do if the organization has no additional money for its production system but needs further performance improvements?
Q4) ____________________ is the prevention of unauthorized access,either intentional or accidental,to a database.
Q5) The DBA uses views and the SQL ____________________ statement as two security mechanisms.
Q6) The ____________________ strictly controls the production system.
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) A DDBMS that has at least two sites at which the local DBMSs are different is known as a ____.
A)homogeneous DDBMS
B)heterogeneous DDBMS
C)holistic DDBMS
D)heuristic DDBMS
Q2) On a class diagram,the lines joining the classes represent the relationships and are called ____________________.
Q3) A(n) ____ consists of rows that contain consolidated and summarized data.
A)class
B)data model
C)fact table
D)object
Q4) In ____ systems,you create actions as part of data manipulation rather than as part of the data definition.
A)object-oriented
B)relational
C)parallel
D)simple
Q5) What are the advantages of distributed databases?
To view all questions and flashcards with answers, click on the resource link above. Page 11