Oracle Study Guide Sections 1-10

Consider an example where an Oracle database works "behind the scenes" for common internet activity. Which of the following best describes a database transaction? -A person looks in the newspaper for good internet sites. -A student places a link to his homepage from the school's website. -A person searches an airline website to find all available fares for a flight. -A business identifies the processes it uses for purchasing inventory.

-A person searches an airline website to find all available fares for a flight.

Which of the following can be added to a relationship? -An attribute -An arc can be assigned -A composite attribute -An optional attribute can be created

-An arc can be assigned

Which of the following represents the correct sequence of steps in the Database Development Process? -Analyze, Design, Build -Build, Analyze, Design -Analyze, Build, Design -Design, Build, Analyze

-Analyze, Design, Build

How would you model a business rule that states that on a student's birthday, he does not have to attend his classes? -Use a supertype -You cannot model this. You need to document it -Make the attribute Birthdate mandatory -Use a subtype

-You cannot model this. You need to document it

Which of the following are relationship types? (Choose Two) -One to Another -Many to Many -One to Many -One to Some

-Many to Many -One to Many

When data is stored in more than one place in a database, the database violates the rules of ___________. -Normalization -Decency -Replication -Normalcy

-Normalization

If the same relationship is represented twice in an Entity Relationship Model, it is said to be: -Redundant -Removable -Replicated -Resourceful

-Redundant

If a relationship can be moved between instances of the entities it connects, it is said to be: -Implicit -Committed -Recursive -Transferable

-Transferable

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. -Attribute -Process -Table -ERD

-Attribute

What are the major content areas covered in the Oracle Academy? -SQL, database configuration, and performance tuning. -Data Modeling, PJava and C+ -Data Modeling, SQL, and PL/SQL -Database programming, and Computer repair.

-Data Modeling, SQL, and PL/SQL

A Matrix Diagram will help you with all of the following except: -Verifying Relationships Between Entities -Defining Instances of Entities -Naming Relationships -Identifying Entities

-Defining Instances of Entities

A non-transferable relationship is represented by which of the following symbols? -Diamond -Heart -Circle -Triangle

-Diamond

Entities are usually verbs. True or False?

-False

Entity names are always plural. True or False?

-False

If subtypes are listed, a supertype should have at least two subtypes. True or False?

-False

Many-to-Many relationships are perfectly acceptable in a finished ERD. There is no need to do any more work on them. True or False?

-False

Data Modeling is the last step in the database development process. True or False?

-False (First Step)

An entity may have which of the following? -Experiences -Instances -Tables -None of the above

-Instances

A unique identifier can only be made up of one attribute. True or False?

-False

All instances of the supertype are also instances of one of the subtypes. True or False?

-False

An Entity Relationship Diagram is an example of a Physical Model. True or False?

-False

An entity can be on 2nd Normal Form even if it has repeated values. True or False?

-False

Personal computers (PCs) have been in existence since 1950. True or False?

-False

A customized hat sitting on your friend's head is an example of which model--the conceptual model or the physical model? -Physical Model -Conceptual Model

-Physical Model

A UID can be made up from the following: (Choose Two) -Entities -Synonyms -Relationships -Attributes

-Relationships -Attributes

Entity boxes are drawn as... -Soft Boxes -Normal Circles -Hard Boxes -Bold Circle

-Soft Boxes

Examine the following entity and decide which attribute breaks the 2nd Normal Form rule: ENTITY: CLASS ATTRIBUTES: CLASS ID DURATION SUBJECT TEACHER NAME AND ADDRESS -DURATION -TEACHER NAME AND ADDRESS -SUBJECT -CLASS ID

-TEACHER NAME AND ADDRESS

A subtype can have a relationship not shared by the supertype. True or False?

-True

Attributes are written inside the entity to which they belong. True or False?

-True

If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by -Creating new attributes. -Barring the relationships to the original entities. -Placing the UID attributes from the original entities into the intersection entity. -None of the above.

-Barring the relationships to the original entities.

The word "Volatile" means: -Static; unlikely to change -Changing constantly; unstable -Limited quantity -Large quantity

-Changing constantly; unstable

What are the results of having all your data in one central location? (Choose two) -Easier access to data -Improved performance -Updates are harder to execute -Decreased performance

-Easier access to data -Improved performance

Creating a Matrix Diagram is a mandatory step in Data Modeling. True or False?

-False

The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network. True or False?

-False

When reading a relationship between 2 entities, the relationship is only read from left to right. True or False?

-False

