Database Systems Exam Practice Tests
Course Introduction
Database Systems introduces students to the fundamental concepts, architectures, and applications of modern database management systems. The course covers data models, relational algebra, SQL query language, database design techniques, normalization, and transaction management. Students will gain practical experience designing, implementing, and querying databases, while also exploring concepts such as indexing, storage structures, and security. Emphasis is placed on real-world applications, scalability considerations, and the evolving landscape of database technologies.
Recommended Textbook
Database Systems Design Implementation and Management 9th Edition by Carlos Coronel
Available Study Resources on Quizplus
15 Chapters
1320 Verified Questions
1320 Flashcards
Source URL: https://quizplus.com/study-set/521
Page 2
Chapter 1: Database Systems
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/9760
Sample Questions
Q1) A(n)____ database is designed to support a company's day-to-day operations.
A) desktop
B) workgroup
C) enterprise
D) transactional
Answer: D
Q2) Raw data must be properly ____________________ for storage,processing and presentation.
Answer: formatted
Q3) What are the advantages of having the DBMS between the end user's applications and the database?
Answer: Having a DBMS between the end user's applications and the database offers some important advantages.First,the DBMS enables the data in the database to be shared among multiple applications or users.Second,the DBMS integrates the many different users' views of the data into a single all-encompassing data repository.
Q4) ____________________ exists when the same data are stored unnecessarily at different places.
Answer: Data redundancy
To view all questions and flashcards with answers, click on the resource link above.
3
Chapter 2: Data Models
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/9761
Sample Questions
Q1) A(n)____ represents a particular type of object in the real world.
A) attribute
B) entity
C) relationship
D) constraint
Answer: B
Q2) The hierarchical data model was developed in the ____.
A) 1960s
B) 1970s
C) 1980s
D) 1990s
Answer: A
Q3) A verb associating two nouns in a business rule translates to a(n)____ in the data model.
A) entity
B) attribute
C) relationship
D) constraint
Answer: C
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: The Relational Database Model
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9762
Sample Questions
Q1) In the following table description,____ is the primary key.
PRODUCT (PROD_CODE,PROD_DESCRIPT,PROD_PRICE,PROD_ON_HAND,VEND_CODE)
A) PROD_DESCRIPT
B) PROD_CODE
C) PROD_PRICE
D) PROD_ON_HAND
Answer: B
Q2) ____ yields a vertical subset of a table.
A) PROJECT
B) SELECT
C) UNION
D) DIFFERENCE
Answer: A
Q3) The ____ constraint can be placed on a column to ensure that every row in the table has a value for that column.
A) HAS VALUE
B) NOT NULL
C) MUST HAVE VALUE
D) NOT EMPTY
Answer: B
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Entity Relationship (ER)Modeling
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9763
Sample Questions
Q1) Relationships operate only in one direction.
A)True
B)False
Q2) A ____ attribute is one that cannot be subdivided.
A) composite
B) simple
C) single-valued
D) multivalued
Q3) In the relationship "EMPLOYEE claims DEPENDENT" the DEPENDENT entity is ____________________ on the EMPLOYEE entity.
Q4) The Crow's Foot model is more ____________________-oriented than the Chen model.
Q5) Attributes may share a ____.
A) name
B) domain
C) location
D) table
Q6) Explain the difference between simple and composite attributes.Provide at least one example of each.
Q8) A(n)____________________ attribute cannot be subdivided. Page 6
Q7) The ERM forms the basis of a(n)___________________________________.
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 5: Advanced Data Modeling
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/9764
Sample Questions
Q1) Overlapping subtypes are subtypes that contain ____ subsets of the supertype entity set.
A) entity
B) subtypes
C) unique
D) nonunique
Q2) The ____________________ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype.
Q3) ____ keys work with primary keys to properly implement relationships in the relational model.
A) Foreign
B) Composite
C) Natural
D) Surrogate
Q4) Explain the "no change over time" characteristic of a good primary key.
Q5) To model time-variant data,you must create a new entity in a M:N relationship with the original entity.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 6: Normalization of Database Tables
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9765
Sample Questions
Q1) An attribute that is part of a key is known as a(n)____ attribute.
A) important
B) nonprime
C) prime
D) entity
Q2) Of the following normal forms,____,is mostly of theoretical interest.
A) 1NF
B) 3NF
C) BCNF
D) DKNF
Q3) Relational models view the data as part of a table or collection of tables in which all key values must be identified.
A)True
B)False
Q4) In a(n)____ diagram,the arrows above the attributes indicate all desirable dependencies.
A) Chen
B) dependency
C) functionality
D) ER
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: 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/9766
Sample Questions
Q1) Frequency distributions can be created quickly and easily using the SQL ____________________ clause.
Q2) An example of a command you would use when making changes to a PRODUCT table is ____.
A) CHANGE PRODUCT
SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
B) ROLLBACK PRODUCT
SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
C) EDIT PRODUCT
SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
D) UPDATE PRODUCT
SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
Q3) What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.
Q4) ____________________ words are words used by SQL to perform specific functions.
Q5) To delete an index,use the ____________________ command. Page 10
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 8: Advanced SQL
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9767
Sample Questions
Q1) The Oracle equivalent to an MS Access AutoNumber is a(n)____.
A) auto-number
B) sequence
C) TO_NUMBER function
D) trigger
Q2) ____ is a relational set operator.
A) MINUS
B) PLUS
C) ALL
D) EXISTS
Q3) The ____ operator could be used in place of INTERSECT if the RDBMS does not support it.
A) IN
B) OF C) AND D) UNION
Q4) Just like database triggers,stored procedures are stored in the database.
A)True
B)False
Q5) The IN subquery uses a(n)____________________ operator.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 9: Database Design
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9768
Sample Questions
Q1) Database backups can be performed at different levels.List and describe these.
Q2) Database performance is one of the least important factors in all database implementations.
A)True
B)False
Q3) The conceptual design step that defines the DBMS and data model to use is ____.
A) database analysis and requirements
B) ER modeling and normalization
C) data-model verification
D) distributed database design
Q4) What are the factors affecting the purchasing decision for DBMS software?
Q5) Evaluation,maintenance,and enhancement are part of the ____ phase of the SDLC. A) planning
B) maintenance
C) detailed systems design
D) implementation
Q6) Problems defined during the planning phase are examined in greater detail during the analysis phase.
A)True
B)False
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Transaction Management and Concurrency
Control
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/9769
Sample Questions
Q1) The phenomenon of uncommitted data occurs when two transactions are executed concurrently and the first transaction is rolled back after the second transaction has already accessed the uncommitted data-thus violating the isolation property of transactions.
A)True
B)False
Q2) Durability requires that all portions of the transaction must be treated as a single,logical unit of work in which all operations are applied and completed to produce a consistent database.
A)True
B)False
Q3) During the ____ phase,changes are permanently applied to the database.
A) read
B) validation
C) write
D) shared
Q4) The ____________________ interleaves the execution of database operations to ensure serializability.
Q5) Explain the functions of shared and exclusive locks.
Q6) What is transaction isolation and why it is important? Page 14
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 11: Database Performance Tuning and Query
Optimization
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/9770
Sample Questions
Q1) On the server side,the DBMS environment must be properly configured to respond to clients requests in the fastest way possible,while making optimum use of existing resources.The activities required to achieve that goal are commonly referred to as ____ tuning.
A) client and server
B) database
C) SQL performance
D) DBMS performance
Q2) ____________________ is a measure of how likely an index will be used in query processing.
Q3) A(n)____ is a logical grouping of several data files that store data with similar characteristics.
A) procedure cache
B) file group
C) data files
D) extends
Q4) Database ____________________ activities can be divided into those taking place either on the client side or on the server side.
Q5) Describe query optimization and the modes that an optimizer can operate in.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 12: Distributed Database Management Systems
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/9771
Sample Questions
Q1) In a DDBMS,query ____________________ is used to find the best access strategy.
Q2) ____ distributed database systems integrate different types of centralized DBMSs over a network.
A) Homogeneous
B) Heterogeneous
C) Fully homogeneous
D) Combination
Q3) What is transaction transparency? What are some of the basic concepts that you should know to understand how transactions are managed in a DDBMS?
Q4) The ____________________ commit protocol guarantees that if a portion of a transaction operation cannot be committed,all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.
Q5) Distributed processing does not require a distributed database,and a distributed database does not require distributed processing.
A)True
B)False
Q6) One of the advantages of a DDBMS is less danger of a single-____________________ failure.
17
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Business Intelligence and Data Warehouses
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9772
Sample Questions
Q1) Business ____________________ are the central units of operation in a business.
Q2) To support a(n)____________________ adequately,the DBMS might be required to use advanced hardware,such as multiple disk arrays,and even more importantly,to support multiple-processor technologies,such as a symmetric multiprocessor (SMP)or a massively parallel processor (MPP).
Q3) The reliance on ____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.
A) normalization
B) denormalization
C) star schema
D) multidimensional schema
Q4) ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework.
A)True
B)False
Q5) A(n)_______________________________________________________ uses special proprietary techniques to store data in matrix-like n-dimensional arrays.
Page 18
Q6) OLAP systems share four main characteristics.What are they?
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Database Connectivity and Web Technologies
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9773
Sample Questions
Q1) Another name for a database server-side extension is ____.
A) Web server
B) Web application server
C) Web-to-database middleware
D) Database application server
Q2) The first line of an XML document represents the document declaration,and it is mandatory.
A)True
B)False
Q3) An API uses script files that perform specific functions on the client's parameters that are passed to the Web server.
A)True
B)False
Q4) ___________________________________ is an application programming interface that allows a Java program to interact with a wide range of data sources (relational databases,tabular data sources,spreadsheets,and text files).
Q5) What are some of the features provided by Web application servers?
Q6) The Web ____________________ is the main hub through which all Internet services are accessed.
19
To view all questions and flashcards with answers, click on the resource link above.
Chapter 15: Database Administration and Security
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9774
Sample Questions
Q1) In the Oracle Enterprise Manager,a ____ is basically any object created by end users; for example,tables,views,indexes,stored procedures,and triggers.
A) component
B) database object
C) policy
D) role
Q2) Procedures and standards must be revised at least ____ to keep them up-to-date.
A) weekly
B) monthly
C) every six months
D) annually
Q3) The DBA must periodically generate a(n)____________________ report to determine whether there have been actual or attempted security violations-and,if so,from what locations,and if possible,by whom.
Q4) The DBA can use an audit log to automatically record a brief description of the database operations performed by the users.
A)True
B)False
Q5) The most common backup medium has traditionally been
20
To view all questions and flashcards with answers, click on the resource link above.