Database Management Systems
Exam Questions
Course Introduction
Database Management Systems introduces students to the fundamental concepts and techniques involved in designing, implementing, and managing databases. This course covers relational database models, data modeling with Entity-Relationship diagrams, SQL querying, normalization, and transaction management. Students will gain practical experience working with database systems, understanding data integrity, security, and backup strategies, as well as exploring emerging topics such as NoSQL databases and distributed database architectures. By the end of the course, students will be equipped with the skills needed to design well-structured databases and manage data efficiently for a variety 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 record in the logical design of a database is represented by what in the physical database?
A) row
B) field
C) record,
D) row.
Answer: D
Q2) A file is composed of a group of related ____________________.
Answer: records
Q3) A database is a physical storage device for data.
A)True
B)False
Answer: False
Q4) Which of the following terms represents a collection of fields?
A) field
B) record
C) character
D) file
Answer: B
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 types of columns will automatically right-align the data when it is displayed?
A) character
B) date
C) alphanumeric
D) numeric
Answer: D
Q2) The DESCRIBE command is used to view data in a table.
A)True
B)False
Answer: False
Q3) What is used to indicate the end of an SQL statement?
A) /
B) :
C) ;
D) *
Answer: C
Q4) The names of the columns to be retrieved are listed in the ____________________ clause.
Answer: SELECT
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) Which keywords are used to complete the deletion of a column previously marked with SET UNUSED?
A) DELETE UNUSED COLUMNS
B) DROP UNUSED COLUMNS
C) UNSET UNUSED COLUMNS
D) DROP SET COLUMNS
Answer: B
Q2) 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
Q3) A table name can contain the number sign and ____________________ symbols.
Answer: underscore
Q4) Only one column can be added to an existing table at one time.
A)True
B)False
Answer: False
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) A(n) \(\underline { \text { UNIQUE } }\) constraint will allow NULL values to be stored in the designated column. _________________________
A)True
B)False
Q2) A(n) \(\underline { \text { constraint } }\) can be created during the creation of a database table or added to a table afterwards. _________________________
A)True
B)False
Q3) A FOREIGN KEY constraint can only reference a column in another table that has been assigned a(n) ____ constraint.
A) NOT NULL
B) UNIQUE
C) CHECK
D) none of the above
Q4) Each column can only be included in one constraint. A)True B)False
Q5) The ____________________ command can be used to enable or disable a constraint.
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(n) \(\underline { \text { exclusive } }\) lock is automatically obtained when the user executes the SELECT...FOR UPDATE command. _________________________
A)True
B)False
Q2) A(n) ____ lock will prevent any DDL operations from being performed on the locked table.
A) shared
B) exclusive
C) partial
D) partitioned
Q3) The variable name of a substitution variable is preceded by a(n) \(\underline { \text { percent sign. } }\)_________________________
A)True
B)False
Q4) The ____________________ keyword can be included in the INSERT command to enter the computer's date into the row when it is added to the table.
Q5) The duration of a(n) ____________________ is defined by when a COMMIT implicitly or explicitly occurs.
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) \(\underline { \text { Indexes } }\) are usually created for frequently referenced or searched columns. _________________________
A)True
B)False
Q2) The ____________________ SYNONYM command is used to permanently remove a synonym from a database.
Q3) Which of the following serves the same basic purpose as an index in a book, by allowing users to quickly locate specific records?
A) view
B) index
C) synonym
D) sequence
Q4) When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in descending order.
A)True
B)False
Q5) The ____________________ pseudocolumn is used to generate the next sequence value.
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) Which of the following commands will grant a role to a user?
A) GRANT rolename TO username;
B) GRANT ROLE rolename TO username;
C) GRANT rolename FOR username;
D) GRANT ROLE rolename FOR username;
Q3) A system privilege can be taken away from a user through the \(\underline { \text { UNGRANT } }\) command. _________________________
A)True
B)False
Q4) Which of the following can be considered potential threats to an organization's data?
A) natural disaster
B) disgruntled employees
C) computer criminals
D) all of the above
Page 9
To view all questions and flashcards with answers, click on the resource link above.
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) Comparison operators are used to combine search conditions.
A)True
B)False
Q2) Based upon the contents of the ORDERS table in the accompanying figure, which of the following SQL statements will list all orders placed by customer # 1020 that have not yet been shipped?
A) SELECT * FROM orders WHERE customer# = 1020 OR shipdate = NULL;
B) SELECT * FROM orders WHERE customer# = 1020 AND shipdate IS NULL;
C) SELECT * FROM orders WHERE customer# = 1020 OR shipdate IS NULL;
D) SELECT * FROM orders WHERE customer# = 1020 AND shipdate = NULL;
Q3) Based upon the contents of the ORDERS table in the accompanying figure, which of the following SQL statements will display all orders contained in the ORDERS table that have been shipped to the customer?
A) SELECT * FROM orders WHERE shipdate = 'NOT NULL';
B) SELECT * FROM orders WHERE shipdate = NOT NULL;
C) SELECT * FROM orders WHERE shipdate IS NULL;
D) SELECT * FROM orders WHERE shipdate IS NOT NULL;
Q4) The ____________________ logical operator is evaluated last in a sequence of logical operators.
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) In Oracle11g, tables can be linked through which clause(s)?
A) SELECT
B) FROM
C) WHERE
D) both b and c
Q2) The most common type of join is an equijoin, which joins two or more tables together based upon the tables having equivalent data values in a common column.
A)True
B)False
Q3) The outer join operator is placed on the side of the comparison that is deficient or is missing the matching rows.
A)True
B)False
Q4) In which of the following examples is the ORDERS table used as a column qualifier?
A) o.order#
B) orders.order#
C) order#.o
D) order#.orders
To view all questions and flashcards with answers, click on the resource link above.
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 functions can be used to determine the date one month after a specified date?
A) ADD_MONTH
B) ADD_MONTHS
C) ONE_MONTH
D) NEXT_MONTH
Q2) The \(\underline {\text { ROUND } }\) function can be used to round numeric data to the left or right of the decimal point. _________________________
A)True
B)False
Q3) The \(\underline {\text { NEXT DATE } }\) function is used to determine the next occurrence of a specific day of the week after a given date.
A)True
B)False
Q4) The DECODE function allows the user to specify different actions to be taken, depending on the value being used for the comparison.
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) Group functions can only be nested to a depth of ____________________.
Q2) The ____________________ function can be used to count the total records that meet a specific condition, including those that contain NULL values.
Q3) The ____ function is used to calculate the total amount stored in a numeric field.
A) TOTAL
B) SUM
C) AVERAGE
D) ADD
Q4) The MAX function can be used with character data.
A)True
B)False
Q5) If the DISTINCT keyword is not included in the VARIANCE function, the ____ keyword will be assumed.
A) UNIQUE
B) ALL
C) NULLS ONLY
D) NONULLS
Q6) The SUM function can only be used with ____________________ columns.
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) A subquery is required when the condition for the outer query is based upon an unknown.
A)True B)False
Q2) The <ALL operator indicates that for a value to be included in the results, it must be less than the lowest value returned by the subquery.
A)True
B)False
Q3) The \(\underline {\mathrm{< ANY} }\) operator indicates that a value must be less than the lowest value returned by the subquery to be included in the results.
A)True
B)False
Q4) Which of the following terms refers to a type of subquery that is processed, or executed, once for each row in the outer query?
A) correlated subquery
B) uncorrelated subquery
C) multiple-column subquery
D) single-row subquery
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 of the following describes a subquery used in a FROM clause to create a "temporary" table that can be referenced by the SELECT and WHERE clauses of the outer query?
A) simple view
B) complex view
C) inline view
D) "TOP-N" analysis
Q2) An ORDER BY clause can be included in a(n) ____________________ view to perform "TOP-N" analysis.
Q3) An inline view is created by a SELECT statement that contains a(n) ____________________ in the FROM clause.
Q4) The \(\underline { \text { OR REPLACE } }\) clause is only necessary if another view may already exist with the same name. _________________________
A)True
B)False
Q5) A view can be created to simplify issuing complex SQL queries.
A)True
B)False
Q6) How does a materialized view differ from the other types of views?
Page 15
To view all questions and flashcards with answers, click on the resource link above.