oracle 1

Question 1

{“How do you turn ‘data’ into ‘information’?”,
{“By testing it”, “By querying it or accessing it “,
“By storing it in a database”, “By storing it on a server”},

Answer 1

{2}}

Question 2

{“Which of the following are examples of data becoming information:”,
{“A. Student age -> average age of all students in class”,
“B. Bank deposit amount -> total account balance”,
“C. Winning time for a race -> length of race”,
“D. Price of a computer -> total sales of all computers for a company”,
“E. A, B, and D “},

Answer 2

{5}}

Question 3

{“Most of the well known Internet search engines use databases to store data. True or False?”,
{“True “, “False”},

Answer 3

{1}

Question 4

{“Businesses involved in any of the following typically use databases to handle their data: Finance, Logistics, Commerce, Procurement, and Distribution? True or False?”,
{“True “, “False”},

Answer 4

{1}}

Question 5

{“Which of the following are examples of e-businesses that use database software? (Choose all correct answers)”,
{“Online book store “, “Online personal web page”, “Online research paper”,
“Online clothing store “, “Online personal shopping service “},

Answer 5

{1, 3, 4}}

Question 6

{“A specialized type of software, which controls and manages the hardware in a computer system.”,
{“Operating System “, “Software”, “Client”, “Hardware”},

Answer 6

{1}}

Question 7

{“Which of the following represents the correct sequence of steps in the Database Development Process?”,
{“Design, Build, Analyze”, “Analyze, Design, Build “, “Build, Analyze, Design”, “Analyze, Build, Design”},

Answer 7

{2}}

Question 8

{“Data Modeling is the last step in the database development process. True or False?”,
{“True “, “False”},

Answer 8

{2}}

Question 9

Ai spus:
{“The main subject areas taught by the Oracle Academy are:”,
{“Data Modeling, SQL and PL/SQL”, “Computer Repairs”, “Database performance tuning”, “Systems programming and computer architecture”},

Answer 9

{1}},

Question 10

{“ERDish describes a relationship in words.”,
{“True “, “False”},

Answer 10

{1}}, // Single correct answer

Question 11

{“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 “},

Answer 11

{2}}, // Single correct answer

Question 12

{“Which term describes the physical components of a computer system?”,
{“Software”, “Hardware “, “Client”, “Operating System”},

Answer 12

{2}}, // Single correct answer

Question 13

{“The market for IT professionals is still increasing and will continue to do so in the future as the world gets ever more dependent on computer systems. True or False?”,
{“True “, “False”},

Answer 13

{1}}, // Single correct answer

Question 14

{“The demand for Information Technology professionals in today’s market is increasing.”,
{“True “, “False”},

Answer 14

{1}}, // Single correct answer

Question 15

{“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.”,
{“False. Business requirements can and will change. For instance new legal requirements may arise. “,
“True. The only requirement for creating a perfect system is a perfect programmer.”,
“True. Users never know what they want anyway, so building systems is best left to the professionals.”,
“True. Users delay the delivery of a system by changing their minds and adding new requirements.”},

Answer 15

{1}}, // Single correct answer

Question 16

{“Which of the following are true about Cardinality? (Choose two)”,
{“Cardinality tells ‘how many’. “, “Cardinality specifies only singularity or plurality, but not a specific plural number. “,
“Cardinality specifies whether something is required or not.”,
“Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.”},

Answer 16

{1, 2}}, // Multiple correct answers

Question 17

{“Which of the following are true about Cardinality? (Choose two)”,
{“Cardinality tells ‘how many’. “, “Cardinality specifies only singularity or plurality, but not a specific plural number. “,
“Cardinality specifies whether something is required or not.”,
“Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.”},

Answer 17

{1, 2}}, // Multiple correct answers

Question 18

{“Which of the following are true about Relationship Optionality? (Choose two)”,
{“Optionality specifies whether something is required or not. “,
“Optionality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.”,
“Optionality answers ‘may or must’. “,
“Optionality specifies only singularity or plurality, but not a specific plural number.”},

Answer 18

{1, 3}}, // Multiple correct answers

Question 19

{“All of the following would be instances of the entity ANIMAL SPECIES, except which one?”,
{“Elephant”, “Bird”, “Leaf “, “Dog”},

Answer 19

{3}}, // Single correct answer

Question 19

{“All of the following would be instances of the entity PERSON except which?”,
{“Angelina Rosalie”, “Male “, “David Jones”, “Grace Abinajam”},

Answer 19

{2}}, // Single correct answer

Question 20

{“Unique Identifiers:”,
{“Distinguish nothing”, “Distinguish one entity from another”,
“Distinguish all entities in a database”,
“Distinguish one instance of an entity from all other instances of that entity “},

Answer 20

{4}}, // Single correct answer

