Oracle Section 1 - 3
What are some INCORRECT attributes for PERSON.
Freddy Wilson Priya Hansenna
Many reasons exist for creating a conceptual model. Choose three appropriate.
They accurately describe what a physical model will contain. They capture current and future needs. They model functional and informational needs.
Which statements about attributes are true?
They describe, qualify, quantify, classify, or specify an entity. They have a data type, such as number or character string.
Unique Identifiers do what?
Distinguish one instance of an entity from all other instances of that entity.
The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network.
False
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
Consider the recommended drawing conventions for ERD's. What accurately describes diagramming conventions for entities and attributes?
The * means that an attribute is mandatory or required; the entity name should be singular.
Relationships always exist between...
2 entities (or one entity and itself)
A Matrix Diagram won't help you with what?
Defining Instances of Entities
Entities are usually verbs. True or False?
False
Relationships can be either mandatory or optional. True or False?
True
Consider an example where an Oracle database works "behind the scenes" for common internet activity. What best describes a database transaction?
A person searches an airline website to find all available fares for a flight.
Which of the following are examples of data vs. information:
A. Student age vs. average age of all students in class B. Bank deposit amount vs. total account balance D. Price of a computer vs. total sales of all computers for a compan
How do you turn "data" into "information"?
By querying it or accessing it.
In a physical data model, an attribute is represented as a/an
Column
What are the major content areas covered in the Oracle Academy?
Data Modeling, SQL, and PL/SQL
Personal computers (PCs) have been in existence since 1950. True or False?
False
Users would interact with which of the following software to access essential business applications? (Choose three)
GUI software Operating System software Internet Browser software
What is the purpose of a Unique Identifier?
To identify one unique instance of an entity by using one or more attributes and/or relationships.
An Entity Relationship model is independent of the hardware or software used for implementation. True or False?
True
Matrix Diagrams help verify that you have identified all possible relationships between your existing entities. True or False?
True
Oracle was one of the first relational database systems available commercially. True or False?
True
Which statements are true about ERD's?
You should not model derivable data. A piece of information should only be found in one place on an ERD.