Section 1

(Answer all questions in this section)

1. The technical software requirements for this course include all of the
following except:
Mark for Review

(1) Points
Oracle SQL Developer Data Modeler
Microsoft Access (*)
Oracle APEX application
All are requirements.
Correct

2. SQL *Plus is being used in the Oracle Academy courses to run SQL code. True
or False?
Mark for Review

(1) Points
True
False (*)
Incorrect. Refer to Section 1 Lesson 1.

3. Which is the first step in the Database Development Process ?

Mark for Review

(1) Points
Design
Strategy and Analysis (*)
Build
Testing
Correct

4. In the relational database model, each table name must be unique. The
column names in the table must be unique too. You can have two different
tables that have column names that are the same.
Mark for Review
(1) Points
True (*)
False
Correct

5. A flat file may contain many fields, often, with duplicate data that are prone to
data corruption.
Mark for Review

(1) Points
True (*)
False
Correct
6. Which of the following is not a stage in the Database Development Process?
Mark for Review

(1) Points
Build
Reporting (*)
Design
Strategy and Analysis
Correct

7. The reason or drive for using databases rather than files has been …
(Choose 3)
Mark for Review

(1) Points
Integration of data for easier access and modification for complex
transactions (*)
Reduced redundancy of data (*)
Use of blocks
Availability of data to a diverse set of users (*)
Incorrect. Refer to Section 1 Lesson 4.

8. When completing the conceptual modeling process we must take into account
the following:
Mark for Review

(1) Points
Business Rules
Assumptions
Problems
All of the above (*)
Correct

9. Using a database solution instead of a flat file eliminates all of the following
issues except:
Mark for Review

(1) Points
Redundancy
Data entry anomalies
Incorrect data (*)
Inconsistency
Incorrect. Refer to Section 1 Lesson 4.

10. All Business Rules can be modeled.

Mark for Review

(1) Points
True
False (*)
Correct
Previous Page 2 of 3 Next 

11. Business ______ are used to understand business processes, and the nature,
role, and scope of the data.
Mark for Review

(1) Points
Goals
Processes
Mission Statements
Rules (*)
Correct

12. DBMS stands for :

Mark for Review

(1) Points
Database Management System (*)
Database Management Software
Database Manipulation System
Database Memory System
Correct

13. Information is the result of combining, comparing and performing

calculations on data.
Mark for Review

(1) Points
True (*)
False
Correct

14. Which transformation in computing allows for storage and delivery of

applications and data over the internet?
Mark for Review

(1) Points
Mainframe computing
Grid Computing
Desktop computing
Cloud Computing (*)
Correct

15. The transformations that have occurred in the computing world progressing

in this order:
Mark for Review
(1) Points
Mainframe computing, Desktop computing, Client/Server Computing, Grid
computing. (*)
Grid Computing, Desktop Computing, Mainfram Computing, Client/Server
Computing
Mainframe Computing, Desktop Computing, Grid Computing, Client/Server
Computing.
Desktop computing, Grid computing, Client/Server computing, Mainframe
computing.
Correct

Section 2
(Answer all questions in this section)
1. Many reasons exist for creating a conceptual model. Choose three appropriate
reasons from the options below.

(0/1) Points

They capture the data values.

They accurately describe what a physical model will contain. (*)

They capture current and future needs. (*)

They capture the implementation details of the physical model.

They model functional and informational needs. (*)

Incorrect. Refer to Section 2 Lesson 2.

2. The logical model determines relationship optionality and cardinality

(1/1) Points

True (*)

False
Correct

3. A row is called a record.

(0/1) Points

True (*)

False
Incorrect. Refer to Section 2 Lesson 1.

4. In the relational model, relationships between relations or tables are created by
using?

(1/1) Points

Composite Keys

Primary Keys
Foreign Keys (*)

Candidate Keys
Correct

5. One-to-Many relationships have cardinality of one or more in both directions. True or

False?

(1/1) Points

True

False (*)
Correct

6. Which of the following is NOT an example of cardinality?

(1/1) Points
All are examples of cardinality.
How many types of jobs are there? (*)
How many employees can hold one specific job?
How many jobs can one employee hold?
Correct

7. A __________ relationship is a relationship between an entity and itself.

(1/1) Points
Recursive (*)
One to one
Mandatory
Hierarchical
Correct

8. A unique identifier must be made up of more than one attribute. True or
False?
(1/1) Points
True
False (*)
Correct

9. All entities must be given a new artificial UID. True or False?

(1/1) Points
True
False (*)
Correct

10. Which of the attributes is a volatile attribute?

(1/1) Points
Eye color
Date of birth
Race
Age (*)
Correct
11. Which of the following entities most likely contains invalid attributes?
(1/1) Points
Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built
Entity: Pet. Attributes: Name, Birthdate, Owner
Entity: Mother. Attributes: Name, Birthdate, Occupation, Number of Children
Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed (*)
Correct

12. When creating entities in a logical model you must follow these rules:
(Choose Two)
(0/1) Points
Name them in Plural
Exclude Attributes
Include Attributes (*)
Name them in Singular (*)
Incorrect. Refer to Section 2 Lesson 3.

13. Which of the following is not a goal of ER modeling:

(1/1) Points
It is acceptable to include information that is derivable. (*)
Capture all required information.
Locate information in a logical manner
Ensure information appears only once.
Correct
14. The conceptual model does all of the following except:
(0/1) Points
Takes into account regulations and laws goverining the industry being
addressed.
Documents type of operating system to be used. (*)
Describes the needs of the business.
Prevents mistakes and misunderstandings.
Incorrect. Refer to Section 2 Lesson 6.

15. Using ERDish, which wording represents cardinality? (Choose Two)

(0/1) Points
one and only one (*)
one only
one or more (*)
one or multiple
Incorrect. Refer to Section 2 Lesson 6.

1. To identify an attribute as part of a unique identifier on an ER diagram, the #

symbol goes in front of it. True or False?
(1/1) Points
True (*)
False
Correct

2. In this course, we use the __________ notation for ERD modeling.
(0/1) Points
Bachman
Barker (*)
Information Engineering
None of the above
Incorrect. Refer to Section 2 Lesson 3.

3. A/an _________ is a piece of information that in some way describes an entity. It

is a property of the entity and it quantifies, qualifies, classifies, or specifies the
entity.
(1/1) Points
Attribute (*)
Process
ERD
Table
Correct

4. Primary UIDs are:

(0/1) Points
Always comprised of numbers
Optional in data modeling.
Mandatory in data modeling (*)
Useful as an alternative means of identifying instances of an entity, independent
of their datatype
Incorrect. Refer to Section 2 Lesson 4.

5. People are not born with “numbers”, but a lot of systems assign student
numbers, customer IDs, etc. A shoe has a color, a size, a style, but may not have
a descriptive “number". So, to be able to uniquely and efficiently identify one
instance of the entity SHOE, a/an ______________ UID can be created.
(0/1) Points
Structured
Identification
Unrealistic
Artificial (*)
Incorrect. Refer to Section 2 Lesson 4.

6. Which of the following is NOT a relationship type?

(1/1) Points
One to One
Many to Many
One to Many
Some to None (*)
Correct
7. A __________ relationship is a relationship between an entity and itself.
(1/1) Points
Hierarchical
Recursive (*)
Mandatory
One to one
Correct

8. A relationship is transformed from logical to physical model using _________.

(1/1) Points
Composite Keys
Foreign Keys (*)
Candidate Keys
Secondary Keys
Correct

9. A table must have a primary key. True or False?

(0/1) Points
True (*)
False
Incorrect. Refer to Section 2 Lesson 1.

10. In the relational model, data is organized in a basic storage structure called a
____________.
(1/1) Points
Field
Tuples
Table (*)
Row
Correct

11. Using ERDish, which wording represents optionality? (Choose Two)

(0/1) Points
must (*)
may (*)
mandatory
maybe
Incorrect. Refer to Section 2 Lesson 6.

12. Data modeling is performed for the following reasons: (Choose Two)

(0/1) Points
We draw an ERD solely to please the users; once completed, the ERD is never
referred to again as it serves no purpose in the real world.
The ERD becomes a blueprint for designing the actual system. (*)
It helps discussions and reviews. (*)
We do not need datamodels; we can just start coding right away.
Incorrect. Refer to Section 2 Lesson 6.

13. Using ERDish, which wording represents cardinality? (Choose Two)

(0/1) Points
one or more (*)
one or multiple
one only
one and only one (*)
Incorrect. Refer to Section 2 Lesson 6.

14. Many reasons exist for creating a conceptual model. Choose three

appropriate reasons from the options below.
(0/1) Points
They model functional and informational needs. (*)
They capture the data values.
They accurately describe what a physical model will contain. (*)
They capture the implementation details of the physical model.
They capture current and future needs. (*)
Incorrect. Refer to Section 2 Lesson 2.

15. In a relational database system, the next step after creating a conceptual
data model is to convert it to a _________ .
(0/1) Points
External data model
An entity-relation data model
Internal data model
Logical data model (*)
Incorrect. Refer to Section 2 Lesson 2.
1. Entity Boxes are drawn on an ERD using what type of shape?
(0/1) Points
Diamonds
Rectangles
Soft Boxes (*)
Hard Boxes
Incorrect. Refer to Section 2 Lesson 3.

2. Which of the following are suitable Entity names? (Choose Two)

(1/1) Points
ANIMAL (*)
DOG (*)
ANIMALS
DOGS
Correct

3. Which of the attributes is a volatile attribute?

(1/1) Points
Age (*)
Race
Date of birth
Eye color
Correct

4. A relationship is transformed from logical to physical model using _________.

(1/1) Points
Secondary Keys
Foreign Keys (*)
Composite Keys
Candidate Keys
Correct

5. Which of the following are true about Cardinality? (Choose two)

(0/1) Points
Cardinality tells "how many". (*)
Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
Cardinality specifies only singularity or plurality, but not a specific plural
number. (*)
Cardinality specifies whether something is required or not.
Incorrect. Refer to Section 2 Lesson 5.
6. Matrix Diagrams should be developed BEFORE the ERD. True or False?
(1/1) Points
True (*)
False
Correct

7. Each column in a relation is called an entity. True or False?

(0/1) Points
True
False (*)
Incorrect. Refer to Section 2 Lesson 1.

8. A relational database stores information in tables with rows and columns.
(1/1) Points
True (*)
False
Correct

9. The Physical Model is derived from the Logical Model. True or False?
(1/1) Points
True (*)
False
Correct

10. The logical model's entities, attributes, unique identifiers and relationships

map to the physical model's _________________.
(1/1) Points
Optionality and Cardinality
Files, records, fields and data values
Tables, columns, primary keys and foreign keys (*)
Correct
11. Using ERDish, which wording represents optionality? (Choose Two)
(0/1) Points
maybe
mandatory
may (*)
must (*)
Incorrect. Refer to Section 2 Lesson 6.

12. When mapping a relationship for an ERD diagram both sides of the

relationship have to be mapped.
(0/1) Points
True (*)
False
Incorrect. Refer to Section 2 Lesson 6.

13. ERDish includes the following except:

(0/1) Points
Cardinality
Optionality
Data Values. (*)
Relationship Names
Incorrect. Refer to Section 2 Lesson 5.

14. Unique Identifiers…
(1/1) Points
Distinguish one entity from another.
Distinguish all entities in a database
Distinguish one instance of an entity from all other instances of that entity (*)
Distinguish nothing
Correct

15. A unique identifier must be made up of more than one attribute. True or
False?
(1/1) Points
True
False (*)
Correct
1. In a business that sells pet food, choose the best relationship name between
FOOD TYPE and ANIMAL (e.g. dog, horse, or cat). (Choose Two)
(0/1) Points
Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
Each FOOD TYPE may be made from one or more ANIMALs.
Each ANIMAL must be the seller of one or more FOOD TYPES.
Each FOOD TYPE may be given to one or more ANIMALs. (*)
Incorrect. Refer to Section 2 Lesson 5.

2. One-to-Many relationships have cardinality of one or more in both directions.

True or False?
(1/1) Points
True
False (*)
Correct

3. In a relationship , _________ are used to helped describe the meaning of the
connection between the entities.
(0/1) Points
crows feet
descriptions
arrows
names (*)
Incorrect. Refer to Section 2 Lesson 5.

4. The logical model's entities, attributes, unique identifiers and relationships

map to the physical model's _________________.
(1/1) Points
Files, records, fields and data values
Optionality and Cardinality
Tables, columns, primary keys and foreign keys (*)
Correct

5. The Physical Model is derived from the Logical Model. True or False?
(1/1) Points
True (*)
False
Correct
6. Attributes that can be divided into smaller subparts are called________________.
(1/1) Points
Composite Attribute (*)
Mandatory Attribute
Single Attribute
Volatile Attribute
Correct

7. Which of the following entities most likely contains invalid attributes?

(1/1) Points
Entity: Pet. Attributes: Name, Birthdate, Owner
Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built
Entity: Mother. Attributes: Name, Birthdate, Occupation, Number of Children
Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed (*)
Correct

8. Attributes have Instances. True or False?

(1/1) Points
True
False (*)
Correct

9. Which of the following would be good as a Unique Identifier for its Entity?
(Choose Three)
(1/1) Points
Vehicle Registration Number for Car (*)
Date of birth for Baby
ISBN Number for Book (*)
Personal Identification number for Person (*)
Correct

10. A unique identifier made up of more than one attribute is called a __________.
(0/1) Points
Unique UID
Candidate UID
Composite UID (*)
Foreign UID
Incorrect. Refer to Section 2 Lesson 4.
11. Using ERDish, which wording represents cardinality? (Choose Two)
(1/1) Points
one only
one or multiple
one and only one (*)
one or more (*)
Correct

12. A model is considered to be Implementation-Free if it can be implemented

using ____ of the database software models such as hierarchical, network or
relational.
(1/1) Points
any (*)
only one
none
Correct

13. ERDish is a language used to create database structures in SQL

(0/1) Points
True
False (*)
Incorrect. Refer to Section 2 Lesson 5.

14. In a relational database a table is referred to as ..

(1/1) Points
A unique identifier
A basic storage structure (*)
An attribute
None of the above.
Correct

15. Identify all of the incorrect statements that complete this sentence: A

primary key is...(Choose three)
(0/1) Points
One or more columns in a table that uniquely identifies each row in that table.

A set of columns in one table that uniquely identifies each row in another
table. (*)
Only one column that must be null. (*)
A single column that uniquely identifies each column in a table. (*)
Incorrect. Refer to Section 2 Lesson 1.
1. The logical model's entities, attributes, unique identifiers and relationships
map to the physical model's _________________.
(1/1) Points
Files, records, fields and data values
Tables, columns, primary keys and foreign keys (*)
Optionality and Cardinality
Correct

2. An ERD is an example of a ______ Model.

(0/1) Points
Physical
Conceptual (*)
Network
Data Integrity
Incorrect. Refer to Section 2 Lesson 2.

3. Primary keys can contain null values.

(1/1) Points
True
False (*)
Correct

4. All entities must be given a new artificial UID. True or False?

(1/1) Points
True
False (*)
Correct

5. Which symbol is used to show that a particular attribute is optional?

(0/1) Points
&
*
o (*)
#
Incorrect. Refer to Section 2 Lesson 3.
6. Entities are usually _____________.
(1/1) Points
Nouns (*)
Adjectives
Adverbs
Verbs
Correct

7. Attributes have Instances. True or False?

(1/1) Points
True
False (*)
Correct

8. Which of the following is NOT a relationship type?

(1/1) Points
One to Many
Many to Many
Some to None (*)
One to One
Correct

9. Which of the following are true about Cardinality? (Choose two)

(1/1) Points
Cardinality specifies whether something is required or not.
Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
Cardinality tells "how many". (*)
Cardinality specifies only singularity or plurality, but not a specific plural
number. (*)
Correct
10. The cardinality of a relationship can be _____________. (Choose two)
(0/1) Points
one or more (*)
one and only one (*)
one to one
many to many
Incorrect. Refer to Section 2 Lesson 5.
11. ERDish includes the following except:
(1/1) Points
Relationship Names
Optionality
Data Values. (*)
Cardinality
Correct

12. ERDish is a language used to create database structures in SQL

(1/1) Points
True
False (*)
Correct

13. Data modeling is performed for the following reasons: (Choose Two)

(1/1) Points
We draw an ERD solely to please the users; once completed, the ERD is never
referred to again as it serves no purpose in the real world.
It helps discussions and reviews. (*)
We do not need datamodels; we can just start coding right away.
The ERD becomes a blueprint for designing the actual system. (*)
Correct

14. Which of the following statements does not apply to relational databases?

(0/1) Points
Relational databases have a strong procedural orientation. (*)
Relational databases are simple to understand.
Relational databases relate tables to each other using common fields called
keys.
Tables are one of the basic components of relational databases.
Incorrect. Refer to Section 2 Lesson 1.

15. A _____ is a type of database that stores data in a single table.

(0/1) Points
Relational
Hierarchical
Network
Flat file (*)
Incorrect. Refer to Section 2 Lesson 1.
1. The logical model determines relationship optionality and cardinality
(1/1) Points
True (*)
False
Correct

2. Which of the following are reasons we create conceptual models?

(1/1) Points
It facilitates discussion; a picture is worth a thousand words
It forms important ideal system documentation
It takes into account government regulations and laws
It forms a sound basis for physical database design
All of the above (*)
Correct

3. Which of the following is NOT an example of cardinality?

(1/1) Points
All are examples of cardinality.
How many employees can hold one specific job?
How many types of jobs are there? (*)
How many jobs can one employee hold?
Correct

4. One-to-Many relationships have cardinality of one or more in both directions.

True or False?
(1/1) Points
True
False (*)
Correct

5. The optionality of a relationship must be either _______ or _______.

(0/1) Points
One or (One or More)
Mandatory or Optional (*)
Single or Multiple
Bidirectional or a single direction
Incorrect. Refer to Section 2 Lesson 5.
6. People are not born with “numbers”, but a lot of systems assign student
numbers, customer IDs, etc. A shoe has a color, a size, a style, but may not have
a descriptive “number". So, to be able to uniquely and efficiently identify one
instance of the entity SHOE, a/an ______________ UID can be created.
(1/1) Points
Identification
Unrealistic
Artificial (*)
Structured
Correct

7. What is the purpose of a Unique Identifier?

(0/1) Points
To identify a specific row within a table, using one or more columns and/or
foreign keys.
Create an entity that is unlike any other entity aside from itself.
To identify one unique instance of an entity by using one or more attributes
and/or relationships. (*)
To uniquely determine a table and columns within that table.
Incorrect. Refer to Section 2 Lesson 4.

8. In a relational database a table is referred to as ..

(1/1) Points
A unique identifier
A basic storage structure (*)
An attribute
None of the above.
Correct

