Database Management Systems
Mock Exam
Course Introduction
Database Management Systems (DBMS) introduces students to the fundamental concepts, architectures, and applications of modern databases. The course covers data models, relational algebra, database design using Entity-Relationship (ER) modeling, and normalization techniques to ensure data integrity and efficiency. Students learn Structured Query Language (SQL) for data definition and manipulation, understand transaction management, concurrency control, and recovery techniques to maintain database reliability. Additionally, the course explores indexing, query optimization, and an overview of emerging trends such as NoSQL databases and distributed databases, equipping students with essential skills for designing, implementing, and managing robust database systems in real-world scenarios.
Recommended Textbook
A Guide to SQL 8th Edition by Philip J. Pratt
Available Study Resources on Quizplus
8 Chapters
600 Verified Questions
600 Flashcards
Source URL: https://quizplus.com/study-set/1123
Page 2
Chapter 1: Introduction to Premiere Products, Henry Books, and Alexamara Marina Group
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22071
Sample Questions
Q1) At Premiere Products, the three sections of an order are the heading, body, and footing.
A)True
B)False
Answer: True
Q2) Information about the services requested by Alexamara owners is stored in the ____ table.
A) MARINA
B) MARINA_SLIP
C) SERVICE_REQUEST
D) OWNER
Answer: C
Q3) A marina ____________________ uniquely identifies each marina in the MARINA table for Alexamara.
Answer: number
Q4) Each row in the ORDER_LINE table has an order number, part number, number ordered, quoted price, and total amount.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Database Design Fundamentals
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22072
Sample Questions
Q1) In an entity-relationship (E-R) diagram, ____ are used to represent an entity.
A) rectangles
B) ovals
C) circles
D) diamonds
Answer: A
Q2) A record is another term for a(n) ____.
A) row
B) field
C) attribute
D) property
Answer: A
Q3) Each column in a table of a relational database should have a distinct name.
A)True
B)False
Answer: True
Q4) In a relational database, column B is ____________________ on another column A, if at any point in time a value for A determines a single value for B.
Answer: functionally dependent
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Creating Tables
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22073
Sample Questions
Q1) The ____ command defines a table's structure by listing its columns, data types, and column lengths.
A) NEW TABLE
B) DEFINE TABLE
C) CREATE TABLE
D) ADD TABLE
Answer: C
Q2) In SQL, there are special rules that specify that a particular word must begin in a particular position on the line.
A)True
B)False
Answer: False
Q3) For any column whose data type is CHAR, values must be enclosed in ____.
A) double quotation marks
B) parentheses
C) single quotation marks
D) square brackets
Answer: C
Q4) In Oracle 10G Express, you enter commands on the SQL ____________________ page.
Answer: Commands
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Single-Table Queries
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22074
Sample Questions
Q1) The COUNT function only applies to columns with numeric values. A)True
B)False
Q2) When you use the MAX function, SQL ignores any ____________________ value(s) in the column and eliminates them from the computations.
Q3) ____________________ conditions are formed by connecting two or more simple conditions.
Q4) After the word FROM in a SELECT statement, you list any conditions (restrictions) that apply to the data you want to retrieve.
A)True
B)False
Q5) When the ____________________ operator connects simple conditions, all the simple conditions must be true in order for the compound condition to be true.
Q6) The DISTINCT operator is useful when used in conjunction with the COUNT function. A)True B)False
Q7) The column on which data is to be sorted is called a sort
6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Multiple-Table Queries
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22075
Sample Questions
Q1) It is permissable to qualify all column names in a query.
A)True
B)False
Q2) You can join three tables together but not four tables.
A)True
B)False
Q3) Sometimes you need to list all the rows from one of the tables in a join, regardless of whether they match any rows in the other table. This type of join is called a(n) ____________________ join.
Q4) You can use the EXISTS operator to retrieve data from more than one table.
A)True
B)False
Q5) In a full outer join, all rows from both tables will be included regardless of whether they match rows from the other table.
A)True
B)False
Q6) The ____________________ of two tables is the set of all rows that are in the first table but that are not in the second table.
Q7) What steps should you take to construct the SQL command to join (relate) tables?
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Updating Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22076
Sample Questions
Q1) If the Autocommit mode is turned off, you can cancel updates at any time during your current work session.
A)True
B)False
Q2) One of the nicest features of a relational DBMS, such as Oracle, is the ease with which you can change table structures.
A)True
B)False
Q3) You can use the ____ command to create a new table using data in an existing table.
A) CREATE TABLE
B) NEW TABLE
C) UPDATE
D) ALTER TABLE
Q4) To add a new column, use the ____________________ clause of the ALTER TABLE command.
Q5) Describe the format for the UPDATE command.
Q6) How can you use the COMMIT and ROLLBACK commands to support transactions?
Q7) In Oracle, use the ____________________ command to display the structure of a table.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Database Administration
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22077
Sample Questions
Q1) You cannot delete a row from a view.
A)True
B)False
Q2) To add a row to your view, simply add a row to each underlying derived table.
A)True
B)False
Q3) What are the benefits of using views?
Q4) With a view, the display of data can be customized to meet each user's needs.
A)True
B)False
Q5) Views provide data validation.
A)True
B)False
Q6) The process of managing a database is called database
Q7) The main mechanism for providing access to a database is the ____________________ command.
Q8) To ensure the uniqueness of values in a non-primary key column, you can create a unique index by using the ____________________ command.
Page 9
Q9) Information about tables in the database is kept in the system
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 8: SQL Functions and Procedures
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22078
Sample Questions
Q1) In Oracle, SQL Server, and Microsoft Access, use the ____ function to round a numeric value to a desired number of decimal places.
A) INT
B) INTEGER
C) ROUND
D) TRUNCATE
Q2) When you anticipate running a particular query often, you can improve overall performance by saving the query in a file called a routine.
A)True
B)False
Q3) PL/SQL commands have a certain format and cannot include any blank lines in the code.
A)True
B)False
Q4) In T-SQL, all arguments start with the ampersand (&) symbol.
A)True
B)False
Q5) In the function UPPER(LAST_NAME), the item in parentheses (LAST_NAME) is called the ____________________ for the function.
To view all questions and flashcards with answers, click on the resource link above. Page 11