Question 21

{“A/an _________ is defined as ‘Something’ of significance to the business about which data must be known.”,
{“Instance”, “Relationship”, “Entity “, “None of the above”},

Answer 21

{3}}, // Single correct answer

Question 22

{“Which of the following statements about Entities are true? (Choose 3)”,
{“A name for a set of similar ‘things’ “, “They never have Instances”,
“They are usually a noun. “,
“‘Something’ of significance to the business about which data must be known. “},

Answer 22

{1, 3, 4}}, // Multiple correct answers

Question 23

{“Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. (Choose all correct answers)”,
{“They capture the implementation details of the physical model.”,
“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. “},

Answer 23

{2, 3, 5}}, // Multiple correct answers

Question 24

{"The Physical Model is derived from the Conceptual Model. True or False?", {"True ", "False"},

Answer 24

{1}}, // Single correct answer

Question 25

{"The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network.", {"True", "False "},

Answer 25

{2}}, // Single correct answer

Question 26

{"Data models show users the data that their Physical Model will contain.", {"True ", "False"},

Answer 26

{1}}, // Single correct answer

Question 27

{"Oracle was one of the first relational database systems available commercially.", {"True ", "False"},

Answer 27

{1}}, // Single correct answer

Question 28

{"Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases.", {"True ", "False"},

Answer 28

{1}}, // Single correct answer

Question 29

{"What is the difference between 'information' and 'data'?", {"Data turns into useful information. It is stored in a database and accessed by systems and users. ", "Information and data are the same.", "Information is held and understood only by users.", "Data is held and understood only by systems."},

Answer 29

{1}}, // Single correct answer

Question 30

{"Is the total number of books out on loan in one given month considered Data or Information?", {"Data", "Information", "Both", "Neither"},

Answer 30

{2}}, // Single correct answer

Question 31

{"Changes in computing have affected many of our day-to-day activities. Are all of the following examples of this change? EX: 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 ", "No"},

Answer 31

{1}}, // Single correct answer

Question 32

{"Entities are transformed into Tables during the Database Design process.", {"True ", "False"},

Answer 32

{1}}, // Single correct answer

Question 33

{"In the grid computing model, resources are pooled together for efficiency.", {"True ", "False"},

Answer 33

{1}}, // Single correct answer

Question 33

{"Personal computers (PCs) have been in existence since 1950.", {"True", "False "},

Answer 33

{2}}, // Single correct answer

Question 34

{"An Entity Relationship model is independent of the hardware or software used for implementation.", {"True ", "False"},

Answer 34

{1}}, // Single correct answer

Question 35

{"Matrix Diagrams are developed BEFORE the ERD.", {"True ", "False"},

Answer 35

{1}}, // Single correct answer

Question 36

{"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 ", "False"},

Answer 36

{1}}, // Single correct answer

Question 37

{"An ERD is an example of a Physical Model.", {"True", "False "},

Answer 37

{2}}, // Single correct answer

Question 38

{"Documenting Business Requirements helps developers control the scope of the system and prevents users from claiming that the new system does not meet their business requirements.", {"True ", "False"},

Answer 38

{1}}, // Single correct answer

Question 39

{"Find two good examples of ENTITY: Instance.", {"BOOK: Biography of Mahatma Gandhi ", "VEGETABLE: grows", "TRAIN: runs", "DAIRY PRODUCT: milk "},

Answer 39

{1, 4}}, // Multiple correct answers

Question 40

{"Which of the following attributes is suitable to be a Unique Identifier?", {"Address", "Last name", "First name", "Social Security Number "},

Answer 40

{4}}, // Single correct answer

Question 40

{"Which of the following entities most likely contains valid attributes? (Choose two)", {"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, Start Date"},

Answer 40

{1, 2}}, // Multiple correct answers

Question 41

{"Which of the following are examples of ENTITY: Instance? (Choose Two)", {"MEAT PRODUCT: Lettuce", "TRANSPORTATION METHOD: Car ", "BODY PART: Larry Ellison", "ANIMAL: Dog "},

Answer 41

{2, 4}}, // Multiple correct answers

Question 41

{"Which of the following can be found in an ERD? (Choose Two)", {"Attributes. ", "Instances.", "Entities. ", "Tables."},

Answer 41

{1, 3}}, // Multiple correct answers

Question 42

{"Which of the following is an example of a volatile attribute?", {"Hire Date", "Name", "Date of Birth", "Age "},

Answer 42

{4}}, // Single correct answer

Question 43

{"All of the following could be attributes of an ENTITY called PERSON, except which one?", {"Gender", "Natacha Hansen ", "Weight", "Haircolor"},

Answer 43

{2}}, // Single correct answer