9. Flat file databases are generally in plain-text form, where each line holds only
one record. True or False?
(1/1) Points
True (*)
False
Correct

10. Attributes have Instances. True or False?

(0/1) Points
True
False (*)
Incorrect. Refer to Section 2 Lesson 3.
11. Which of the following are suitable Entity names? (Choose Two)
(1/1) Points
ANIMALS
DOG (*)
DOGS
ANIMAL (*)
Correct

12. When creating entities in a logical model you must follow these rules:
(Choose Two)
(1/1) Points
Exclude Attributes
Include Attributes (*)
Name them in Singular (*)
Name them in Plural
Correct

13. Data models are drawn to show users the actual Data that their new system
will contain; only Data listed on the Diagram can be entered into the Database.
True or False?
(0/1) Points
True
False (*)
Incorrect. Refer to Section 2 Lesson 6.

14. Which of the following is not a goal of ER modeling:

(1/1) Points
Capture all required information.
It is acceptable to include information that is derivable. (*)
Locate information in a logical manner
Ensure information appears only once.
Correct

15. When mapping a relationship for an ERD relationship names must be

included.
(1/1) Points
True (*)
False
Correct
Links: https://quizlet.com/_5ygxe8?x=1jqt&i=3qlb1n
https://quizlet.com/_5zbfls?x=1jqt&i=3qlb1n

A ____ relationship is a relationship between an entity and itself

TERM
IMAGE
Recursive
DEFINITION
Which of the following is NOT a relationship type?
-Many to Many
-Someone to None
-One to One
-One to Many
TERM
IMAGE
Some to None
DEFINITION
Which of the following are true about Cardinality? (Choose 2)
-Cardinality specifies a counting number (like 1,2,3,4,etc) in a relationship
-Cardinality specifies whether something is required or not
-Cardinality tells "how many"
-Cardinality specifies only singularity or plurality, but not a specific plural number
TERM
IMAGE
Cardinality specifies "how many" & Cardinality specifies only sungularity or plurality,
but not a specific plural number
DEFINITION
A ___ is a collection of records
TERM
IMAGE
Table
DEFINITION
Data Integrity ensures ____ in the information
TERM
IMAGE
no duplication
DEFINITION
The conceptual model does all of the following except:
-Takes into account regulations and laws governing the industry being addressed.
-Describes the needs of the business.
-Prevents mistakes and misunderstandings.
-Documents type of operating system to be used.
TERM
IMAGE
Documents type of operating system to be used
DEFINITION
ERDish includes all of the following except:
- Optionality
- Cardinality
- Data Values
- Relationship Names
TERM
IMAGE
Data values
DEFINITION
In an ERD diagram how is cardinality represented? (2)
- With a crow's foot
- With a single toe
- With a solid line
- With a dotted line
TERM
IMAGE
With a crow's foot & With a single toe
DEFINITION
Something can have a lot of characteristics but may not have a descriptive "number,"
to be able to identify one instance of an object like that an ______ UID is used
TERM
IMAGE
Artificial
DEFINITION
A unique identifier must be made up of more than one attribute? (T/F)
TERM
IMAGE
False
DEFINITION
To identify an attribute as part of a unique identifier on an ER diagram, the # symbol
goes in
front of it. (T/F)
TERM
IMAGE
True
DEFINITION
Which attribute counts as a volatile attribute?
-Date of birth
-Eye color
-Race
-Age
TERM
IMAGE
Age
DEFINITION
An entity may have which of the following?
-Experiences
-Instances
-Tables
-None of the above
TERM
IMAGE
Instances
DEFINITION
The physical model shows all table structures (T/F)
TERM
IMAGE
True
DEFINITION
Which of the following are reasons to create a conceptual model? (3)
o They capture current and future needs.
o They capture the implementation details of the physical model.
o They capture the data values.
o They model functional and informational needs.
o They accurately describe what a physical model will contain.
TERM
IMAGE
They capture current and future needs, they model functional and informational
needs, and they accurately describe what a physical model will contain
DEFINITION
A candidate UID that does not get chosen to become the primary UID is called a
____
TERM
IMAGE
Secondary UID
DEFINITION
The candidate UID that is chosen to identify an entity is called the Primary UID; other
candidate UIDs are called
Secondary UIDs.
o No, each Entity can only have one UID, the secondary one.
o No, after UIDs are first sorted, the first one is called the Primary UID, the second is
the
Secondary UID, etc.
o No, it is not possible to have more than one UID for an Entity.
o Yes, this is the way UID's are named.
TERM
IMAGE
Yes, this is the way UID's are named
DEFINITION
In this course, we use the __________ notation for ERD modeling.
o Bachman
o Barker
o Information Engineering
o None of the above
TERM
IMAGE
Barker
DEFINITION
Entities are usually _____________.
o Adverbs
o Adjectives
o Nouns
o Verbs
TERM
IMAGE
Nouns
DEFINITION
When creating entities in a logical model you must follow these rules: (Choose Two)
o Name them in Singular
o Exclude Attributes
o Name them in Plural
o Include Attributes
TERM
IMAGE
Name them in singular, include attributes
DEFINITION
Which of the following statements is true regarding Implementation-Free logical
models?
The model does not need to implemented on a DBMS.
The model changes depending on operating system that is being used.
The model changes depending on the relational database software being used
The model stays the same regardless of the DBMS or operating system used.
TERM
IMAGE
The model stays the same regardless of the DBMS or operating system used
DEFINITION
When mapping a relationship for an ERD diagram both sides of the relationship have
to be
mapped. (T/F)
TERM
IMAGE
True
DEFINITION
An ERD created using ERDish is a __________ representation of entities and their
relationships to each other.
technical
graphical
textual
hierarchical
TERM
IMAGE
Graphical
DEFINITION
In a relational database system, the next step after creating a conceptual data model
is to
convert it to a _________ .
External data model
Internal data model
Logical data model
An entity-relation data model
TERM
IMAGE
Logical data model
DEFINITION
The logical model's entities, attributes, unique identifiers and relationships map
to the physical
model's _________________.
Optionality and Cardinality
Files, records, fields and data values
Tables, columns, primary keys and foreign keys
TERM
IMAGE
Tables, columns, primary and foreign keys
DEFINITION
A relationship can be between ____________.
two entities
an entity and itself
multiple entities
| all of the above
TERM
IMAGE
all of the above
DEFINITION
A relationship is transformed from logical to physical model using _________.
Secondary Keys
Candidate Keys
Foreign Key
Composite Keys
TERM
IMAGE
Foreign keys
DEFINITION
In the relational model, relationships between relations or tables are created by
using?

Candidate Keys
Primary Keys
Foreign Keys
Composite Keys
TERM
IMAGE
Foreign Keys
DEFINITION
What does single table refer to? (Choose Two) (Choose all correct answers)
A database where all of the data is stored in one large table.
Non-relational systems that typically store each table and index in separate
files and often do not support the SQL language.
A type of database storage method where all of the data elements are stored
on top of each other.
A fully-relational database system like Microsoft's SQL Server or Oracle's
database systems.
TERM
IMAGE
A database where all of the data is stored in one large table, non-relational systems
that typically store each table and index in separate files and often do not support
SQL
DEFINITION

Section 3
(Answer all questions in this section)

1. When you resolve a M:M, you simply re-draw the relationships between the two
original entities; no new entities are created. True or False?

(1/1) Points

True

False (*)
Correct

2. Intersection Entities are at the ______ end of the newly created 1:M (Parent:Child)
relationship;
(0/1) Points

Child (*)

Parent

Single

Barred
Incorrect. Refer to Section 3 Lesson 1.

3. Which of the following would best be represented by an arc?

(1/1) Points

TEACHER (Female, Bob)

PARENT (Girl, Bob)

STUDENT (Grade A student, Average Student)

DELIVERY ADDRESS (Home, Office) (*)

Correct

4. All ER diagrams must have one of each of the following: (Choose two)

(1/1) Points

Relationships between entities (*)

Arcs

One or more Entities (*)

At least one supertype and subtype

Correct

5. The "Other" subtype is mandatory. True or False?

(0/1) Points

True
False (*)
Incorrect. Refer to Section 3 Lesson 1.

6. Relationships are mapped in a physical model using ____________ keys and

foreign keys.
(1/1) Points
primary (*)
composite
secondary
unique
Correct

7. Attribute names are converted to column names by _________________.

(0/1) Points
Replacing numbers with letters.
Replacing periods with commas.
Replacing spaces with underscores. (*)
Replacing underscores with dashes.
Incorrect. Refer to Section 3 Lesson 4.

8. When mapping entities containing supertypes and subtypes a _________ table

implementation is used when most of the attributes and relationships are
shared at the supertype level.
(0/1) Points
single-table (*)
two-table
many to many
multiple-table
Incorrect. Refer to Section 3 Lesson 4.

9. Business rules are important to data modelers. True or False?

(1/1) Points
True (*)
False
Correct

10. A new system would have a mixture of both Procedural and Structural
Business Rules as part of the documentation of that new system. True or False?
(1/1) Points
True (*)
False
Correct
11. Which of the following is not true regarding normalization:
(1/1) Points
It assists in handling insert, update and delete anomalies.
It does not impact the performance of the database. (*)
It helps with the performance of the database.
It is the process of organizing the attributes and tables of a relational database
to minimize redundancy.
Correct

12. A table is in 2NF if the table is in 1NF and what other condition is met?
(1/1) Points
There are no null values in primary key fields.
There are no attributes that are not functionally dependent on the relation's
entire primary key. (*)
There are no repeating groups.
There are no functional dependencies.
Correct

13. "Only teachers may supervise exams" is an example of which of the

following?
(0/1) Points
An attribute that is not be inherited from the PERSON supertype and is unique
to the TEACHER subtype
A structural business rule
A procedural business rule (*)
An attribute that should be stored on the PERSON entity
Incorrect. Refer to Section 3 Lesson 3.

14. Modeling historical data can produce a unique identifier that includes dates.
True or False?
(1/1) Points
True (*)
False
Correct

15. A ______________ is frequently used to track information about a relationship

that changes over time.
(1/1) Points
intersection entity (*)
many to many relationship
non-transferable relationship
recursive relationship
Correct
1. The transformation from an ER diagram to a physical design involves changing
terminology. Secondary Unique Identifiers become _____.
(1/1) Points
Columns
Primary Key Constraints
Tables
Unique Constraints (*)
Correct

2. In a physical data model, a relationship is represented as a combination of:

(Choose Two)
(0/1) Points
Check Constraint or Unique Key
Foreign Key (*)
Primary Key or Unique Key (*)
Column
Incorrect. Refer to Section 3 Lesson 4.

3. The transformation from an ER diagram to a physical design involves changing

terminology. Primary Unique Identifiers in the ER diagram become __________
and relationships become ____________.
(1/1) Points
Primary keys, Foreign keys (*)
Foreign keys, Primary keys
Unique Keys, Primary keys
Foreign keys, mandatory business rules
Correct
4. Why is it important to follow the rules of normalization?
(1/1) Points
To reduce redundant data in the existing design
To increase the integrity of data and the design's stability
To eliminate other types of data inconsistencies and anomalies
To identify missing tables, columns, and constraints
All of the above. (*)
Correct

5. An entity without repeated values is said to be in __________.

(1/1) Points
1st normal form (*)
3rd normal form
4th normal form
2nd normal form
Correct
6. According to ___________, an attribute must be dependent on its entity’s entire
unique identifier.
(0/1) Points
2nd normal form (*)
3rd normal form
4th normal form
1st normal form
Incorrect. Refer to Section 3 Lesson 3.

7. A table is in 3NF if it has met all database requirements for both 1NF and 2NF
and all transitive dependencies are eliminated.
(1/1) Points
True (*)
False
Correct

8. When data is only stored in one place in a database, the database conforms to
the rules of ___________.
(1/1) Points
Normalization (*)
Normality
Multiplication
Reduction
Correct

9. Which of the following would be a logical constraint when modeling time for a
City entity?
(0/1) Points
People are born in the city and people die in the city.
Daily traffic patterns must be monitored to determine how many law
enforcement officers are needed.
Cites may change their names and/or country association if the borders of a
country change. (*)
If you are doing a system for any French City, you would need security clearance.

Incorrect. Refer to Section 3 Lesson 2.

10. Which of the following scenarios should be modeled so that historical data is

kept? (Choose two)
(1/1) Points
CUSTOMER and ORDERS (*)
BABY and AGE
CUSTOMER and PAYMENTS (*)
TEACHER and AGE
11. Intersection Entities are at the ______ end of the newly created 1:M
(Parent:Child) relationship;
(1/1) Points
Child (*)
Parent
Single
Barred
Correct

12. A _________ on a relationship line indicates the Relationship as Non-

Tranferable.
(1/1) Points
Diamond (*)
Circle
Triangle
Star
Correct

13. Transferable relationships can only be mandatory, not optional. True or

False?
(1/1) Points
True
False (*)
Correct

14. Which of the following statements about subtypes is not true?

(1/1) Points
Inherits all relationships of the supertype.
Must have subtypes of its own. (*)
Never exists alone.
Inherits all attributes of the supertype.
Correct

15. Arcs are used to visually represent _________ between two or more

relationships in an ERD.
(0/1) Points
Differences
Inheritance
Exclusivity (*)
Sameness
Incorrect. Refer to Section 3 Lesson 1.
Link: 1-3 questions

Using a database solution instead of a flat file eliminates all of the following issues
except:
-Incorrect data
-Data entry anomalies
-Rednunancy
-Inconsistency
TERM
IMAGE
Incorrect data
DEFINITION
T/F: Business rules help you understand the standardization procedure an
organization follows when handling huge data.
TERM
IMAGE
True
DEFINITION
Business _____ are used to understand business procedures, and the nature, role,
and scope of the data.
TERM
IMAGE
Rules
DEFINITION
Business rules are important because _______.
TERM
IMAGE
They allow the developer to understand the relationship and constraints of the
participating entities
DEFINITION
T/F: All Business Rules can be modeled.
TERM
IMAGE
False
DEFINITION
The advantages of an object-oriented data model are:

-Reduced Maintenance
-Real-World Modeling
-Both of the above
-Neither of the above
TERM
IMAGE
Both of the above
DEFINITION
In a hierarchical database model the data is stored as records that are connected to
one through ________.
TERM
IMAGE
links
DEFINITION
In a __________ database model the data is organized into a tree-like structure and
to retrieve data the whole tree needs to be traversed starting from the root node.
TERM
IMAGE
Hierarchical
DEFINITION
T/F: A network database comprises of a collection of records connected to one
another through links.
TERM
IMAGE
True
DEFINITION
What is the difference between "information" and "data"?
TERM
IMAGE
Data turns into useful information. It is stored in a database and accessed by
systems and users.
DEFINITION
Which transformation in computing allows for storage and delivery of applications
and data over the internet?

-Cloud Computing
-Mainframe computing
-Grid Computing
-Desktop computing
TERM
IMAGE
Cloud Computing
DEFINITION
T/F: A database is a centralized and structured set of data stored on a computer
system and provides facilities for retrieving, adding, modifying, and deleting the data
when required.
TERM
IMAGE
True
DEFINITION
Which of the following transformations in computing led to the increase in graphical
user interface (GUI) applications?

-Mainframe computing
-Desktop computing
-Grid Computing
-Client/Server Computing
TERM
IMAGE
Desktop computing
DEFINITION
Select the business or industry that would not have a need for a database.

-Banking
-Retail
-Scientific Research
-All these businesses could benefit from using a database.
TERM
IMAGE
All these businesses could benefit from using a database.
DEFINITION
Matrix Diagrams are used to verify that all _______________ have been identified
for an ERD.
TERM
 IMAGE
relationships
DEFINITION
In a business that sells pet food, choose the best relationship name between FOOD
TYPE and ANIMAL (e.g. dog, horse, or cat). (Choose Two) (Choose all correct
answers)

-Each ANIMAL must be the seller of one or more FOOD TYPES.

-Each FOOD TYPE may be made from one or more ANIMALS.
-Each FOOD TYPE may be given to one or more ANIMALS.
-Each FOOD TYPE must be suitable for one or more ANIMALS.
TERM
IMAGE
-Each FOOD TYPE may be given to one or more ANIMALS.
-Each FOOD TYPE must be suitable for one or more ANIMALS.
DEFINITION
The optionality of a relationship must be either __________ or ____________.
TERM
IMAGE
Mandatory or Optional
DEFINITION
A relationship can be between ____________.

-two entities
-an entity and itself
-multiple entities
-All of the above.
TERM
IMAGE
All of the above.
DEFINITION
In the relational model, relationships between relations or tables are created by
using?
TERM
IMAGE
Foreign Keys
DEFINITION
Which of the following is not an advantage of a relational database?

-One table with all the data.

-Data Integrity
-Efficiency
-Less Redundancy
TERM
IMAGE
One table with all the data.
DEFINITION
The candidate UID that is chosen to identify an entity is called Primary UID; other
candidates UIDs are called Secondary UIDs.
-No, after UIDs are first sorted, the first one is called the Primary UID, the second is
the Secondary UID, etc.
-No, it is not possible to have more than one UID for an Entity.
-Yes, this is the way UID's are named.
-No, each Entity an only have one UID, the secondary one.
TERM
IMAGE
Yes, this is the way UID's are named.
DEFINITION
A unique identifier made up of more than one attribute is called a _______________.
TERM
IMAGE
Composite UID
DEFINITION
Relationships are mapped in a physical model using ____________ keys and
foreign keys.
TERM
IMAGE
primary
DEFINITION
T/F: A Unique Identifier has a NULL value for each instance of the entity for the
lifetime of the instance.
TERM
IMAGE
False
DEFINITION
T/F: When mapping a relationship for an ERD relationship names must be included.
TERM
IMAGE
True
DEFINITION
Data modelling is performed for the following reasons: (Choose Two) (Choose all
correct answers)

-The ERD becomes a blueprint for designing the actual system.

-We do not need datamodels; we can just start coding right away.
-We draw an ERD solely to please the users; once completed, the ERD is never
referred to again as it serves no purpose in the real world.
-It helps discussions and reviews.
TERM
IMAGE
-The ERD becomes a blueprint for designing the actual system.
-It helps discussions and reviews.
DEFINITION
The _______________ model includes entities, attributes, UIDs, relationships as
well as optionality and cardinality of these items.
TERM
IMAGE
Logical
DEFINITION
T/F: ERDish is a language used to create database structures in SQL
TERM
IMAGE
False
DEFINITION
Which of the following are reasons we create conceptual models?

-It facilitates discussion; a picture is worth a thousand words

-It forms important ideal system documentation
-It takes into account government regulations and laws
-It forms a sound basis for physical database design
-All of the above
TERM
IMAGE
All of the above
DEFINITION
The Physical Model is derived from the Logical Model. True or False?
TERM
IMAGE
True
DEFINITION
The physical model shows all table structures. True or False.
TERM
IMAGE
False
DEFINITION
Which of the following are suitable Entity names? (Choose Two)

