Data Modeling and SQL MCQ PDF

https://quizplus.com/study-set/1085
13 Chapters
1685 Verified Questions
 Data Modeling and SQL
MCQ PDF
Cou
This course introduces students to the principles and practices of data modeling and

the use of Structured Query Language (SQL). Students will learn how to design and

construct conceptual, logical, and physical data models for efficient database

organization and management. Emphasis is placed on understanding

entity-relationship diagrams, normalization processes, and relational schema design.

The course also covers fundamental and advanced SQL topics including data definition,

manipulation, constraints, joins, subqueries, indexes, and security considerations,

enabling students to create, query, and maintain robust database systems for

real-world 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) Analyzing historical sales data stored in a database is commonly referred to as
____.
A) data storage
B) data mining
C) data manipulation
D) archived data
Answer: B

Q2) Data is in ____________________ normal form if it does not have any

repeating groups and has a primary key.
Answer: first
1st

Q3) 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

Q4) A foreign key uniquely identifies each row in a table.

A)True
B)False
Answer: False

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) ____________________ is an alternative column heading displayed in the
output of a query.
Answer: column alias

Q2) The use of a column alias in the SELECT clause can be designated by the keyword
\(\underline { \text { ALIAS } }\). _________________________
A)True
B)False
Answer: False

Q3) Insignificant zeros \(\underline { \text { are } }\) displayed for numeric columns by
default to show two decimal places. _________________________
A)True
B)False
Answer: False

Q4) A string literal must be enclosed in ____________________ marks.

Answer: single quotation
single-quotation
''

Q5) 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) The DROP TABLE command can be used to remove a table and all its data from a
database.
A)True
B)False
Answer: True

Q2) If the CREATE TABLE is being used to create a table from existing data, the SUBQUERY
keyword must be used.
A)True
B)False
Answer: False

Q3) The \(\underline { \text { CHAR } }\) datatype is used to store variable-length data
that can consist of letters and numbers. _________________________
A)True
B)False
Answer: False

Q4) SELECT9 \(\underline { is }\) a valid table name.

_________________________
A)True
B)False
Answer: True

To view all questions and flashcards with Page 5 click on the resource link above.
answers,
 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 NOT NULL constraint will display the search condition of
____________________ in the USER_CONSTRAINTS view.

Q2) A NOT NULL constraint can only be added to an existing table by using the
\(\underline { ADD }\) clause with the ALTER TABLE command.
_________________________
A)True
B)False

Q3) The FOREIGN KEY constraint is usually placed on the \(\underline { \text { "one" }
}\) side of a one-to-many relationship. _________________________
A)True
B)False

Q4) Which of the following constraints cannot be added to an existing table with the ADD
clause of the ALTER TABLE command?
A) CHECK
B) UNIQUE
C) NOT NULL
D) none of the above

Q5) What is the relationship between a NOT NULL constraint and a CHECK constraint?

Q6) The ____________________ command can be used to enable or disable a

constraint. Page 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) When the UPDATE command is used to change existing data values, the
____________________ clause is used to specify the new data value and the
column being changed.

Q2) The ____________________ command is used to remove rows from a table.

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) A(n) \(\underline { \text { exclusive } }\) lock is automatically obtained when the
user executes the SELECT...FOR UPDATE command. _________________________
A)True
B)False

Q5) When new rows are being added to a table, the actual data being added are listed
in the ____ clause.
A) INSERT INTO
B) DATA
C) VALUES
D) ADD

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) If the minimum value for a sequence is not specified, then NOMINVALUE will be
assumed as the default.
A)True
B)False

Q2) The ____________________ value of a sequence cannot be changed if the

sequence has already generated a number greater than that value.

Q3) 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;

Q4) A(n) ____________________ can be used to generate values for a column

designated as the primary key for a table.

Q5) A negative number can be assigned to the ____ clause to generate sequential
numbers in decreasing order.
A) DECREMENT BY
B) INCREMENT BY
C) DECREASE BY
D) GENERATE BY

To view all questions and flashcards with Page

answers,
8 click on the resource link above.
 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 views will display the privileges currently enabled for a user?