When resolving a M:M relationship, the new relationships will always be __________ on the many side. -Optional -Mandatory -Redundant -Recursive

-Mandatory

Examine the following Entity and decide which sets of attributes break the 3rd Normal Form rule: (choose two) ENTITY: TRAIN (SYNONYM: ROLLING STOCK) ATTRIBUTES: TRAIN ID MAKE MODEL DRIVER NAME DEPARTURE STATION NUMBER OF CARRIAGES NUMBER OF SEATS DATE OF MANUFACTURE -TRAIN ID, MAKE -MODEL, DATE OF MANUFACTURE -NUMBER OF CARRIAGES, NUMBER OF SEATS -DEPARTURE STATION, DRIVER NAME

-NUMBER OF CARRIAGES, NUMBER OF SEATS -DEPARTURE STATION, DRIVER NAME

What are the three properties that every relationship should have? -A UID bar, a diamond, an arc -Transferability, degree, name -Name, optionality, arcs -Name, optionality, cardinality

-Name, optionality, cardinality

Some of the following could be attributes of an ENTITY called PERSON; select the INCORRECT attributes for PERSON. (Choose Two) -Priya Hansenna -Age -Freddy Wilson -Name

-Priya Hansenna -Freddy Wilson

Which of the following pairs of entities is most likely to be modeled as a M:M relationship? (Choose Two) -RENTAL CAR and DRIVER -TREE and SEEDLING -STUDENT and CLASS -PARENT and CHILD

-RENTAL CAR and DRIVER -STUDENT and CLASS

Which of the following would best be represented by an arc? -STUDENT (will-attend-university, will-not-attend-university) -STUDENT (graduating, non-graduating) -STUDENT (senior, junior) -STUDENT ( University, Trade School)

-STUDENT ( University, Trade School)

Which of the following is true about supertypes and subtypes? -Two subtypes from the same supertype have a one-to-one relationship between them -Subtypes inherit the relationships and attributes of the supertype. -Subtypes may have no more than 2 levels of nesting. -Supertype and subtype entities must mutually exclude one another

-Subtypes inherit the relationships and attributes of the supertype.

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 C.Winning time for a race vs. length of race D.Price of a computer vs. total sales of all computers for a company

-A,B, and D

Which of the following is an example of a structural business rule? -All overdue payments will have an added 10 % late fee. -All products will have a selling price no less than 30 % greater than wholesale. -All employees must belong to at least one department. -Buildings to be purchased by the business must be current with earthquake building code.

-All employees must belong to at least one department.

What is the rule of Second Normal Form? -All non-UID attributes must be dependent upon the entire UID. -Some non-UID attributes can be dependent on the entire UID. -No non-UID attributes can be dependent on any part of the UID. -None of the above

-All non-UID attributes must be dependent upon the entire UID.

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 -All of the above

-All of the above

Many to many relationships between entities usually hide what? -Uniqueness -Another relationship -More attributes -Another entity

-Another entity

To visually represent exclusivity between two or more relationships in an ERD you would most likely use a/an ________. -Arc -UID -Supertype -Subtype

-Arc

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". To be able to uniquely and efficiently identify one instance of the entity SHOE, a/an ______________ UID can be created. -Artificial -Structured -Unrealistic -Identification

-Artificial

The "Other" subtype is best used: -For instances that belong to the supertype and at least one other subtype. -For a subtype that does not have any of the same attributes as the supertype to which it belongs. -As an extra subtype to ensure that the list of subtypes is exhaustive. By having an "Other" subtype, all instances of the Supertype will have a subtype to belong to. -You should never have a subtype called "Other".

-As an extra subtype to ensure that the list of subtypes is exhaustive. By having an "Other" subtype, all instances of the Supertype will have a subtype to belong to.

How do you turn "data" into "information"? -By testing it -By storing it in a database -By querying it or accessing it -By storing it on a server

-By querying it or accessing it

In a physical data model, an attribute is represented as a/an -Instance -Row -Column -Foreign Key

-Column

An entity can only have one UID. True or False?

-False

No database in the world is ever truly on 3rd Normal Form. Everyone always stops after 2nd Normal Form. True or False?

-False

Non-transferable relationships can only be mandatory, not optional. True or False?

-False

The purpose of an ERD is to document the proposed system and facilitate discussion and understanding of the requirements captured by the developer. True or False? -True -False

-True

Two entities can have one or more relationships between them. True or False?

-True

Which symbol is used to show that a particular attribute is optional? -# -& -* -o

-o