-ANIMAL
-DOG
-DOGS
-ANIMALS
TERM
IMAGE
-ANIMAL
-DOG
DEFINITION
Entities are usually _____________.
TERM
IMAGE
Nouns
DEFINITION
Which of the following statements about attributes are true? (Choose Two) (Choose
all correct answers)

-They describe, qualify, quantify, classify, or specify an entity.

-They are the primary container for data.
-They must be single valued unless they belong to more than one entity.
-They are often adjectives
TERM
 IMAGE
-They describe, qualify, quantify, classify, or specify an entity.
-They are often adjectives
DEFINITION
Which symbol is used to show that a particular attribute is mandatory?
&
*
#
o
TERM
IMAGE
*
DEFINITION
A __________________ is frequently used to track information about a relationship
that changes over time.
TERM
IMAGE
intersection entity
DEFINITION
The transformation from an ER diagram to a physical design involves changing
terminology. Primary Unique Identifiers in the ER diagram become __________ and
relationships become ____________.
TERM
IMAGE
Primary keys, Foreign keys
DEFINITION
When mapping a many to many relationship it must first be resolved using
_____________.
TERM
IMAGE
An intersection entity
DEFINITION
Attribute names are converted to column names by _________________.
TERM
IMAGE
Replacing spaces with underscores.
DEFINITION
A table is in 1NF if ... (Choose all correct answers)

-There are no duplicate rows

-There is only one data value.
-The entries in a column are of different type
-Each row contains different columns
TERM
IMAGE
-There are no duplicate rows
-There is only one data value.
DEFINITION
An entity without repeated values is said to be in __________.
TERM
 IMAGE
1st normal form
DEFINITION
When is an entity in 2nd Normal Form?
TERM
IMAGE
When all non-UID attributes are dependent upon the entire UID.
DEFINITION
Normalization is the process of organizing the attributes and entities of a relational
database to minimize ______________

-redundancy
-data inconsistencies
-anomalies
-All of the above.
TERM
IMAGE
All of the above.
DEFINITION
Until all attributes are single-valued, the database model is said to be:
TERM
IMAGE
Not Normalized
DEFINITION
When you resolve a M:M, you simply re-draw the relationships between the two
original entities; no new entities are created. True or False?
TERM
IMAGE
False
DEFINITION
If a relationship can NOT be moved between instances of the entities it connects, it
is said to be:
TERM
IMAGE
Non-Transferable
DEFINITION
A recursive relationship has cardinality of ___________.
TERM
IMAGE
Cannot be determined without more information.
DEFINITION
In an ERD diagram how is an optional relationship represented?
TERM
IMAGE
With a dotted line
DEFINITION
All ER diagrams must have one of each of the following: (Choose two) (Choose all
correct answers)

-Arcs
-Relationships between entities
-At least one supertype and subtype
-One or more Entities
TERM
IMAGE
-Relationships between entities
-One or more Entities
DEFINITION
Data models are drawn to show users the actual Data that their new system will
contain; only Data listed on the Diagram can be entered into the Database. True or
False?
TERM
IMAGE
True
DEFINITION
T/F: A flat file may contain many fields, often, with duplicate data that are prone to
data corruption.
TERM
IMAGE
True
DEFINITION
Once you have learned how to write programs and build systems, you no longer
need any input or involvement from any users as you are perfectly capable of
delivering the systems that businesses need and want. (true/false)
TERM
IMAGE
False. Business requirements can and will change. For instance, new legal
requirements may arise.
DEFINITION
Which of the following is NOT a relationship type?

-One to Many
-Some to None
-Many to Many
-One to One
TERM
IMAGE
Some to None
DEFINITION
When completing the conceptual modeling process we must take into account the
following:

-Business Rules
-Assumptions
-Problems
-All of the above
TERM
IMAGE
All of the above
DEFINITION
The transformations that have occurred in the computing world progressing in this
order:

-Mainframe Computing, Desktop Computing, Grid Computing, Client/Server

Computing.
-Desktop computing, Grid computing, Client/Server computing, Mainframe
computing.
-Grid Computing, Desktop Computing, Mainframe Computing, Client/Server
Computing.
-Mainframe computing, Desktop computing, Client/Server Computing, Grid
computing.

.
TERM
IMAGE
Mainframe computing, Desktop computing, Client/Server Computing, Grid
computing.
DEFINITION
A DBMS comprises of the following elements: (Choose 3)(Choose all correct
answers)

-Query language
-Client
-Data Dictionary
-Memory and Storage Management
TERM
IMAGE
-Query language
-Data Dictionary
-Memory and Storage Management
DEFINITION
T/F: Information is the result of combining, comparing and performing calculations on
data.
TERM
IMAGE
True
DEFINITION
What does single table refer to? (Choose Two) (Choose all correct answers)

-A fully-relational database system like Microsoft's SQL Server or Oracle's database

systems.
-A database where all of the data is stored in one large table.
-A type of database storage method where all of the data elements are stored on top
of each other.
-Non-relational systems that typically store each table and index in separate files and
often do not support the SQL language.
TERM
IMAGE
-A database where all of the data is stored in one large table.
-Non-relational systems that typically store each table and index in separate files and
often do not support the SQL language.
DEFINITION
Which of the following statements about entity relationship diagrams (ERD) is true?

-Used to communicate the physical structure of the database to users.

-Used to communicate the logical structure of the database to users.
-Is a hard and fast document that cannot be changed once development of the
database has begun.
-Used to communicate the technical specifications of the database to users
TERM
IMAGE
Used to communicate the logical structure of the database to users.
DEFINITION
You can only create relationships to a Supertype, not to a Subtype. True or False?
TERM
IMAGE
False
DEFINITION
Which is the first step in the Database Development Process?
TERM
IMAGE
Strategy and Analysis
DEFINITION
T/F: In the relational database model, each table name must be unique. The column
names in the table must be unique too. You can have two different tables that have
column names that are the same.
TERM
IMAGE
True
DEFINITION
The strategies for learning used in this course include:

-Instructor led training

-Industry recognized certification
-Project driven curriculum
-All of the above
TERM
IMAGE
All of the above
DEFINITION
SQL *Plus is being used in the Oracle Academy courses to run SQL code. True or
False?
TERM
IMAGE
True
DEFINITION
The conceptual model does all of the following except:

-Prevents mistakes and misunderstandings.

-Takes into account regulations and laws governing the industry being addressed.
-Describes the needs of the business.
-Documents type of operating system to be used.
TERM
IMAGE
Documents type of operating system to be used.
DEFINITION
An ERD created using ERDish is a __________ representation of entities and their
relationships to each other.
TERM
IMAGE
graphical
DEFINITION
Which of the following is not a goal of ER modeling:

-Locate information in a logical manner

-Capture all required information.
-It is acceptable to include information that is derivable.
-Ensure information appears only once.
TERM
IMAGE
It is acceptable to include information that is derivable.
DEFINITION
Which of the following is not true regarding normalization:

-It helps with the performance of the database.

-It assists in handling insert, update and delete anomalies.
-It does not impact the performance of the database.
-It is the process of organizing the attributes and tables of a relational database to
minimize redundancy.
TERM
IMAGE
It does not impact the performance of the database.
DEFINITION
An ERD is an example of a ______ Model.
TERM
IMAGE
Conceptual
DEFINITION
Many reasons exist for creating a conceptual model. Choose three appropriate
reasons from the options below. (Choose all correct answers)

-They model functional and informational needs.

-They capture the implementation details of the physical model.
-They capture current and future needs.
-They accurately describe what a physical model will contain.
-They capture the data values.
TERM
IMAGE
-They model functional and informational needs.
-They capture current and future needs.
-They accurately describe what a physical model will contain.
DEFINITION
A conceptual model includes:
TERM
IMAGE
Only Entities and Relationships
DEFINITION
Which of the following statements are true? (Choose two) (Choose all correct
answers)

-Flat file database systems pay more attention to retrieving data and making it
accessible to the user, whereas relational databases spend more energy updating
indexes and data pointers.
-Relational database systems are the main thrust behind SQL since it provides the
language elements needed to tie together the information in the database.
-Relational systems pay more attention to retrieving data and making it accessible to
the user.
-Flat file database structures help eliminate redundant information.
TERM
IMAGE
-Relational database systems are the main thrust behind SQL since it provides the
language elements
needed to tie together the information in the database.
-Relational systems pay more attention to retrieving data and making it accessible to
the user.
DEFINITION
Which of the following statements does not apply to relational databases?

-Relational databases are simple to understand.

-Relational databases have a strong procedural orientation.
-Relational databases relate tables to each other using common fields called keys.
-Tables are one of the basic components of relational databases.
TERM
IMAGE
Relational databases are simple to understand.
DEFINITION
What is the purpose of a Unique Identifier?
TERM
IMAGE
To identify one unique instance of an entity by using one or more attributes and/or
relationships.
DEFINITION
A unique identifier must be made up of more than one attribute. True or False?
TERM
IMAGE
False
DEFINITION
Unique Identifiers...
-Distinguish nothing
-Distinguish one entity from another.
-Distinguish one instance of an entity from all other instances of that entity
-Distinguish all entities in a database
TERM
IMAGE
Distinguish one instance of an entity from all other instances of that entity
DEFINITION
People are not born with "numbers", but a lot of systems assign student numbers,
customer IDs, etc. A shoe has a color, a size, a style, but may not have a descriptive
"number." So, to be able to uniquely and efficiently identify one instance of the entity
SHOE, a/an ______________ UID can be created.
TERM
IMAGE
Artificial
DEFINITION
Attributes have Instances. True or False?
TERM
IMAGE
False
DEFINITION
Which of the following entities most likely contains invalid attributes?

-Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built

-Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed
-Entity: Mother. Attributes: Name, Birthdate, Occupation, Number of Children
-Entity: Pet. Attributes: Name, Birthdate, Owner
TERM
IMAGE
Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed
DEFINITION
When creating entities in a logical model you must follow these rules: (Choose Two)
(Choose all correct
answers)

-Exclude Attributes
-Include Attributes
-Name them in Singular
-Name them in Plural
TERM
IMAGE
-Include Attributes
-Name them in Singular
DEFINITION
A/an _________ is a piece of information that in some way describes an entity. It is a
property of the entity and it quantifies, qualifies, classifies, or specifies the entity.
TERM
IMAGE
Attribute
DEFINITION
The components of a relationship include all of the following except:

-Cardinality
-Names
-Optionality
-Relational Integrity
TERM
IMAGE
Relational Integrity
DEFINITION
All relationships participating in an arc must be mandatory. True or False?
TERM
IMAGE
False
DEFINITION
Matrix Diagrams should be developed BEFORE the ERD. True or False?
TERM
IMAGE
True
DEFINITION
T/F: A foreign key is a column or combination of columns in one table that uniquely
identifies a row of another table.
TERM
IMAGE
True
DEFINITION
Intersection Entities are at the ______ end of the newly created 1:M (Parent:Child)
relationship;
TERM
IMAGE
Barred
DEFINITION
A _________ on a relationship line indicates the Relationship as Non-Tranferable.
TERM
IMAGE
Diamond
DEFINITION
Many to many relationships must be left in the Model. It is important to have them
documented as M-M.
True or False?
TERM
IMAGE
False
DEFINITION
Which of the following pairs of entities is most likely to be modeled as a M:M
relationship?

-TEACHER and SUBJECT AREA

-PERSON and FINGERPRINT
-TREE and BRANCH
-CAR and WHEEL
TERM
IMAGE
TEACHER and SUBJECT AREA
DEFINITION
Which of the following is true about subtypes?

-Subtypes should not be exhaustive.

-Subtypes must not be mutually exclusive.
-One instance of a supertype may belong to two subtypes.
-Subtypes must be mutually exclusive.
TERM
IMAGE
Subtypes must be mutually exclusive.
DEFINITION
Which of the following would be a logical constraint when modeling time for a City
entity?

-Daily traffic patterns must be monitored to determine how many law enforcement
officers are needed.
-If you are doing a system for any French City, you would need security clearance.
-People are born in the city and people die in the city.
-Cites may change their names and/or country association if the borders of a country
change.
TERM
IMAGE
Cites may change their names and/or country association if the borders of a country
change.
DEFINITION
T/F: If there is a column missing in an entity - normalization should identify this
problem.
TERM
IMAGE
True
DEFINITION
The "Other" subtype is mandatory. True or False?
TERM
IMAGE
True
DEFINITION
Can all constraints be modeled on an ER diagram?
TERM
IMAGE
No, and those that cannot be modeled should be listed on a separate document to
be handled programmatically
DEFINITION
According to ___________, an attribute must be dependent on its entity's entire
unique identifier.
TERM
IMAGE
2nd normal form
DEFINITION
Sources of business rules include all of the following except:

-Standards
-Word of mouth
-Procedures
-Operational manuals
TERM
IMAGE
Word of mouth
DEFINITION
Table names can contain all of the following except:

-Some special characters

-Letters
-Numbers
-Spaces
TERM
IMAGE
Spaces
DEFINITION
In a physical data model, a relationship is represented as a combination of: (Choose
Two)
(Choose all correct answers)

-Check Constraint or Unique Key

-Column
-Primary Key or Unique Key
-Foreign Key
TERM
IMAGE
-Primary Key or Unique Key
-Foreign Key
DEFINITION
T/F: When mapping a barred relationship a primary key and foreign key can be the
same field.
TERM
IMAGE
True
DEFINITION
T/F: A table is in 3NF if it has met all database requirements for both 1NF and 2NF
and all transitive dependencies
are eliminated.
TERM
IMAGE
True
DEFINITION

TERM
 IMAGE

DEFINITION
+ ADD CARD

Test: DFo Database Foundations Midterm Exam

Review your answers, feedback, and question scores below. An asterisk (*)
indicates a correct answer.

Section 1
(Answer all questions in this section)

1. A ___________ model describes a database in terms of tables, columns, and joins
between tables.

(1/1) Points

Network

Hierarchical

Object Oriented

Relational (*)
Correct

2. The advantages of an object-oriented data model are:

(1/1) Points

Reduced Maintenance

Real-World Modeling

Both A and B. (*)

Neither A or B.
Correct

3. In a hierarchical database model the data is stored as records that are connected to
one another through ________.

(1/1) Points
databases

primary keys

fields

links (*)
Correct

4. Which is the first step in the Database Development Process ?

(1/1) Points

Strategy and Analysis (*)

Build

Testing

Design
Correct

5. A database interacts with the data and provides the following facilities:

(1/1) Points

Retrieving data

Inserting data

Deleting data

All of the above. (*)

Correct

6. A DBMS comprises of the following elements: (Choose 3)

(1/1) Points
Client
Query language (*)
Memory and Storage Management (*)
Data Dictionary (*)
Correct

7. Information is the result of combining, comparing and performing calculations

on data.
(1/1) Points
True (*)
False
Correct

8. The transformations that have occurred in the computing world progressing

in this order:
(1/1) Points
Mainframe Computing, Desktop Computing, Grid Computing, Client/Server
Computing.
Grid Computing, Desktop Computing, Mainfram Computing, Client/Server
Computing
Desktop computing, Grid computing, Client/Server computing, Mainframe
computing.
Mainframe computing, Desktop computing, Client/Server Computing, Grid
computing. (*)
Correct

9. The main subject areas taught by the Oracle Academy are:

(1/1) Points
Data Modeling, SQL, and PL/SQL (*)
Database performance tuning
Systems programming and computer architecture
Computer Repairs
Correct

10. The technical software requirements for this course include all of the
following except:
(1/1) Points
Oracle SQL Developer Data Modeler
Microsoft Access (*)
Oracle APEX application
All are requirements.
Correct
11. Business ______ are used to understand business processes, and the nature,
role, and scope of the data.
(1/1) Points
Mission Statements
Rules (*)
Goals
Processes
Correct

12. Once you have learned how to write programs and build systems, you no
longer need any input or involvement from any users as you are perfectly
capable of delivering the systems that businesses need and want.
(1/1) Points
True. Users delay the delivery of a system by changing their minds and adding
new requirements.
False. Business requirements can and will change. For instance new legal
requirements may arise. (*)
True. Users never know what they want anyway, so building systems is best left
to the professionals.
True. The only requirement for creating a perfect system is a perfect
programmer.
Correct

13. Business rules are important because_________.

(1/1) Points
They can become outdated quickly.
They allow the developer to understand the relationship and constraints of the
participating entities (*)
They can all be incorporated into the database design structure.
They are complex and difficult to understand.
Correct

14. The reason or drive for using databases rather than files has been …
(Choose 3)
(1/1) Points
Availability of data to a diverse set of users (*)
Use of blocks
Integration of data for easier access and modification for complex
transactions (*)
Reduced redundancy of data (*)
Correct

15. When completing the conceptual modeling process we must take into

account the following:
(1/1) Points
Business Rules
Assumptions
Problems
All of the above (*)
Correct
Section 2
(Answer all questions in this section)

16. Which of the following are suitable Entity names? (Choose Two)

(1/1) Points

ANIMALS

DOGS

ANIMAL (*)

DOG (*)
Correct

17. To identify an attribute as part of a unique identifier on an ER diagram, the # symbol

goes in front of it. True or False?

(1/1) Points

True (*)

False
Correct

18. Entity names are always singular. True or False?

(1/1) Points

True (*)

False
Correct

19. When creating entities in a logical model you must follow these rules: (Choose Two)

(1/1) Points

Name them in Plural

Include Attributes (*)

Name them in Singular (*)

Exclude Attributes
Correct

20. Primary UIDs are:

(1/1) Points

Optional in data modeling.

Useful as an alternative means of identifying instances of an entity, independent of their

datatype

Mandatory in data modeling (*)

Always comprised of numbers

Correct

21. The candidate UID that is chosen to identify an entity is called the Primary
UID; other candidate UIDs are called Secondary UIDs.
(1/1) Points
Yes, this is the way UID's are named. (*)
No, each Entity can only have one UID, the secondary one.
No, it is not possible to have more than one UID for an Entity.
No, after UIDs are first sorted, the first one is called the Primary UID, the second
is the Secondary UID, etc.
Correct

22. All entities must be given a new artificial UID. True or False?

(1/1) Points
True
False (*)
Correct

23. People are not born with “numbers”, but a lot of systems assign student
numbers, customer IDs, etc. A shoe has a color, a size, a style, but may not have
a descriptive “number". So, to be able to uniquely and efficiently identify one
instance of the entity SHOE, a/an ______________ UID can be created.
(1/1) Points
Artificial (*)
Structured
Unrealistic
Identification
Correct

24. In an ERD diagram how is cardinality represented ? (Choose two)

