Database Management Systems
Review Questions
Course Introduction
This course provides a comprehensive introduction to Database Management Systems (DBMS), exploring the fundamental concepts, architecture, and design principles underlying modern databases. Topics include relational data models, entity-relationship modeling, SQL query language, normalization, concurrency control, transaction management, and database security. Emphasis is placed on both theoretical understanding and practical skills, enabling students to design, implement, and manage database systems efficiently. Through hands-on labs and projects, students gain experience with popular DBMS software and learn best practices for managing large-scale data in various application domains.
Recommended Textbook
A Guide to SQL 9th Edition by Philip J. Pratt
Available Study Resources on Quizplus
8 Chapters
600 Verified Questions
600 Flashcards
Source URL: https://quizplus.com/study-set/813 Page 2
Chapter 1: Introduction to TAL Distributors, Colonial
Adventure Tours, and Solmaris Condominium Group
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/16101
Sample Questions
Q1) The TRIP_GUIDES table in the Colonial Adventure Tours database has three columns.
A)True
B)False
Answer: False
Q2) The REP table consists of the sales representatives' number,last name,first name,address,total commission,and ____.
A)total sales
B)commission rate
C)customers
D)order number
Answer: B
Q3) When designing tables a ____ structure is preferred.
A)complex
B)simple
C)detailed
D)complete
Answer: B
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/16102
Sample Questions
Q1) Each column in a table of a relational database should have a distinct name.
A)True
B)False
Answer: True
Q2) ____ can occur when there is a column in a table that is dependent on only a portion of the primary key.
A)Qualification
B)Update anomalies
C)Function splitting
D)Determination
Answer: B
Q3) A relation is in ____ if it does not contain any repeating groups.
A)first normal form
B)second normal form
C)third normal form
D)Boyce-Codd normal form
Answer: A
Q4) When you combine a column name with a table name,you are said to ____________________ the column name.
Answer: qualify
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/16103
Sample Questions
Q1) You use the ____________________ command to describe the layout of a table.
Answer: CREATE TABLE
Q2) Oracle stores script files is a special location called Saved Commands.
A)True
B)False
Answer: False
Q3) Unlike Oracle,Access does not support the DECIMAL data type.
A)True
B)False
Answer: True
Q4) When adding rows to character columns,make sure you enclose the values in single quotation marks.
A)True
B)False
Answer: True
Q5) Should a user be allowed to enter null values for the primary key?
Answer: No,The primary key should uniquely identify a given row.This would be impossible if nulls were allowed.
Q6) You can delete the entire table using the ____________________ TABLE command.
Answer: DROP Page 5
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 4: Single-Table Queries
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/16104
Sample Questions
Q1) The column on which data is to be sorted is called a sort
Q2) When you need to sort data on two columns,the less important column is called the ____ sort key.
A)double
B)primary
C)minor
D)foreign
Q3) Compare the WHERE and HAVING clauses.
Q4) A(n)____________________ clause provides a concise way of phrasing certain conditions.
Q5) The UNIQUE operator eliminates duplicate values in a query. A)True
B)False
Q6) You use the ____________________ clause to retrieve rows that satisfy some condition.
Q7) In SQL,you specify the order of data in query results by using the ____________________ clause.
B)False Page 7
Q8) Aggregate functions apply to groups of rows. A)True
To view all questions and flashcards with answers, click on the resource link above.
Page 8
Chapter 5: Multiple-Table Queries
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/16105
Sample Questions
Q1) SQL Server does not support the MINUS operator.
A)True
B)False
Q2) Two tables are ____________________ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths.
Q3) Why do you use the ANY and ALL operators? What is the difference between the two operators?
Q4) If you precede the subquery by the ____ operator,the condition is true only if it satisfies any value (one or more)produced by the subquery.
A)IS SOME
B)IS ANY
C)SOME
D)ANY
Q5) SQL performs many built-in ____________________ that analyze queries to determine the best way to satisfy them.
Q6) Joining a table to itself is called a(n)____________________.
Q7) The ____________________ of two tables is a table containing every row that is in either the first table,the second table,or both tables.
Page 9
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/16106
Sample Questions
Q1) Describe the format for the UPDATE command.
Q2) ____ is the default transaction mode in Oracle and commits each action query as soon as the user executes the query.
A)Execute
B)Run
C)Autocommit
D)Enabled
Q3) You cannot use a compound condition with an UPDATE command.
A)True
B)False
Q4) In some cases,you might need to change a table's structure in ways that are beyond the capabilities of your DBMS.When that happens,use the RESTRUCTURE command to redesign the table.
A)True
B)False
Q5) You use the APPEND command to add additional rows to tables.
A)True
B)False
Q6) The ROLLBACK command reverses changes made to the ____________________ only.
Q7) A(n)____________________ is a logical unit of work.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 7: Database Administration
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/16107
Sample Questions
Q1) You can add rows to a view that includes calculations.
A)True
B)False
Q2) You can create and use a(n)____________________ to speed up the searching process significantly.
Q3) To create a view definition,use the DEFINE VIEW command.
A)True
B)False
Q4) An auxiliary key is a column in one table whose values match the primary key in another table.
A)True
B)False
Q5) The privilege ____ can be granted to change the table structure.
A)WRITE
B)UPDATE
C)ALTER
D)MODIFY
Q6) The existing,permanent tables in a relational database are called stable tables. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
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/16108
Sample Questions
Q1) 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
Q2) In T-SQL,arguments should have the same data type and length as the particular column in a table that they represent.
A)True
B)False
Q3) In Oracle,to add a specific number of months to a date,use the ____ function.
A)MONTHS
B)ADD_DATE
C)ADD_MONTHS
D)CALC_MONTHS
Q4) In Microsoft Access,you must store an SQL command in a string variable.
A)True
B)False
Q5) A function can have more than one argument.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12