SQL and Database Applications
Mock Exam
Course Introduction
This course introduces students to the principles and practical applications of Structured Query Language (SQL) and relational database systems. Students will learn to design, implement, and manage databases using SQL for data retrieval, manipulation, and reporting. Topics include relational database concepts, normalization, entity-relationship modeling, indexing, transactions, and basic security practices. Throughout the course, students will gain hands-on experience developing and optimizing databases that support real-world applications, preparing them for work in data management and information systems roles.
Recommended Textbook
Database Systems Design Implementation and Management 11th Edition by Carlos Coronel
Available Study Resources on Quizplus
15 Chapters
1318 Verified Questions
1318 Flashcards
Source URL: https://quizplus.com/study-set/1460 Page 2
Chapter 1: Database Systems
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/29009
Sample Questions
Q1) serve as the intermediary between the user and the database.
A) DBMSs
B) Metadata
C) End-user data
D) Programming languages
Answer: A
Q2) The only way to access the data in a database is through the DBMS.
A)True
B)False
Answer: True
Q3) Raw data must be properly for storage, processing and presentation.
Answer: formatted
Q4) The database structure in a DBMS is stored as a .
A) single file
B) collection of files
C) set of key/value pairs
D) collection of queries
Answer: B
Q5) is data about data through which the end-user data are integrated and managed.
Answer: Metadata
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Data Models
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29016
Sample Questions
Q1) The data model uses the concept of inheritance.
A) relational
B) network
C) object-oriented
D) entity relationship
Answer: C
Q2) A(n) is bidirectional.
A) attribute
B) entity
C) relationship
D) constraint
Answer: C
Q3) Which of the following is True of NoSQL databases?
A) They do not support distributed database architectures.
B) They are not based on the relational model.
C) They are geared toward transaction consistency rather D) They do not support very large amounts of than performance. sparse data.
Answer: B
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29017
Sample Questions
Q1) The is actually a system-created database whose tables store the user/designer-created database characteristics and contents.
A) database tuple
B) systematic database
C) unique index
D) system catalog
Answer: D
Q2) , also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.
A) INTERSECT
B) UNION
C) DIFFERENCE
D) SELECT
Answer: D
Q3) The order of the rows and columns is important to the DBMS.
A)True
B)False
Answer: False
Q4) The proper use of keys is crucial to controlling data redundancy.
Answer: foreign
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29018
Sample Questions
Q1) A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.
A)True
B)False
Q2) The entity relationship model uses the associative entity to represent a(n) relationship between two or more entities.
A) M:N
B) 1:M
C) N:1
D) M:1
Q3) In a 1:M relationship, to avoid the possibility of referential integrity errors, the data of the "1" side must be loaded first.
A)True
B)False
Q4) A attribute can be further subdivided to yield additional attributes.
A) composite
B) simple
C) single-valued
D) multivalued
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Advanced Data Modeling
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29019
Sample Questions
Q1) The function of the primary key is to describe an entity.
A)True
B)False
Q2) While using a surrogate key, one must ensure that the candidate key of the entity in question performs properly through the use of the " " and "not null" constraints.
Q3) Unique values can be better managed when they are , because the database can use internal routines to implement a counter-style attribute that automatically increments values with the addition of each new row.
Q4) If one exists, a data modeler uses a as the primary key of the entity being modeled. A) foreign key
B) combination key
C) surrogate key
D) natural identifier
Q5) One important inheritance characteristic is that all entity subtypes inherit their primary key attribute from their supertype.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Normalization of Database Tables
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/29020
Sample Questions
Q1) Explain normalization and its different forms.
Q2) The conflicts between design efficiency, information requirements, and performance are often resolved through_____.
A) compromises that include normalization
B) conversion from 2NF to 3NF
C) compromises that include denormalization
D) conversion from 3NF to 4NF
Q3) In order to meet performance requirements, portions of the database design may need to be occasionally denormalized.
A)True
B)False
Q4) The advantage of higher processing speed must be carefully weighed against the disadvantage of data anomalies.
A)True
B)False
Q5) Explain how database designers design and normalize databases.
Q6) The price paid for increased performance through denormalization is a larger amount of .
Q7) refers to the level of detail represented by the values stored in a table's row.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Introduction to Structured Query Language Sql
Available Study Resources on Quizplus for this Chatper
111 Verified Questions
111 Flashcards
Source URL: https://quizplus.com/quiz/29021
Sample Questions
Q1) Which of the following queries is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?
A) SELECT ONLY V_CODE FROM PRODUCT;
B) SELECT UNIQUE V_CODE FROM PRODUCT;
C) SELECT DIFFERENT V_CODE FROM PRODUCT;
D) SELECT DISTINCT V_CODE FROM PRODUCT;
Q2) To list all the contents of the PRODUCT table, a user would use .
A) LIST * FROM PRODUCT
B) SELECT * FROM PRODUCT
C) DISPLAY * FROM PRODUCT
D) SELECT ALL FROM PRODUCT
Q3) All changes in a table structure are made using the command, followed by a keyword that produces the specific changes a user wants to make.
A) ALTER TABLE
B) UPDATE TABLE
C) COMMIT TABLE
D) ROLLBACK TABLE
Q4) The basic SQL vocabulary has fewer than words.
Q5) In a 1:M relationship, a user must always create the table for the side first.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Advanced Sql
Available Study Resources on Quizplus for this Chatper
109 Verified Questions
109 Flashcards
Source URL: https://quizplus.com/quiz/29022
Sample Questions
Q1) A(n) join will select only the rows with matching values in the common attribute(s).
A) natural
B) cross
C) full
D) outer
Q2) A(n) subquery is a subquery that executes once for each row in the outer query.
Q3) When using a subquery, the output of a(n) query is used as the input for the outer query.
Q4) Which of the following is a feature of oracle sequences?
A) Oracle sequences are tied to columns and tables.
B) Oracle sequences generate a character string that can be assigned to tables.
C) An oracle sequence uses the identity column
D) An oracle sequence can be created and deleted property to automatically number rows. anytime.
Q5) Describe the important features and applications of SQL functions
Q6) Explain the different basic types of join operations. What are they and how do they work?
Q7) Describe the characteristics of an Oracle sequence.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Database Design
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/29023
Sample Questions
Q1) Selecting database management system (DBMS) software is part of the phase of the Database Life Cycle (DBLC).
A) database initial study
B) database design
C) implementation and loading
D) testing and evaluation
Q2) The first step in the ER model verification process is to .
A) identify each module and its components
B) identify the ER model's central entity
C) verify all processes against the ER model
D) identify each module's internal transaction requirements
Q3) The system and operational costs are addressed by the during the planning phase of the Systems Development Life Cycle (SDLC).
Q4) During the implementation phase of the Systems Development Life Cycle (SDLC), the hardware, database management system (DBMS) software, and application programs are installed, and the database design is implemented.
A)True
B)False
Q5) Explain the concept of logical design and list the steps involved.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Transaction Management and Concurrency
Control
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29010
Sample Questions
Q1) -level locks are less restrictive than database-level locks, but they create traffic jams when many transactions are waiting to access the same table.
Q2) The interleaves the execution of database operations to ensure serializability.
Q3) Uniqueness ensures that no equal time stamp values can exist, and ensures that time stamp values always increase.
Q4) ANSI defines four events that signal the end of a transaction. Of the following events, which is defined by ANSI as being equivalent to a ROLLBACK?
A) Five SQL statements are executed.
B) The end of a program is successfully reached.
C) The program is abnormally terminated.
D) The database is shut down for maintenance.
Q5) Incomplete or improper transactions can have a devastating effect on database integrity.
A)True
B)False
Q6) The rule states that only one transaction at a time can own an exclusive lock on the same object.
Q7) What is transaction isolation and why it is important?
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Database Performance Tuning and Query
Optimization
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29011
Sample Questions
Q1) The table space is the most frequently accessed table space and should be stored in its own volume.
Q2) In-memory database systems are optimized to store small portions of the database in disk storage alone.
A)True
B)False
Q3) On the server side, the database 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 this goal are commonly referred to as tuning.
A) client and server
B) database SQL
C) SQL performance
D) DBMS performance
Q4) All factors must be checked to ensure that each system component operates at its optimum level and has sufficient resources to minimize the occurrence of bottlenecks.
A)True
B)False
Page 13
Q5) helps provide a balance between performance and fault tolerance.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: Distributed Database Management Systems
Available Study Resources on Quizplus for this Chatper
83 Verified Questions
83 Flashcards
Source URL: https://quizplus.com/quiz/29012
Sample Questions
Q1) transparency allows the integration of several different local database management systems (DBMS) under a common, or global, schema.
A) Transaction
B) Performance
C) Distribution
D) Heterogeneity
Q2) A distributed can reference several different local or remote data processing sites.
A) request
B) site
C) data location
D) transaction
Q3) A DDBMS is subject to which of the following restrictions?
A) Multiple instances of the same database should be integrated over a network.
B) All database processing must be done at a single site.
C) Rapid ad hoc data access is not possible.
D) Remote data access is provided on a read-only basis.
Q4) One of the advantages of a distributed database management system (DDBMS) is operating cost.
Q5) Explain the three types of operations defined by the DO-UNDO-REDO protocol.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Business Intelligence and Data Warehouses
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29013
Sample Questions
Q1) What is the difference between decision support data and operational data from the point of view of data analyst?
Q2) Explanatory analytics employs mathematical and statistical algorithms, neural networks, artificial intelligence, and other advanced modeling tools to create actionable predictive models based on available data.
A)True
B)False
Q3) To deliver efficient decision support, OLAP tools must have advanced data features.
Q4) Fact and dimension tables are related by keys.
A) shared
B) primary
C) foreign
D) linked
Q5) Decision support data tend to be non-normalized, , and pre-aggregated.
A) unique
B) duplicated
C) optimized
D) sorted
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Database Connectivity and Web Technologies
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29014
Sample Questions
Q1) Which of the following is a client-side extension?
A) ActiveX
B) ODBC
C) SQL*Net
D) TCP/IP
Q2) What is JavaScript? How does it work?
Q3) cloud is a type of cloud infrastructure that is built by a third-party organization to sell cloud services to the general public.
A) Community
B) Public
C) Exclusive
D) Private
Q4) A(n) can use a shared connection to the database instead of creating a new one every time.
A) DLL
B) API
C) web browser
D) HTTP GET request
Q5) ODBC, OLE-DB, and ADO.NET form the backbone of the architecture.
Q6) webpages are at the heart of current generation websites.
Page 16
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
86 Verified Questions
86 Flashcards
Source URL: https://quizplus.com/quiz/29015
Sample Questions
Q1) The requirement that a password must have a maximum of 12 characters is an example of a(n) .
Q2) Within the data security framework, is concerned with keeping data consistent and free of errors or anomalies.
Q3) are more detailed and specific than policies and describe the minimum requirements of a given DBA activity.
A) Guidelines
B) Standards
C) Procedures
D) Documentations
Q4) An enterprise database can be defined as the company's data representation that provides support for all present and expected future operations.
A)True
B)False
Q5) Training people to use the DBMS and its tools is not included in the responsibilities of a DBA.
A)True
B)False
Q6) A(n) _____ physically stores the database's data.
Page 17
To view all questions and flashcards with answers, click on the resource link above.