(0/1) Points
With a solid line
With a crow's foot (*)
With a single toe (*)
With a dotted line
Incorrect. Refer to Section 2 Lesson 6.

25. Using ERDish, which wording represents optionality? (Choose Two)

(1/1) Points
must (*)
mandatory
maybe
may (*)
Correct
26. ERDish is a language used to create database structures in SQL
(1/1) Points
True
False (*)
Correct

27. Data modeling is performed for the following reasons: (Choose Two)

(1/1) Points
It helps discussions and reviews. (*)
We draw an ERD solely to please the users; once completed, the ERD is never
referred to again as it serves no purpose in the real world.
The ERD becomes a blueprint for designing the actual system. (*)
We do not need datamodels; we can just start coding right away.
Correct

28. In a relational database system, the next step after creating a conceptual
data model is to convert it to a _________ .
(1/1) Points
Internal data model
External data model
Logical data model (*)
An entity-relation data model
Correct

29. A logical model includes :

(1/1) Points
Only Entities and Relationships
Only Entities, Attributes and Unique Identifiers
Only Entities, Attributes and Relationships
Entities, Attributes, Unique Identifiers and Relationships (*)
Correct

30. The logical model's entities, attributes, unique identifiers and relationships

map to the physical model's _________________.
(1/1) Points
Optionality and Cardinality
Files, records, fields and data values
Tables, columns, primary keys and foreign keys (*)
Correct
31. In a relationship , _________ are used to helped describe the meaning of the
connection between the entities.
(1/1) Points
names (*)
descriptions
crows feet
arrows
Correct

32. If a relationship is mandatory there must be at least one instance of the

corresponding entity related to it.
(1/1) Points
True (*)
False
Correct

33. Matrix Diagrams are used to verify that all ____________ have been identified
for an ERD.
(1/1) Points
relationships (*)
keys
entities
attributes
Correct

34. Which of the following are true about Cardinality? (Choose two)

(1/1) Points
Cardinality tells "how many". (*)
Cardinality specifies whether something is required or not.
Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
Cardinality specifies only singularity or plurality, but not a specific plural
number. (*)
Correct

35. A _______ is a collection of records.

(1/1) Points
column
row
table (*)
field
Correct
36. Flat file databases avoids data duplication. True or False?

(1/1) Points

True

False (*)
Correct

Section 3
(Answer all questions in this section)

37. All instances of the supertype _____ be an instance of one of the subtypes.

(0/1) Points

may

must (*)

cannot

will sometimes
Incorrect. Refer to Section 3 Lesson 1.

38. Which of the following would best be represented by an arc?

(1/1) Points

TEACHER (Female, Bob)

PARENT (Girl, Bob)

DELIVERY ADDRESS (Home, Office) (*)

STUDENT (Grade A student, Average Student)

Correct
39. A recursive relationship has cardinality of ___________.

(0/1) Points

Many to Many

Cannot be determined without more information. (*)

One to One

One to Many
Incorrect. Refer to Section 3 Lesson 1.

40. Intersection Entities often have the relationships participating in the UID, so the
relationships are often barred. True or False?

(1/1) Points

True (*)

False
Correct

41. A non-transferable relationship means the detail _____ be changed to point to

a new master.
(1/1) Points
sometimes can
can
can not (*)
Correct

42. Table names can contain all of the following except:

(1/1) Points
Some special characters
Spaces (*)
Numbers
Letters
Correct
43. Relationships are mapped in a physical model using ____________ keys and
foreign keys.
(1/1) Points
unique
composite
primary (*)
secondary
Correct

44. The transformation from an ER diagram to a physical design involves

changing terminology. Primary Unique Identifiers in the ER diagram become
__________ and relationships become ____________.
(0/1) Points
Foreign keys, Primary keys
Primary keys, Foreign keys (*)
Foreign keys, mandatory business rules
Unique Keys, Primary keys
Incorrect. Refer to Section 3 Lesson 4.

45. When data is only stored in one place in a database, the database conforms
to the rules of ___________.
(1/1) Points
Normalization (*)
Reduction
Multiplication
Normality
Correct
46. A table is in 2NF if
(0/1) Points
It meets the requirements for the 1 NF.
Each non-key attribute is fully functional dependent on the table's primary key.

Both A and B must be true. (*)

Neither A or B must be true.
Incorrect. Refer to Section 3 Lesson 3.
47. A table is in 3NF if it has met all database requirements for both 1NF and
2NF and all transitive dependencies are eliminated.
(1/1) Points
True (*)
False
Correct

48. Until all attributes are single-valued, the database model is said to be:
(1/1) Points
in 2nd Normal Form
in 1st Normal Form
Normalized
Not Normalized (*)
Correct

49. Can all constraints be modeled on an ER diagram?

(0/1) Points
No, and those that cannot be modeled should be listed on a separate document
to be handled programmatically (*)
Yes, all constraints must be modeled and shown on the ER diagram
No, but you just explain them to the users so they can enforce them
No, in which case you should let the database administrator handle them
Incorrect. Refer to Section 3 Lesson 3.

50. Modeling historical data is optional. True or False?

(1/1) Points
True (*)
False

Sections 4 and 5 Quiz

(Answer all questions in this section)
1. The glossary can be used as the naming standard for your Logical Model.
(1/1) Points
True (*)
False
Correct
2. Each attribute in an entity maps to a _________ in a table.
(1/1) Points
column (*)
instance
row
primary key
Correct

3. A ___________ model is the blue print to the actual database implementation
and can be used as the basis for implementing any type of Database
Management System (DBMS).
(1/1) Points
Relational (*)
Logical
Database
Conceptual
Correct

4. A ______________ in Oracle SQL Developer Data Modeler is a set of accepted

terms that can be used in the design.
(1/1) Points
validation rule
table
glossary (*)
template
Correct

5. Primary key constraints are named using the __________________.

(1/1) Points
full table name
foreign key name
table short name (*)

UID suffix

6. To use the Oracle SQL Developer Data Modeler to apply naming standards :
(1/1) Points
Use a .docx file constaining table names and abbreviations
Use a .csv file constaining table names and abbreviations (*)
Use a .accdb file constaining table names and abbreviations
None of the above.
Correct

7. We can apply naming abbreviations using the .csv file containing the
abbreviations
(1/1) Points
True (*)
False
Correct

8. Primary key constraints should have a suffix of PKEY.

(1/1) Points
True
False (*)
Correct

9. The Oracle SQL Data Modeler enables you to do all of the following except:
(1/1) Points
Store application data (*)
Create process, logical, relational and physical models
Capture business rules and information
Store metadata information
Correct

10. Which of the following cannot be modeled using the Oracle SQL Data
Modeler ?
(1/1) Points
Entities, attributes, UIDs
Supertype and subtype entities
Recursive Relationships
Arc relationships
All can be modeled. (*)
Correct
11. When building a model in Oracle SQL Data Modeler you begin in the ________
tab.
(1/1) Points
Conceptual
Relational
Physical
Logical (*)
Correct

12. The steps to convert a Relational model to a Logical model using the Oracle
SQL Developer Data Modeler are :
(0/1) Points
Select the Relational model, Accept defaults, Click the Engineer to Logical Model
icon, Click Engineer
Click the Engineer to Relational Model icon, Select the Logical model, Click
Engineer, Accept defaults.
Select the Relational model, Click the Engineer to Logical Model icon, Accept
defaults, Click Engineer (*)
None of the above.
Incorrect. Refer to Section 4 Lesson 2.

13. Converting a Relational model to a Logical model is called reverse

engineering.
(1/1) Points
True (*)
False
Correct

14. _______ Engineering is the process of creating a conceptual or logical model

by extracting the information from an existing data source.
(0/1) Points
Target
Reverse (*)
Top-Down
Forward
Incorrect. Refer to Section 4 Lesson 2.
15. When creating a database based on extracting metadata from an existing
database or using the DDL code obtained from an implementation of an existing
database, which data modeling approach would you choose?
(1/1) Points
Top-Down Modeling
Target Modeling
You cannot model this.
Bottom-Up Modeling (*)
Correct
4-5 links: https://quizlet.com/_5zbykc?x=1jqt&i=3qlb1n

https://quizlet.com/_62cv8n?x=1jqt&i=3qlb1n

The Oracle SQL Data Modeler enables you to do all of the following except:
TERM
IMAGE
Store application data
DEFINITION
When building a model in Oracle SQL Data Modeler you begin in the ________ tab.
TERM
IMAGE
Logical
DEFINITION
In Oracle SQL Developer Data Modeler you can select how you want to map your subtypes.
TERM
IMAGE
True
DEFINITION
Constraints should be given meaningful names to make them easier to reference.
TERM
IMAGE
True
DEFINITION
To use the Oracle SQL Developer Data Modeler to apply naming standards :
TERM
IMAGE
Use a .csv file containing table names and abbreviations
DEFINITION
Primary key constraints should have a suffix of PKEY.
TERM
IMAGE
False
DEFINITION
A ______________ in Oracle SQL Developer Data Modeler is a set of accepted terms that
can be used in the design.
TERM
IMAGE
glossary
DEFINITION
A ___________ model is the blue print to the actual database implementation and can be
used as the basis for implementing any type of Database Management System (DBMS).
TERM
IMAGE
Relational
DEFINITION
Each attribute in an entity maps to a _________ in a table.
TERM
IMAGE
column
DEFINITION
A Relational model is closer to the implementation solution, facilitates discussion and forms
the basis for the physical database design.
TERM
IMAGE
True
DEFINITION
When creating a database based on extracting metadata from an existing database or using the
DDL code obtained from an implementation of an existing database, which data modeling
approach would you choose?
TERM
IMAGE
Bottom-Up Modeling
DEFINITION
Converting a Relational model to a Logical model is called reverse engineering.
TERM
IMAGE
True
DEFINITION
The steps to convert a Relational model to a Logical model using the Oracle SQL Developer
Data Modeler are :
TERM
IMAGE
Select the Relational model, Click the Engineer to Logical Model icon, Accept defaults, Click
Engineer
DEFINITION
________ Engineering is the process of transforming a Logical Data Model to a Relational
Model.
TERM
IMAGE
Forward
DEFINITION
Top-Down Modeling is the approach taken for designing a new database.
TERM
IMAGE
True
DEFINITION
To define naming templates in Oracle SQL Data Modeler:
TERM
IMAGE
Right click the name of the design in object browser, Select properties, select template, Edit
the template to use abbreviations
DEFINITION
You can define naming standards in Oracle SQL Developer Data Modeler using
_______________.
TERM
IMAGE
Glossary, Naming Templates, Design Rule Validations
DEFINITION
When mapping subtypes to tables we can ________
TERM
IMAGE
Either one or multiple tables are valid options.
DEFINITION
Each of the following can be modeled using the Oracle SQL Data Modeler ?
TERM
IMAGE
Entities, attributes, UIDs, Supertype and subtype entities, Recursive Relationships, Arc
relationships
DEFINITION
Foreign key constraints are named using the ______________ of both tables.
TERM
IMAGE
short table name
DEFINITION
Primary key constraints are named using the __________________.
TERM
IMAGE
UID Suffix
DEFINITION
In Oracle SQL Data Modeler, the attribute that you assign as primary UID is automatically
set to a mandatory attribute and will be engineered to a primary key in the relational model.
TERM
IMAGE
True
DEFINITION
A column or combination of columns in one table that refers to a primary key in the same or
another table.
TERM
IMAGE
Foreign Key
DEFINITION
The steps to convert a Logical model to a Relational model using the Oracle SQL Developer
Data Modeler are :
TERM
IMAGE
Select the Logical model, Click the Engineer to Relational Model icon, Accept
defaults, Click Engineer

Which of the following cannot be modeled using the Oracle SQL Data Modeler?
-Entities, attributes, UIDs
-Supertype and subtype entities
-Recursive Relationships
-Arc relationships
-All can be modeled.
TERM
IMAGE
-All can be modeled.
DEFINITION
When building a model in Oracle SQL Data Modeler you begin in the ________ tab.
TERM
IMAGE
logical
DEFINITION
The Oracle SQL Data Modeler enables you to do all of the following except:
-Store application data
-Create process, logical, relational and physical models
-Store metadata information
-Capture business rules and information
TERM
IMAGE
-Store application data
DEFINITION
You can define naming standards in Oracle SQL Developer Data Modeler using
_______________.
-Glossary
-Naming Templates
-Design Rule Validations
-All of the above can be used to define naming standards in Oracle SQL Data
Modeler.
TERM
IMAGE
-All of the above can be used to define naming standards in Oracle SQL Data
Modeler.
DEFINITION
The glossary can be used as the naming standard for your Logical Model.
(true/false)
TERM
IMAGE
true
DEFINITION
Each attribute in an entity maps to a _________ in a table.
TERM
IMAGE
column
DEFINITION
The steps to create a glossary from an existing Logical model are
TERM
IMAGE
Right click Logical model, select Create Glossary from Logical Model
DEFINITION
You must first select the Logical model you want to work with to Engineer it to a
Relational model. (true/false)
TERM
IMAGE
true
DEFINITION
A Relational model is closer to the implementation solution, facilitates discussion and
forms the basis for the physical database design. (true/false)
TERM
IMAGE
true
DEFINITION
Converting a Relational model to a Logical model is called reverse engineering.
(true/false)
TERM
IMAGE
true
DEFINITION
The steps to convert a Relational model to a Logical model using the Oracle SQL
Developer Data Modeler are
TERM
IMAGE
Select the Relational model, Click the Engineer to Logical Model icon, Accept
defaults, Click Engineer
DEFINITION
Primary key constraints should have a suffix of PKEY. (true/false)
TERM
IMAGE
false
DEFINITION
To define naming templates in Oracle SQL Data Modeler:
-Right click the name of the design in object browser
-Select properties, select template
-Edit the template to use abbreviations
-Do all of these steps.
TERM
IMAGE
-Do all of these steps.
DEFINITION
To use the Oracle SQL Developer Data Modeler to apply naming standards
TERM
IMAGE
Use a .csv file containing table names and abbreviations
DEFINITION
In Oracle SQL Developer Data Modeler you can select how you want to map your
subtypes. (true/false)
TERM
IMAGE
true
DEFINITION
Constraints should be given meaningful names to make them easier to reference.
(true/false)
TERM
IMAGE
true
DEFINITION
________ Engineering is the process of transforming a Logical Data Model to a
Relational Model.
TERM
IMAGE
forward
DEFINITION
The steps to convert a Logical model to a Relational model using the Oracle SQL
Developer Data Modeler are:
TERM
IMAGE
Select the Logical model, Click the Engineer to Relational Model icon, accept
defaults, Click Engineer
DEFINITION
Foreign key constraints are named using the ______________ of both tables.
TERM
IMAGE
short table name
DEFINITION
Primary key constraints are named using the __________________.
TERM
IMAGE
table short name
DEFINITION
In Oracle SQL Data Modeler, the attribute that you assign as primary UID is
automatically set to a mandatory attribute and will be engineered to a primary key in
the relational model. (true/false)
TERM
IMAGE
true
DEFINITION
A ___________ model is the blue print to the actual database implementation and
can be used as the basis for implementing any type of Database Management
System (DBMS).
TERM
IMAGE
relational
DEFINITION
A ______________ in Oracle SQL Developer Data Modeler is a set of accepted
terms that can be used in the design.
TERM
IMAGE
glossary
DEFINITION
_______ Engineering is the process of creating a conceptual or logical model by
extracting the information from an existing data source.
TERM
IMAGE
forward
DEFINITION
We can apply naming abbreviations using the .csv file containing the abbreviations
(true/false)
TERM
IMAGE
true
DEFINITION
An Entity Relationship model does not highlight the physical and database
constraints. It is essential to transform the ER model into a relational model which
can serve as the basis for defining the physical implementation of the database.
(true/false)
TERM
IMAGE
true
DEFINITION
When creating a database based on extracting metadata from an existing database
or using the DDL code obtained from an implementation of an existing database,
which data modeling approach would you choose?
TERM
IMAGE
Bottom-Up Modeling
DEFINITION
When mapping subtypes to tables we can ________
TERM
IMAGE
use either one or multiple tables are valid options.
DEFINITION
Top-Down Modeling is the approach taken for designing a new database. (true/false)
TERM
IMAGE
true
DEFINITION
A column or combination of columns in one table that refers to a primary key in the
same or another table.
TERM
IMAGE
Foreign Key
DEFINITION
Section 6 Quiz 1 L1-L4
(Answer all questions in this section)
1. Structured Query Language (SQL) is the set-based, declarative language used
to access data in an Oracle database.
(1/1) Points
True (*)
False
Correct

2. A __________ can be found at the intersection of a row and column and
contains one value.
(1/1) Points
field (*)
table
instance
entity
Correct

3. Which software is used to manage reading and manipulating a relational

database ?
(0/1) Points
ERD software
Flat file software
Spreadsheet software
DBMS software (*)
Incorrect. Refer to Section 6 Lesson 2.

4. All of the following are stages of SQL Processing except:

(1/1) Points
Row Source Generation
Execution
Parsing
Optimization
All of the above options are stages of SQL processing. (*)
Correct

5. When you _______ a table, the database loses all the data in the table.
(1/1) Points
ALTER
DROP (*)
SELECT
ERASE
Correct
6. You can name a constraint or the Oracle server generates a name by using the
SYS_Cn format.
(1/1) Points
True (*)
False
Correct

7. ___________ constraints can only be created at the column level.

(1/1) Points
Primary Key
Not Null (*)
Unique
Check
Correct

8. To issue a CREATE TABLE statement, you must have the __________ privilege.
(1/1) Points
DISTRIBUTE TABLE
CREATE TABLE (*)
Both
None
Correct

9. You can upload and save a SQL Script from the _____________ option.
(1/1) Points
Utilities
RESTful Services
SQL Commands
Object Browser
SQL Scripts (*)
Correct

10. To see all the fields and records in the employees table you can run the
following query :
(1/1) Points
SELECT all FROM employees;
SELECT columns FROM employees;
SELECT * FROM employees; (*)
SELECT # FROM employees;
None of the above.
Correct
11. To use a computer application you must understand how it is built and how
it works inside.
(1/1) Points
True
False (*)
Correct

12. Application programs enable us to ________.

(1/1) Points
Check email.
Create documents
Edit photogrphs
All of the above. (*)
Correct

13. You can delete a row that contains a primary key that is used as a foreign key
in another table.
(1/1) Points
True
False (*)
Correct

14. ___________________ is used to add, modify and delete data.

(1/1) Points
Data Definition Language
Data Control Language
Data Manipulation Language (*)
Data Management Language
Correct

15. When you have constraints in place on columns, an error is returned if you

try to violate the constraint rule.
(1/1) Points
True (*)
False