Question 43

{"Which symbol is used to show that a particular attribute is mandatory?", {"o", "* ", "#", "&"},

Answer 43

{2}}, // Single correct answer

Question 44

{"When reading a relationship between 2 entities, the relationship is read both from left to right and right to left.", {"True ", "False"},

Answer 44

{1}}, // Single correct answer

Question 45

{"Matrix Diagrams show Optionality and Cardinality of the ERDs they document.", {"True ", "False"},

Answer 45

{2}}, // Single correct answer

Question 46

{"Relationship names are not shown on an ERD.", {"True", "False "},

Answer 46

{2}}, // Single correct answer

Question 47

{"Which of the following statements are true about ERD's? (Choose Two)", {"You should not model derivable data. ", "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. ", "All data must be represented on the ERD, including derived summaries and the result of calculations."},

Answer 47

{1, 3}}, // Multiple correct answers

Question 48

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

Answer 48

{2}}, // Single correct answer

Question 48

{"Why is it important to identify and document business rules?", {"It allows you to create a complete 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"},

Answer 48

{1}}, // Single correct answer

Question 49

{"Relationship Cardinality is important.", {"True ", "False"},

Answer 49

{1}}, // Single correct answer

Question 49

{"Which of the following are used to show Cardinality on an ERD? (Choose two)", {"Dashed line.", "Single toe. ", "Crow's foot. ", "Solid line."},

Answer 49

{2, 3}}, // Multiple correct answers

Question 50

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

Answer 50

{2}}, // Single correct answer

Question 51

{"Data Modeling is the last step in the database development process. True or False?", {"True ", "False"},

Answer 51

{2}}, // Single correct answer

Question 52

{"Data Modeling is the last step in the database development process. True or False?", {"True ", "False"},

Answer 52

{2}}, // Single correct answer

Question 53

{"Data modeling is performed for the following reasons: (Choose Two)", {"We do not need datamodels; we can just start coding right away.", "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. "},

Answer 53

{2, 4}}, // Multiple correct answers

Question 54

{"Why is it important to identify and document structural rules?", {"Ensures we know what data to store and how that data works together. ", "Ensures nothing. There are no benefits to documenting your Structural Business Rules.", "We need to concentrate on the Procedural Business Rules only.", "Ensures we know what processes are in place and how to program them."},

Answer 54

{1}}, // Single correct answer

Question 55

{"A subtype is drawn on an ERD as an entity inside the 'softbox' of the supertype.", {"True ", "False"},

Answer 55

{1}}, // Single correct answer

Question 56

{"All ER diagrams must have one of each of the following: (Choose two)", {"At least one supertype and subtype", "One or more Entities ", "Relationships between entities ", "Arcs"},

Answer 56

{2, 3}}, // Multiple correct answers

Question 57

{"A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system.", {"True ", "False"},

Answer 57

{1}}, // Single correct answer

Question 58

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

Answer 58

{3}}, // Single correct answer

Question 59

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

Answer 59

{3}}, // Single correct answer

Question 60

{"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."},

Answer 60

{2}}, // Single correct answer

Question 61

"A subtype is shown on an ERD as an entity with a one to many relationship to the supertype.", {"True", "False "},

Answer 61

{2}}, // Single correct answer

Question 62

{"A subtype can have a relationship not shared by the supertype.", {"True ", "False"},

Answer 62

{1}}, // Single correct answer

Question 63

{"All instances of a subtype may be an instance of the supertype but does not have to.", {"True", "False "},

Answer 63

{2}}, // Single correct answer

Question 64

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

Answer 64

{3}}, // Single correct answer

Question 65

{"What uncommon relationship is described by the statements: 'Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE'", {"Many to Many Mandatory", "One to Many Optional", "One to Many Mandatory", "One to One Optional "},

Answer 65

{4}}, // Single correct answer

Question 66

{"If two entities have two relationships between them, these relationships can be either:", {"Redundant or Required ", "Replicated or Required", "Resourced and Really Good", "Redundant and Replicated"},

Answer 66

{1}}, // Single correct answer

Question 67

{"Which of the following pairs of entities is most likely to be modeled as a M:M relationship?", {"TREE and BRANCH", "PERSON and FINGERPRINT", "TEACHER and SUBJECT AREA ", "CAR and WHEEL"},

Answer 67

{3}}, // Single correct answer

Question 68

{"If a relationship can NOT be moved between instances of the entities it connects, it is said to be:", {"Mandatory", "Transferable", "Optional", "Non-Transferable "},

Answer 68

{4}}, // Single correct answer

Question 68

{"Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False?", {"True", "False "},

Answer 68

{2}}, // Single correct answer

Question 69

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

Answer 69

{2}}, // Single correct answer

