Term
| There is a big increase in demand for Information Technology professionals in today's market. True or False? |
|
Definition
|
|
Term
| What are the major content areas covered in the Oracle Academy? |
|
Definition
| Data Modeling, SQL and PL/SQL |
|
|
Term
| What are the results of having all your data in one central location? |
|
Definition
Improved performance
Easier access to data |
|
|
Term
| How do you turn "data" into "information"? |
|
Definition
| By querying it or accessing it |
|
|
Term
| the following is an example of data vs. information:Student age vs average age of all students in class. |
|
Definition
|
|
Term
| Consider an example where an Oracle database works "behind the scenes" for common internet activity. Which of the following best describes a database transaction? |
|
Definition
| A person searching an airline website to find all available fares for a flight. |
|
|
Term
| Data Modeling is the last stage in the development of a database. True or False? |
|
Definition
|
|
Term
| Oracle was one of the first relational database systems available commercially? True or False? |
|
Definition
|
|
Term
| Which of the following is the correct order for the Database Development Process? |
|
Definition
| Strategy, Analysis, Design, Build |
|
|
Term
| Which of the following are examples of e-businesses that use database software? |
|
Definition
Online clothing store
Online book store
Online personal shopping service |
|
|
Term
| Personal computers (PCs) have been in existence since 1950. True or False? |
|
Definition
|
|
Term
Are all of the following examples of how changes in computing have affected day-to-day activities? 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. |
|
Definition
|
|
Term
| In the grid computing model, resources are pooled together for efficiency. True or False? |
|
Definition
|
|
Term
| The overall mission of the Oracle Corporation is to use the internet and fast servers to meet the needs of organizations by only storing data. True or False? |
|
Definition
|
|
Term
| Users would use which of the following software to access essential business applications? |
|
Definition
GUI Interface
Internet Browser
Operating System |
|
|
Term
| A customized hat is an example of the conceptual model or the physical model? |
|
Definition
|
|
Term
| Which of the following are reasons we create conceptual models? |
|
Definition
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 |
|
|
Term
| Many reasons exist for creating a conceptual model. |
|
Definition
They model functional and informational needs.
They capture current and future needs.
They accurately describe what a physical model will contain |
|
|
Term
| An Entity Relationship Diagram is an example of a Physical Model. True or False? |
|
Definition
|
|
Term
In the following statements, find two examples of ENTITY: Instance. (Choose Two)
DAIRY PRODUCT: milk
VEGETABLE: grows
BOOK: Biography of Mahatma Gandhi
TRAIN: runs |
|
Definition
DAIRY PRODUCT: milk
BOOK: Biography of Mahatma Gandhi |
|
|
Term
| An entity may have which of the following? |
|
Definition
|
|
Term
| In a physical data model, an attribute is represented as a/an |
|
Definition
|
|
Term
| 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. |
|
Definition
|
|
Term
| 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. |
|
Definition
|
|
Term
All of the following would be instances of the entity PERSON except which?
David Jones
Male
Angelina Rosalie
Grace Abinajam |
|
Definition
|
|
Term
|
Definition
| Distinguish one instance of an entity from all other instances of that entity |
|
|
Term
Some of the following could be attributes of an ENTITY called PERSON. Select the incorrect attributes for PERSON. (Choose Two)
Age
Freddy Wilson
Name
Priya Hansenna |
|
Definition
Freddy Wilson
Priya Hansenna |
|
|
Term
| Entities are usually verbs. True or False? |
|
Definition
|
|
Term
Which of the following statements about attributes are true? (Choose Two)
They describe, qualify, quantify, classify, or specify an entity.
They are often adjectives.
They have a data type such as a number or character string.
They must be single valued unless they belong to more than one entity. |
|
Definition
They describe, qualify, quantify, classify, or specify an entity.
They have a data type such as a number or character string. |
|
|
Term
| What is the purpose of a Unique Identifier? |
|
Definition
| To identify one unique instance of an entity, by using one or more attributes and/or relationships. |
|
|
Term
Which of the following entities most likely contains invalid attributes?
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: Mother. Attributes: Name, Birthdate, Occupation, Salary |
|
Definition
| Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed |
|
|
Term
| The word "Volatile" means.... |
|
Definition
| Changing constantly; unstable |
|
|
Term
| 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? |
|
Definition
|
|
Term
| An Entity Relationship model is independent of the hardware or software used for implementation. True or False? |
|
Definition
|
|
Term
Which of the following statements are true about ERD's? (Choose Two)
A piece of information can be shown multiple times on an ERD.
A piece of information should only be found one place on an ERD.
You should not model derivable data.
All data must be represented on the ERD, including derived summaries and the result of calculations. |
|
Definition
A piece of information should only be found one place on an ERD.
You should not model derivable data. |
|
|
Term
| 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? |
|
Definition
|
|
Term
| Relationships can be either mandatory or optional. True or False? |
|
Definition
|
|
Term
| What are the three properties that every relationship should have? |
|
Definition
| Name, optionality, degree |
|
|
Term
| Whhat is the best relationship name from CUSTOMER to ITEM |
|
Definition
| Each CUSTOMER must be the buyer of one or more ITEMS. |
|
|
Term
| Relationships always exist between |
|
Definition
| 2 entities (or one entity twice) |
|
|
Term
| Entity names are always plural. True or False? |
|
Definition
|
|
Term
Which symbol is used to show that a particular attribute is optional?
*
o
#
& |
|
Definition
|
|
