Business Database Systems
Exam Practice Tests
Course Introduction
Business Database Systems explores the design, implementation, and management of database systems tailored to business environments. The course covers foundational concepts such as data modeling, relational databases, and SQL, while also addressing advanced topics like database normalization, transaction management, data security, and emerging database technologies. Students will gain hands-on experience developing and interacting with databases to solve real-world business problems, preparing them to support effective data-driven decision-making processes within organizations.
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) Analyzing historical data stored in a database is referred to as ____________________.
Answer: data mining
Q2) A record in the logical design of a database corresponds to a row in the physical table of a relational database.
A)True
B)False Answer: True
Q3) A file is composed of a group of related ____________________. Answer: records
Q4) Which of the following is not a step in the Systems Development Life Cycle (SDLC)?
A) systems analysis
B) systems investigation
C) systems design
D) all of the above are steps in the SDLC
Answer: D
Q5) Data is in third normal form if it is in second normal form and has no _________________________.
Answer: Transitive dependencies
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) Which of the following is a mandatory clause in a SELECT statement?
A) FROM
B) WHERE
C) HAVING
D) both a and b are mandatory
Answer: A
Q2) The ____ for a SQL statement gives the basic structure, or rules, required to execute the statement.
A) clauses
B) keywords
C) sequence
D) syntax
Answer: D
Q3) If you assign a column alias to a column, it must be enclosed in double quotation marks (" ").
A)True
B)False
Answer: False
Q4) Combining the contents of two or more columns is known as ____________________.
Answer: concatenation
Page 4
To view all questions and flashcards with answers, click on the resource link above.
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) Once a column has been set as UNUSED, which of the following is correct?
A) It is unavailable and will not be displayed in the table structure.
B) It will still appear in the results of subqueries until it is dropped.
C) It is unavailable, but will still be displayed in the table structure.
D) All DDL operations can be performed on it until it is actually dropped.
Answer: A
Q2) SELECT9 \(\underline { is }\) a valid table name.
A)True
B)False
Answer: True
Q3) The precision of a NUMBER does not include the decimal point itself in the total number of digits that can be stored in a column.
A)True
B)False
Answer: True
Q4) What is the difference between truncating a table and dropping a table?
Answer: When a table is truncated, the table structure remains, but the data stored in the table are removed. When a table is dropped, both the table structure and the data contained in the table are permanently deleted.
Page 5
To view all questions and flashcards with answers, click on the resource link above.
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) In the USER_CONSTRAINTS view, the value displayed in the CONSTRAINT_TYPE column will be a(n) ____ for a NOT NULL constraint.
A) C
B) K
C) N
D) R
Q2) The SYSDATE can be used as a condition in a CHECK constraint. A)True B)False
Q3) A NOT NULL constraint can only be created at the column level. A)True B)False
Q4) The default name for a constraint is \(\underline {\text { SYS Cn } }\) where n consists of a number that will make the name unique within the database. A)True B)False
Q5) If a(n) ____________________ constraint is being dropped, then only the type of constraint and the column name need to be included in the DROP clause of the ALTER TABLE command.
6
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) The data being inserted into a table are listed in the ADD clause of the INSERT command.
A)True
B)False
Q2) Single-row functions cannot be included in the UPDATE command.
A)True
B)False
Q3) The WHERE clause of the DELETE command is used to identify the rows to be deleted from the table.
A)True
B)False
Q4) Which of the following statements about the DELETE command is incorrect?
A) The DELETE command applies to an entire row and cannot be applied to specific columns within a row.
B) The proper command syntax for the DELETE command is DELETE FROM tablename;
C) If you omit the optional WHERE clause, then all the rows in the table will be deleted.
D) If you omit the mandatory WHERE clause, an error message will be issued.
Q5) ______________________________ commands are used to modify data.
Q6) The ____________________ command is used to change data stored in a table.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
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) A function-based index can be used for queries that include searches based upon arithmetic expressions or functions.
A)True
B)False
Q2) Which command will create a synonym for a table?
A) CREATE SYNONYM synonymname IN tablename;
B) CREATE SYNONYM synonymname ON tablename;
C) CREATE SYNONYM synonymname REFERENCE tablename;
D) CREATE SYNONYM synonymname FOR tablename;
Q3) A(n) ____ generates sequential integers that can be used by organizations to assist with internal controls or simply to serve as a primary key for a table.
A) view
B) index
C) synonym
D) sequence
Q4) The NEXTVALUE pseudocolumn is used to actually generate the next value in a sequence.
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 grant all object privileges for the ORDERS table to user RTHOMAS?
A) GRANT ALL ON orders TO rthomas;
B) GRANT * ON orders TO rthomas;
C) GRANT ALL OBJECTS ON orders TO rthomas;
D) GRANT ALL OPRIVS ON orders TO rthomas;
Q2) The ____ command will assign a default role to a user.
A) ALTER USER username MODIFY ROLE rolename;
B) ALTER DEFAULT ROLE rolename GRANT username;
C) ALTER ROLE rolename MODIFY USER username;
D) ALTER USER username DEFAULT ROLE rolename;
Q3) Permissions allow users to execute certain SQL statements in Oracle11g.
A)True B)False
Q4) Even if users are \(\underline { \text { authenticated } }\)by the operating system, the users are still required to have valid Oracle11g accounts to access the database.
A)True B)False
Q5) ____________________ privileges allow users to execute specific DDL commands.
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) The process of specifying that certain rows be displayed in the results of a query is known as \(\underline { \text { selection } }\). _________________________
A)True
B)False
Q2) What is the purpose of the ORDER BY clause?
Q3) Logical operators are evaluated in the order of NOT, AND, and OR.
A)True
B)False
Q4) Which of the following search patterns could be used to find the word HELLO in Oracle11g?
A) %H%
B) HEL*
C) _EL*
D) %HEL?O
Q5) The IN logical operator is similar to using \(\underline{OR}\).
A)True B)False
Q6) What is the purpose of the WHERE clause?
Page 10
To view all questions and flashcards with answers, click on the resource link above.
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(n) \(\underline {\text { non-equality }}\) join is when a table is joined to itself.
A)True
B)False
Q2) A(n) ____________________ is an alternate name temporarily assigned to a table.
Q3) Which of the following types of joins refers to joining a table to itself?
A) Cartesian join
B) equality join
C) self-join
D) outer join
Q4) The\(\underline {\text { outer join } }\)operator is used to combine the results of multiple SELECT statements. _________________________
A)True
B)False
Q5) If a Cartesian join is used to link table A which contains five rows to table B which contains eight rows, there will be 13 rows in the results.
A)True
B)False
Q6) The ____________________ JOIN keyword can be used to create a Cartesian join.
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) The \(\underline { \text { SUBSTR } }\) function is used to return a portion of a character string. _________________________
A)True
B)False
Q2) The ____ function can be used to convert dates and numbers to a formatted character string.
A) TO_DATE
B) CONVERT
C) FORMATMODEL
D) TO_CHAR
Q3) LOWER, UPPER, and INITCAP functions are all \(\underline {\text { character manipulation } }\)functions. _________________________
A)True B)False
Q4) The ____________________ function is used to return a portion of a string.
Q5) When functions are nested, the \(\underline {\text { inner }}\) function is solved first. _________________________
A)True
B)False
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) 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
Q2) The ____ function can be used to include NULL values in a calculation.
A) AVG
B) SUM
C) NULL
D) NVL
Q3) If a SELECT statement contains HAVING, GROUP BY, and WHERE clauses, the ____ clause will be processed first.
A) HAVING
B) GROUP BY
C) WHERE
D) ORDER BY
Q4) Explain how nested group functions are processed.
Q5) The SUM function can only be used with ____________________ columns.
Page 13
Q6) Group functions can only be nested to a depth of ____________________.
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) IN is not a valid operator for a multiple-column subquery.
A)True
B)False
Q2) When a multiple-column subquery is used in the outer query's FROM clause, it creates a temporary table, called an inline view, that can be referenced by other clauses of the outer query.
A)True
B)False
Q3) A subquery is a(n) ____________________ query - one complete query inside another query.
Q4) The EXISTS operator can be used with multiple-row subqueries.
A)True
B)False
Q5) A(n) \(\underline {\text { correlated }}\) subquery is when the outer query is executed first, and then the inner query is executed. _________________________
A)True
B)False
Q6) A(n) ____________________ query can return several rows of results, but only one column.
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) Which type of view is created with the following command? CREATE VIEW OR REPLACE outstanding AS SELECT customer#, order#, orderdate, shipdate FROM orders WHERE shipdate IS NULL WITH READ ONLY;
A) simple B) complex C) derived D) inline
Q2) When a query references a view, the query in the view is processed, and the results are treated as a(n) \(\underline { \text { permanent } }\) table.
A)True B)False
Q3) A(n) \(\underline {\text { UPDATE } }\) operation can be performed on a complex view that contains an arithmetic operation. _________________________ A)True B)False
To view all questions and flashcards with answers, click on the resource link above.
Page 15