Links https://quizlet.com/_655pdq?x=1jqt&i=3qlb1n
https://quizlet.com/_6g41ih?x=1jqt&i=3qlb1n
https://quizlet.com/_5zbd0m?x=1jqt&i=3qlb1n

T/F: Converting a Relational model to a Logical model is called reverse engineering.

TERM
IMAGE
True
DEFINITION
The steps to convert a Relational model to a Logical model using the Oracle SQL
Developer Data
Modeler are:
Select the Relational model, Accept defaults, Click the Engineer to Logical Model
icon,
Click Engineer
Click the Engineer to Relational Model icon, Select the Logical model, Click
Engineer,
Accept defaults.
Select the Relational model, Click the Engineer to Logical Model icon, Accept
defaults,
Click Engineer
None of the above.
TERM
IMAGE
Select the Relational model, Click the Engineer to Logical Model icon, Accept
defaults,
Click Engineer
DEFINITION
When building a model in Oracle SQL Data Modeler you begin in the ________ tab.
TERM
IMAGE
Logical
DEFINITION
The Oracle SQL Data Modeler enables you to do all of the following except:
Store metadata information
Create process, logical, relational and physical models
Capture business rules and information
Store application data
TERM
IMAGE
Store application data
DEFINITION
T/F: In Oracle SQL Developer Data Modeler you can select how you want to map
your subtypes.
TERM
IMAGE
True
DEFINITION
When mapping subtypes to tables we can ________
Use one table
Use multiple tables
Either one or multiple tables are valid options.
Neither one or multiple tables are valid options.
TERM
IMAGE
Either one or multiple tables are valid options.
DEFINITION
The steps to create a glossary from an existing Logical model are:
Right click Logical model, select Create Glossary from Logical Model
Double click the Logical Model
Rick click the Relational model, select Create Glossary from Relational Model
None of the above.
TERM
IMAGE
Right click Logical model, select Create Glossary from Logical Model
DEFINITION
T/F: An Entity Relationship model does not highlight the physical and database
constraints. It is essential
to transform the ER model into a relational model which can serve as the basis for
defining the physical
implementation of the database.
TERM
IMAGE
True
DEFINITION
_______ consistency guarantees a consistent view of the data at all times.
TERM
IMAGE
Read
DEFINITION
A database transaction consists of the following except:
One TCL Statement
DML statements representing one consistent change to the data
SELECT queries
One DDL Statement
TERM
 IMAGE
SELECT queries
DEFINITION
T/F: The Oracle server ensures data consistency based on transactions.
TERM
IMAGE
True
DEFINITION
An automatic commit occurs when _________ . (Choose 2)(Choose all correct
answers)
A TCL statement is executed.
A DML statement is executed.
SELECT statement is executed.
A DDL statement is executed.
TERM
IMAGE
A TCL statement is executed.
A DDL statement is executed.
DEFINITION
T/F: Top-n-analysis is used when you want to retrieve only the top number of records
from a result set.
TERM
IMAGE
True
DEFINITION
Which character is used as a substitution variable in APEX?
TERM
IMAGE
: (a colon)
DEFINITION
T/F: The ORDER BY clause must be placed before the WHERE clause in a SQL
statement.
TERM
IMAGE
False
DEFINITION
T/F: Substitution variables are used when you want to prompt for different criteria in
a condition.
TERM
IMAGE
True
DEFINITION
Oracle Application Express is an application platform used to share and learn _____
and __________.
TERM
IMAGE
SQL, PL/SQL
DEFINITION
You can use Application Express (APEX) for
TERM
 IMAGE
Developing and expanding your skills with Oracle database, SQL and PL/SQL
DEFINITION
T/F: In the SQL Commands option of APEX, you can run more than one SQL
command at a time.
TERM
IMAGE
False
DEFINITION
T/F: When you define a table, you can specify that a column should be given a
default value by using
the LITERAL option.
TERM
IMAGE
False
DEFINITION
Once you have created a table, you can use the ________________ command to
confirm that it was created. (Choose 2) (Choose all correct answers)
ORDER BY
SELECT
LIST
DESCRIBE
TERM
IMAGE
SELECT
DESCRIBE
DEFINITION
When altering a table, you can decrease the width of a column if ...(Choose 3)
(Choose all correct
answers)
The table has no rows
The decrease in column width is not less than the existing values in that column
The column contains only null values
The column contains numeric values
TERM
IMAGE
The table has no rows
The decrease in column width is not less than the existing values in that column
The column contains only null values
DEFINITION
DDL means:
TERM
IMAGE
Data Definition Language
DEFINITION
The Data Definition Language performs all of the following except:
Add constraints to tables
Insert data into tables
Alter tables
Create tables
TERM
IMAGE
Insert data into tables
DEFINITION
You can link columns to other columns, arithmetic expressions, or constant values to
create a character expression by using the ____________ operator (||).
TERM
IMAGE
concatenation
DEFINITION
By default column aliases appear _________.
TERM
IMAGE
Upper case
DEFINITION
T/F: Literals can be used within a SELECT statement.
TERM
IMAGE
True
DEFINITION
The following statement will result in an error (True or False): SELECT last_name
"Name" , salary*12 "Annual Salary", salary +100 FROM employees;
TERM
IMAGE
False
DEFINITION
Which column alias is invalid?
First Name
"First Name"
"FIRST NAME"
First_Name
TERM
IMAGE
First Name
DEFINITION
You can display selected columns of a table by listing them in the __________
clause.
TERM
IMAGE
SELECT
DEFINITION
T/F: The CARTESIAN or CROSS join gets created when a join condition is omitted.
TERM
IMAGE
True
DEFINITION
Which of the following statements is syntactically correct?
SELECT e.employee_id, e.last_name, e.department_id, d.department_id,
d.location_id
FROM employees e JOIN departments d ON (e.department_id = d.department_id)
AND
e.manager_id = 149 ;
SELECT e.employee_id, e.last_name, e.department_id, d.department_id,
d.location_id
FROM employees e JOIN departments d ON (e.department_id = d.department_id)
WHERE
e.manager_id = 149;
Both statements are syntactically correct.
Neither statement is syntactically correct.
TERM
IMAGE
Both statements are syntactically correct.
DEFINITION
T/F: We must use the ON clause to join three tables.
TERM
IMAGE
Answer Key: False
But uhhh, pretty sure 'tis true.
DEFINITION
A _______ clause creates an equijoin between two tables using one column with the
same name, regardless of the data type.
TERM
IMAGE
USING
DEFINITION
T/F: A join between two tables that returns the results of the INNER join as well as
the unmatched rows from the left (or right) table is called a left (or right) OUTER join.
TERM
IMAGE
True
DEFINITION
T/F: A self-join can be used when there are two fields with the same data on a table
that have different meanings.
TERM
IMAGE
True
DEFINITION
To connect to an Oracle database you need to use a client program. True or False?
TERM
IMAGE
True
DEFINITION
Relational Databases store data in a two-dimensional matrix known as a _________.
TERM
IMAGE
table
DEFINITION
The stages of SQL processing are Parsing, Optimization, Row Source Generation
and _____________ .
TERM
IMAGE
Execution
DEFINITION
You can logically relate data from multiple tables using ___________.
TERM
IMAGE
foreign keys
DEFINITION
Any column that is not listed explicitly obtains a null value in the new row unless we
have _________ values for the missing columns that are used.
TERM
IMAGE
DEFAULT
DEFINITION
Data Manipulation Language includes all of the following except:
DELETE
COMMIT
INSERT
UPDATE
TERM
IMAGE
COMMIT
DEFINITION
T/F: The TRUNCATE statement is a data definition language (DDL) statement and
generates no rollback information.
TERM
IMAGE
True
DEFINITION
___________________ is used to add, modify and delete data.
TERM
IMAGE
Data Manipulation Language
DEFINITION
T/F: When you have constraints in place on columns, an error is returned if you try to
violate the constraint rule.
TERM
IMAGE
True
DEFINITION
You use the ______ operator to perform wildcard searches of valid search string
values.
TERM
IMAGE
LIKE
DEFINITION
According to the rules of precedence which operator will be evaluated first?
AND
OR
Both are on the same level of precedence.
TERM
IMAGE
AND
DEFINITION
The ______ operator requires either of the component conditions to be true.
AND
BETWEEN
EITHER
OR
TERM
IMAGE
OR
DEFINITION
T/F: Character strings and dates in the WHERE clause must be enclosed with single
quotation marks
TERM
IMAGE
True
DEFINITION
What is the result of executing the following statement: SELECT EMPLOYEE_ID,
LAST_NAME, JOB_ID, DEPARTMENT_ID AS "DEPTID" FROM EMPLOYEES
WHERE DEPARTMENT_ID = 90 ;
-Displays the EMPLOYEE_ID, LAST_NAME, JOB_ID, DEPARTMENT_ID, DEPTID
from the EMPLOYEES table where the department id is 90.
-Displays the EMPLOYEE_ID, LAST_NAME, JOB_ID, DEPARTMENT_ID from the
EMPLOYEES table where the department id is 90.
-Prompts the user for additional information.
-Throws an error
TERM
IMAGE
no correct answers???
[https://classroom.google.com/c/MTc2MTU5MjU3NjVa/m/MzA0OTM1ODEyMDRa/d
etails]
I think it's the second one (the one without DEPTID)
DEFINITION
T/F: In Oracle SQL Data Modeler, the attribute that you assign as primary UID is
automatically set to a mandatory attribute and will be engineered to a primary key in
the relational model.
TERM
IMAGE
True
DEFINITION
T/F: Top-Down Modeling is the approach taken for designing a new database.
TERM
IMAGE
True
DEFINITION
________ Engineering is the process of transforming a Logical Data Model to a
Relational Model.
TERM
IMAGE
Forward
DEFINITION
To define naming templates in Oracle SQL Data Modeler:
Right click the name of the design in object browser
Select properties, select template
Edit the template to use abbreviations
Do all of these steps.
TERM
IMAGE
Do all of these steps.
DEFINITION
T/F: The glossary can be used as the naming standard for your Logical Model.
TERM
IMAGE
True
DEFINITION
Why will the following statement result in an error?
SELECT l.city, d.department_name FROM locations l JOIN departments d USING
(location_id) WHERE d.location_id = 1400;
WHERE clause cannot be used in a query with USING.
The field in the USING clause cannot have a qualifier.
Syntax of the USING clause is incorrect.
There is nothing wrong - this will run correctly.
TERM
IMAGE
The field in the USING clause cannot have a qualifier.
DEFINITION
The ___________ JOIN clause produces the cross-product of two tables.
TERM
IMAGE
CROSS
DEFINITION
Joining tables with the NATURAL JOIN, USING, or ON clauses results in an
__________ join.
(Choose 2) (Choose all correct answers)
CROSS
OUTER
INNER
Equi-join
TERM
IMAGE
OUTER
INNER
DEFINITION
Which statement will display those employees who have a job title that contains the
string 'JEF' and earn $10,000 or more?
SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary
>= 10000 AND job_id LIKE '%JEF%' ;
SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary
>= 10000 OR job_id LIKE '%JEF%' ;
Either statement displays the desired output.
Neither statement displays the desired output.
TERM
IMAGE
SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary
>= 10000 AND job_id LIKE '%JEF%' ; (the first option)
DEFINITION
T/F: You can override the default order by using parentheses around the
expressions that you want to calculate first.
TERM
IMAGE
True
DEFINITION
The _______ condition tests for nulls.
TERM
IMAGE
IS NULL
DEFINITION
All of the following are tools to access a relational database except:
SQL * Plus
Oracle Application Express
Oracle SQL Data Modeler
Oracle SQL Developer
TERM
IMAGE
Oracle SQL Data Modeler
DEFINITION
A __________ can be found at the intersection of a row and column and contains
one value.
TERM
IMAGE
field
DEFINITION
What does the following statement do: ALTER TABLE DEPT_TEST ADD
CONSTRAINT unq_dept_det UNIQUE (DEPT_ID, DEPARTMENT_NAME) ;
It alters the DEPT_TEST table to add a composite unique key comprising of the
DEPT_ID and DEPARTMENT_NAME.
It alters the DEPT_TEST table to add a composite foreign key comprising of the
DEPT_ID and DEPARTMENT_NAME.
It alters the DEPT_TEST table to add a the DEPT_ID and DEPARTMENT_NAME
columns.
It alters the DEPT_TEST table to add a composite primary key comprising of the
DEPT_ID and DEPARTMENT_NAME.
TERM
IMAGE
It alters the DEPT_TEST table to add a composite unique key comprising of the
DEPT_ID and DEPARTMENT_NAME. (the first option)
DEFINITION
T/F: Columns without the NOT NULL constraint can contain null values by default.
TERM
IMAGE
True
DEFINITION
T/F: Table names and column names must begin with a number and should be 1-30
characters long.
TERM
IMAGE
False
DEFINITION
___________ constraints can only be created at the column level.
Not Null
Check
Unique
Primary Key
TERM
IMAGE
Not Null
DEFINITION
A literal can be all of the following except:
a calculation
a character
a number
a date
TERM
IMAGE
a calculation
DEFINITION
Which two statements are correct? (Choose all correct answers)
Keywords cannot be abbreviated or split across lines.
SQL statements are not case sensitive (unless indicated).
Keywords can be abbreviated or split across lines.
SQL statements are case sensitive.
TERM
IMAGE
Keywords cannot be abbreviated or split across lines.
SQL statements are not case sensitive (unless indicated).
DEFINITION
T/F: You can specify multiple columns after the DISTINCT qualifier.
TERM
IMAGE
True
DEFINITION
Arithmetic expressions containing a null value evaluate to _________.
TERM
IMAGE
null
DEFINITION
To eliminate duplicate rows in the result, include the _________ keyword in the
SELECT clause.
TERM
IMAGE
DISTINCT
DEFINITION
____________ give you more flexibility and control when changing data, and they
ensure data consistency in the event of user process failure or system failure.
TERM
IMAGE
Transactions
DEFINITION
T/F: Users may view data that is in the process of being changed by another user.
TERM
IMAGE
False
DEFINITION
Which SQL key word is used to do ranking in top-n-analysis
TERM
IMAGE
ROWNUM
DEFINITION
You can use _____________ to temporarily store values, while executing a query.
TERM
IMAGE
substitution variables
DEFINITION
T/F: You can delete a row that contains a primary key that is used as a foreign key in
another table.
TERM
IMAGE
False
DEFINITION
A collection of DML statements that form a logical unit of work is called a
______________.
TERM
IMAGE
transaction
DEFINITION
T/F: In APEX SQL Workshop and Object Browser options you can view table
layouts.
TERM
IMAGE
True
DEFINITION
With the __________ and ROLLBACK statements, you have control over making
changes to the
data permanent
TERM
IMAGE
COMMIT
DEFINITION
The UPDATE statement modifies the values of a specific row or rows if the _______
clause is specified.
TERM
IMAGE
MODIFY
VALUE
WHERE
SET
Answer key says it's SET, but uh...
DEFINITION
The command that removes all rows from a table, leaving the table empty and the
table
structure intact is...
TERM
IMAGE
TRUNCATE
DEFINITION
Which statement displays the last name, salary, and annual compensation of
employees where the annual compensation is calculated by multiplying the monthly
salary with 15, plus a one-time bonus of $200.
SELECT last_name, salary, 15*salary+200 FROM employees;
SELECT last_name, salary, 15*(salary+200) FROM employees;
Either statement will produced the desired result.
Neither statement will produce the desired result.
TERM
IMAGE
SELECT last_name, salary, 15*salary+200 FROM employees; (first option)
DEFINITION
The following statement displays all the rows in the departments table: SELECT
____ FROM
departments;
TERM
IMAGE
*
DEFINITION
The ________ join clause is based on all the columns in the two tables that have the
same name and the same datatype.
TERM
IMAGE
NATURAL JOIN
DEFINITION
Which operator is used to display rows based on an ordered range of values?
TERM
IMAGE
BETWEEN
DEFINITION
Which symbol is the wildcard used for any number of characters in SQL?
TERM
 IMAGE
%
DEFINITION
T/F: A foreign key value must match an existing primary key value otherwise, it must
be null.
TERM
IMAGE
True
DEFINITION
T/F: Constraints cannot be added to a table after its creation.
TERM
IMAGE
False
DEFINITION
To issue a CREATE TABLE statement, you must have the __________ privilege.
TERM
IMAGE
CREATE TABLE
DEFINITION
If a table already contains rows when a column is added, the new column is initially
null or takes the default value for all the rows. True or False?
TERM
IMAGE
True
DEFINITION
Which is the correct order of execution for statements in a SELECT query?
FROM, SELECT, ORDER BY, WHERE
SELECT, ORDER BY, FROM, WHERE
FROM, WHERE, SELECT, ORDER BY
SELECT, WHERE, FROM, ORDER BY
TERM
IMAGE
once again, no correct answers?????
[https://classroom.google.com/c/MTc2MTU5MjU3NjVa/m/MzA0OTM1ODEyMDRa/d
etails]
Answer Key: SELECT, WHERE, FROM, ORDER BY
Internet & Emily: FROM, WHERE, SELECT, ORDER BY
DEFINITION

