Introduction to Databases Pre-Test
Questions
Course Introduction
Introduction to Databases provides a foundational understanding of database systems, exploring their role in storing, organizing, and retrieving data efficiently. Students will learn key concepts such as data models, relational databases, SQL querying, normalization, and database design. The course also covers fundamental principles of data management, including data integrity, security, and transaction processing, while offering hands-on experience in creating and manipulating databases using modern database management systems. This course equips students with the essential skills needed to design, implement, and maintain robust databases for a wide range of applications.
Recommended Textbook
Oracle 11G SQL 2nd Edition by Joan Casteel
Available Study Resources on Quizplus
13 Chapters
1685 Verified Questions
1685 Flashcards
Source URL: https://quizplus.com/study-set/1085 Page 2
Chapter 1: Overview of Database Concepts
Available Study Resources on Quizplus for this Chatper
108 Verified Questions
108 Flashcards
Source URL: https://quizplus.com/quiz/21418
Sample Questions
Q1) A solid straight line in an E-R Model depicts a(n) ____________________ relationship.
Answer: one-to-one one to one
Q2) A straight line with a crow's foot at one end depicts a(n) ____________________ relationship in an E-R Model.
Answer: one-to-many one to many
Q3) A foreign key is usually found on which side of a relationship?
A) one B) many C) unnormalized D) primary entity
Answer: B
Q4) Data redundancy is created through a process known as normalization. A)True B)False
Answer: False
Q5) A(n) ____________________ is a storage structure that contains data.
Answer: database
3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Basic Sql Select Statements
Available Study Resources on Quizplus for this Chatper
122 Verified Questions
122 Flashcards
Source URL: https://quizplus.com/quiz/21419
Sample Questions
Q1) The name of the table containing the data to be retrieved is specified in the ____________________ clause.
Answer: FROM
Q2) When should double-quotation marks (" ") be used in a SELECT statement?
Answer: Double-quotation marks are used when a column alias included in the SELECT statement contains blank spaces, special symbols, or to indicate that the column alias should be displayed in lower or mixed case.
Q3) If a column heading is longer than the assigned width of a(n) ____________________ field, the column heading will be truncated.
Answer: character
Q4) If multiple column names are listed in the SELECT clause of a SELECT statement, the columns must be separated by a comma (,).
A)True B)False
Answer: True
Q5) Combining the contents of two or more columns is known as ____________________.
Answer: concatenation
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Table Creation and Management
Available Study Resources on Quizplus for this Chatper
132 Verified Questions
132 Flashcards
Source URL: https://quizplus.com/quiz/21420
Sample Questions
Q1) Which of the following terms refers to commands that are used to create or modify database tables?
A) data manipulation language (DML)
B) data control language (DCL)
C) data definition language (DDL)
D) data formatting language (DFL)
Answer: C
Q2) If the MAXRETAIL column of the PROMOTION table has been set as unused, which of the following commands is valid?
A) ALTER TABLE promotion RESET maxretail USED;
B) ALTER TABLE promotion DROP COLUMN maxretail;
C) ALTER TABLE promotion DROP UNUSED COLUMNS;
D) both b and c
Answer: C
Q3) The DROP COLUMN clause of the ALTER TABLE command can only be used to \(\underline { \text { delete } }\)one column at a time.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Constraints
Available Study Resources on Quizplus for this Chatper
132 Verified Questions
132 Flashcards
Source URL: https://quizplus.com/quiz/21421
Sample Questions
Q1) A FOREIGN KEY constraint can be added to the column of a table to ensure that the referenced data value actually exists in the other table.
A)True B)False
Q2) A(n) \(\underline { \text { FOREIGN KEY } }\) constraint is used to ensure that referential integrity exists between tables. _________________________
A)True B)False
Q3) The ALTER TABLE command can be used to \(\underline { \text { delete } }\) an existing constraint. _________________________ A)True B)False
Q4) If the ON DELETE CASCADE keywords are included when a(n) \(\underline { \text { PRIMARY KEY } }\) constraint is created, then if a row is deleted from the parent table, any corresponding records in the child table are also deleted.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Data Manipulation and Transaction Control
Available Study Resources on Quizplus for this Chatper
132 Verified Questions
132 Flashcards
Source URL: https://quizplus.com/quiz/21422
Sample Questions
Q1) Commands used to modify data are called ____ commands.
A) data control language (DCL)
B) data manipulation language (DML)
C) data modification language (DML)
D) data definition language (DDL)
Q2) A(n) \(\underline { \text { exclusive } }\) lock is automatically obtained when the user executes the SELECT...FOR UPDATE command. _________________________
A)True
B)False
Q3) If a new row is added to the PROMOTION table, which of the following will make the change permanent?
A) COMMIT;
B) UPDATE; C) ROLLBACK;
D) The change is permanent when the command is executed.
Q4) A COMMIT is \(\underline { \text { explicitly } }\) issued when the user exits SQL*Plus. _________________________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Additional Database Objects
Available Study Resources on Quizplus for this Chatper
132 Verified Questions
132 Flashcards
Source URL: https://quizplus.com/quiz/21423
Sample Questions
Q1) Which of the following is a pseudocolumn?
A) CURRENTVAL
B) DUAL
C) NEXTVAL
D) both a and c
Q2) A column has low cardinality if it contains many distinct values.
A)True B)False
Q3) Which of the following statements about sequences is incorrect?
A) A sequence can be used to generate unique names for database objects.
B) A sequence can be used to generate unique values to serve as a primary key.
C) A sequence can be used to generate sequential values for internal control purposes.
D) A sequence can be used to generate sequential numbers to track records like checks, invoices, and purchase orders.
Q4) The \(\underline { \text { GENERATE } }\) option can be used to have a sequence pre-generate a set of numbers before they are requested by a user.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: User Creation and Management
Available Study Resources on Quizplus for this Chatper
132 Verified Questions
132 Flashcards
Source URL: https://quizplus.com/quiz/21424
Sample Questions
Q1) Which of the following SQL statements will remove user RTHOMAS from the database?
A) DELETE rthomas;
B) DELETE USER rthomas;
C) DROP USER rthomas;
D) DROP rthomas;
Q2) Even if a set of privileges have been assigned to a role, it does not make it any easier for the DBA since the privileges will still need to be granted individually to the users.
A)True
B)False
Q3) Which of the following statements about granting object privileges is incorrect?
A) The grantor has a choice to either grant individual privileges, or to use the ALL keyword in the GRANT clause.
B) The FROM clause is used to identify the password of the user to which the privilege(s) applies.
C) The TO clause identifies the user or role receiving the privilege.
D) The WITH GRANT OPTION gives the user the ability to grant the same object privileges to other users.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Restricting Rows and Sorting Data
Available Study Resources on Quizplus for this Chatper
132 Verified Questions
132 Flashcards
Source URL: https://quizplus.com/quiz/21425
Sample Questions
Q1) If a user performs a query that restricts the rows returned based upon a specified date, the date must be enclosed in ____.
A) double quotation marks (" ")
B) single quotation marks (' ')
C) parentheses ( )
D) none of the above
Q2) The IN logical operator is similar to using \(\underline{OR}\).
A)True
B)False
Q3) The ____________________ logical operator is used to combine search conditions when only one of the conditions must be True to be included in the results.
Q4) Oracle11g \(\underline {\text { is case sensitive } }\) when comparing data to a search condition. _________________________
A)True B)False
Q5) The ____________________ logical operator is used to combine search conditions that must both be True to include a row in the results of a query.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Joining Data From Multiple Tables
Available Study Resources on Quizplus for this Chatper
131 Verified Questions
131 Flashcards
Source URL: https://quizplus.com/quiz/21426
Sample Questions
Q1) A full outer join cannot be created in the ____________________ clause.
Q2) A column qualifier is used to indicate the table containing the column being referenced.
A)True
B)False
Q3) Which of the following keywords is used to create a Cartesian join?
A) OUTER JOIN
B) CROSS JOIN
C) NATURAL JOIN
D) JOIN...USING
Q4) Column qualifiers must be included in the WHERE clause if the columns used to join the tables have the same column names.
A)True
B)False
Q5) The ____________________ set operator is used to display the results that were returned by the first query that were not also returned by the second query.
Q6) A column qualifier is separated from the column name with a colon.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Selected Single Row Functions
Available Study Resources on Quizplus for this Chatper
133 Verified Questions
133 Flashcards
Source URL: https://quizplus.com/quiz/21427
Sample Questions
Q1) Which of the following will display the name of each customer in lower-case characters based upon the contents of the CUSTOMERS table?
A) SELECT LOWER(name) FROM customers;
B) SELECT LOWER(firstname) || ' ' || LOWER(lastname) FROM customers;
C) SELECT CONCAT(LOWER(firstname), ' ', LOWER(lastname)) FROM customers;
D) none of the above
Q2) The TRUNC function can be used to add insignificant zeros to the right of a decimal point for numeric data.
A)True
B)False
Q3) The \(\underline { \text { SUBSTR } }\) function is used to return a portion of a character string. _________________________
A)True
B)False
Q4) Character functions can be used to change the case of characters or to manipulate characters.
A)True
B)False
Q5) The ____________________ function is used to return a portion of a string.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Group Functions
Available Study Resources on Quizplus for this Chatper
134 Verified Questions
134 Flashcards
Source URL: https://quizplus.com/quiz/21428
Sample Questions
Q1) Based upon the contents of the BOOKS table, which of the following will determine the number of books provided by publisher 3?
A) SELECT SUM(isbn) FROM books
WHERE pubid = 3;
B) SELECT TOTAL(*) FROM books
WHERE pubid = 3;
C) SELECT COUNT(pubid) FROM books
WHERE pubid = 3; D) none of the above
Q2) A group function can be nested inside a(n)____.
A) group function
B) single-row function
C) order function
D) both a and b
Q3) The ____________________ clause is used to restrict the groups returned by a query.
Q4) The ____________________ clause can be used to restrict rows, but not groups.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Subqueries and Merge Statements
Available Study Resources on Quizplus for this Chatper
132 Verified Questions
132 Flashcards
Source URL: https://quizplus.com/quiz/21429
Sample Questions
Q1) Which comparison operator allows you to search for NULL values in a subquery?
A) IS NULL
B) NVL
C) =NULL
D) NVLS
Q2) Which of the following operators is the equivalent of the IN comparison operator?
A) <ANY
B) >ANY
C) =ANY
D) =ALL
Q3) A group function can be used in a(n) \(\underline {\text { inline view }}\).
A)True
B)False
Q4) If a subquery is nested in a HAVING clause, the subquery must be on the right side of the comparison operator.
A)True
B)False
Q5) Valid multiple-row operators include ANY, ALL, and ____________________.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Views
Available Study Resources on Quizplus for this Chatper
133 Verified Questions
133 Flashcards
Source URL: https://quizplus.com/quiz/21430
Sample Questions
Q1) DML operations are not allowed on views that include the pseudo column
Q2) A(n) \(\underline { \text { existing } }\) view cannot be modified.
A)True
B)False
Q3) The \(\underline { \text { NOFORCE } }\) keyword can be used to create a view based upon a table that has not yet been created. _________________________
A)True
B)False
Q4) A view can be created to simplify issuing complex SQL queries.
A)True
B)False
Q5) A(n) ____________________ table is a table that does not contain the primary key being used by a complex view to uniquely identify each row displayed by the view.
Q6) A view cannot be given the same name as another database object.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15