Advanced Database Concepts
Test Preparation
Course Introduction
Advanced Database Concepts delves into the theoretical and practical aspects of modern database systems beyond the fundamentals. The course covers topics such as database architecture, transaction management, concurrency control, query optimization, distributed databases, NoSQL and NewSQL systems, and data warehousing. It explores the challenges of big data management, discusses advanced data modeling techniques, and examines solutions for scalability, reliability, and security in complex data environments. Students will apply advanced SQL, analyze emerging database technologies, and evaluate case studies to deepen their understanding of next-generation database applications and architectures.
Recommended Textbook
Database Processing Fundamentals Design and Implementation 14th Edition by David M. Kroenke
Available Study Resources on Quizplus
25 Chapters
1978 Verified Questions
1978 Flashcards
Source URL: https://quizplus.com/study-set/2437
Page 2
Chapter 1: Introduction
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/48385
Sample Questions
Q1) Which of the following database systems is not enterprise-class?
A)Microsoft SQL Server
B)Microsoft Access
C)Oracle Database
D)IBM DB2
Answer: B
Q2) Which of the following statements is not true for primary keys in a relational database system?
A)They can be used to create relationships between tables.
B)They must contain numeric data.
C)They uniquely identify a row in a table.
D)They can be part of relational integrity constraints.
Answer: B
Q3) The e-commerce companies use Web activity databases to determine which items on a Web page are popular and successful.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Introduction to Structured Query Language
Available Study Resources on Quizplus for this Chatper
114 Verified Questions
114 Flashcards
Source URL: https://quizplus.com/quiz/48388
Sample Questions
Q1) Outer joins can be either up joins or down joins.
A)True
B)False
Answer: False
Q2) In an SQL query,which built-in function is used to obtain the largest value of numeric columns?
A)AVG
B)COUNT
C)MAX
D)MIN Answer: C
Q3) The SQL keyword WHERE is used to specify the table(s)that contain(s)the data to be retrieved.
A)True
B)False
Answer: False
Q4) An alternative to combining tables by a subquery is to use a join.
A)True
B)False
Answer: True
Page 4
To view all questions and flashcards with answers, click on the resource link above.
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/48391
Sample Questions
Q1) Relations are classified into normal forms based on the types of modification anomalies that they are vulnerable to.
A)True
B)False
Answer: True
Q2) Which of the following is NOT true about the functional dependency A (X,Y)?
A)X is functionally dependent on A.
B)A determines Y.
C)X and Y together determine A.
D)X and Y are functionally dependent on A.
Answer: C
Q3) Briefly describe the various tasks of the primary key.
Answer: The primary key is used for four primary tasks.First,it is used to uniquely identify the rows in a table.Second,it is used to represent rows in relationships.Third,most DBMS products use the values of the primary key to organize the storage of the relation.Finally,primary keys are used in indexes and other structures to improve performance for search operations.
To view all questions and flashcards with answers, click on the resource link above.
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/48393
Sample Questions
Q1) Normalization requires applications to use more complex SQL since they will need to write subqueries and joins to recombine data stored in separate relations.
A)True
B)False
Q2) A null value in a column may indicate that there is no appropriate value for that attribute.
A)True
B)False
Q3) When you are given a set of tables and asked to create a database to store their data,the first step is to ________.
A)assess the existing tables' structure and content
B)design the database structure
C)create one or more new tables
D)move the data into the new database
Q4) A missing value is called a(n)________.
A)empty value
B)null value
C)missing value
D)deleted value
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
104 Verified Questions
104 Flashcards
Source URL: https://quizplus.com/quiz/48395
Sample Questions
Q1) The characteristics of a thing are described by its ________.
A)identifiers
B)entities
C)objects
D)attributes
Q2) A single relationship class involves only one entity class.
A)True
B)False
Q3) Relationships among instances of a single entity class are called redundant relationships.
A)True
B)False
Q4) Relationships are classified by their cardinality.
A)True
B)False
Q5) What are supertype and subtype entities? Include an example.
Q6) In an E-R model,the three types of maximum cardinality are 1:1,1:N,and N:M.
A)True
B)False
Q7) How is maximum cardinality expressed in IE Crow's Foot E-R diagrams? Page 7
To view all questions and flashcards with answers, click on the resource link above.
Page 8
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/48397
Sample Questions
Q1) When transforming an ID-dependent E-R data model relationship into a relational database design and the parent entity has a surrogate primary key and the child entity has a data identifier,then the primary key of the child table should be ________.
A)the parent's surrogate key + the child's data key
B)the parent's surrogate key + a surrogate key in the child
C)either A or B will work,but method A is preferable
D)either A or B will work,but method B is preferable
Q2) What is an association relationship and how does it differ from an N:M relationship?
Q3) Discriminator attributes can be represented in relational designs.
A)True
B)False
Q4) Briefly describe the process of converting an extended E-R model into a relational database design.
Q5) A null value is an attribute value that has been set to zero.
A)True
B)False
Q6) How are one-to-one recursive relationships addressed using the relational model?
Q7) Explain the pragmatic reason for using surrogate keys.
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
104 Verified Questions
104 Flashcards
Source URL: https://quizplus.com/quiz/48399
Sample Questions
Q1) SQL views are not used ________.
A)to hide columns
B)to show results of computed columns
C)to hide complicated SQL statements
D)to enforce primary key constraints
Q2) If the values in an SQL view are not changeable through the view itself,you may still be able to update the view by using unique application logic.In this case,the specific logic is placed in an INSTEAD OF trigger.
A)True
B)False
Q3) One advantage of using the CONSTRAINT command to define a primary key is that the database designer controls the name of the constraint.
A)True
B)False
Q4) According to the SQL-92 standard,statements used to construct views cannot contain the WHERE clause.
A)True
B)False
Q5) Explain how relationships are created using SQL.Include an example.
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
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/48401
Sample Questions
Q1) Explain and contrast the results provided by the EXISTS,NOT EXISTS,and doubly-nested NOT EXISTS keywords.
Q2) Because EXISTS and NOT EXISTS are forms of correlated subqueries,the processing of the associated SELECT statements must be nested.
A)True B)False
Q3) What is the process for adding a NOT NULL column to a table?
Q4) Changing table names is complicated by the fact that constraints and triggers are often associated with the table and will also need to be changed. A)True B)False
Q5) To change the minimum cardinality on the parent side from zero to one,the foreign key,which would have been NULL,must be changed to NOT NULL. A)True B)False
Q6) To add a NULL column to a table,we simply use the MODIFY TABLE statement. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 9: Managing Multiuser Databases
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/48403
Sample Questions
Q1) Explain the purpose of transaction logs and checkpoints.
Q2) When a transaction rereads data that has been changed and finds changes due to committed transactions,this is known as a ________.
A)Clean read
B)Dirty read
C)Nonrepeatable read
D)Phantom read
Q3) The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.
A)True
B)False
Q4) According to ANSI SQL,the serializable isolation level will not allow phantom reads,dirty reads,and nonrepeatable reads.
A)True
B)False
Q5) Locks placed automatically by the DBMS are called implicit locks.
A)True
B)False
Q6) Distinguish between the four cursor types.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Managing Databases With SQL Server 2014
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/48383
Sample Questions
Q1) In SQL Server,the full recovery model creates a log entry for every change to the database.
A)True
B)False
Q2) To use an SQL Server reserved word as a user identifier,it must be enclosed in square brackets [ ].
A)True
B)False
Q3) SQL Server automatically makes determinations of whether or not to promote or demote a lock.
A)True
B)False
Q4) Which of the following is true about indexes in SQL Server?
A)SQL Server automatically creates indexes for columns appearing in WHERE clauses in queries.
B)SQL Server pads all indexes.
C)SQL Server supports filling up to a limit of 70 percent.
D)SQL Server automatically creates indexes for foreign keys.
Q5) Describe the database files that are automatically created when a new database is created in SQL Server.
13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Managing Databases With Oracle Database
Available Study Resources on Quizplus for this Chatper
106 Verified Questions
106 Flashcards
Source URL: https://quizplus.com/quiz/48386
Sample Questions
Q1) In Oracle Database,indexes are created using the ALTER command.
A)True
B)False
Q2) The Oracle tool used to copy data into a database table from a spreadsheet is called the ________.
A)Spreadsheet Wizard
B)Data Import Wizard
C)Database Configuration Assistant
D)Enterprise Manager Database Express
Q3) The NextVal method provides the next value in a sequence.
A)True
B)False
Q4) What is the Oracle Enterprise Manager Database Express?
Q5) The Oracle Database PL/SQL statement used to repeat a set of PL/SQL statements as long as some condition is true is ________.
A)DECLARE
B)BEGIN
C)IF...ELSE...END IF
D)LOOP
Q6) What is SQL*Plus?
Page 14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: Managing Databases With Mysql 56
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/48389
Sample Questions
Q1) The MySQL Table Editor is accessible from the MySQL Workbench.
A)True
B)False
Q2) MySQL uses MySQL OLD transition variables with triggers to access old data updated or deleted from a table row.
A)True
B)False
Q3) Explain the MySQL control-of-flow statements.
Q4) MySQL supports BEFORE triggers.
A)True
B)False
Q5) MySQL uses MySQL NEW transition variables with triggers to access new data inserted into a table row.
A)True
B)False
Q6) Logging into the MySQL DBMS is done using ________.
A)the Connect to Server command
B)the Connect to Server dialog box
C)the Local instance MySQL56 command
D)the Local instance MySQL56 dialog box
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
128 Verified Questions
128 Flashcards
Source URL: https://quizplus.com/quiz/48405
Sample Questions
Q1) Which of the following can only interact with relational database and table-like data structures?
A)OLE DB
B)ODBC
C)ASP
D)ADO
Q2) Applet bytecode is transmitted to the user's computer via ________.
A)the JDBC driver
B)the Java virtual machine
C)HTTP
D)the bytecode interpreter
Q3) What type of JDBC driver is known as a JDBC-ODBC bridge?
A)Type 1 driver
B)Type 2 driver
C)Type 3 driver
D)Type 4 driver
Q4) Compare and contrast servlets and applets.
Q5) What is XML,and why is it significantly better than HTML?
Q6) Explain the relationships among native DBMS libraries,ODBC,OLE DB,ADO,and ADO.NET and why each led to the development of the next.
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Big Data, Data-Warehouses, and Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
108 Verified Questions
108 Flashcards
Source URL: https://quizplus.com/quiz/48407
Sample Questions
Q1) In OLAP,the data item of interest is called a ________.
A)level
B)dimension
C)measure
D)member
Q2) Structured storage column families are indistinguishable from relational database tables.
A)True
B)False
Q3) Business Intelligence (BI)systems are information systems that help users analyze and use data.
A)True
B)False
Q4) What is a Microsoft Excel PivotTable?
Q5) Most data mining techniques are simple and easy to use.
A)True
B)False
Q7) What are Business Intelligence (BI)systems? Page 17
Q6) Compare the characteristics of an operational database and a dimensional database.
To view all questions and flashcards with answers, click on the resource link above.
Page 18
Chapter 15: Getting Started With Microsoft Access 2013
Available Study Resources on Quizplus for this Chatper
53 Verified Questions
53 Flashcards
Source URL: https://quizplus.com/quiz/48384
Sample Questions
Q1) Data in columns defined using which of the following data types in Microsoft Access cannot be changed by the user?
A)Long Text
B)Date/Time
C)Number
D)AutoNumber
Q2) In Microsoft Access 2013,the maximum length in characters of a "Short Text" data type column is ________.
A)25
B)255
C)65535
D)unlimited
Q3) The Microsoft Access data type of AutoNumber is used when there is a specific need for a ________.
A)foreign key
B)primary key
C)surrogate key
D)secondary key
Q4) Explain how to create a relationship in Microsoft Access.Include an example.
Q5) 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 16: Getting Started With Systems Analysis and Design
Available Study Resources on Quizplus for this Chatper
37 Verified Questions
37 Flashcards
Source URL: https://quizplus.com/quiz/48387
Sample Questions
Q1) A deliverable from the requirements analysis step is a ________.
A)user requirements document (URD)
B)user requirements statement (URS)
C)statement of work (SOW)
D)A and sometimes C
Q2) Data models are created during the component design step.
A)True
B)False
Q3) 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)
Q4) How does Michael Porter define primary or operational business activities? What do they include?
Q5) What activities take place during the component design step of the systems development life cycle (SDLC)?
Q6) One definition of information is knowledge derived from data.
A)True
B)False Page 20
To view all questions and flashcards with answers, click on the resource link above.
Page 21
Chapter 17: E-R Diagrams and the IDEF1X Standard
Available Study Resources on Quizplus for this Chatper
37 Verified Questions
37 Flashcards
Source URL: https://quizplus.com/quiz/48390
Sample Questions
Q1) In IDEF1X,extended E-R model weak,but non-ID-dependent relationships are called
A)identifying connection relationships
B)nonspecific relationships
C)category clusters
D)There is no equivalent IDEF1X term.
Q2) In IDEF1X,extended E-R model subtype entities are grouped into ________.
A)generic entities
B)category entities
C)nonspecific entities
D)category clusters
E)There is no equivalent IDEF1X term.
Q3) The IDEF1X default cardinality of a nonidentifying connection relationship is one-to-one,with a mandatory parent and an optional child.
A)True
B)False
Q4) What line symbols are used in IDEF1X diagrams to represent relationships?
Q5) What are the IDEF1X equivalents of 1:1,1:N and N:M relationships?
Q6) What symbols are used in IDEF1X diagrams to represent cardinalities?
Q7) What is IDEF1X?
To view all questions and flashcards with answers, click on the resource link above. Page 22
Chapter 18: 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/48392
Sample Questions
Q1) 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
Q2) One weakness of UML-style E-R diagrams is that there is no means of distinguishing between a weak entity that is ID-dependent and a weak entity that is not ID-dependent.
A)True
B)False
Q3) In the UML-style entity class ORDERS shown above,"SumOfOrders" is ________.
A)an entity attribute
B)a method
C)a constraint
D)a class attribute
Q4) In UML-style E-R diagrams,the third segment of an entity class contains ________.
A)the name of the entity
B)the cardinalities of the entity
C)constraints and methods
D)entity attributes
To view all questions and flashcards with answers, click on the resource link above.
23
Chapter 19: 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/48394
Sample Questions
Q1) Describe how to set table properties in a MySQL Workbench database design.
Q2) Table names are edited in the MySQL EER Component Editor.
A)True
B)False
Q3) In the MySQL Table Editor,the abbreviation for Primary Key is ________.
A)PK
B)NN
C)UQ
D)AI
Q4) In the MySQL Table Editor,the abbreviation PK stands for partial key.
A)True
B)False
Q5) Table column characteristics can be edited in the MySQL Table Editor. A)True
B)False
Q6) Describe the MySQL Connector/ODBC and how to install it.
Page 24
Q7) To create a new MySQL Workbench EER model,you can use the Create new EER Model link on the Home page.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Page 25
Chapter 20: Getting Started With Microsoft Visio 2013
Available Study Resources on Quizplus for this Chatper
32 Verified Questions
32 Flashcards
Source URL: https://quizplus.com/quiz/48396
Sample Questions
Q1) In Microsoft Visio 2013,the cardinalities of the Relationship connector object end points are formatted using ________.
A)the Set Begin Symbol command
B)the Set End Symbol command
C)the Set Non-primary Key Unique column
D)Both A and B are correct
Q2) In Microsoft Visio 2013,how do we create data models?
Q3) 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 Relationship connector objects
D)There are no separate objects to create supertype/subtype,so we use standard objects.
Q4) In Microsoft Visio 2013,the Crow's Foot Database Notation stencil objects include a Category object.
A)True
B)False
Q5) 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 26
Chapter 21: Data Structures for Database Processing
Available Study Resources on Quizplus for this Chatper
39 Verified Questions
39 Flashcards
Source URL: https://quizplus.com/quiz/48398
Sample Questions
Q1) A ________ is a file that has no repeating groups.
A)flat file
B)stacked file
C)record file
D)key file
Q2) The primary work key is a field or fields whose value uniquely identifies a record.
A)True
B)False
Q3) A flat file is a file that has repeating groups.
A)True
B)False
Q4) A collection of records and the 1:N relationships between them is a ________.
A)simple network
B)complex network
C)compound network
D)logical network
Q5) A simple network can be represented using linked lists and indexes.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 27
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/48400
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) Semantic objects are said to be ________.
A)Semantically self-contained
B)Semantically complete
C)Semantically inclusive
D)Both A and B are correct
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
Q4) Describe the two ways that semantic object views can be used.
Q5) Explain why semantic object attributes are called paired attributes.
Q6) Explain the differences between the E-R model and the semantic object model.
Q7) Distinguish between the physical description and the semantic description of an attribute domain.
To view all questions and flashcards with answers, click on the resource link above. Page 28
Chapter 23: Getting Started With Web Servers, PHP, and the
Netbeans IDE
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/48402
Sample Questions
Q1) For a workstation running the Windows operating system,the user file system permissions Modify and Write must be granted to ________ at the wwwroot folder.
A)the ISUR_{WebServerName} User
B)the IAPP_{WebServerName} User
C)the WebUsers group
D)the Users group
Q2) What is the Microsoft Web Platform Installer,and what are the advantages and disadvantages of using it to install PHP?
Q3) Which of the following is not true about PHP dynamic extension files (dll files)?
A)They can be shared by many applications.
B)They allow php to make application calls directly to the DBMS rather than using ODBC.
C)There is no relationship between the php.ini file and the dll files.
D)They enable support for PHP Data Objects (PDO).
Q4) Only the 64-bit version of the Java Runtime Environment should be installed when using a 64-bit operating system.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 29
Chapter 24: Business Intelligence Systems
Available Study Resources on Quizplus for this Chatper
82 Verified Questions
82 Flashcards
Source URL: https://quizplus.com/quiz/48404
Sample Questions
Q1) RFM analysis can be done using SQL ________.
A)user-defined functions
B)stored procedures
C)triggers
D)union queries
Q2) Which of the following is a common supervised data mining technique?
A)Cluster analysis
B)Regression analysis
C)RFM analysis
D)SQL analysis
Q3) A reporting system does not maintain a database of metadata.
A)True
B)False
Q4) Refer to the table above.What is the confidence of Drug B being purchased given that Drug A has been purchased?
A).200
B).250
C).333
D).400
Q5) What is a data warehouse?
Page 30
To view all questions and flashcards with answers, click on the resource link above.
Chapter 25: Big Data
Available Study Resources on Quizplus for this Chatper
81 Verified Questions
81 Flashcards
Source URL: https://quizplus.com/quiz/48406
Sample Questions
Q1) An example of a key-value database is ________.
A)DynamoDB
B)Couchbase Server
C)Bigtable
D)Neo4j
Q2) XML Schema is used to define ________.
A)document content and structure
B)XQL queries
C)DOM-compliant parsers
D)DTDs
Q3) Graph databases are composed of three elements,one of which is the attribute.
A)True
B)False
Q4) An example of a document database is ________.
A)Dynamo
B)Couchbase Server
C)Bigtable
D)Neo4j
Q5) What is an XML Schema?
Q6) What does NoSQL stand for,and what does it mean?
To view all questions and flashcards with answers, click on the resource link above. Page 31