Question 70

{"Many to many relationships must be left in the Model. It is important to have them documented as M-M.", {"True", "False "},

Answer 70

{2}}, // Single correct answer

Question 71

{"A non-transferable relationship means the relationship is mandatory at both sides.", {"True", "False "},

Answer 71

{2}}, // Single correct answer

Question 71

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

Answer 71

{4}}, // Single correct answer

Question 72

{"Intersection Entities often have the relationships participating in the UID, so the relationships are often barred.", {"True ", "False"},

Answer 72

{1}}, // Single correct answer

Question 73

{"Many to many relationships between entities usually hide what?", {"More attributes", "Another entity ", "Uniqueness", "Another relationship"},

Answer 73

{2}}, // Single correct answer

Question 74

{"A barred relationship on an ERD signifies that the UID of the intersection entity is inherited from the entities that made up the original many to many relationship.", {"True ", "False"},

Answer 74

{1}}, // Single correct answer

Question 75

{"What relationship is described by the statements: 'Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER'", {"One to Many ", "Many to Many", "One to One", "Many to More"},

Answer 75

{1}}, // Single correct answer

Question 76

{"Which of the following is an example of a non-transferable relationship?", {"STUDENT to COURSE", "TEACHER to SCHOOL", "EMPLOYEE to DEPARTMENT", "PERSON to BIRTH PLACE "},

Answer 76

{4}}, // Single correct answer

Question 77

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

Answer 77

{1}}, // Single correct answer

Question 78

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

Answer 78

{2}}, // Single correct answer

Question 79

{"Why is it important to identify and document structural rules?", {"Ensures we know what data to store and how that data works together. ", "Ensures nothing. There are no benefits to be gained from documenting your Structural Business Rules.", "We need to concentrate on the Procedural Business Rules only.", "Ensures we know what processes are in place and how to program them."},

Answer 79

{1}}, // Single correct answer

Question 80

{"A business rule such as 'We only ship goods after customers have completely paid any outstanding balances on their account' is best enforced by:", {"Creating additional programming code to verify no goods are shipped until the account has been settled in full. ", "Making the payment attribute optional.", "We need to trust our customers, and we know they will pay some day.", "Making the payment attribute null."},

Answer 80

{1}}, // Single correct answer

Question 81

{"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 subtype", "You cannot model this. You need to document it ", "Make the attribute Birthdate mandatory", "Use a supertype"},

Answer 81

{2}}, // Single correct answer

Question 82

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

Answer 82

{1}}, // Single correct answer

Question 83

{"Which of the following is true about subtypes?", {"Subtypes must be mutually exclusive. ", "Subtypes should not be exhaustive.", "One instance of a supertype may belong to two subtypes.", "Subtypes must not be mutually exclusive."},

Answer 83

{1}}, // Single correct answer

Question 84

{"How would you model a business rule that states that girls and boys may not attend classes together?", {"Make the attribute Gender optional", "Make the attribute Gender mandatory", "Use a supertype", "Supertype STUDENT has two subtypes BOY and GIRL which are related to GENDER, which is related to CLASS "},

Answer 84

{4}}, // Single correct answer

Question 85

{"All instances of the supertype must be an instance of one of the subtypes. True or False?", {"True ", "False"},

Answer 85

{2}}, // Single correct answer

Question 86

{"All instances of a subtype must be an instance of the supertype.", {"True ", "False"},

Answer 86

{1}}, // Single correct answer

Question 87

{"Which of the following are used to show a relationship on an ERD? (Choose Three)", {"# symbol.", "Crow's foot. ", "Solid line. ", "Dashed line. "},

Answer 87

{2, 3, 4}}, // Multiple correct answers

Question 88

{"When reading the relationships in an ERD, you are said to be speaking:", {"Gibberish", "Relationship-ish", "Entity-ish", "ERDish "},

Answer 88

{4}}, // Single correct answer

Question 89

{"To identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it. True or False?", {"True ", "False"},

Answer 89

{1}}, // Single correct answer

Question 90

{"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)", {"Each FOOD TYPE may be given to one or more ANIMALs. ", "Each FOOD TYPE may be manufactured by one or more ANIMALs.", "Each ANIMAL must be the seller of one or more FOOD TYPES.", "Each FOOD TYPE must be suitable for one or more ANIMALs. "},

Answer 90

{1, 4}}, // Multiple correct answers

Question 90

{"Relationships always exist between:", {"2 attributes", "3 or more attributes", "3 or more entities", "2 entities (or one entity and itself) "},

Answer 90

{4}}, // Single correct answer

Question 90

{"One Relationship can be mandatory in one direction and optional in the other direction. True or False?", {"True ", "False"},

Answer 90

{1}}, // Single correct answer