Advanced Database Systems
Exam Solutions
Course Introduction
Advanced Database Systems explores the theoretical foundations and practical implementations of modern database management systems beyond the basics of relational databases. The course covers advanced topics such as distributed and parallel database architectures, query optimization, data warehousing, NoSQL systems, transactions and concurrency control, data mining, and big data management. Students will analyze the design and scalability considerations for high-performance databases, examine emerging trends like cloud storage and NewSQL, and work with real-world datasets to develop efficient solutions for complex data management challenges. Through hands-on projects and case studies, participants will gain practical experience with advanced database technologies and their application in current industry contexts.
Recommended Textbook
Modern Database Management 12th Edition by Jeffrey A. Hoffer
Available Study Resources on Quizplus
14 Chapters
1469 Verified Questions
1469 Flashcards
Source URL: https://quizplus.com/study-set/1058
2
Chapter 1: The Database Environment and Development Process
Available Study Resources on Quizplus for this Chatper
116 Verified Questions
116 Flashcards
Source URL: https://quizplus.com/quiz/20934
Sample Questions
Q1) Systems analysts work directly with both management and users to analyze the business situation and develop detailed project specifications.
A)True
B)False
Answer: False
Q2) Discuss why alternative IS development approaches have evolved, and provide an overview of a couple of these methodologies.
Answer: The SDLC is often criticized for being too long from the time of system start until a finished product is delivered. As such, organizations have begun to adopt rapid application development techniques. One technique is prototyping, where a system is designed as a prototype, given to the user for testing and then corrected as needed. This is an iterative process. Another methodology is Agile software development, which focuses more on people than processes.
Q3) Separation of metadata from application programs that use the data is called data independence.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Modeling Data in the Organization
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20935
Sample Questions
Q1) An entity that associates the instances of one or more entity types and contains attributes specific to the relationships is called a(n):
A) associative entity.
B) build entity.
C) gateway entity.
D) smush entity.
Answer: A
Q2) A business rule is a statement that defines or constrains some aspect of the business.
A)True
B)False
Answer: True
Q3) A business rule should be internally consistent.
A)True
B)False
Answer: True
Q4) A ternary relationship is equivalent to three binary relationships.
A)True
B)False
Answer: False
Page 4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: The Enhanced E-R Model
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20936
Sample Questions
Q1) Explain the terms subtype and supertype. Discuss the differences between them. Answer: A subtype is an entity which represents data meaningful to the organization. For example, an undergraduate student and a graduate student might be a subtype. A supertype is a generalization of various subtypes and contains attributes which are common to both. Supertypes and subtypes may have relationships with other entities. Also, a subtype inherits the attributes of its supertype.
Q2) Given the following entities, which of the choices below would be the most complicated? Automobile: VIN, EngineSize, NumberOfDoors, NumberOfPassengers, FuelType, Transmission
SUV: VIN, EngineSize, NumberOfPassengers, NoWheelDrive, FuelType, Transmission Truck: VIN, EngineSize, NoWheelDrive, FuelType, Transmission, Payload
A) Define one vehicle entity type to hold all entities.
B) Define a separate entity type for each entity.
C) Define a supertype called vehicle and make each of the entities subtypes.
D) Keep only the Truck entity type.
Answer: A
Q3) Describe how subtype discriminators are used when we have overlapping subtypes. Answer: When we have overlapping subtypes, we need to create a composite subtype discriminator with Boolean values.
To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 4: Logical Database Design and the Relational Model
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20937
Sample Questions
Q1) When transforming a unary many-to-many relationship to relations, a recursive foreign key is used.
A)True
B)False
Q2) An anomaly is a type of flaw in the database server.
A)True
B)False
Q3) An enterprise key is a foreign key whose value is unique across all relations.
A)True
B)False
Q4) Discuss the properties of relations.
Q5) In the SQL language, the ________ statement is used to make table definitions.
A) create session
B) create table
C) create index
D) select
Q6) Explain what a candidate key is and how it might be used.
B)False Page 6
Q7) A primary key is an attribute that uniquely identifies each row in a relation. A)True
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 5: Physical Database Design and Performance
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20938
Sample Questions
Q1) The query processor always knows the best way to process a query.
A)True
B)False
Q2) Discuss the critical decisions that must be made during physical database design.
Q3) An appropriate datatype for one wanting a fixed-length type for last name would include:
A) VarChar.
B) Char.
C) Blob.
D) Date.
Q4) A detailed coding scheme recognized by system software for representing organizational data is called a(n):
A) DBMS code.
B) data type.
C) SQL.
D) DB layout.
Q5) Discuss how data integrity can be controlled.
Q6) Discuss when it is best to use indexes.
Q7) Explain what primary, secondary and unique key indexes are.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Introduction to SQL
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20939
Sample Questions
Q1) Which of the following will produce the minimum of all standard prices?
A) Select standard_price from Product_V where Standard_Price = min;
B) Select min(standard_price) from Product_V;
C) Select Standard_Price from min(Product_V);
D) Select min(Standard_Price) from Product_V where Standard_Price = min(Standard_Price);
Q2) Discuss when to use the GROUP BY clause.
Q3) The command for creating a database is:
A) create table.
B) create view.
C) create schema.
D) create authorization.
Q4) What does the following SQL command do? insert into Customer_T values (001,'John Smith','231 West St','Boston','MA','02115');
A) Adds a new record to the Customer_T
B) Creates the Customer_T table
C) Deletes the Customer_T table
D) Updates the Customer_T table
Q5) What were the original purposes of SQL, and does SQL as we know it today live up to those standards?
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 7: Advanced SQL
Available Study Resources on Quizplus for this Chatper
107 Verified Questions
107 Flashcards
Source URL: https://quizplus.com/quiz/20940
Sample Questions
Q1) What results would the following SQL statement produce? select owner, table_name From dba_tables
Where table_name = 'CUSTOMER';
A) A listing of all customers in the customer table
B) A listing of the owner of the customer table
C) A listing of the owner of the customer table as well as customers
D) An error message
Q2) The following code would include:
SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID
FROM Customer_T, Order_T
WHERE Customer_T.CustomerID = Order_T. CustomerID;
A) all rows of the Order_T Table regardless of matches with the Customer_T Table.
B) all rows of the Customer_T Table regardless of matches with the Order_T Table.
C) only rows that match both Customer_T and Order_T Tables.
D) only rows that don't match both Customer_T and Order_T Tables.
Q3) What are some tips for developing queries?
Q4) When is it better to use a subquery over using a join?
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 8: Database Application Development
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20941
Sample Questions
Q1) Which of the following is an advantage of stored procedures?
A) Data integrity improves when fewer applications access the procedure.
B) The layers get cleaner.
C) Stored procedures result in fatter clients.
D) Performance improves for compiled SQL statements.
Q2) Sets of routines that an application program uses to direct the performance of procedures by the computer's operating system is called a(n):
A) application program interface.
B) xpi.
C) application device interface.
D) CMOS.
Q3) A client PC that is responsible for presentation logic, application logic, and many DBMS functions is called a fat client.
A)True
B)False
Q4) The presentation logic component of a client/server system is responsible for formatting and presenting data on the user's screen.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 9: Data Warehousing
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20942
Sample Questions
Q1) Reconciled data are data that have been selected, formatted, and aggregated for end-user decision support applications.
A)True
B)False
Q2) Explain what the star schema is.
Q3) Explain the dependent data mart and operational data store architecture.
Q4) Organizations adopt data mart architectures because it is easier to have separate, small data warehouses than to get all organizational parties to agree to one view of the organization in a central data warehouse.
A)True
B)False
Q5) There are applications for fact tables without any nonkey data, only the foreign keys for the associated dimensions.
A)True
B)False
Q6) What is the surrogate key rule for the star schema, and what are the main reasons for this rule?
Q7) What is data mining, and what are its goals?
Q8) Explain the four basic steps to build an independent data mart.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Data Quality and Integration
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20943
Sample Questions
Q1) Quality data are not essential for well-run organizations.
A)True
B)False
Q2) The uncontrolled proliferation of spreadsheets, databases and repositories leads to data quality problems.
A)True
B)False
Q3) Retention refers to the amount of data that is not purged periodically from tables.
A)True
B)False
Q4) What are the key steps in a data quality program?
Q5) The process of combining data from various sources into a single table or view is called:
A) extracting.
B) updating.
C) selecting.
D) joining.
Q6) What are some of the reasons for deteriorated data quality?
Q7) What are some of the characteristics of quality data?
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Big Data and Analytics
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20944
Sample Questions
Q1) The oldest form of analytics is:
A) predictive analytics.
B) descriptive analytics.
C) prescriptive analytics.
D) comparative analytics.
Q2) Customers leave clues about their preferences when navigating a company's Web site.
A)True
B)False
Q3) ________ tools commonly load data into intermediate hypercube structures.
A) OLAP
B) MOLAP
C) ROLAP
D) TLAP
Q4) NoSQL databases DO NOT support ACID (atomicity, consistency, isolation, and durability).
A)True
B)False
Q5) Describe the Five Vs of Big Data.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 12: Data and Database Administration
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/20945
Sample Questions
Q1) An open-source DBMS is:
A) a free source-code RBMS that provides the functionality of an SQL-compliant DBMS.
B) a beta release of a commercial RDBMS.
C) an object-oriented database management system.
D) source code for a commercial RDBMS.
Q2) The transaction log contains before and after images of records that have been modified.
A)True
B)False
Q3) A repository of information about a database that documents data elements of a database is called a:
A) schema.
B) subschema.
C) view.
D) data dictionary.
Q4) What are some of the core roles of the traditional data administrator?
Q5) The granularity of locking is not a critical decision in database design.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 13: Distributed Databases
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/20946
Sample Questions
Q1) Which of the following supports a simple path to other databases, without the benefits of one logical database?
A) Linked; differential
B) Gateways
C) Autonomous; cross-linked
D) Federated; nonautonomous
Q2) Replication transparency is a design goal in distributed database systems, which says that even though a data item may be replicated at several nodes throughout the network, a user may treat the data item as if it were a single data item at a single node.
A)True
B)False
Q3) Applications such as decision support or data warehousing often do not require current data and are supported by periodic snapshots.
A)True
B)False
Q4) A replicated database with snapshots is very manageable.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Page 16
Chapter 14: Object-Oriented Data Modeling
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20947
Sample Questions
Q1) In aggregation, some of the operations of the whole automatically apply to its parts.
A)True
B)False
Q2) A model of a real world application and associated properties are created in the:
A) analysis phase.
B) design phase.
C) implementation phase.
D) evaluation phase.
Q3) An update operation has side effects since it alters the state of an object.
A)True
B)False
Q4) In addition to specifying the multiplicity of an association role, you can also specify other properties, for example, if the objects playing the role are ordered or not.
A)True
B)False
Q5) What is the purpose of a constructor operation?
Q6) What is the difference between a class and an object?
To view all questions and flashcards with answers, click on the resource link above.
Page 17