It alters the DEPT_TEST table to add a composite unique key comprising of the DEPT_ID
and DEPARTMENT_NAME.
TERM
IMAGE
What does the following statement do: ALTER TABLE DEPT_TEST ADD CONSTRAINT
unq_dept_det UNIQUE (DEPT_ID, DEPARTMENT_NAME) ;
DEFINITION
DROP
TERM
IMAGE
When you _______ a table, the database loses all the data in the table.
DEFINITION
SET
TERM
IMAGE
The UPDATE statement modifies the values of a specific row or rows if the _______ clause
is specified.
DEFINITION
UPDATE, INSERT, DELETE
TERM
IMAGE
Data Manipulation Language includes all of the following:
DEFINITION
Check email, Create documents, Edit photographs
TERM
IMAGE
Application programs enable us to ________.
DEFINITION
SQL Scripts
TERM
IMAGE
You can upload and save a SQL Script from the _____________ option.
DEFINITION
SQL, PL/SQL
TERM
IMAGE
Oracle Application Express is an application platform used to share and learn _____ and
__________.
DEFINITION
SQL Workshop
TERM
IMAGE
SQL Commands can be entered and run from the ________________ option within the
APEX Application.
DEFINITION
unique
TERM
IMAGE
A primary key must contain a value and the value must be _______.
DEFINITION
DML
TERM
IMAGE
The type of SQL Command used to modify data is :
DEFINITION
foreign keys
TERM
IMAGE
You can logically relate data from multiple tables using ___________.
DEFINITION
DESCRIBE and SELECT
TERM
IMAGE
Once you have created a table, you can use the ________________ command to confirm that
it was created.
DEFINITION
Table name, Field names, Field data types
TERM
IMAGE
To create a table you must identify all of the following:
DEFINITION
The table has no rows, The column contains only null values, or The decrease in column
width is not less than the existing values in that column
TERM
IMAGE
When altering a table, you can decrease the width of a column if ...
DEFINITION
WHERE
TERM
IMAGE
When issuing a SQL DELETE command all rows in the table are deleted if you omit the
__________ clause.
DEFINITION
SELECT * FROM employees;
TERM
IMAGE
To see all the fields and records in the employees table you can run the following query :
DEFINITION
History
TERM
IMAGE
In the SQL Workshop/SQL Commands ___________ tab you can view and retrieve
previously run queries.
DEFINITION
Only one
TERM
IMAGE
In the SQL Commands option of APEX, you can run __________ SQL command at a time.
DEFINITION
Row Source Generation, Execution, Parsing, and Optimization
TERM
IMAGE
All of the following are stages of SQL Processing:
DEFINITION
table
TERM
IMAGE
Relational Databases store data in a two-dimensional matrix known as a _________.
DEFINITION
DDL
TERM
IMAGE
The type of SQL Command used to define database structures is :
DEFINITION
Not Null
TERM
IMAGE
___________ constraints can only be created at the column level.
DEFINITION
schema
TERM
IMAGE
In the APEX application a ______ is a collection of logical structures of data. A _______ is
owned by a database user and has the same name as that user.
DEFINITION
SYS_Cn
TERM
IMAGE
You can name a constraint or the Oracle server generates a name by using the ________
format.
DEFINITION
initially null or takes the default value
TERM
IMAGE
If a table already contains rows when a column is added, the new column is
________________ for all the rows.
DEFINITION
generates no rollback information
TERM
IMAGE
The TRUNCATE statement is a data definition language (DDL) statement and
______________________.
DEFINITION
foreign key, primary key
TERM
IMAGE
A _____________ value must match an existing _____________ value otherwise, it must be
null.
DEFINITION
can
TERM
IMAGE
Constraints ________ be added to a table after its creation.
DEFINITION
error is returned if you try to violate the constraint rule
TERM
IMAGE
When you have constraints in place on columns, an ________________________.
DEFINITION
basic storage
TERM
IMAGE
A table is the _______________ structure of an RDBMS.
DEFINITION
client
TERM
IMAGE
To connect to an Oracle database you need to use a _____________ program.
DEFINITION
set-based, declarative language
TERM
IMAGE
Structured Query Language (SQL) is the ____________________ used to access data in an
Oracle database.
DEFINITION
consistency and integrity
TERM
IMAGE
Constraints ensure the ___________________ of the database.

Any column that is not listed explicitly obtains a null value in the new row unless we
have ___ values for the missing columns that are used
TERM
IMAGE
DEFAULT
DEFINITION
Data Manipulation Language includes all of the following except:
-DELETE
-UPDATE
-COMMIT
-INSERT
TERM
IMAGE
COMMIT
DEFINITION
When you have constraints in place on columns, an error is returned if you try to
violate the constraint rule (true/false)
TERM
IMAGE
true
DEFINITION
Once you have created a table, you can use the ____ command to confirm that it
was created (2 correct)
-SELECT
-LIST
-DESCRIBE
-ORDER BY
TERM
IMAGE
-SELECT
-DESCRIBE
DEFINITION
When altering a table, you can decrease the width of a column if ____ (3 correct)
-the decrease in column width is not less than existing values in that column
-the table has no rows
-the column contains only null values
-the column contains only numeric values
TERM
IMAGE
-the decrease in column width is not less than existing values in that column
-the table has no rows
-the column contains only null values
DEFINITION
the Data Definition Language preforms all of the following except:
-alter tables
-insert data into tables
-create tables
-add constraints to tables
TERM
IMAGE
-insert data into tables
DEFINITION
columns without the NOT NULL constraint can contain null values by default
(true/false)
TERM
IMAGE
true
DEFINITION
in SQL Workshop/SQL Commands ___ tabs you can view and retrieve previously
run queries
TERM
IMAGE
history
DEFINITION
Oracle Application Express is an application platform used to share and learn ___
and ___
TERM
IMAGE
SQL & PL/SQL
DEFINITION
To see all fields and records in the employees tables you can run the following query
TERM
IMAGE
SELECT * FROM employees
DEFINITION
the __ clause in a query comes immediately after the SELECT and FROM
TERM
IMAGE
WHERE
DEFINITION
The stages of SQL processing are Parsing, Optimization, Row Source Generation
and ____
TERM
IMAGE
Execution
DEFINITION
You can logically relate data from multiple tables using ____
TERM
IMAGE
foreign keys
DEFINITION
all of the following are tools to access a relational database except:
-Oracle SQL Developer
-Oracle SQL Data Modeler
-SQL * Plus
-Oracle Application Express
TERM
IMAGE
-Oracle SQL Data Modeler
DEFINITION
a ___ can be found at the intersection of a row and column and contains one value
TERM
IMAGE
field
DEFINITION
which software is used to manage reading and manipulating a relational database
TERM
IMAGE
DBMS software
DEFINITION
a table is the basic storage structure of an RDBMS (true/false)
TERM
IMAGE
true
DEFINITION
Structure Query Language (SQL) is the set-based, declarative language used to
access data in an Oracle database (true/false)
TERM
IMAGE
true
DEFINITION
constraints ensure the consistency and integrity of the database (true/false)
TERM
IMAGE
true
DEFINITION
when you define a table, you can specify that a column should be given a default
value by using the LITERAL option (true/false)
TERM
 IMAGE
false
DEFINITION
you use the ___ option to mark one or more columns as unused
TERM
IMAGE
SET UNUSED
DEFINITION
to issue a CREATE TABLE statement, you must have the __ privilege
TERM
IMAGE
CREATE TABLE
DEFINITION
SQL Commands can be entered and run from the ___ option within the APEX
Application
TERM
IMAGE
SQL Workshop
DEFINITION
Application programs enable us to __
-check email
-create documents
-edit photographs
-all of the above
TERM
IMAGE
-all of the above
DEFINITION
to use a computer application you must understand how it is built and how it works
inside (true/false)
TERM
IMAGE
false
DEFINITION
a collection of DML statements that form a logical unit of work is called a __
TERM
IMAGE
transaction
DEFINITION
when issuing a SQL DELETE command all rows in the table are deleted if you omit
the __ clause
TERM
IMAGE
WHERE
DEFINITION

Section 6 Quiz 2 L5-L9

(Answer all questions in this section)
1. The _______ condition tests for nulls.
(1/1) Points
IS NULL (*)
NULL
ISN'T NULL
NULLABLE
Correct

2. What is the result of executing the following statement:

SELECT EMPLOYEE_ID, LAST_NAME, JOB_ID, DEPARTMENT_ID AS "DEPTID"
FROM EMPLOYEES
WHERE DEPARTMENT_ID = 90 ;
(0/1) Points
Displays the EMPLOYEE_ID, LAST_NAME, JOB_ID, DEPARTMENT_ID, DEPTID from
the EMPLOYEES table where the department id is 90.
Displays the EMPLOYEE_ID, LAST_NAME, JOB_ID, DEPARTMENT_ID from the
EMPLOYEES table where the department id is 90. (*)
Prompts the user for additional information.
Throws an error
Incorrect. Refer to Section 6 Lesson 7.

3. A database transaction consists of the following except :

(1/1) Points
SELECT queries (*)
One DDL Statement
DML statements representing one consistent change to the data
One TCL Statement
Correct

4. The Oracle server ensures data consistency based on transactions.

(1/1) Points
True (*)
False
Correct

5. If an arithmetic expression contains more than one operator, __________ are
evaluated first.
(1/1) Points
anything in parenthesis (*)
multiplication and division
addition and subtraction
exponentiation
Correct
6. By default column aliases appear _________.
(1/1) Points
Lower case
There is no default.
Upper case (*)
Mixed case
Correct

7. Which statement displays the last name, salary, and annual compensation of
employees where the annual compensation is calculated by multiplying the
monthly salary with 15, plus a one-time bonus of $200.
(1/1) Points
SELECT last_name, salary, 15*salary+200 FROM employees; (*)
SELECT last_name, salary, 15*(salary+200) FROM employees;
Either statement will produced the desired result.
Neither statement will produce the desired result.
Correct

8. You can display all columns of data in a table by following the SELECT keyword
with an asterisk (*).
(1/1) Points
True (*)
False
Correct

9. Which two statements are correct?

(1/1) Points
SQL statements are not case sensitive (unless indicated). (*)
SQL statements are case sensitive.
Keywords can be abbreviated or split across lines.
Keywords cannot be abbreviated or split across lines. (*)
Correct

10. Which of the following statements is syntactically correct?

(1/1) Points
SELECT e.employee_id, e.last_name, e.department_id, d.department_id,
d.location_id
FROM employees e JOIN departments d
ON (e.department_id = d.department_id)
AND e.manager_id = 149 ;
SELECT e.employee_id, e.last_name, e.department_id, d.department_id,
d.location_id
FROM employees e JOIN departments d
ON (e.department_id = d.department_id)
WHERE e.manager_id = 149 ;
Both statements are syntactically correct. (*)
Neither statement is syntactically correct.
Correct
11. Which of the following statements is an example of a SELF JOIN?
(1/1) Points
SELECT e.employee_id, e.last_name, e.department_id, d.department_id,
d.location_id
FROM employees e JOIN departments d
ON (e.department_id = d.department_id);
SELECT worker.last_name emp, manager.last_name mgr
FROM employees worker JOIN employees manager
ON (worker.manager_id = manager.employee_id); (*)
SELECT department_id, department_name,location_id, city
FROM departments NATURAL JOIN locations;
SELECT e.employee_id, e.last_name, e.department_id, d.department_id,
d.location_id
FROM employees e JOIN departments d
ON (e.department_id = d.department_id)
AND e.manager_id = 149 ;
Correct

12. The __________ clause can be used to match columns with the same name,
but different data types.
(1/1) Points
NATURAL JOIN
OUTER JOIN
CROSS JOIN
USING (*)
Correct

13. A _______________ is a join condition containing something other than an

equality operator.
(1/1) Points
INNER JOIN
OUTER JOIN
CROSS JOIN
NONEQUIJOIN (*)
Correct

14. You can use _____________ to temporarily store values, while executing a

query.
(1/1) Points
literal values
substitution variables (*)
database fields
database tables
Correct

15. Which statements are not true?

(Choose 2)
(1/1) Points
You cannot use a column alias in the ORDER BY clause. (*)
You can sort by a column that is not in the SELECT list.
You can sort query results by specifying the numeric position of the column in
the SELECT clause.
You cannot sort query results by more than one column. (*)
Correct
Links https://quizlet.com/_655pdq?x=1jqt&i=3qlb1n
https://quizlet.com/_63l8ch?x=1jqt&i=3qlb1n
https://quizlet.com/_6oj06l?x=1jqt&i=3qlb1n

T/F: Converting a Relational model to a Logical model is called reverse engineering.