A) CURRENT_PRIVS
B) SESSION_PRIVILEGES
C) SESSION_PRIVS
D) CURRENT_PRIVILEGES

Q2) Which of the following keywords must be included with the GRANT command to
allow the user to grant object privileges to other users?
A) WITH GRANT OPTION
B) WITH ADMIN OPTION
C) WITH SYSADMIN OPTION
D) WITH DBA OPTION

Q3) The WITH GRANT OPTION is required to allow a user to grant the specified object
privileges to other users.
A)True
B)False

Q4) Granting users limited ____________________ to access data is one security

method used in Oracle11g.

Q5) ____________________ privileges allow users to execute specific DDL

commands.

To view all questions and flashcards with Page

answers,
9 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) 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 IN logical operator is similar to using \(\underline{OR}\).

_________________________
A)True
B)False

Q3) A column alias that has been defined in the SELECT clause of a SELECT statement
cannot be referenced in an ORDER BY clause.
A)True
B)False

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) Which of the following set operators will display only the unique results of the
combined SQL statements?
A) UNION
B) UNION ALL
C) INTERSECT
D) MINUS

Q2) The ____________________ keyword can be included in the FROM clause to

link tables.

Q3) Which of the following set operators will display the results of the combined SQL
statements without suppressing duplicate rows?
A) UNION
B) UNION ALL
C) INTERSECT
D) MINUS

Q4) If a table alias is assigned in the\(\underline { \text { SELECT } }\)clause, it must be

used any time the table is referenced in that SQL statement.
_________________________
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) When functions are nested, the outer function is solved or executed first.
A)True
B)False

Q2) Which of the following functions determines the number of characters in a character
string?
A) COUNT
B) NUMBER
C) LENGTH
D) none of the above

Q3) Use MON in the format argument to spell out the specified month.
A)True
B)False

Q4) Which of the following functions can be used to change the format of a date that
has been entered by a user to the default storage format use by Oracle11g?
A) TO_CHAR
B) TO_DATE
C) DEFAULT
D) DATE

Q5) Describe the order in which Oracle11g resolves nested functions.

To view all questions and flashcards withPage

answers,
12 click on the resource link above.
 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 ORDERS table, which of the following SELECT statements
will determine the number of orders placed by each customer?
A) SELECT COUNT(DISTINCT(customer#))
FROM orders;
B) SELECT COUNT(*)
FROM orders;
C) SELECT customer#, COUNT(customer#)
FROM orders
GROUP BY customer#;
D) none of the above

Q2) The ____ function calculates the standard deviation for a specific set of data.
A) STDDEVIATION
B) STD
C) STDDEV
D) STANDARDDEV

Q3) The SUM function can only be used with ____________________ columns.

Q4) The DISTINCT keyword cannot be used with the MAX function.
A)True
B)False

Q5) Explain the difference between a WHERE and a HAVING clause.

Page 13
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) If a multiple-column subquery is contained in the WHERE or HAVING clause of the
outer query, the ____________________ operator must be used.

Q2) The following SQL statement contains which type of subquery? SELECT title, retail,
category, cataverage FROM books NATURAL JOIN
(SELECT category, AVG(retail) cataverage FROM books GROUP BY category);
A) single-row
B) multiple-row
C) correlated
D) uncorrelated

Q3) Which of the following must be used to separate a subquery from the outer query?
A) / /
B) " "
C) | |
D) ( )

Q4) IN is not a valid operator for a multiple-column subquery.

A)True
B)False

Q5) A subquery, except one in the FROM clause, cannot contain a(n)
____________________ clause.

To view all questions and flashcards withPage

answers,
14 click on the resource link above.
 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 view can be modified using the MODIFY clause of the ALTER VIEW command.
A)True
B)False

Q2) An inline analysis can be used to find the \(\underline { \text { "Top-N" } }\)values.
_________________________
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 based on the contents of one table that uses an expression for one of the
columns is considered a(n) ____ view.
A) simple
B) complex
C) inline
D) outer

Q5) How does a materialized view differ from the other types of views?

Q6) How is a "TOP-N" analysis performed?

Page 15
To view all questions and flashcards with answers, click on the resource link above.