Database Administration
Question Bank
Course Introduction
Database Administration is designed to provide students with comprehensive knowledge and practical skills necessary for managing and maintaining modern database systems. The course covers core concepts such as database architecture, user management, backup and recovery, security, and performance tuning. Students will learn to install, configure, and upgrade database management systems, implement access controls, troubleshoot common issues, and ensure data integrity and availability. Emphasizing hands-on experience, the course prepares students to function effectively as database administrators in enterprise environments, supporting business operations and ensuring reliable data management.
Recommended Textbook
Database Concepts 7th Edition by David M. Kroenke
Available Study Resources on Quizplus
18 Chapters
1205 Verified Questions
1205 Flashcards
Source URL: https://quizplus.com/study-set/1260
Page 2
Chapter 1: Getting Started
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24869
Sample Questions
Q1) The DBMS is used to create the database itself.
A)True
B)False Answer: True
Q2) SQL stands for Structural Question Language.
A)True
B)False Answer: False
Q3) Although users use database systems,they are not considered part of a database system.
A)True
B)False Answer: False
Q4) Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for database files.
A)True
B)False Answer: False
Q5) A relational database stores data in the form of ________. Answer: tables
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: The Relational Model
Available Study Resources on Quizplus for this Chatper
87 Verified Questions
87 Flashcards
Source URL: https://quizplus.com/quiz/24871
Sample Questions
Q1) In Microsoft Access,the Relationships window is accessed by using the ________ button on the Database tools command tab.
Answer: Relationship
Q2) Given the functional dependency for the attributes of ENTITY1,X (A,B,C),X is a candidate key for the relation ENTITY1 (A,B,C,X).
A)True
B)False
Answer: True
Q3) When the primary key of one relation is placed in a second relation to represent a relationship,the attribute in the second relation is called a(n)________ key.
Answer: foreign
Q4) When used to represent a relationship,the primary key must have the same name as the corresponding foreign key.
A)True
B)False
Answer: False
Q5) A key that contains two or more attributes is called a(n)________ key. Answer: composite
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Structured Query Language
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/24873
Sample Questions
Q1) When using SQL to create a table,specifying a data type of Char(10)indicates a fixed length field of 10 characters.
A)True
B)False
Answer: True
Q2) Given the table CUSTOMER(CustID,Name,PhoneNum,AcctBalance)
What is the standard SQL query phrase to retrieve the Name and Phone Number of customers?
A) SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum
B) SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum)
C) SELECT Name, PhoneNum
D) SELECT (Name, PhoneNum)
E) SELECT *
Answer: C
Q3) Data is added to a table using the SQL INSERT command.
A)True
B)False
Answer: True
Q4) The SQL command used to add new data to a table is ________.
Answer: INSERT
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Data Modeling and the Entity-Relationship
Model
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24875
Sample Questions
Q1) How is minimum cardinality expressed in crow's foot E-R diagrams?
Q2) Explain maximum cardinality.
Q3) Microsoft Access 2013 database files can be easily ________ to create multiple copies of a database.
Q4) Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system?
A) Business rules
B) User interviews
C) Forms
D) Use cases
E) All of the above are sources for user requirements.
Q5) The ________ is a representation of the content,relationships,and constraints of the data needed to support the system requirements.
Q6) Describe the use of Microsoft Access as a prototyping tool.
Q7) Microsoft Access 2013 can be used to build a prototype database,which allows users to validate the data model by demonstrating the consequences of data modeling decisions.
6
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Database Design
Available Study Resources on Quizplus for this Chatper
81 Verified Questions
81 Flashcards
Source URL: https://quizplus.com/quiz/24877
Sample Questions
Q1) After a 1:1 relationship has been created between two tables in Microsoft Access,the Relationship Type of One-To-One appears:
A) in the Relationship Type property of the primary key column in table Design View. B) in the Relationship Type property of the foreign key column in table Design View. C) in the table object in the Relationships window.
D) in the Show Table dialog box.
E) in the Edit Relationships dialog box.
Q2) For a(n)________ weak entity,it is necessary to add the key of the parent entity to the weak entity's relation so that this added attribute becomes part of the weak entity's key.
Q3) How are one-to-one recursive relationships addressed using the relational model?
Q4) After a 1:1 relationship has been created between two tables in Microsoft Access,the Relationship Type of One-To-One appears in the ________.
Q5) Explain the pragmatic reason for using surrogate keys.
Q6) To normalize a relation,the determinant of every functional dependency should be a(n)________.
Q7) As far as Microsoft Access is concerned,there are no ________.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Database Administration
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/24879
Sample Questions
Q1) Statement level consistency means that all statements within a transaction will access consistent rows across the lifetime of the entire transaction.
A)True
B)False
Q2) Database administrators must make sure that ________ and ________ techniques and procedures are operating to protect the database in case of failure and to recover it as quickly and accurately as possible when necessary.
Q3) Transaction results are kept in a(n)________,which contains records of the data changes in chronological order.
Q4) In terms of database security,a user can be assigned many roles,and a role can be assigned to many users.
A)True
B)False
Q5) One of the major tasks of the database administration is called ________ control,which allows multiple users to access the database simultaneously.
Q6) Microsoft Access 2013 can secure databases by using ________ to encrypt and decrypt the database files.
To view all questions and flashcards with answers, click on the resource link above.
Page 8
Chapter 7: Database Processing Applications
Available Study Resources on Quizplus for this Chatper
82 Verified Questions
82 Flashcards
Source URL: https://quizplus.com/quiz/24881
Sample Questions
Q1) After getting data from a database,a PHP program needs to:
A) open the connection.
B) test the connection.
C) query the database.
D) process the query results.
E) close the connection.
Q2) Every DBMS product has a(n)________ that allows DBMS functions to be executed from application program code.
Q3) Briefly describe three types of triggers.
Q4) What is the NetBeans IDE?
Q5) HTML standards are defined by the World Wide Web Consortium (W3C).
A)True
B)False
Q6) A stored procedure is a module of logic normally written in a traditional programming language like C++ and stored in the application program.
A)True
B)False
Q7) When using Microsoft Access and IIS with an ODBC data source,the ODBC data source should be a(n)________.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Big Data, data Warehouses, and Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/24883
Sample Questions
Q1) In the snowflake schema,the ________ tables are normalized.
Q2) In the MapReduce process,the first step is the ________ step.
A) column
B) super column
C) column family
D) map
E) reduce
Q3) Operational databases store historical data.
A)True
B)False
Q4) What is a star schema?
Q5) A variant of the star schema is the ________.
Q6) What is a Microsoft Excel PivotTable?
Q7) Business Intelligence (BI)reporting systems are used to filter data,sort data,group data and make simple calculations based on the data.
A)True
B)False
Q8) Apache Cassandra is an example of a column family database.
A)True
B)False Page 10
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 9: Getting Started With Microsoft Sql Server 2012
Available Study Resources on Quizplus for this Chatper
40 Verified Questions
40 Flashcards
Source URL: https://quizplus.com/quiz/24868
Sample Questions
Q1) SQL Server 2014 uses DBMS authentication by default.
A)True
B)False
Q2) To create a new SQL query,click the New Query button.
A)True
B)False
Q3) Describe why SQL Server 2014 is sensitive to certain words being used in SQL commands or scripts,and what to do about it.
Q4) Microsoft SQL Server 2014 Express Advanced includes:
A) SQL Server 2014 Management Studio.
B) SQL Server 2014 Reporting Services.
C) Windows Installer 4.5.
D) Both A and B
E) All of the above
Q5) SQL Server 2014 Express requires that the .NET Framework version 2.0 be installed.
A)True
B)False
Q6) The ODBC Driver 11 for SQL Server is installed ________ when SQL Server 2014 is installed.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Getting Started With Oracle Database 11g
Release 2
Available Study Resources on Quizplus for this Chatper
43 Verified Questions
43 Flashcards
Source URL: https://quizplus.com/quiz/24870
Sample Questions
Q1) In SQL Developer,DBMS objects are displayed:
A) in the Navigation Pane.
B) in the Object Browser.
C) in the Connections area.
D) in the tabbed document window.
E) in the command tab.
Q2) When using Oracle Database,a sequence is an object that generates a sequential series of unique numbers.
A)True
B)False
Q3) To log into a workspace connection in Oracle SQL Developer,use the username and password you created for Application Express.
A)True
B)False
Q4) To run an SQL query,click the ________ button.
Q5) Users in SQL Developer log into a workspace using the ________ account.
Q6) Describe how to create and run an SQL query in Oracle Database 11g Release 2 .
Q7) The NextVal method provides the next value in a sequence.
A)True
B)False Page 13
To view all questions and flashcards with answers, click on the resource link above.
Page 14
Chapter 11: Getting Started With Mysql 56 Community Server
Available Study Resources on Quizplus for this Chatper
71 Verified Questions
71 Flashcards
Source URL: https://quizplus.com/quiz/24872
Sample Questions
Q1) 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.
Q2) DBMS objects are displayed:
A) in the Navigator Pane.
B) in the Object Browser.
C) in the tabbed database window.
D) in the tabbed document window.
E) in the command tab.
Q3) Describe how to create and run an SQL script in MySQL 5.6 Community Server Edition.
Q4) In the MySQL Table Editor,the abbreviation PK stands for partial key.
A)True
B)False
Q5) What is an SQL script,and why are SQL scripts useful?
Q6) Describe how to create a new database design in the MySQL Workbench.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 12: James River Jewelry Project Questions
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/24874
Sample Questions
Q1) Stored procedures have the advantage of ________.
A) greater security
B) decreased network traffic
C) SQL optimized by the DBMS compiler
D) code sharing
E) All of the above
Q2) The SQL keyword ________ can be used with SELECT statements retrieving view instances to sort the results of the SELECT.
Q3) Unlike application code,stored procedures are never distributed to the client computers.
A)True
B)False
Q4) Microsoft Access queries:
A) can use previously stored view equivalent Access queries.
B) cannot use previously stored view equivalent Access queries for any purpose.
C) cannot use previously stored view equivalent Access queries to hide rows.
D) cannot use previously stored view equivalent Access queries to hide columns.
E) cannot use previously stored view equivalent Access queries to hide complicated SQL syntax.
Q5) SQL statements used to construct views cannot contain the ________ clause.
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Sql Views
Available Study Resources on Quizplus for this Chatper
47 Verified Questions
47 Flashcards
Source URL: https://quizplus.com/quiz/24876
Sample Questions
Q1) Data is facts and numbers.
A)True
B)False
Q2) A business process is a set of activities that transforms materials into products.
A)True
B)False
Q3) One definition of ________ is knowledge derived from data.
Q4) The classic systems analysis methodology is called the:
A) Systems Development Life Cycle (SDLC).
B) Analysis Development Life Cycle (ADLC).
C) Component Development Life Cycle (CDLC).
D) Information Development Life Cycle (IDLC).
E) None of the above is correct.
Q5) Databases are created in a DBMS during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
E) systems maintenance
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 14: Getting Started in Systems Analysis and Design
Available Study Resources on Quizplus for this Chatper
34 Verified Questions
34 Flashcards
Source URL: https://quizplus.com/quiz/24878
Sample Questions
Q1) In Microsoft Visio 2013,describe the possible cardinality settings for a Relationship object that can be set in the symbols menu in a database design,and how these settings correspond to the IE Crow's Foot symbols shown in Figure G-21.
Q2) Microsoft Visio 2013 can be used to create data models,but not database designs.
A)True
B)False
Q3) In Microsoft Visio 2013,how do we create database designs?
Q4) In Microsoft Visio 2013,when the Entity object is placed in a diagram,it is labeled as a table.
A)True
B)False
Q5) In Microsoft Visio 2013,the cardinalities of the relationship are set using the Set Begin Symbol and Set End Symbol commands.
A)True
B)False
Q6) In Microsoft Visio 2013,we can create database designs using Entity and Dynamic connector objects.
A)True
B)False
18
To view all questions and flashcards with answers, click on the resource link above.
Chapter 15: Getting Started With Microsoft Visio 2010
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/24880
Sample Questions
Q1) Microsoft Access 2013 switchboards use text labels as part of the menu.
A)True
B)False
Q2) A Microsoft Access 2013 switchboard provides networking capabilities in Microsoft Access 2013.
A)True
B)False
Q3) A Microsoft Access 2013 switchboard provides application menuing capabilities in Microsoft Access 2013.
A)True
B)False
Q4) Microsoft Access 2013 provides application menuing capabilities by means of a(n)________.
Q5) Microsoft Access 2013 switchboards can be used to create:
A) application forms.
B) application reports.
C) application menus.
D) application databases.
E) All of the above
Q6) Microsoft Access 2013 switchboards use ________ to place text on switchboards.
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 16: The Access Workbench-section Microsoft
Access
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/24882
Sample Questions
Q1) What is the NetBeans IDE?
Q2) Installing PHP using the Microsoft Installer provides sufficient PHP support for use with Database Concepts 7th Edition.
A)True
B)False
Q3) The NetBeans IDE is installed using a standard Windows operating system installation routine.
A)True
B)False
Q4) For a Web server running the Windows operating system,the most commonly used Web server is:
A) the IIS Web server.
B) the Apache Web server.
C) the Tomcat Web server.
D) the ASP.NET Web server.
E) the JSP Web server.
Q5) The default Web page for the IIS Web server is index.html.
A)True
B)False
Q6) What is PHP? Page 20
To view all questions and flashcards with answers, click on the resource link above.
Page 21
Chapter 17: Getting Started With Web Servers, php, and the
Netbeans IDE
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/24884
Sample Questions
Q1) A data mart is a collection of data that addresses a particular component or functional area of a business.
A)True
B)False
Q2) Why is operational data sometimes unusable for Business Intelligence purposes?
Q3) Data warehouses are populated with data prepared by ________ programs.
Q4) A data warehouse database differs from an operational database because:
A) data warehouse data are not stored in tables.
B) data warehouse databases do not have metadata.
C) data warehouse data are often stored in a dimensional database.
D) Both B and C
E) All of the above
Q5) BI reporting systems summarize the current status of business activities and compare that status with past events but not with predicted future activities.
A)True
B)False
Q6) A(n)________ is a collection of data that addresses a particular component or functional area of a business.
Page 22
Q7) A(n)________ is an information system that helps users analyze and use data.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 18: Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
77 Verified Questions
77 Flashcards
Source URL: https://quizplus.com/quiz/24885
Sample Questions
Q1) XML Schema is used to define ________.
A) document content and structure
B) XQL queries
C) DOM-compliant parsers
D) DTDs
E) XPath searches
Q2) A complex element must have more than one simple element.
A)True
B)False
Q3) DTD stands for Document Type Declaration.
A)True
B)False
Q4) What is an XML Schema?
Q5) XML designers created a system that allows document structure,data content,and materialization to be mixed.
A)True
B)False
Q6) Unlike SQL views,XML views are not limited to one multivalued path.
A)True
B)False
Page 23
To view all questions and flashcards with answers, click on the resource link above.