Secondary UID's are... -Mandatory in data modeling -Not permitted in data modeling -Always comprised of numbers -Useful as an alternative means of identifying instances of an entity

-Useful as an alternative means of identifying instances of an entity

When are relationships unnecessary? -When you can derive the relationship from other relationships in the model -When they have the same visual structure but different meaning -When the information does not relate to the model -When the relationships connect 2 entities and they each have distinct meanings

-When you can derive the relationship from other relationships in the model

Changes in computing have affected many of our day-to-day activities. Are all of the following activities examples of this change? Yes or No? -"In the past you used to use the phone system to call directory assistance to get a phone number. Today you can use your PC to look up a phone number online." -"In the past you used to have to go to the shoe store to buy shoes. Today you can use your PC to order shoes online." -"In the past you had to use your PC to send a person an email. Today you can use your phone to send a text message."

-Yes

On an ER diagram, which symbol identifies an attribute as part of a unique identifier. -# -o -* -x

-#

When all attributes are single-valued, the database model is said to conform to: -3rd Normal Form -4th Normal Form -1st Normal Form -2nd Normal Form

-1st Normal Form

Relationships always exist between -2 entities (or one entity and itself) -2 attributes -3 or more attributes -3 or more entities

-2 entities (or one entity and itself)

Which of the following statements are true about ERD's? (Choose Two) -All data must be represented on the ERD, including derived summaries and the result of calculations. -A piece of information can be shown multiple times on an ERD. -A piece of information should only be found in one place on an ERD. -You should not model derivable data.

-A piece of information should only be found in one place on an ERD. -You should not model derivable data.

'Only managers can approve travel requests' is an example of which of the following? -An optional business rule. -A mandatory business rule. -A structural business rule. -A procedural business rule.

-A procedural business rule.

When you resolve a M:M by creating an intersection entity, this new entity will always inherit: -A relationship to each entity from the original M:M. -The attributes of both related entities. -The UID's from the entities in the original M:M. -Nothing is inherited from the original entities and relationship.

-A relationship to each entity from the original M:M

Which of the following is the best scenario for using supertype/subtype entities: -A vehicle dealership that sells boats on trailers, cars, and trucks. -A pet store that sells small animals that need different sized cages and different food. -A grocery store that gives customers a choice of plastic or paper bags.

-A vehicle dealership that sells boats on trailers, cars, and trucks.

Consider the recommended drawing conventions for ERD's. Indicate which of the following accurately describes diagramming conventions for entities and attributes: -The 'o' means that the attribute is optional; entity names should be plural verbs. -The '*' means that an attribute is mandatory or required; the entity name should be singular. -The 'o' means that the attribute is mandatory or required; the entity name should be a singular noun. -The '*' means that an attribute is optional; entity names should be plural verbs.

-The * means that an attribute is mandatory or required; the entity name should be singular.

Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. -They accurately describe what a physical model will contain. -They model functional and informational needs. -They capture current and future needs. -They model the information flow of data.

-They accurately describe what a physical model will contain. -They model functional and informational needs. -They capture current and future needs.

All attributes that are part of the UID are mandatory. True or False?

-True

All instances of a subtype must be an instance of the supertype. True or False?

-True

A business rule such as "All accounts must be paid in full within 10 days of billing" is best enforced by: -Hiring a programmer to create additional programming code to identify and report accounts past due. -Making the relationship between CUSTOMER and PAYMENT fully mandatory and 1:1 on both sides. -Making the payment attribute mandatory. -Creating a message to be printed on every bill that reminds the customer to pay within ten days.

-Hiring a programmer to create additional programming code to identify and report accounts past due.

Users would interact with which of the following software to access essential business applications? (Choose three) -Internet Browser software -GUI software -Server software -Operating System software

-Internet Browser Software -GUI Software -Operating System Software

Why is it important to identify and document business rules? -It allows you to create your data model and then check it for accuracy. -It allows you to improve the client's business. -It ensures that the data model will automate all manual processes. -None of the above

-It allows you to create your data model and then check it for accuracy.

How should you handle constraints that cannot be modeled on an ER diagram? -List them on a separate document to be handled programmatically -Explain them to the users so they can enforce them -Always let the network architect handle them -All constraints must be modeled and shown on the ER diagram

-List them on a separate document to be handled programmatically

All of the following would be instances of the entity PERSON except which? -Angelina Rosalie -David Jones -Grace Abinajam -Male

-Male

