Database Systems
Test Bank
Course Introduction
Database Systems is a foundational course that introduces students to the principles, design, and implementation of modern database management systems. Topics covered include data modeling using the Entity-Relationship model, relational algebra, SQL querying, normalization, transaction management, concurrency control, and database security. Students will gain hands-on experience in designing and interacting with relational databases and develop a comprehensive understanding of how databases support data storage, retrieval, and manipulation in various applications.
Recommended Textbook
Database Processing Fundamentals Design and Implementation 13th Edition by David M. Kroenke
Available Study Resources on Quizplus
24 Chapters
1921 Verified Questions
1921 Flashcards
Source URL: https://quizplus.com/study-set/1804 Page 2
Chapter 1: Introduction
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35866
Sample Questions
Q1) A database is a self-describing collection of non-integrated tables.
A)True
B)False
Answer: False
Q2) A database designed to implement requirements for a reporting application needed by the Sales department is a database being designed ________.
A)from existing non-database data
B)as a new systems development project
C)as a redesign of an existing database
D)A and B
E)A,B,and C
Answer: B
Q3) In a database,each table stores data about a different type of thing.
A)True
B)False
Answer: True
Q4) The CODASYL DBTG mode structured data relationships as a tree structure.
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
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/35868
Sample Questions
Q1) To have SQL automatically eliminate duplicate rows from a result,use the keyword DISTINCT with the FROM keyword.
A)True
B)False
Answer: False
Q2) To obtain all columns,use an asterisk (*)wildcard character instead of listing all the column names.
A)True
B)False
Answer: True
Q3) A WHERE clause can contain only one condition.
A)True
B)False
Answer: False
Q4) SQL statements end with a colon.
A)True
B)False
Answer: False
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/35870
Sample Questions
Q1) A characteristic of a relation is that the rows of a relation may hold identical values.
A)True
B)False
Answer: False
Q2) In functional dependencies,the attribute whose value is known or given is referred to as the determinant.
A)True
B)False
Answer: True
Q3) An attribute is considered to be a non-key attribute when it is a non-prime attribute,which means that the attribute is not contained in any candidate key.
A)True
B)False Answer: True
Q4) A referential integrity constraint limits the values of a foreign key.
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/35872
Sample Questions
Q1) If you see a column name Notes,it is likely that this is a general-purpose remarks column.
A)True
B)False
Q2) SQL statements that can be used to create referential integrity statements for normalized tables are created during the normalization process.
A)True
B)False
Q3) A null value in a column may indicate that there is an appropriate value for that attribute,but it is unknown.
A)True
B)False
Q4) The problem with a general-purpose remarks column is that the data it contains are likely to be verbal,inconsistent and stored in a verbose manner.
A)True
B)False
Q5) What are general-purpose remarks columns,and why are they a problem?
Q6) What are inconsistent values,and why are they a problem?
To view all questions and flashcards with answers, click on the resource link above. Page 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/35874
Sample Questions
Q1) What is meant by the degree of a relationship?
Q2) An identifier of an entity instance must consist of one and only one attribute.
A)True
B)False
Q3) The occurrence of a particular entity is called an ________.
A)entity class
B)entity relationship
C)entity instance
D)entity attribute
E)None of the above.
Q4) When an entity has a relationship to itself,we have a(n)________.
A)supertype/subtype relationship
B)archetype/instance relationship
C)recursive relationship
D)A or C
E)B or C
Q5) When transforming a data model into a relational design,relationships of all degrees are treated as combinations of binary relationships.
A)True
B)False
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/35876
Sample Questions
Q1) Explain the representation of a many-to-many strong entity relationship in a relational database design.
Q2) Each attribute of an entity becomes a(n)________ of a table.
A)column
B)primary key
C)foreign key
D)alternate key
E)B or D
Q3) The first step in the database design process is to create tables and columns from entities and attributes.
A)True
B)False
Q4) Many-to-many relationships are represented by ________.
A)two tables with an M:N relationship
B)two tables with a 1:N relationship
C)an intersection table which has M:N relationships with the two tables
D)an intersection table which has 1:N relationships with the two tables
E)two intersection tables which each have 1:N relationships with the two tables
Page 8
Q5) Briefly describe the process of converting an extended E-R model into a relational database design.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Sql for Database Construction and Application Processing
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35878
Sample Questions
Q1) Explain how relationships are created using SQL.
Q2) 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
Q3) SQL views can be used to provide a level of insulation between data processed by applications and the data actually stored in the database tables.
A)True
B)False
Q4) SQL triggers are used for ________.
A)validity checking
B)providing default values
C)updating views
D)A and B
E)A,B,and C
Page 9
Q5) What are SQL stored procedures and how are they used?
Q6) Discuss SQL data types.
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 8: Database Redesign
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/35880
Sample Questions
Q1) Discuss workable data conversion and possible data loss when changing table data types during a database redesign.
Q2) If a DEFAULT constraint is included when a new column is added to a table,the default value is applied to ________.
A)all existing rows at the time the column is added
B)all new rows
C)all new rows but only after the UPDATE command is issued
D)A and B
E)A and C
Q3) The data model produced by reverse engineering may include some entities that should not appear in the data model.
A)True
B)False
Q4) Discuss the role of backup and test databases in database redesign.
Q5) To drop a foreign key column from a table,no preliminary steps are needed and we can simply use the ALTER TABLE DROP COLUMN statement.
A)True
B)False
Q6) What is a correlated subquery?
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/35882
Sample Questions
Q1) With pessimistic locking,the assumption is made that a conflict will occur.
A)True
B)False
Q2) Locks that are placed assuming that a conflict will not occur are called:
A)dynamic.
B)explicit.
C)implicit.
D)optimistic.
E)pessimistic.
Q3) Locks that are placed assuming that a conflict will occur are called:
A)dynamic locks.
B)explicit locks.
C)implicit locks.
D)optimistic locks.
E)pessimistic locks.
Q4) Explain the process of using optimistic locking.
Q5) A passive data repository is preferred over an active repository because it requires less human intervention.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: A: Managing Databases With SQL Server 20012
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35865
Sample Questions
Q1) Locking hints included in an SQL statement will override locking behavior based on explicit transaction isolation level statements.
A)True
B)False
Q2) Anytime you want to use an SQL Server reserved word as a user identifier,enclose it in ________.
A){ }
B)[ ]
C)( )
D)" "
E)< >
Q3) The default cursor concurrency setting for a keyset cursor in SQL Server is
A)SCROLL_LOCK
B)Optimistic
C)Serializable
D)Read only
E)Pessimistic
Q4) Explain two ways of creating tables in SQL Server.
Q5) What is the SQL CLR?
13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: B: Managing Databases With Oracle Database
11g Release 2
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35864
Sample Questions
Q1) Which of the following is true of Oracle Database when the isolation level is set to Serializable?
A)It will update any row having an SCN greater than the Transaction SCN.
B)It will delete any row having an SCN greater than the Transaction SCN.
C)It will read any row having an SCN greater than the Transaction SCN.
D)It will wait for a blocking transaction to release an exclusive lock.
E)It will not generate an error if the transaction must be rolled back.
Q2) Each Oracle Database tablespace has one or more datafiles associated with it. A)True
B)False
Q3) The Oracle Database PL/SQL block structure begins with ________. A)DECLARE
B)BEGIN
C)IF...THEN...ELSE...END IF D)LOOP
E)END;
Q4) Sequences are most often used to provide values for surrogate keys.
A)True
B)False
Q5) What is SQL*Plus?
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 10: C: Managing Databases With MySQL
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/35863
Sample Questions
Q1) The MySQL command line utility is:
A)MySQL*Plus.
B)the MySQL Command-Line Client.
C)MySQL-Shell.
D)MySQL-CMD.
E)None of the above is correct.
Q2) The MySQL LOOP statement is used to repeat a set of SQL statements as long as some condition is true.
A)True
B)False
Q3) Describe how to create and run an SQL query in MySQL Server Community Edition.
Q4) The MySQL Workbench is the main utility used to implement MySQL security.
A)True
B)False
Q5) Schema is the MySQL synonym for database. A)True
B)False
Q6) To run an SQL script,click the Execute button on the Query Toolbar. A)True
B)False
Page 15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: The Web Server Environment
Available Study Resources on Quizplus for this Chatper
198 Verified Questions
198 Flashcards
Source URL: https://quizplus.com/quiz/35884
Sample Questions
Q1) A data source that is local to a single computer and can be used by the operating system and any user on that computer is called a ________ data source.
A)file
B)common
C)shared
D)system
E)user
Q2) The document type declaration for an XML document begins with the keyword
A)XML
B)DTD
C)TYPE
D)DOCTYPE
E)TYPEDECL
Q3) PDO stands for:
A)PHP Data Objects.
B)PHP Design Objects.
C)Personal Data Objects.
D)Personal Design Objects.
E)None of the above.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 12: Big Data datawarehouse and Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/35885
Sample Questions
Q1) In the MapReduce process,the first step is the ________ step.
A)column
B)super column
C)column family
D)map
E)reduce
Q2) To create an OLAP report for an SQL Server 2012 database,we can build a PivotTable in:
A)Microsoft Access 2013.
B)Microsoft Word 2013.
C)Microsoft Visio 2013.
D)Microsoft Excel 2013.
E)Microsoft PowerPoint 2013.
Q3) Microsoft Excel 2013 allows us to connect directly to an SQL Server 2012 database when building a PivotTable.
A)True
B)False
Q4) In a snowflake table,each dimension table is normalized.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 13: Microsoft Access 2013
Available Study Resources on Quizplus for this Chatper
48 Verified Questions
48 Flashcards
Source URL: https://quizplus.com/quiz/35862
Sample Questions
Q1) The Microsoft Access 2013 Close button is actually a:
A)Save and Close button.
B)Save and Exit button.
C)Close and Exit button.
D)Print and Close button.
E)Print and Exit button.
Q2) Describe the tabbed Ribbon.
Q3) Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for database files.
A)True
B)False
Q4) In Microsoft Access,referential integrity constraints are created:
A)by setting a property value on the primary key in the table which contains it.
B)by setting a property value on the foreign key in the table which contains it.
C)by setting a property value on the primary key in the Relationships window.
D)by setting a property value on the foreign key in the Relationships window.
E)by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box.
Q5) Explain how to run an SQL query in Microsoft Access
Q6) What Microsoft Access file format is used by default in Microsoft Access 2013?
Page 18
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: 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/35867
Sample Questions
Q1) An information system is a set of components that interact to achieve some purpose or goal.
A)True
B)False
Q2) 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
Q3) Data is facts and numbers.
A)True
B)False
Q4) A computer-based information system has four components.
A)True
B)False
Q5) Databases are created in a DBMS during the implementation step.
A)True
B)False
Q6) What are the five step or stages of the systems development life cycle (SDLC)? Page 19
To view all questions and flashcards with answers, click on the resource link above.
Page 20
Chapter 15: 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/35869
Sample Questions
Q1) IDEF1X categories are put into a cluster.
A)True
B)False
Q2) In IDEF1X,a category cluster includes BLACK and WHITE,but does not show GREY,which is also a possible category.This is an IDEF1X:
A)complete category cluster.
B)incomplete category cluster.
C)inherited category cluster.
D)inconclusive category cluster.
E)None of the above.
Q3) 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
Q4) Extended E-R model N:M relationships are called nonidentifying connection relationships in IDEF1X.
A)True
B)False
Q5) What symbols are used in IDEF1X diagrams to represent cardinalities?
To view all questions and flashcards with answers, click on the resource link above. Page 21
Chapter 16: 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/35871
Sample Questions
Q1) In UML,cardinalities are represented by an x ..y format.
A)True
B)False
Q2) Attributes preceded by a + are public.
A)True
B)False
Q3) Which of the following is a true statement about the current version of UML?
A)UML places a filled-in diamond on the parent of a weak entity.
B)UML does not provide a means to document exclusivity among subtypes.
C)UML uses the label <identifying> to document an ID-dependent relationship.
D)UML shows the cardinality on the parent entity of a weak entity as simply "1."
E)All of the above.
Q4) Which of the following is true about UML?
A)UML is a methodology for developing OOP systems.
B)UML is a set of tools to support the development OOP systems.
C)UML is primarily focused on database development.
D)A and B
E)A,B,and C
Q5) What format is used for weak entities in UML-style E-R diagrams?
To view all questions and flashcards with answers, click on the resource link above. Page 22
Chapter 17: 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/35873
Sample Questions
Q1) In the MySQL Table Editor,the abbreviation PK stands for partial key.
A)True
B)False
Q2) In the Windows 8 OS,to start working with the MySQL Workbench use the command Start | All Programs | MySQL | MySQL Workbench 5.2 CE.
A)True
B)False
Q3) Describe how to create a new database design in the MySQL Workbench.
Q4) In the MySQL Workbench,a 1:N identifying relationship between two tables that do not contain the needed primary and foreign keys is created using:
A)the 1:N Identifying Relationship button.
B)the 1:N Non-identifying Relationship button.
C)the N:M Identifying Relationship button.
D)the Place a Relationship Using Existing Columns button.
E)None of the above is correct.
Q5) The MySQL Workbench EER models are data models.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 23
Q6) Describe how to create relationships in a MySQL Workbench database design.
Chapter 18: Getting Started With Microsoft Visio 2013
Available Study Resources on Quizplus for this Chatper
34 Verified Questions
34 Flashcards
Source URL: https://quizplus.com/quiz/35875
Sample Questions
Q1) In Microsoft Visio 2013,we can create supertype/subtype relationships in data models using:
A)Entity and Dynamic connector objects.
B)Table and Relationship connector objects.
C)Category and Dynamic connector objects.
D)Category and Relationship connector objects.
E)There are no separate objects to create supertype/subtype,so we use standard objects.
Q2) In Microsoft Visio 2010,which object can be formatted with the line end symbols needed to create IE Crow's Foot notation?
A)Dynamic connector object
B)Relationship connector object
C)Category object
D)Parent to category connector object
E)Category to child connector object
Q3) In Microsoft Visio 2013,we can create database designs using Entity and Dynamic connector objects.
A)True
B)False
Q4) In Microsoft Visio 2013,how do we create database designs?
To view all questions and flashcards with answers, click on the resource link above. Page 24
Chapter 19: Data Structures for Database Processing
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35877
Sample Questions
Q1) Simple networks can be represented by using: A)indexes.
B)linked lists.
C)sequential lists.
D)A and B
E)A,B,and C
Q2) Each physical record is addressed by its:
A)relative record number (RRN).
B)sequential record number (SRN).
C)transaction record number (TRN).
D)ultimate record number (URN).
E)unknown record number (XRN).
Q3) A simple network is a collection of records and the 1:N relationships between them.
A)True
B)False
Q4) A simple network can be represented using linked lists and indexes. A)True
B)False
Q5) What is a B-tree?
To view all questions and flashcards with answers, click on the resource link above. Page 25
Chapter 20: the Semantic Object Model
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/35879
Sample Questions
Q1) Semantic objects represent distinct identities.
A)True
B)False
Q2) A parent object is also known as a(n):
A)supertype object.
B)child object.
C)subtype object.
D)multiple-value object.
E)intersection object.
Q3) The relationship between a parent object and its associated subtype objects is a(n):
A)HAS-A relationship.
B)WANTS-A relationship.
C)NEEDS-A relationship.
D)IS-A relationship.
E)None of the above.
Q4) Explain the concept of semantic objects as being a "sufficient description."
Q5) The first attribute of a subtype object is the childID attribute. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 26
Chapter 21: 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/35881
Sample Questions
Q1) The IIS Web server is automatically installed when the Windows operating system is installed,and no additional steps are necessary to either install or activate it.
A)True
B)False
Q2) For a Web server running the Linux 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.
Q3) The Java JRE is installed directly from the Java download page at www.java.com.
A)True
B)False
Q4) What is the Microsoft Web Platform Installer,and what are the advantages and disadvantages of using it to install PHP?
Q5) What is PHP?
Q6) What is the Eclipse PDT?
Page 27
To view all questions and flashcards with answers, click on the resource link above.
Chapter 22: Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
80 Verified Questions
80 Flashcards
Source URL: https://quizplus.com/quiz/35883
Sample Questions
Q1) A report that is sent to users on a predetermined schedule is called a push report.
A)True
B)False
Q2) RFM analysis analyzes and ranks customers based on:
A)their purchasing patterns.
B)their income status.
C)their residential location.
D)Both A and B
E)All of the above
Q3) BI reporting systems are intended to create meaningful information from disparate data sources and to deliver that information to the proper users on a timely basis.
A)True
B)False
Q4) Cluster analysis is a commonly used technique in supervised data mining.
A)True
B)False
Q5) What is a star schema?
Q6) What is a reporting system?
To view all questions and flashcards with answers, click on the resource link above. Page 28