Relational Database Systems Test Bank
Course Introduction
Relational Database Systems introduces the fundamental concepts and principles of relational databases, focusing on data modeling, database design, and Structured Query Language (SQL). The course covers topics such as the relational data model, normalization, entity-relationship diagrams, and the implementation of databases using modern relational database management systems. Students gain hands-on experience with data definition, manipulation, and retrieval operations, as well as best practices for ensuring data integrity, security, and efficient performance in multi-user environments. The course also explores emerging trends in database technology and applications in real-world information systems.
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 field in the logical design of a database corresponds to a row in the physical table of a relational database.
A)True
B)False
Answer: False
Q2) A character is a basic unit of data and can consist of a number, letter, or special symbol.
A)True
B)False
Answer: True
Q3) Two tables can be linked or joined together through a common field.
A)True
B)False
Answer: True
Q4) Data is in third normal form if it is in second normal form and has no
Answer: Transitive dependencies
Q5) A(n) ____________________ is referred to as a row in the physical database. Answer: record
To view all questions and flashcards with answers, click on the resource link above. Page 3
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) A(n) ____ has a predefined meaning in Oracle11g.
A) keyword
B) statement
C) syntax
D) clause
Answer: A
Q2) SQL*Plus can only be accessed via an internet interface.
A)True
B)False
Answer: False
Q3) By default, data within a numeric column is \(\underline {\text { right } }\)-aligned when it is displayed. _________________________
A)True
B)False
Answer: True
Q4) A(n) ____________________ can consist of numbers, characters, or special symbols that should be included in the output exactly as entered by the user.
Answer: string literal
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) When modifying data in existing columns, which of the following is correct?
A) A column must be as wide as the data it already contains.
B) If a NUMBER column already contains data, its precision and scale can be decreased.
C) Changing the default value of a column will change the values of data already in a table.
D) If a NUMBER column is empty, its precision and scale cannot be changed.
Answer: A
Q2) A datatype identifies the type of data to be stored in a column.
A)True
B)False
Answer: True
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
Q4) The ____________________ command can be used to modify the structure of a table.
Answer: ALTER TABLE
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) Based on the structure of the ORDERITEMS table, which of the following commands will add a NOT NULL constraint to the ISBN column?
A) ALTER TABLE orderitems ADD (isbn NOT NULL);
B) ALTER TABLE orderitems ADD NOT NULL (isbn);
C) ALTER TABLE orderitems ADD isbn NOT NULL; D) none of the above
Q2) If a(n) \(\underline {\text { FOREIGN KEY } }\) constraint has been created for a table, it means the data values in that column must be unique and cannot contain NULL values. _________________________
A)True B)False
Q3) A referential integrity constraint is usually placed on the ____________________ side of a one-to-many relationship.
Q4) A constraint for a composite primary key must be created at the table level.
A)True B)False
Q5) A(n) ____________________ constraint requires that, if an entry is made into the column, the data value must be unique.
To view all questions and flashcards with answers, click on the resource link above. Page 6
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) A subquery can be used with the INSERT command to enter data from an existing table into the destination table.
A)True
B)False
Q2) A(n) ____________________ lock will allow other users to view the data stored in the table, but it prevents anyone from altering the structure of the table.
Q3) The BLOCK ACCESS command can be used to prevent other users from updating a specific table.
A)True
B)False
Q4) If the WHERE clause of the DELETE command is omitted, then all rows in the referenced table will be removed.
A)True
B)False
Q5) Commands used to modify data are known as DML commands.
A)True
B)False
Q6) The ____________________ command is used to remove rows from a table.
Q7) Rows can be deleted from a table using the ____________________ command.
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) The USER_INDEXES data dictionary view can be used to verify existing indexes.
A)True
B)False
Q2) A Bitmap index is useful for improving queries on columns that have low cardinality.
A)True
B)False
Q3) A sequence serves as a nickname for a database object.
A)True
B)False
Q4) The ____________________ option is used to indicate that the values assigned by a sequence can be used after the maximum value is reached.
Q5) A(n) ____________________ can be used for internal control purposes by generating a series of numbers.
Q6) An index can be created ____.
A) implicitly
B) explicitly
C) only at instance startup
D) both a and b
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 commands will change a user's password?
A) ALTER USERNAME username IDENTIFIED BY newpassword;
B) ALTER USER username IDENTITY newpassword;
C) ALTER USER username IDENTIFIED BY newpassword;
D) ALTER USERNAME username PASSWORD newpassword;
Q2) All the Oracle11g system privileges can be viewed through the data dictionary view
A) USER_SYSTEM_PRIVILEGES
B) DISPLAY_SYSTEM_PRIVILEGES
C) SYSTEM_PRIVILEGE_MAP
D) none of the above
Q3) The \(\underline {\text { DEFAULT ROLE }}\) option of the ALTER USER command can be used to assign a default role to an existing user. _________________________ A)True
B)False
Q4) What are the differences between object and system privileges?
Q5) Permissions allow users to execute certain SQL statements in Oracle11g. A)True
B)False
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) Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will retrieve all book titles that are in the Business or Computer category and have a retail price of more than $35.00?
A) SELECT title FROM books
WHERE category = 'BUSINESS' OR 'COMPUTER' AND retail >35;
B) SELECT title FROM books
WHERE category = 'BUSINESS' OR category ='COMPUTER' AND retail >35;
C) SELECT title FROM books
WHERE (category = 'BUSINESS' OR category ='COMPUTER' ) AND retail >35;
D) SELECT title FROM books WHERE category = 'BUSINESS' OR category ='COMPUTER' AND (retail >35);
Q2) The percent sign (%) and asterisk (*) symbols can be used with the LIKE comparison operator to create a search pattern.
A)True B)False
Q3) The IN comparison operator is used when searching for a pattern of characters. A)True B)False
Q4) What is the purpose of the ORDER BY clause?
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) The MINUS set operator is used to display rows that were uniquely returned by the first query in the set.
A)True
B)False
Q2) A Cartesian join usually results from the user omitting the joining condition that links two or more tables together.
A)True
B)False
Q3) Set operators are used to combine the results of multiple queries.
A)True
B)False
Q4) If you are attempting to join two tables that have multiple common columns, which of the following JOIN keywords should be used to specify how the tables should be linked?
A) OUTER JOIN
B) CROSS JOIN
C) JOIN...USING
D) none of the above
Q5) The ____________________ JOIN keyword can be used to create a Cartesian join.
11
Q6) A(n) ____________________ is an alternate name temporarily assigned to a table.
To view all questions and flashcards with answers, click on the resource link above. Page 12
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 is used to return a portion of a character string?
A) SUBSTR
B) SUBSTRING
C) PARTSTR
D) PORTION
Q2) Which of the following functions can be used to substitute another value for a NULL value during calculations?
A) NVL
B) NULLVAL
C) NULVAL
D) NLV
Q3) The ____________________ function is used to combine two sets of character strings into one set.
Q4) The ____________________ function converts character strings to mixed-case, with each word beginning with a capital letter.
Q5) The \(\underline { \text { CONCAT } }\) function can be used to concatenate the data contained in two columns. _________________________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13
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 on the contents of the BOOKS table, which of the following SQL statements will return the total profit generated by books provided by publisher 4?
A) SELECT TOTAL(retail-cost) FROM books WHERE pubid = 4;
B) SELECT TOTAL(retail-cost) FROM books
GROUP BY pubid;
C) SELECT SUM(retail-cost) FROM books WHERE pubid = 4;
D) SELECT SUM(retail-cost) FROM books
GROUP BY pubid = 4;
Q2) If the DISTINCT keyword is not included in the STDDEV function, the ____ keyword will be assumed.
A) UNIQUE
B) ALL
C) NONULLS
D) none of the above
Q3) The MAX function can be used with the ____________________ keyword to ignore duplicate values.
Q4) The ____________________ clause can be used to restrict rows, but not groups.
14
To view all questions and flashcards with answers, click on the resource link above.
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) A single-row subquery can return several columns, but only one row, of results to the outer query.
A)True
B)False
Q2) 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
Q3) A multiple-column subquery nested in the \(\underline {\text { SELECT } }\) clause of the outer query is known as an inline view. _________________________
A)True
B)False
Q4) When a multiple-column subquery is used in the WHERE clause of the outer query, the column names listed on the left side of the comparison operator must be enclosed in \(\underline {\text { single-quotation marks }}\).
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 15
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) A(n) ____ table is a table that does not contain the primary key that a view uses to uniquely identify each record being displayed by the view.
A) non key-preserved
B) key-preserved
C) primary
D) non primary-keyed
Q2) The ____________________ keywords can be used to ensure data cannot be changed through the view.
Q3) Which of the following statements is incorrect?
A) A view can be created with the CREATE VIEW command.
B) Views can be modified by using the ALTER VIEW...MODIFY command.
C) A view cannot be modified; if you need to change it, you must use the CREATE OR REPLACE VIEW keywords.
D) A view cannot be given the same name as another database object in the same schema.
Q4) Rows can be added through a complex view that is based upon grouped data.
A)True
B)False
Q5) A(n) ____________________ view can contain group functions.
To view all questions and flashcards with answers, click on the resource link above. Page 16