oracle 1 Flashcards
{“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”},
{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 “},
{5}}
{“Most of the well known Internet search engines use databases to store data. True or False?”,
{“True “, “False”},
{1}
{“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”},
{1}}
{“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 “},
{1, 3, 4}}
{“A specialized type of software, which controls and manages the hardware in a computer system.”,
{“Operating System “, “Software”, “Client”, “Hardware”},
{1}}
{“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”},
{2}}
{“Data Modeling is the last step in the database development process. True or False?”,
{“True “, “False”},
{2}}
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”},
{1}},
{“ERDish describes a relationship in words.”,
{“True “, “False”},
{1}}, // Single correct answer
{“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 “},
{2}}, // Single correct answer
{“Which term describes the physical components of a computer system?”,
{“Software”, “Hardware “, “Client”, “Operating System”},
{2}}, // Single correct answer
{“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”},
{1}}, // Single correct answer
{“The demand for Information Technology professionals in today’s market is increasing.”,
{“True “, “False”},
{1}}, // Single correct answer
{“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.”},
{1}}, // Single correct answer
{“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.”},
{1, 2}}, // Multiple correct answers
{“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.”},
{1, 2}}, // Multiple correct answers
{“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.”},
{1, 3}}, // Multiple correct answers
{“All of the following would be instances of the entity ANIMAL SPECIES, except which one?”,
{“Elephant”, “Bird”, “Leaf “, “Dog”},
{3}}, // Single correct answer
{“All of the following would be instances of the entity PERSON except which?”,
{“Angelina Rosalie”, “Male “, “David Jones”, “Grace Abinajam”},
{2}}, // Single correct answer
{“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 “},
{4}}, // Single correct answer
{“A/an _________ is defined as ‘Something’ of significance to the business about which data must be known.”,
{“Instance”, “Relationship”, “Entity “, “None of the above”},
{3}}, // Single correct answer
{“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. “},
{1, 3, 4}}, // Multiple correct answers
{“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. “},
{2, 3, 5}}, // Multiple correct answers
{“The Physical Model is derived from the Conceptual Model. True or False?”,
{“True “, “False”},
{1}}, // Single correct answer
{“The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network.”,
{“True”, “False “},
{2}}, // Single correct answer
{“Data models show users the data that their Physical Model will contain.”,
{“True “, “False”},
{1}}, // Single correct answer
{“Oracle was one of the first relational database systems available commercially.”,
{“True “, “False”},
{1}}, // Single correct answer
{“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”},
{1}}, // Single correct answer
{“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.”},
{1}}, // Single correct answer
{“Is the total number of books out on loan in one given month considered Data or Information?”,
{“Data”, “Information”, “Both”, “Neither”},
{2}}, // Single correct answer
{“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”},
{1}}, // Single correct answer
{“Entities are transformed into Tables during the Database Design process.”,
{“True “, “False”},
{1}}, // Single correct answer
{“In the grid computing model, resources are pooled together for efficiency.”,
{“True “, “False”},
{1}}, // Single correct answer
{“Personal computers (PCs) have been in existence since 1950.”,
{“True”, “False “},
{2}}, // Single correct answer
{“An Entity Relationship model is independent of the hardware or software used for implementation.”,
{“True “, “False”},
{1}}, // Single correct answer
{“Matrix Diagrams are developed BEFORE the ERD.”,
{“True “, “False”},
{1}}, // Single correct answer
{“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”},
{1}}, // Single correct answer
{“An ERD is an example of a Physical Model.”,
{“True”, “False “},
{2}}, // Single correct answer
{“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”},
{1}}, // Single correct answer