TERM
IMAGE
True
DEFINITION
The steps to convert a Relational model to a Logical model using the Oracle SQL
Developer Data
Modeler are:
Select the Relational model, Accept defaults, Click the Engineer to Logical Model
icon,
Click Engineer
Click the Engineer to Relational Model icon, Select the Logical model, Click
Engineer,
Accept defaults.
Select the Relational model, Click the Engineer to Logical Model icon, Accept
defaults,
Click Engineer
None of the above.
TERM
IMAGE
Select the Relational model, Click the Engineer to Logical Model icon, Accept
defaults,
Click Engineer
DEFINITION
When building a model in Oracle SQL Data Modeler you begin in the ________ tab.
TERM
IMAGE
Logical
DEFINITION
The Oracle SQL Data Modeler enables you to do all of the following except:
Store metadata information
Create process, logical, relational and physical models
Capture business rules and information
Store application data
TERM
IMAGE
Store application data
DEFINITION
T/F: In Oracle SQL Developer Data Modeler you can select how you want to map
your subtypes.
TERM
IMAGE
True
DEFINITION
When mapping subtypes to tables we can ________
Use one table
Use multiple tables
Either one or multiple tables are valid options.
Neither one or multiple tables are valid options.
TERM
IMAGE
Either one or multiple tables are valid options.
DEFINITION
The steps to create a glossary from an existing Logical model are:
Right click Logical model, select Create Glossary from Logical Model
Double click the Logical Model
Rick click the Relational model, select Create Glossary from Relational Model
None of the above.
TERM
IMAGE
Right click Logical model, select Create Glossary from Logical Model
DEFINITION
T/F: An Entity Relationship model does not highlight the physical and database
constraints. It is essential
to transform the ER model into a relational model which can serve as the basis for
defining the physical
implementation of the database.
TERM
IMAGE
True
DEFINITION
_______ consistency guarantees a consistent view of the data at all times.
TERM
IMAGE
Read
DEFINITION
A database transaction consists of the following except:
One TCL Statement
DML statements representing one consistent change to the data
SELECT queries
One DDL Statement
TERM
IMAGE
SELECT queries
DEFINITION
T/F: The Oracle server ensures data consistency based on transactions.
TERM
IMAGE
True
DEFINITION
An automatic commit occurs when _________ . (Choose 2)(Choose all correct
answers)
A TCL statement is executed.
A DML statement is executed.
SELECT statement is executed.
A DDL statement is executed.
TERM
IMAGE
A TCL statement is executed.
A DDL statement is executed.
DEFINITION
T/F: Top-n-analysis is used when you want to retrieve only the top number of records
from a result set.
TERM
IMAGE
True
DEFINITION
Which character is used as a substitution variable in APEX?
TERM
IMAGE
: (a colon)
DEFINITION
T/F: The ORDER BY clause must be placed before the WHERE clause in a SQL
statement.
TERM
IMAGE
False
DEFINITION
T/F: Substitution variables are used when you want to prompt for different criteria in
a condition.
TERM
IMAGE
True
DEFINITION
Oracle Application Express is an application platform used to share and learn _____
and __________.
TERM
IMAGE
SQL, PL/SQL
DEFINITION
You can use Application Express (APEX) for
TERM
IMAGE
Developing and expanding your skills with Oracle database, SQL and PL/SQL
DEFINITION
T/F: In the SQL Commands option of APEX, you can run more than one SQL
command at a time.
TERM
IMAGE
False
DEFINITION
T/F: When you define a table, you can specify that a column should be given a
default value by using
the LITERAL option.
TERM
IMAGE
False
DEFINITION
Once you have created a table, you can use the ________________ command to
confirm that it was created. (Choose 2) (Choose all correct answers)
ORDER BY
SELECT
LIST
DESCRIBE
TERM
IMAGE
SELECT
DESCRIBE
DEFINITION
When altering a table, you can decrease the width of a column if ...(Choose 3)
(Choose all correct
answers)
The table has no rows
The decrease in column width is not less than the existing values in that column
The column contains only null values
The column contains numeric values
TERM
IMAGE
The table has no rows
The decrease in column width is not less than the existing values in that column
The column contains only null values
DEFINITION
DDL means:
TERM
IMAGE
Data Definition Language
DEFINITION
The Data Definition Language performs all of the following except:
Add constraints to tables
Insert data into tables
Alter tables
Create tables
TERM
IMAGE
Insert data into tables
DEFINITION
You can link columns to other columns, arithmetic expressions, or constant values to
create a character expression by using the ____________ operator (||).
TERM
IMAGE
concatenation
DEFINITION
By default column aliases appear _________.
TERM
IMAGE
Upper case
DEFINITION
T/F: Literals can be used within a SELECT statement.
TERM
IMAGE
True
DEFINITION
The following statement will result in an error (True or False): SELECT last_name
"Name" , salary*12 "Annual Salary", salary +100 FROM employees;
TERM
IMAGE
False
DEFINITION
Which column alias is invalid?
First Name
"First Name"
"FIRST NAME"
First_Name
TERM
IMAGE
First Name
DEFINITION
You can display selected columns of a table by listing them in the __________
clause.
TERM
IMAGE
SELECT
DEFINITION
T/F: The CARTESIAN or CROSS join gets created when a join condition is omitted.
TERM
IMAGE
True
DEFINITION
Which of the following statements is syntactically correct?
SELECT e.employee_id, e.last_name, e.department_id, d.department_id,
d.location_id
FROM employees e JOIN departments d ON (e.department_id = d.department_id)
AND
e.manager_id = 149 ;
SELECT e.employee_id, e.last_name, e.department_id, d.department_id,
d.location_id
FROM employees e JOIN departments d ON (e.department_id = d.department_id)
WHERE
e.manager_id = 149;
Both statements are syntactically correct.
Neither statement is syntactically correct.
TERM
IMAGE
Both statements are syntactically correct.
DEFINITION
T/F: We must use the ON clause to join three tables.
TERM
IMAGE
Answer Key: False
But uhhh, pretty sure 'tis true.
DEFINITION
A _______ clause creates an equijoin between two tables using one column with the
same name, regardless of the data type.
TERM
IMAGE
USING
DEFINITION
T/F: A join between two tables that returns the results of the INNER join as well as
the unmatched rows from the left (or right) table is called a left (or right) OUTER join.
TERM
IMAGE
True
DEFINITION
T/F: A self-join can be used when there are two fields with the same data on a table
that have different meanings.
TERM
IMAGE
True
DEFINITION
To connect to an Oracle database you need to use a client program. True or False?
TERM
IMAGE
True
DEFINITION
Relational Databases store data in a two-dimensional matrix known as a _________.
TERM
IMAGE
table
DEFINITION
The stages of SQL processing are Parsing, Optimization, Row Source Generation
and _____________ .
TERM
IMAGE
Execution
DEFINITION
You can logically relate data from multiple tables using ___________.
TERM
IMAGE
foreign keys
DEFINITION
Any column that is not listed explicitly obtains a null value in the new row unless we
have _________ values for the missing columns that are used.
TERM
IMAGE
DEFAULT
DEFINITION
Data Manipulation Language includes all of the following except:
DELETE
COMMIT
INSERT
UPDATE
TERM
IMAGE
COMMIT
DEFINITION
T/F: The TRUNCATE statement is a data definition language (DDL) statement and
generates no rollback information.
TERM
IMAGE
True
DEFINITION
___________________ is used to add, modify and delete data.
TERM
IMAGE
Data Manipulation Language
DEFINITION
T/F: When you have constraints in place on columns, an error is returned if you try to
violate the constraint rule.
TERM
IMAGE
True
DEFINITION
You use the ______ operator to perform wildcard searches of valid search string
values.
TERM
IMAGE
LIKE
DEFINITION
According to the rules of precedence which operator will be evaluated first?
AND
OR
Both are on the same level of precedence.
TERM
IMAGE
AND
DEFINITION
The ______ operator requires either of the component conditions to be true.
AND
BETWEEN
EITHER
OR
TERM
IMAGE
OR
DEFINITION
T/F: Character strings and dates in the WHERE clause must be enclosed with single
quotation marks
TERM
IMAGE
True
DEFINITION
What is the result of executing the following statement: SELECT EMPLOYEE_ID,
LAST_NAME, JOB_ID, DEPARTMENT_ID AS "DEPTID" FROM EMPLOYEES
WHERE DEPARTMENT_ID = 90 ;
-Displays the EMPLOYEE_ID, LAST_NAME, JOB_ID, DEPARTMENT_ID, DEPTID
from the EMPLOYEES table where the department id is 90.
-Displays the EMPLOYEE_ID, LAST_NAME, JOB_ID, DEPARTMENT_ID from the
EMPLOYEES table where the department id is 90.
-Prompts the user for additional information.
-Throws an error
TERM
IMAGE
no correct answers???
[https://classroom.google.com/c/MTc2MTU5MjU3NjVa/m/MzA0OTM1ODEyMDRa/d
etails]
I think it's the second one (the one without DEPTID)
DEFINITION
T/F: In Oracle SQL Data Modeler, the attribute that you assign as primary UID is
automatically set to a mandatory attribute and will be engineered to a primary key in
the relational model.
TERM
IMAGE
True
DEFINITION
T/F: Top-Down Modeling is the approach taken for designing a new database.
TERM
IMAGE
True
DEFINITION
________ Engineering is the process of transforming a Logical Data Model to a
Relational Model.
TERM
IMAGE
Forward
DEFINITION
To define naming templates in Oracle SQL Data Modeler:
Right click the name of the design in object browser
Select properties, select template
Edit the template to use abbreviations
Do all of these steps.
TERM
IMAGE
Do all of these steps.
DEFINITION
T/F: The glossary can be used as the naming standard for your Logical Model.
TERM
IMAGE
True
DEFINITION
Why will the following statement result in an error?
SELECT l.city, d.department_name FROM locations l JOIN departments d USING
(location_id) WHERE d.location_id = 1400;
WHERE clause cannot be used in a query with USING.
The field in the USING clause cannot have a qualifier.
Syntax of the USING clause is incorrect.
There is nothing wrong - this will run correctly.
TERM
IMAGE
The field in the USING clause cannot have a qualifier.
DEFINITION
The ___________ JOIN clause produces the cross-product of two tables.
TERM
IMAGE
CROSS
DEFINITION
Joining tables with the NATURAL JOIN, USING, or ON clauses results in an
__________ join.
(Choose 2) (Choose all correct answers)
CROSS
OUTER
INNER
Equi-join
TERM
IMAGE
OUTER
INNER
DEFINITION
Which statement will display those employees who have a job title that contains the
string 'JEF' and earn $10,000 or more?
SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary
>= 10000 AND job_id LIKE '%JEF%' ;
SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary
>= 10000 OR job_id LIKE '%JEF%' ;
Either statement displays the desired output.
Neither statement displays the desired output.
TERM
IMAGE
SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary
>= 10000 AND job_id LIKE '%JEF%' ; (the first option)
DEFINITION
T/F: You can override the default order by using parentheses around the
expressions that you want to calculate first.
TERM
IMAGE
True
DEFINITION
The _______ condition tests for nulls.
TERM
IMAGE
IS NULL
DEFINITION
All of the following are tools to access a relational database except:
SQL * Plus
Oracle Application Express
Oracle SQL Data Modeler
Oracle SQL Developer
TERM
IMAGE
Oracle SQL Data Modeler
DEFINITION
A __________ can be found at the intersection of a row and column and contains
one value.
TERM
IMAGE
field
DEFINITION
What does the following statement do: ALTER TABLE DEPT_TEST ADD
CONSTRAINT unq_dept_det UNIQUE (DEPT_ID, DEPARTMENT_NAME) ;
It alters the DEPT_TEST table to add a composite unique key comprising of the
DEPT_ID and DEPARTMENT_NAME.
It alters the DEPT_TEST table to add a composite foreign key comprising of the
DEPT_ID and DEPARTMENT_NAME.
It alters the DEPT_TEST table to add a the DEPT_ID and DEPARTMENT_NAME
columns.
It alters the DEPT_TEST table to add a composite primary key comprising of the
DEPT_ID and DEPARTMENT_NAME.
TERM
IMAGE
It alters the DEPT_TEST table to add a composite unique key comprising of the
DEPT_ID and DEPARTMENT_NAME. (the first option)
DEFINITION
T/F: Columns without the NOT NULL constraint can contain null values by default.
TERM
IMAGE
True
DEFINITION
T/F: Table names and column names must begin with a number and should be 1-30
characters long.
TERM
IMAGE
False
DEFINITION
___________ constraints can only be created at the column level.
Not Null
Check
Unique
Primary Key
TERM
IMAGE
Not Null
DEFINITION
A literal can be all of the following except:
a calculation
a character
a number
a date
TERM
IMAGE
a calculation
DEFINITION
Which two statements are correct? (Choose all correct answers)
Keywords cannot be abbreviated or split across lines.
SQL statements are not case sensitive (unless indicated).
Keywords can be abbreviated or split across lines.
SQL statements are case sensitive.
TERM
IMAGE
Keywords cannot be abbreviated or split across lines.
SQL statements are not case sensitive (unless indicated).
DEFINITION
T/F: You can specify multiple columns after the DISTINCT qualifier.
TERM
IMAGE
True
DEFINITION
Arithmetic expressions containing a null value evaluate to _________.
TERM
IMAGE
null
DEFINITION
To eliminate duplicate rows in the result, include the _________ keyword in the
SELECT clause.
TERM
IMAGE
DISTINCT
DEFINITION
____________ give you more flexibility and control when changing data, and they
ensure data consistency in the event of user process failure or system failure.
TERM
IMAGE
Transactions
DEFINITION
T/F: Users may view data that is in the process of being changed by another user.
TERM
IMAGE
False
DEFINITION
Which SQL key word is used to do ranking in top-n-analysis
TERM
IMAGE
ROWNUM
DEFINITION
You can use _____________ to temporarily store values, while executing a query.
TERM
IMAGE
substitution variables
DEFINITION
T/F: You can delete a row that contains a primary key that is used as a foreign key in
another table.
TERM
IMAGE
False
DEFINITION
A collection of DML statements that form a logical unit of work is called a
______________.
TERM
IMAGE
transaction
DEFINITION
T/F: In APEX SQL Workshop and Object Browser options you can view table
layouts.
TERM
IMAGE
True
DEFINITION
With the __________ and ROLLBACK statements, you have control over making
changes to the
data permanent
TERM
IMAGE
COMMIT
DEFINITION
The UPDATE statement modifies the values of a specific row or rows if the _______
clause is specified.
TERM
IMAGE
MODIFY
VALUE
WHERE
SET
Answer key says it's SET, but uh...
DEFINITION
The command that removes all rows from a table, leaving the table empty and the
table
structure intact is...
TERM
IMAGE
TRUNCATE
DEFINITION
Which statement displays the last name, salary, and annual compensation of
employees where the annual compensation is calculated by multiplying the monthly
salary with 15, plus a one-time bonus of $200.
SELECT last_name, salary, 15*salary+200 FROM employees;
SELECT last_name, salary, 15*(salary+200) FROM employees;
Either statement will produced the desired result.
Neither statement will produce the desired result.
TERM
IMAGE
SELECT last_name, salary, 15*salary+200 FROM employees; (first option)
DEFINITION
The following statement displays all the rows in the departments table: SELECT
____ FROM
departments;
TERM
IMAGE
*
DEFINITION
The ________ join clause is based on all the columns in the two tables that have the
same name and the same datatype.
TERM
IMAGE
NATURAL JOIN
DEFINITION
Which operator is used to display rows based on an ordered range of values?
TERM
IMAGE
BETWEEN
DEFINITION
Which symbol is the wildcard used for any number of characters in SQL?
TERM
IMAGE
%
DEFINITION
T/F: A foreign key value must match an existing primary key value otherwise, it must
be null.
TERM
IMAGE
True
DEFINITION
T/F: Constraints cannot be added to a table after its creation.
TERM
IMAGE
False
DEFINITION
To issue a CREATE TABLE statement, you must have the __________ privilege.
TERM
IMAGE
CREATE TABLE
DEFINITION
If a table already contains rows when a column is added, the new column is initially
null or takes the default value for all the rows. True or False?
TERM
IMAGE
True
DEFINITION
Which is the correct order of execution for statements in a SELECT query?
FROM, SELECT, ORDER BY, WHERE
SELECT, ORDER BY, FROM, WHERE
FROM, WHERE, SELECT, ORDER BY
SELECT, WHERE, FROM, ORDER BY
TERM
IMAGE
once again, no correct answers?????
[https://classroom.google.com/c/MTc2MTU5MjU3NjVa/m/MzA0OTM1ODEyMDRa/d
etails]
Answer Key: SELECT, WHERE, FROM, ORDER BY
Internet & Emily: FROM, WHERE, SELECT, ORDER BY
DEFINITION

Which column alias will cause an error?

SELECT last_name AS lname FROM employees;
SELECT last_name AS Last Name FROM employees;
SELECT last_name "Last Name" FROM employees;
SELECT last_name lname FROM employees;
TERM
IMAGE
SELECT last_name AS Last Name FROM employees;
DEFINITION
T/F: You can display all columns of data in a table by following the SELECT keyword
with an asterisk
TERM
IMAGE
True
DEFINITION
Which column alias is invalid?
First_Name
"First Name"
"FIRST NAME"
First Name
TERM
IMAGE
First Name
DEFINITION
A literal can be all of the following except :

a calculation
a date
a character
a number
TERM
IMAGE
a calculation
DEFINITION
Which statements will execute successfully? (Choose 2) (Choose all correct
answers)
SELECT employee_id, last_name, job_id, department_id, hire_date FROM
employees ORDER BY 3;
SELECT first_name, last_name FROM employees ORDER BY employee_id DES;
SELECT first_name, last_name, first_name||last_name fullname FROM employees
ORDER BY fullname;
SELECT employee_id, first_name, last_name FROM employees ORDER BY
employee_id DESCEND;
TERM
IMAGE
SELECT employee_id, last_name, job_id, department_id, hire_date FROM
employees ORDER BY 3;
SELECT first_name, last_name, first_name||last_name fullname FROM employees
ORDER BY fullname;
DEFINITION
Which statement will display those employees who have a job title that contains the
string 'JEF'
and earn $10,000 or more?
SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary
>=
10000 AND job_id LIKE '%JEF%';
SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary
>=
10000 OR job_id LIKE '%JEF%';
Either statement displays the desired output.
Neither statement displays the desired output.
TERM
IMAGE
SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary
>=
10000 AND job_id LIKE '%JEF%';
DEFINITION
Which of the following is the wildcard used for any number of characters in SQL?
||
#
%
&
TERM
IMAGE
%
DEFINITION
____________ give you more flexibility and control when changing data, and they
ensure data
consistency in the event of user process failure or system failure.
TERM
 IMAGE
Transactions
DEFINITION
T/F: The Oracle server ensures data consistency based on transactions.
TERM
IMAGE
True
DEFINITION
Will the following statement execute successfully (True or False)?

SELECT e.employee_id, e.last_name, e.department_id, d.department_id,

d.location_id FROM employees
e JOIN departments d ON (e.department_id = d.department_id);
TERM
IMAGE
True
DEFINITION
T/F: The CARTESIAN or CROSS join gets created when a join condition is omitted.
TERM
IMAGE
True
DEFINITION
T/F: A join between two tables that returns the results of the INNER join as well as
the unmatched
rows from the left (or right) table is called a left (or right) OUTER join.
TERM
IMAGE
True
DEFINITION
Why will the following statement result in an error?

SELECT l.city, d.department_name FROM locations l JOIN departments d USING

(location_id) WHERE
d.location_id = 1400;
TERM
IMAGE
The field in the USING clause cannot have a qualifier.
DEFINITION
T/F: The ORDER BY clause must be placed before the WHERE clause in a SQL
statement.
TERM
IMAGE
False
DEFINITION
Which statements are not true? Choose 2) (Choose all correct answers)
You can sort query results by specifying the numeric position of the column in the
SELECT clause.
You can sort by a column that is not in the SELECT list.
You cannot sort query results by more than one column.
You cannot use a column alias in the ORDER BY clause.
TERM
IMAGE
You cannot sort query results by more than one column.
You cannot use a column alias in the ORDER BY clause.
DEFINITION
You use the ______ operator to perform wildcard searches of valid search string
values.
TERM
IMAGE
LIKE
DEFINITION
If an arithmetic expression contains more than one operator, __________ are
evaluated first.
TERM
IMAGE
anything in parenthesis
DEFINITION
The following statement displays all the rows in the departments table: SELECT
____ FROM
departments;
TERM
IMAGE
*
DEFINITION
Which statement displays the last name, salary, and annual compensation of
employees where
the annual compensation is calculated by multiplying the monthly salary with 15, plus
a one-time bonus
of $200.
SELECT last_name, salary, 15*salary+200 FROM employees;
SELECT last_name, salary, 15*(salary+200) FROM employees;
Either statement will produced the desired result.
Neither statement will produce the desired result.
TERM
IMAGE
SELECT last_name, salary, 15*salary+200 FROM employees;
DEFINITION
T/F: Literals can be used within a SELECT statement.
TERM
IMAGE
True
DEFINITION
Arithmetic expressions containing a null value evaluate to _________.
TERM
IMAGE
null
DEFINITION
T/F: You can create a marker in the current transaction by using the SAVEPOINT
statement.
TERM
 IMAGE
True
DEFINITION
Which of the following statements is an example of a SELF JOIN?
SELECT department_id, department_name,location_id, city FROM departments
NATURAL JOIN locations;
SELECT e.employee_id, e.last_name, e.department_id, d.department_id,
d.location_id
FROM employees e JOIN departments d ON (e.department_id = d.department_id);
SELECT e.employee_id, e.last_name, e.department_id, d.department_id,
d.location_id
FROM employees e JOIN departments d ON (e.department_id = d.department_id)
AND
e.manager_id = 149 ;
SELECT worker.last_name emp, manager.last_name mgr FROM employees worker
JOIN
employees manager ON (worker.manager_id = manager.employee_id);
TERM
IMAGE
SELECT worker.last_name emp, manager.last_name mgr FROM employees worker
JOIN
employees manager ON (worker.manager_id = manager.employee_id);
DEFINITION
The ________ join clause is based on all the columns in the two tables that have the
same name
and the same datatype.
TERM
IMAGE
NATURAL JOIN
DEFINITION
A _______ clause creates an equijoin between two tables using one column with the
same name,
regardless of the data type.
TERM
IMAGE
USING
DEFINITION
The __________ clause can be used to match columns with the same name, but
different data
types.
TERM
IMAGE
USING
DEFINITION
Joining tables with the NATURAL JOIN, USING, or ON clauses results in an
__________ join.
(Choose 2) (Choose all correct answers)
OUTER
CROSS
INNER
Equi-join
TERM
IMAGE
INNER
Equi-join
DEFINITION
Null is the same as zero or a blank space. True or False?
TERM
IMAGE
False
DEFINITION
Selecting specific columns from a table to be displayed in a query is called
_____________.
TERM
IMAGE
projection
DEFINITION
Which character is used as a substitution variable in APEX?
TERM
IMAGE
:
DEFINITION
In a SELECT statement the ________ clause can be used to sort the rows.
TERM
IMAGE
ORDER BY
DEFINITION
A transaction begins when the first DML statement is encountered and ends when
one of the
following occurs .....
A COMMIT or ROLLBACK statement is issued.
A DDL statement, such as CREATE, is issued.
Either of the above statements
None of the above
TERM
IMAGE
Either of the above statements
DEFINITION
_______ consistency guarantees a consistent view of the data at all times.
TERM
IMAGE
Read
DEFINITION
The ______ operator requires either of the component conditions to be true.
TERM
IMAGE
OR
DEFINITION
T/F: Users may view data that is in the process of being changed by another user.
TERM
 IMAGE
False
DEFINITION

null
TERM
IMAGE
Arithmetic expressions containing a null value evaluate to _________.
DEFINITION
anything in parenthesis
TERM
IMAGE
If an arithmetic expression contains more than one operator, __________ are evaluated first.
DEFINITION
First Name
TERM
IMAGE
Invalid column alias
DEFINITION
ORDER BY
TERM
IMAGE
In a SELECT statement the ________ clause can be used to sort the rows.
DEFINITION
AND
TERM
IMAGE
According to the rules of precedence which operator will be evaluated first from AND and
OR?
DEFINITION
%
TERM
IMAGE
The wildcard used for any number of characters in SQL.
DEFINITION
COMMIT
TERM
IMAGE
With the __________ and ROLLBACK statements, you have control over making changes to
the data permanent
DEFINITION
One DDL Statement, DML statements representing one consistent change to the data, One
TCL Statement
TERM
IMAGE
A database transaction consists of the following:
DEFINITION
self-join
TERM
 IMAGE
A ___________ can be used when there are two fields with the same data on a table that have
different meanings.
DEFINITION
CROSS JOIN
TERM
IMAGE
What type of join is the following statement? SELECT e.EMPLOYEE_ID, e.LAST_NAME,
d.DEPARTMENT_ID, d.DEPARTMENT_NAME, d.LOCATION_ID FROM EMPLOYEES
e, DEPARTMENTS d;
DEFINITION
DISTINCT
TERM
IMAGE
To eliminate duplicate rows in the result, include the _________ keyword in the SELECT
clause.
DEFINITION
SELECT
TERM
IMAGE
Literals can be used within a __________ statement .
DEFINITION
concatenation
TERM
IMAGE
You can link columns to other columns, arithmetic expressions, or constant values to create a
character expression by using the ____________ operator (||).
DEFINITION
Read
TERM
IMAGE
_______ consistency guarantees a consistent view of the data at all times.
DEFINITION
CROSS
TERM
IMAGE
The ___________ JOIN clause produces the cross-product of two tables.
DEFINITION
:
TERM
IMAGE
Which character is used as a substitution variable in APEX?
DEFINITION
USING
TERM
IMAGE
The __________ clause can be used to match columns with the same name, but different data
types.
DEFINITION
NATURAL JOIN
TERM
IMAGE
The ________ join clause is based on all the columns in the two tables that have the same
name and the same datatype.
DEFINITION
NONEQUIJOIN
TERM
IMAGE
A _______________ is a join condition containing something other than an equality
operator.

Test: DFo Database Foundations Final Exam

Review your answers, feedback, and question scores below. An asterisk (*)
indicates a correct answer.

Section 4
(Answer all questions in this section)

1. Which of the following cannot be modeled using the Oracle SQL Data Modeler ?

(1/1) Points

Entities, attributes, UIDs

Supertype and subtype entities

Recursive Relationships

