Introduction to Databases
Exam Answer Key
Course Introduction
Introduction to Databases offers students a comprehensive overview of the fundamental concepts and principles underlying database systems. The course covers data models, relational algebra, and database design, with an emphasis on the relational model. Students will explore methods for structuring, organizing, and retrieving data efficiently, as well as learn about Structured Query Language (SQL) for data manipulation and querying. The curriculum also examines issues of data integrity, normalization, transaction management, and database security. By the end of the course, students will have practical experience in designing, implementing, and querying relational databases, preparing them for more advanced topics in data management and applications.
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) The author number appears in the AUTHOR table and the ____________________ table in the Henry Books database.
Answer: WROTE
Q2) Why would you not combine the two tables ORDERS and ORDER_LINE at Premiere Products?
Answer: If the two tables were combined, the new table would be more complicated. Some of the individual positions within this table will contain multiple entries, making it difficult to track the information between columns. In general, the simpler structure is preferable, and that is why order lines appear in a separate table.
Q3) In some database systems, the word "order" has a special purpose. A)True
B)False
Answer: True
Q4) At Alexamara Marina Group, marina slips are numbered within each section. A)True
B)False
Answer: True
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) A matrix is the association between entities.
A)True
B)False
Answer: False
Q2) A programmer interviews users, examines existing and proposed documents, and examines organizational policies to determine exactly the type of data needs the database must support.
A)True
B)False
Answer: False
Q3) A determinant is any column (or collection of columns) that determines another table.
A)True
B)False
Answer: False
Q4) When you combine a column name with a table name, you are said to ____________________ the column name.
Answer: qualify
Q5) A(n) ____________________ is another name for a record or a row.
Answer: tuple
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) Access does not support the ____ data type.
A) DECIMAL
B) CURRENCY
C) INT
D) NUMBER
Answer: A
Q2) The ____________________ data type stores integers but uses less space than the INT data type.
Answer: SMALLINT
Q3) When a script file contains more than one command, each command must end with a(n) ____.
A) apostrophe
B) semicolon
C) period
D) colon
Answer: B
Q4) In Access, it is common to create a table using SQL.
A)True
B)False
Answer: False
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) An arithmetic column is a column that does not exist in the database but can be computed using data in existing columns.
A)True
B)False
Q2) 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
Q3) The ____________________ operator eliminates duplicate values in the query results.
Q4) It is possible to place one query inside another.
A)True
B)False
Q5) The DISTINCT operator is useful when used in conjunction with the COUNT function. A)True B)False
Q6) To sort records in descending order, follow the name of the sort key with the ____________________ operator.
To view all questions and flashcards with answers, click on the resource link above. Page 6
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) One reason for using an alias is simplicity.
A)True
B)False
Q2) You can join three tables together but not four tables.
A)True
B)False
Q3) There is only one approach to joining tables.
A)True
B)False
Q4) To produce the same results as the MINUS operator, use NOT, the IN operator and a subquery.
A)True
B)False
Q5) Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause?
A) inner
B) outer
C) nested
D) product
Q6) Joining a table to itself is called a(n) ____________________.
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) Which of the following commands executes a rollback?
A) ROLLBACK TABLE;
B) ROLLBACK;
C) ROLLBACK ALL;
D) ROLLBACK DB;
Q2) If you change the value of a column to NULL, you must enclose the NULL value in single quotation marks.
A)True
B)False
Q3) Access does not support the ____ data type.
A) DECIMAL
B) CURRENCY
C) CHAR
D) INT
Q4) In Access, use the Documenter tool to show the layout of a table.
A)True
B)False
Q5) In a transaction, if you can complete all updates successfully, execute the ____________________ command after completing the final update.
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) A view is a derived table.
A)True
B)False
Q2) You can create and maintain an index for any row in any table.
A)True
B)False
Q3) When you specify a foreign key, the table containing the foreign key is the parent.
A)True
B)False
Q4) To create a view definition, use the DEFINE VIEW command.
A)True
B)False
Q5) The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query.
A) AC
B) SA
C) AS D) IN
Q6) What are the benefits of using views?
To view all questions and flashcards with answers, click on the resource link above. Page 9
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 Microsoft Access, the ____ function displays a value in uppercase letters.
A) CAPITAL
B) UPPER
C) LARGE
D) UCASE
Q2) To create a stored procedure in Oracle, use the ____ command.
A) CREATE ROUTINE
B) CREATE SCRIPT
C) CREATE PROCEDURE
D) CREATE EXECUTABLE
Q3) A function can have more than one argument.
A)True
B)False
Q4) The UPPER function allows you to manipulate numeric data.
A)True
B)False
Q5) To handle processing of errors, include an ABORT clause in a stored procedure.
A)True
B)False
Q6) To close a cursor and deactivate it, use the ____________________ command.
Page 10
To view all questions and flashcards with answers, click on the resource link above.