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.