Arc relationships

All can be modeled. (*)

Correct

2. The Oracle SQL Data Modeler enables you to do all of the following except:

(1/1) Points

Store application data (*)

Capture business rules and information

Create process, logical, relational and physical models

Store metadata information

Correct

3. A Relational model is closer to the implementation solution, facilitates discussion and
forms the basis for the physical database design.

(1/1) Points

True (*)

False
Correct

4. Converting a Relational model to a Logical model is called reverse engineering.

(1/1) Points

True (*)

False
Correct

Section 5
(Answer all questions in this section)

5. Foreign key constraints are named using the ______________ of both tables.

(1/1) Points

full table name

UID suffix

foreign key name

short table name (*)

Correct

Section 5
(Answer all questions in this section)
6. To use the Oracle SQL Developer Data Modeler to apply naming standards :
(1/1) Points
Use a .docx file constaining table names and abbreviations
Use a .csv file constaining table names and abbreviations (*)
Use a .accdb file constaining table names and abbreviations
None of the above.
Correct

7. A ___________ model is the blue print to the actual database implementation
and can be used as the basis for implementing any type of Database
Management System (DBMS).
(1/1) Points
Logical
Database
Relational (*)
Conceptual
Correct

8. An Entity Relationship model does not highlight the physical and database
constraints. It is essential to transform the ER model into a relational model
which can serve as the basis for defining the physical implementation of the
database.
(1/1) Points
True (*)
False
Correct
Section 6
(Answer all questions in this section)
9. A transaction begins when the first DML statement is encountered and ends
when one of the following occurs .....
(1/1) Points
A COMMIT or ROLLBACK statement is issued.
A DDL statement, such as CREATE, is issued.
Either of the above statements (*)
None of the above
Correct

10. Users may view data that is in the process of being changed by another user.
(1/1) Points
True
False (*)
Correct
Section 6
(Answer all questions in this section)
11. A database transaction consists of the following except :
(1/1) Points
DML statements representing one consistent change to the data
SELECT queries (*)
One DDL Statement
One TCL Statement
Correct

12. The Oracle server ensures data consistency based on transactions.

(1/1) Points
True (*)
False
Correct

13. When you define a table, you can specify that a column should be given a
default value by using the LITERAL option.
(1/1) Points
True
False (*)
Correct

14. Table names and column names must begin with a number and should be 1–
30 characters long.
(1/1) Points
True
False (*)
Correct

15. Constraints cannot be added to a table after its creation.

(1/1) Points
True
False (*)
Correct
Section 6
(Answer all questions in this section)
16. The Data Definition Language performs all of the following except :
(1/1) Points
Insert data into tables (*)
Alter tables
Create tables
Add constraints to tables
Correct

17. What does the following statement do:

ALTER TABLE DEPT_TEST
ADD CONSTRAINT unq_dept_det UNIQUE (DEPT_ID, DEPARTMENT_NAME) ;
(1/1) Points
It alters the DEPT_TEST table to add a composite foreign key comprising of the
DEPT_ID and DEPARTMENT_NAME.
It alters the DEPT_TEST table to add a composite unique key comprising of the
DEPT_ID and DEPARTMENT_NAME. (*)
It alters the DEPT_TEST table to add a composite primary key comprising of the
DEPT_ID and DEPARTMENT_NAME.
It alters the DEPT_TEST table to add a the DEPT_ID and DEPARTMENT_NAME
columns.
Correct

18. It is not mandatory to specify the column list in the INSERT statement. True
or False?
(1/1) Points
True (*)
False
Correct

19. You can delete a row that contains a primary key that is used as a foreign key
in another table.
(1/1) Points
True
False (*)
Correct
20. When issuing a SQL DELETE command all rows in the table are deleted if you
omit the __________ clause.
(1/1) Points
WHERE (*)
SELECT
IF
WHEN
Correct
21. Any column that is not listed explicitly obtains a null value in the new row
unless we have _________ values for the missing columns that are used.
(1/1) Points
BEGINNING
INSERT
STANDARD
DEFAULT (*)
Correct

22. The command that always removes all rows from a table, leaving the table
empty and the table structure intact is ...
(0/1) Points
TRUNCATE (*)
DELETE
Both
None
Incorrect. Refer to Section 6 Lesson 4.

23. All of the following are tools to access a relational database except :

(1/1) Points
Oracle SQL Data Modeler (*)
SQL * Plus
Oracle SQL Developer
Oracle Application Express
Correct

24. A table is the basic storage structure of an RDBMS.

(1/1) Points
True (*)
False
Correct

25. Functions of SQL are:

(1/1) Points
Inserting, updating, and deleting rows in a table
Querying data stored in the database
Both of the above options are functions of SQL (*)
Neither of the above options are functions of SQL
Correct
26. The stages of SQL processing are Parsing, Optimization, Row Source
Generation and _____________ .
(1/1) Points
Analyzing
Execution (*)
Display
None of the above are stages of SQL processing.
Correct

27. A _______________ is a join condition containing something other than an

equality operator.
(1/1) Points
INNER JOIN
OUTER JOIN
NONEQUIJOIN (*)
CROSS JOIN
Correct

28. The ___________ JOIN clause produces the cross-product of two tables.

(1/1) Points
OUTER
CARTESIAN
CROSS (*)
INNER
Correct
29. Will the following statement execute successfully (True or False)?
SELECT e.employee_id, e.last_name, e.department_id, d.department_id,
d.location_id
FROM employees e JOIN departments d
ON (e.department_id = d.department_id);
(1/1) Points
True (*)
False
Correct

30. A join between two tables that returns the results of the INNER join as well as
the unmatched rows from the left (or right) table is called a left (or right) OUTER
join.
(1/1) Points
True (*)
False
Correct
31. We must use the ON clause to join three tables.
(1/1) Points
True
False (*)
Correct

32. Joining tables with the NATURAL JOIN, USING, or ON clauses results in an

__________ join. (Choose 2)
(0/1) Points
Equi-join (*)
INNER (*)
OUTER
CROSS
Incorrect. Refer to Section 6 Lesson 9.

33. The ______ operator requires either of the component conditions to be true.

(1/1) Points
EITHER
BETWEEN
AND
OR (*)
Correct

34. You use the ______ operator to perform wildcard searches of valid search
string values.
(1/1) Points
BETWEEN
MATCH
STRING
LIKE (*)
Correct

35. Which statement will display those employees who have a job title that
contains the string ‘JEF’ and earn $10,000 or more?
(0/1) Points
SELECT employee_id, last_name, job_id, salary
FROM employees
WHERE salary >= 10000 AND job_id LIKE '%JEF%' ; (*)
SELECT employee_id, last_name, job_id, salary
FROM employees
WHERE salary >= 10000 OR job_id LIKE '%JEF%' ;
Either statement displays the desired output.
Neither statement displays the desired output.
Incorrect. Refer to Section 6 Lesson 7.
36. You can override the default order by using parentheses around the
expressions that you want to calculate first.
(1/1) Points
True (*)
False
Correct

37. A logical condition combines the result of two component conditions to

produce a single result based on those conditions or it inverts the result of a
single condition.
(1/1) Points
True (*)
False
Correct
38. If an arithmetic expression contains more than one operator, __________ are
evaluated first.
(1/1) Points
exponentiation
anything in parenthesis (*)
multiplication and division
addition and subtraction
Correct

39. Arithmetic expressions containing a null value evaluate to _________.

(1/1) Points
will cause an error
null (*)
zero
whatever the calculation evaluates to
Correct

40. The DESCRIBE command shows the following about a table except :

(0/1) Points
Data values (*)
Field names
Primary key
Data types
Incorrect. Refer to Section 6 Lesson 6.
41. You can link columns to other columns, arithmetic expressions, or constant
values to create a character expression by using the ____________ operator (||).
(1/1) Points
alias
addition
concatenation (*)
literal
Correct

42. Null is the same as zero or a blank space. True or False?

(1/1) Points
True
False (*)
Correct

43. The following statement will result in an error (True or False):

SELECT last_name "Name" , salary*12 "Annual Salary", salary +100
FROM employees;
(1/1) Points
True
False (*)
Correct

44. Oracle Application Express is an application platform used to share and learn

_____ and __________.
(1/1) Points
SQL, Java Script
SQL, PL/SQL (*)
Java, PL/SQL
SQL, Java
Correct

45. In APEX SQL Workshop and Object Browser options you can view table
layouts.
(1/1) Points
True (*)
False
Correct
46. You can use Application Express (APEX) for ...
(0/1) Points
Developing and expanding your skills with Oracle database, SQL and PL/SQL
Gaining access to SQL and PL/SQL examples shared by the Oracle developer
community
APEX can be used for both of the above functions (*)
APEX cannot be used for either of the above functions.
Incorrect. Refer to Section 6 Lesson 1.
47. Substitution variables are used when you want to prompt for different
criteria in a condition.
(1/1) Points
True (*)
False
Correct

48. Top-n-analysis is used when you want to retrieve only the top number of
records from a result set.
(1/1) Points
True (*)
False
Correct

49. Which character is used as a substitution variable in APEX?

(1/1) Points
&
: (*)
*
;
Correct

50. The following statement will execute successfully (true or false):

SELECT employee_id, last_name, salary*12 annsal
FROM employees
ORDER BY annsal ;
(1/1) Points
True (*)
False
Correct
Section 4

(Answer all questions in this section)

1. In Oracle SQL Data Modeler, the attribute that you assign as primary UID
is automatically set to a mandatory attribute and will be engineered to a
primary key in the relational model.
(1/1) Points
True (*)
False
Correct

2. The Oracle SQL Data Modeler enables you to do all of the following
except:
(1/1) Points
Create process, logical, relational and physical models
Store metadata information
Store application data (*)
Capture business rules and information
Correct

3. A Relational model is closer to the implementation solution, facilitates

discussion and forms the basis for the physical database design.
(1/1) Points
True (*)
False
Correct
4. _______ Engineering is the process of creating a conceptual or logical
model by extracting the information from an existing data source.
(0/1) Points
Forward
Top-Down
Reverse (*)
Target
Incorrect. Refer to Section 4 Lesson 2.

Section 5

(Answer all questions in this section)

5. The steps to create a glossary from an existing Logical model are :
(1/1) Points
Right click Logical model, select Create Glossary from Logical Model (*)
Double click the Logical Model
Rick click the Relational model, select Create Glossary from Relational
Model
None of the above.
Correct

6. A ___________ model is the blue print to the actual database

implementation and can be used as the basis for implementing any type of
Database Management System (DBMS).
(1/1) Points
Database
Logical
Conceptual
Relational (*)
Correct
7. Primary key constraints should have a suffix of PKEY.
(1/1) Points
True
False (*)
Correct

8. To define naming templates in Oracle SQL Data Modeler:

(1/1) Points
Right click the name of the design in object browser
Select properties, select template
Edit the template to use abbreviations
Do all of these steps. (*)
Correct

Section 6

(Answer all questions in this section)

9. Which is the correct order of execution for statements in a SELECT query
?
(1/1) Points
SELECT, WHERE, FROM, ORDER BY
SELECT, ORDER BY,FROM, WHERE,
FROM, SELECT, ORDER BY,WHERE
FROM, WHERE, SELECT, ORDER BY (*)
Correct

10. The following statement will execute successfully (true or false):

SELECT employee_id, last_name, salary*12 annsal
FROM employees
ORDER BY annsal ;
(1/1) Points
True (*)
False
Correct

11. Which statements will execute successfully?

(Choose 2)
(0/1) Points
SELECT first_name, last_name
FROM employees
ORDER BY employee_id DES;
SELECT employee_id, last_name, job_id, department_id, hire_date
FROM employees
ORDER BY 3; (*)
SELECT employee_id, first_name, last_name
FROM employees
ORDER BY employee_id DESCEND;
SELECT first_name, last_name, first_name||last_name fullname
FROM employees
ORDER BY fullname; (*)
Incorrect. Refer to Section 6 Lesson 8.

12. Which character is used as a substitution variable in APEX?

(1/1) Points
;
*
: (*)
&
Correct

13. It is not mandatory to specify the column list in the INSERT statement.
True or False?
(1/1) Points
True (*)
False
Correct

14. The command that always removes all rows from a table, leaving the
table empty and the table structure intact is ...
(1/1) Points
TRUNCATE (*)
DELETE
Both
None
Correct

15. A collection of DML statements that form a logical unit of work is

called a ______________.
(1/1) Points
block
statement
command
transaction (*)
Correct
16. Data Manipulation Language includes all of the following except :
(1/1) Points
INSERT
DELETE
COMMIT (*)
UPDATE
Correct

17. The UPDATE statement modifies the values of a specific row or rows if
the _______ clause is specified.
(1/1) Points
WHERE (*)
SET
VALUE
MODIFY
Correct

18. We must use the ON clause to join three tables.

(1/1) Points
True
False (*)
Correct

19. Joining tables with the NATURAL JOIN, USING, or ON clauses results in
an __________ join. (Choose 2)
(1/1) Points
CROSS
INNER (*)
Equi-join (*)
OUTER
Correct

20. An _______ clause creates an equijoin between two tables using one
column from each table regardless of the name or data type.
(1/1) Points
ON (*)
CROSS JOIN
NATURAL JOIN
USING
Correct

21. Which of the following statements is syntactically correct?

(1/1) Points
SELECT e.employee_id, e.last_name, e.department_id, d.department_id,
d.location_id
FROM employees e JOIN departments d
ON (e.department_id = d.department_id)
AND e.manager_id = 149 ;
SELECT e.employee_id, e.last_name, e.department_id, d.department_id,
d.location_id
FROM employees e JOIN departments d
ON (e.department_id = d.department_id)
WHERE e.manager_id = 149 ;
Both statements are syntactically correct. (*)
Neither statement is syntactically correct.
Correct

22. Will the following statement execute successfully (True or False)?

SELECT employee_id, city, department_name
FROM employees e JOIN departments d
ON d.department_id = e.department_id
JOIN locations l
ON d.location_id = l.location_id;
(1/1) Points
True (*)
False
Correct

23. What type of join is the following statement?

SELECT e.EMPLOYEE_ID, e.LAST_NAME, d.DEPARTMENT_ID, d.DEPARTMENT_NAME,
d.LOCATION_ID
FROM EMPLOYEES e, DEPARTMENTS d;
(1/1) Points
INNER JOIN
NATURAL JOIN
OUTER JOIN
CROSS JOIN (*)
Correct

24. The _______ condition tests for nulls.

(1/1) Points
NULLABLE
NULL
IS NULL (*)
ISN'T NULL
Correct

25. You can override the default order by using parentheses around the
expressions that you want to calculate first.
(1/1) Points
True (*)
False
Correct
26. Character strings and dates in the WHERE clause must be enclosed with
single quotation marks (' ').
(1/1) Points
True (*)
False
Correct

27. The ______ operator requires either of the component conditions to be

true.
(0/1) Points
AND
EITHER
OR (*)
BETWEEN
Incorrect. Refer to Section 6 Lesson 7.

28. Which statement will display those employees who have a job title that
contains the string ‘JEF’ and earn $10,000 or more?
(1/1) Points
SELECT employee_id, last_name, job_id, salary
FROM employees
WHERE salary >= 10000 AND job_id LIKE '%JEF%' ; (*)
SELECT employee_id, last_name, job_id, salary
FROM employees
WHERE salary >= 10000 OR job_id LIKE '%JEF%' ;
Either statement displays the desired output.
Neither statement displays the desired output.
Correct

29. When you define a table, you can specify that a column should be given
a default value by using the LITERAL option.
(0/1) Points
True
False (*)
Incorrect. Refer to Section 6 Lesson 3.

30. Which constratint specifies that the column (or combination of column)
must contain unique value AND IS NOT NULL for all rows?
(0/1) Points
CHECK
UNIQUE KEY
NOT NULL
PRIMARY KEY (*)
Incorrect. Refer to Section 6 Lesson 3.

31. When altering a table, you can decrease the width of a column if …
(Choose 3)
(0/1) Points
The decrease in column width is not less than the existing values in that
column (*)
The column contains numeric values
The table has no rows (*)
The column contains only null values (*)
Incorrect. Refer to Section 6 Lesson 3.
32. You can name a constraint or the Oracle server generates a name by
using the SYS_Cn format.
(1/1) Points
True (*)
False
Correct

33. To create a table you must identify all of the following except :
(1/1) Points
Field data types
Field values (*)
Field names
Table name
Correct

34. With the __________ and ROLLBACK statements, you have control over
making changes to the data permanent
(1/1) Points
WHERE
COMMIT (*)
INSERT
DELETE
Correct

35. You can create a marker in the current transaction by using the
SAVEPOINT statement.
(1/1) Points
True (*)
False
36. Users may view data that is in the process of being changed by another
user.
(1/1) Points
True
False (*)
Correct

37. The Oracle server ensures data consistency based on transactions.

(1/1) Points
True (*)
False
Correct

38. The type of SQL Command used to define database structures is :

(1/1) Points
DDL (*)
TCL
DML
DCL
Correct

39. A table is the basic storage structure of an RDBMS.

(1/1) Points
True (*)
False
Correct

40. To connect to an Oracle database you need to use a client program. True
or False?
(1/1) Points
True (*)
False
Correct

41. You can logically relate data from multiple tables using ___________.
(1/1) Points
data values
foreign keys (*)
check constraints
unique keys
Correct

42. Oracle Application Express is an application platform used to share and

learn _____ and __________.
(1/1) Points
SQL, PL/SQL (*)
Java, PL/SQL
SQL, Java
SQL, Java Script
Correct

43. In the SQL Commands option of APEX, you can run more than one SQL
command at a time.
(0/1) Points
True
False (*)
Incorrect. Refer to Section 6 Lesson 1.

44. In APEX SQL Workshop and Object Browser options you can view table
layouts.
(1/1) Points
True (*)
False
Correct

45. Selecting specific columns from a table to be displayed in a query is

called _____________.
(0/1) Points
projection (*)
elimination
selection
sorting
Incorrect. Refer to Section 6 Lesson 6.
46. The following statement will result in an error (True or False):
SELECT last_name "Name" , salary*12 "Annual Salary", salary +100
FROM employees;
(1/1) Points
True
False (*)
Correct

47. You can specify multiple columns after the DISTINCT qualifier.
(1/1) Points
True (*)
False
Correct

48. The following statement displays all the rows in the departments table:
SELECT ____ FROM departments;
(1/1) Points
* (*)
ALL
%
#
Correct

49. A literal can be all of the following except :

(1/1) Points
a character
a date
a calculation (*)
a number
Correct
50. Which column alias will cause an error?
(1/1) Points
SELECT last_name AS Last Name FROM employees; (*)
SELECT last_name "Last Name" FROM employees;
SELECT last_name lname FROM employees;
SELECT last_name AS lname FROM employees;