Database Administration
Review Questions
Course Introduction
Database Administration is an in-depth course designed to equip students with the knowledge and practical skills required to manage, maintain, and secure modern database systems. The course covers fundamental topics such as database installation and configuration, user and security management, backup and recovery strategies, performance tuning, and troubleshooting. Students will explore various database management systems (DBMS), understand the principles behind data integrity and availability, and engage in hands-on exercises to practice real-world administrative tasks. By the end of the course, students will be prepared to efficiently oversee database environments and ensure optimal data management within organizations.
Recommended Textbook
Database Processing 12th Edition by David
M. Kroenke
Available Study Resources on Quizplus
24 Chapters
1854 Verified Questions
1854 Flashcards
Source URL: https://quizplus.com/study-set/1823 Page 2
Chapter 1: Introduction
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36220
Sample Questions
Q1) In an enterprise-class database system,the database application ________.
A)creates queries
B)creates forms
C)creates reports
D)A and B
E)B and C
Answer: E
Q2) The database management system (DBMS)is responsible for enforcing referential integrity constraints.
A)True
B)False
Answer: True
Q3) Database design is important,but fortunately it is simple to do.
A)True
B)False
Answer: False
Q4) A database is called "self-describing" because it reduces data duplication.
A)True
B)False
Answer: False
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Introduction to Structured Query Language SQL
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36222
Sample Questions
Q1) Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the following would find all employees whose name begins with the letter "S" using Microsoft Access?
A)SELECT *
FROM EMPLOYEE WHERE Name IN ['S'];
B)SELECT EmpNo
FROM EMPLOYEE WHERE Name LIKE 'S';
C)SELECT *
FROM Name WHERE EMPLOYEE LIKE 'S*';
D)SELECT *
FROM EMPLOYEE WHERE Name LIKE 'S%';
E)None of the above.
Answer: C
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Relational Model and Normalization
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36224
Sample Questions
Q1) The essence of normalization is taking a relation that is not in BCNF and breaking it into multiple relations such that each one is in BCNF.
A)True
B)False
Answer: True
Q2) Undesirable consequences of changing the data in a relation are called "modification anomalies."
A)True
B)False
Answer: True
Q3) A determinant of a functional dependency may or may not be unique in a relation.
A)True
B)False
Answer: True
Q4) Given the functional dependency (A,B) C,the attributes (A,B)are referred to as a composite determinant.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Database Design Using Normalization
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36226
Sample Questions
Q1) When you are given a set of tables and asked to create a database to store their data,the first step is to assess the tables' structure and content.
A)True
B)False
Q2) If you have a table with a set of columns named "Child01","Child02" and "Child03",the table has the multivalued,multicolumn problem.
A)True
B)False
Q3) A form of multivalued dependency is found in ________.
A)the multivalued,multicolumn problem
B)the inconsistent values problem
C)the missing values problem
D)the general-purpose remarks column problem
E)None of the above is correct.
Q4) Writing SQL subqueries and joins against normalized tables is simple compared to the code that must be written to handle anomalies from multivalued dependencies.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
6
Chapter 5: Data Modeling With the Entity-Relationship
Model
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36228
Sample Questions
Q1) Recursive relationships only exist for one-to-one relationships.
A)True
B)False
Q2) Discriminators can be ________.
A)exclusive only
B)inclusive only
C)decisive only
D)A or B
E)B or C
Q3) An identifier of an entity instance must consist of one and only one attribute.
A)True
B)False
Q4) Minimum cardinality refers to ________.
A)the most instances of one entity class that can be involved in a relationship with one instance of another entity class
B)the minimum number of entity classes involved in a relationship
C)whether or not an instance of one entity class is required to be related to an instance of another entity class
D)whether or not an entity is a weak entity
E)None of the above.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Transforming Data Models Into Database Designs
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/36230
Sample Questions
Q1) The ideal primary key is short,numeric,and fixed.
A)True
B)False
Q2) Association tables sometimes connect more than two entities.
A)True
B)False
Q3) The last step in creating a table is to verify table normalization.
A)True
B)False
Q4) To represent an M:N relationship in a relational database design,a table is created to represent the relationship itself.
A)True
B)False
Q5) In a relational database design,all relationships are expressed by creating a foreign key.
A)True
B)False
Q7) What are MUST NOT and MUST COVER constraints? Page 8
Q6) Explain the representation of a many-to-many strong entity relationship in a relational database design.
To view all questions and flashcards with answers, click on the resource link above.
Page 9
Chapter 7: SQL for Database Construction and Application Processing
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/36232
Sample Questions
Q1) The SQL keyword CONSTRAINT is used to define one of five types of constraints. A)True
B)False
Q2) Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of less work,standardized processing,and specialization among developers.
A)True
B)False
Q3) When a trigger is fired,the DBMS makes the appropriate data available to
A)the SQL interpreter
B)the application code
C)the embedded SQL code
D)the trigger code
E)the stored procedure code
Q4) SQL triggers are used for providing default values,validity checking,updating views,and performing referential integrity actions. A)True
B)False
10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Database Redesign
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/36234
Sample Questions
Q1) Converting date,money or other more specific data types to char or varchar will usually succeed.
A)True
B)False
Q2) Which of the following is not a possible step in the database redesign process?
A)Checking whether certain conditions or assumptions about the data are valid
B)Reverse engineering the data model
C)Testing proposed changes
D)Maintaining backups of the existing database
E)All of the above are possible steps in the database redesign process.
Q3) Database redesign is rarely needed because databases are usually built correctly the first time.
A)True B)False
Q4) Explain the results provided by the EXISTS,NOT EXISTS and double NOT EXISTS keywords.
Q5) In a correlated subquery,the same table is used in the upper and lower SELECT statements.
A)True
B)False
11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Managing Multiuser Databases
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/36236
Sample Questions
Q1) Nonrepeatable reads occur when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.
A)True
B)False
Q2) Explain the purpose of transaction logs and checkpoints.
Q3) Database administration is more important but less difficult in multiuser database systems than in single-user database systems.
A)True
B)False
Q4) The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.
A)True
B)False
Q5) The DBA has to find a balance between the conflicting goals of maximizing availability of the database to users and protecting the database.
A)True
B)False
Q6) Explain the importance of documenting changes in database structure.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Managing Databases With SQL Server 2008 R2
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36237
Sample Questions
Q1) Describe the database files that are automatically created when a new database is created in SQL Server.
Q2) The default cursor concurrency setting for a static cursor in SQL Server is
A)SCROLL_LOCK
B)Optimistic
C)Serializable
D)Read only
E)Pessimistic
Q3) With SQL Server,only one cluster index is allowed per table.
A)True
B)False
Q4) The SQL Server default when creating a new database is to create two data files and one log file for each database.
A)True
B)False
Q5) Database views can only be created in SQL Server through the use of SQL commands.
A)True
B)False
13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Managing Databases With Oracle Database 11g
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36238
Sample Questions
Q1) The Read Only transaction isolation level is unique to Oracle Database.
A)True
B)False
Q2) Which of the following Oracle Database ReDo files are stored on disk and contain the rollback segments from recent database changes?
A)OnLine ReDo files.
B)Active ReDo files.
C)OffLine ReDo files.
D)Archive ReDo files.
E)All of the above.
Q3) Oracle Database only reads committed changes,and therefore dirty reads are not possible.
A)True
B)False
Q4) Among its many functions,SQL*Plus is also a text editor.
A)True
B)False
Q5) SOONER and LATER triggers are placed on tables.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 12: Managing Databases With MySQL 55
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36239
Sample Questions
Q1) Triggers that have been created in MySQL are displayed as objects in the Object Browser of the MySQL Workbench.
A)True
B)False
Q2) Describe how to create a new database in MySQL Community Edition.
Q3) To run an SQL script,click the Execute SQL Script in Connected Server button on the MySQL Workbench.
A)True
B)False
Q4) The main MySQL GUI utility is:
A)MySQL Management Studio.
B)MySQL Developer.
C)My SQL Workbench.
D)A and B
E)A,B and C
Q5) For use with this book,it is recommend that MySQL be configured as a Decision Support (DSS)/OLAP machine.
A)True
B)False
Q6) Explain the MySQL Block Structure.
Page 15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: The Web Server Environment
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/36240
Sample Questions
Q1) ADO.NET is a completely new product,with no connection to ADO except the similar name.
A)True
B)False
Q2) JDBC drivers only exist for a limited number of DBMS products at this time.
A)True
B)False
Q3) The first PHP element to be created is the:
A)Command object.
B)Connection object.
C)Errors collection.
D)Parameters collection.
E)RecordSet object.
Q4) In general,for Web applications it is best to create what type of data source on the Web server?
A)File
B)Common
C)Shared
D)System
E)User
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 14: Database Processing With XML
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36241
Sample Questions
Q1) Most of NoSQL nonrelational database methodologies are known as structured storage.
A)True
B)False
Q2) What is XSLT?
Q3) Which of the following refers to different methods of parsing XML documents?
A)SAX
B)DOM
C)XPath
D)A and B
E)A,B and C
Q4) Which of the following is true about XML?
A)It allows the confounding of document structure,content,and format.
B)It is non-standardized to allow for extension by developers.
C)The structure of documents is formally defined.
D)XML tags,like some HTML tags,are vague and arbitrary.
E)None of the above.
Q5) XML documents that conform to their DTD are said to be type-valid XML documents.
A)True
B)False
17
To view all questions and flashcards with answers, click on the resource link above.
Chapter 15: Database Processing for Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/36242
Sample Questions
Q1) Refer to the table above.What is the definition of confidence for Drug B with reference to Drug A?
A)The probability that Drug A will be purchased.
B)The probability that Drug B will be purchased.
C)The probability that both Drug A and Drug B will be purchased.
D)The probability that Drug A will be purchased given that Drug B has been purchased.
E)The probability that Drug B will be purchased given that Drug A has been purchased.
Q2) In a common form of RFM analysis,an RFM score of {5 1 1} means that the customer orders frequently and orders items of high monetary value but has not ordered anything for some time.
A)True
B)False
Q3) Data warehouses also store the data warehouse metadata.
A)True
B)False
Q4) Data warehouse data are frequently denormalized.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 16: Microsoft Access 2010
Available Study Resources on Quizplus for this Chatper
48 Verified Questions
48 Flashcards
Source URL: https://quizplus.com/quiz/36219
Sample Questions
Q1) What is the Microsoft Office Fluent User Interface?
Q2) Microsoft Access uses the AutoNumber data type to create surrogate keys.
A)True
B)False
Q3) The Microsoft Access window Close button is actually a close-and-exit button.
A)True
B)False
Q4) Describe the Microsoft Access 2010 Navigation Pane.
Q5) In addition to the standard Ribbon command tabs,Microsoft Access 2010 also includes:
A)optional command tabs.
B)contextual command tabs.
C)quick access tabs.
D)gallery tabs.
E)template tabs.
Q6) The Microsoft Access 2010 tabbed Ribbon contains a set of control tabs.
A)True
B)False
Q7) Describe the tabbed Ribbon.
Q8) Explain how to run an SQL query in Microsoft Access.
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 17: Getting Started With Systems Analysis and Design
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/36221
Sample Questions
Q1) The classic systems analysis methodology is called the Analysis Development Life Cycle (ADLC).
A)True
B)False
Q2) The system is updated with patches,service packs and new software releases during the ________ step of the SDLC.
A)system definition
B)requirements analysis
C)component design
D)implementation
E)systems maintenance
Q3) Hardware specifications are determined during the ________ step of the SDLC.
A)system definition
B)requirements analysis
C)component design
D)implementation
E)systems maintenance
Q4) How does Michael Porter define support business activities?
Page 20
Q5) How does Michael Porter define primary or operational business activities?
Q6) Define and discuss an information system.
To view all questions and flashcards with answers, click on the resource link above.
Page 21
Chapter 18: E-R Diagrams and the Idef1x Standard
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/36223
Sample Questions
Q1) The IDEF1X equivalence of the extended E-R model subtype is the category entity,and category entities are placed in categorization clusters.
A)True
B)False
Q2) In IDEF1X,a base domain can have a:
A)data type.
B)value.
C)range definition.
D)B or C
E)A,B or C
Q3) Extended E-R model N:M relationships are called nonidentifying connection relationships in IDEF1X.
A)True
B)False
Q4) IDEF1X nonspecific relationships correspond to N:M relationships in the extended E-R model.
A)True
B)False
Q5) What line symbols are used in IDEF1X diagrams to represent relationships?
To view all questions and flashcards with answers, click on the resource link above. Page 22
Chapter 19: E-R Diagrams and the UML Standard
Available Study Resources on Quizplus for this Chatper
36 Verified Questions
36 Flashcards
Source URL: https://quizplus.com/quiz/36225
Sample Questions
Q1) Persistent means that data should continue to exist in the database even if the object that processes it is destroyed.
A)True
B)False
Q2) In UML-style E-R diagrams,a weak entity is shown by placing a filled-in diamond on the parent of the weak entity.
A)True
B)False
Q3) Which of the following is not a characteristic that was introduced to E-R diagramming by UML?
A)class attributes
B)relationship attributes
C)visibility of attributes
D)methods
E)constraints
Q4) Maximum cardinalities are represented in UML-style E-R diagrams with the same notation (1:1,1:N,N:M)as in traditional E-R diagrams.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 23
Chapter 20: Getting Started With MySQL Workbench Data
Modeling Tools
Available Study Resources on Quizplus for this Chatper
37 Verified Questions
37 Flashcards
Source URL: https://quizplus.com/quiz/36227
Sample Questions
Q1) In the Windows OS,to start working with the MySQL Workbench use the command Start | All Programs | MySQL | MySQL Workbench 5.2 CE.
A)True
B)False
Q2) In order to use MySQL Workbench to create database designs,you must log into MySQL using:
A)the Connect to Database dialog box.
B)the Connect to MySQL Server dialog box.
C)the MySQL | Connect to Server command.
D)Both A and B are used together.
E)None of the above is correct - no login is required.
Q3) In the MySQL Workbench,a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using the 1:N Non-identifying Relationship button.
A)True
B)False
Q4) Describe how to create relationships in a MySQL Workbench database design.
Q5) Describe how to add a table object to a MySQL Workbench database design.
Q6) Describe the MySQL Connector/ODBC and how to install it.
To view all questions and flashcards with answers, click on the resource link above. Page 24
Chapter 21: Getting Started With Microsoft Visio 2010
Available Study Resources on Quizplus for this Chatper
36 Verified Questions
36 Flashcards
Source URL: https://quizplus.com/quiz/36229
Sample Questions
Q1) In Microsoft Visio 2010,both data models and database designs are created using:
A)the Database Model Diagram template.
B)the UML Model Diagram template.
C)the Enterprise Application template.
D)the Data Flow Model template.
E)the Wireframe Diagram template.
Q2) In Microsoft Visio 2010,the Entity Relationship (US units)stencil objects include a Category object.
A)True
B)False
Q3) In Microsoft Visio 2010,when the Table object is placed in a diagram,it is labeled as an Entity.
A)True
B)False
Q4) In Microsoft Visio 2010,whether a relationship is identifying or non-identifying can be set in the Database Properties for that Relationship object.
A)True
B)False
Q5) In Microsoft Visio 2010,how do we create data models?
To view all questions and flashcards with answers, click on the resource link above. Page 25
Chapter 22: the Semantic Object Model
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/36231
Sample Questions
Q1) A "hybrid object" is a semantic object that relates two or more objects and stores data that are peculiar to that relationship.
A)True
B)False
Q2) A "simple object" can contain only simple attributes.
A)True
B)False
Q3) An association object relates two (or more)objects and stores data that are peculiar to that relationship.
A)True
B)False
Q4) Object identifiers may or may not be unique.
A)True
B)False
Q5) A semantic object must represent something with a physical existence. A)True
B)False
Q6) A subtype inherits all the attributes of its parent.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 26
Chapter 23: Data Structures for Database Processing
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/36233
Sample Questions
Q1) The term set refers to all records having the same nonunique secondary key.
A)True
B)False
Q2) Linked lists can be used to keep records in:
A)logical order.
B)physical order.
C)sequential order.
D)A and B
E)B and C
Q3) The DBMS creates physical records,also called blocks,on its direct access fields.
A)True
B)False
Q4) Keys may include:
A)primary keys.
B)unique secondary keys.
C)nonunique secondary keys.
D)B and C
E)A,B and C
Q5) What is a B-tree?
To view all questions and flashcards with answers, click on the resource link above. Page 27
Chapter 24: Getting Started With Web Servers php and the Eclipse PDT
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/36235
Sample Questions
Q1) The discussion of how to install PHP in the text used PHP version ________.
A)5.2.13
B)5.2.14
C)5.3.0
D)5.3.5
E)5.3.6
Q2) The version of the Eclipse IDE that works with PHP is the Eclipse PDT.
A)True
B)False
Q3) For a Web server running the Windows operating system,the most commonly used Web server is IIS.
A)True
B)False
Q4) The default Web page for the IIS Web server is:
A)startup.html.
B)startup.htm.
C)iistart.html.
D)iistart.htm.
E)index.html.
Q5) What is PHP?
Page 28
To view all questions and flashcards with answers, click on the resource link above.