What uncommon relationship is described by the statements: "Each LINE must consist of many POINTS and each POINT must be a part of many LINES" -One to Many Mandatory -Many to Many Mandatory -Many to Many Optional -One to Many Optional

-Many to Many Mandatory

An Entity Relationship model is independent of the hardware or software used for implementation. True or False? -True -False

-True

Business rules are important to data modelers because: -They capture all of the needs, processes, and required functionality of the business. -They are easily implemented in the ERD diagram. -The data modeler must focus on structural rules, because they are easily represented diagrammatically and eliminate other rules that involve extra procedures or programming. -Both A and C are true.

A. They capture all of the needs, processes, and required functionality of the business.

In the following statements, find two good examples of ENTITY: Instance. (Choose Two) -DAIRY PRODUCT: milk -VEGETABLE: grows -BOOK: Biography of Mahatma Gandhi -TRAIN: runs

-DAIRY PRODUCT: milk -BOOK: Biography of Mahatma Gandhi

Unique Identifiers: -Distinguish all entities in a database -Distinguish nothing -Distinguish one instance of an entity from all other instances of that entity -Distinguish one entity from another

-Distinguish one instance of an entity from all other instances of that entity

In a business that sells computers, choose the best relationship name from CUSTOMER to ITEM (computer, in this case). -Each CUSTOMER may be the producer of one or more ITEMS. -Each CUSTOMER must be the seller of one or more ITEMS. -Each CUSTOMER must be the buyer of one or more ITEMS. -Each CUSTOMER may be the maker of one or more ITEMS.

-Each CUSTOMER must be the buyer of one or more ITEMS.

After looking at the diagram, choose the sentence below that could be "read" from the existing relationship (even though you're missing relationship labels!) (Student)>-----------<(Activity) -Each Student may participate in one or more Activities. -Each Activity must belong to one and only one Student. -Each Activity may be performed by one or more Students. -Each Student must have one or more Activities.

-Each Student may participate in one or more Activities.

Which of the following entities most likely contains invalid attributes? -Entity: Mother. Attributes: Name, Birthdate, Occupation, Number of Children -Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built -Entity: Pet. Attributes: Name, Birthdate, Owner -Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed

-Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed

Which of the following is a TRUE statement about the diagram below? ( B ) ( ) ((A)(Z) ) -Every Z is either an A or a B -Every B is a Z -Every A is a Z -Every A is a B

-Every A is a B

A well structured ERD will show only some parts of the finished data model. You should never try to model the entire system in one diagram, no matter how small the diagram might be. True or False? -True -False

-False

An entity can have repeated values and still be in 1st Normal Form. True or False?

-False

If the entity CD has the attributes: #number, *title, *producer, *year, o store name, o store address, this entity is in 3rd Normal Form ("no non-UID attribute can be dependent on another non-UID attribute). True or False?

-False

The following entity is in 1st normal form: True or False? ENTITY: VEHICLE ATTRIBUTES: REGISTRATION MAKE MODEL COLOR DRIVER PASSENGER 1 PASSENGER 2 PASSENGER 3

-False

This diagram could also be expressed as a supertype/subtype construction. True or False? ( Student ) (COURSE ) ( #*ID ) (#*ID ) (* First Name) -----__l_<(Student Class)>__l_--(oDifficulty ) (*Last Name ) (*Descripton) (oEye Color )

-False

Which of the following is the definition for Third Normal Form? -All attributes are single valued -All attributes are uniquely doubled and independent -No non-UID attribute can be dependent on another non-UID attribute -An attribute must be dependent upon the entity's entire UID

-No non-UID attribute can be dependent on another non-UID attribute

Which of the following statements about attributes are true? (Choose Two) -They have a data type, such as number or character string. -They describe, qualify, quantify, classify, or specify an entity. -They are often adjectives. -They must be single valued unless they belong to more than one entity.

-They have a data type, such as number or character string. -They describe, qualify, quantify, classify, or specify an entity.

What is the purpose of a Unique Identifier? -Create an entity that is unlike any other entity aside from itself. -To identify a specific row within a table, using one or more columns and/or foreign keys. -To uniquely determine a table and columns within that table. -To identify one unique instance of an entity by using one or more attributes and/or relationships.

-To identify one unique instance of an entity by using one or more attributes and/or relationships.

As a database designer, you have a responsibility to store data in only one place and in the best possible place. True or False?

-True

In the grid computing model, resources are pooled together for efficiency. 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

Relationships can be either mandatory or optional. True or False?

-True

The demand for Information Technology professionals in today's market is increasing. True or False? -True -False

-True