Q1. What computer-science term matches this description: raw facts and figures? ADBMSBnetwork modelCdataDrecord Show answer Answer: C. data Report a mistake
Q2. A student is asked to explain data. Which answer is most accurate? Araw facts and figuresBan organized collection of related dataCan attribute or column in a tableDa database model that organizes data in a tree-like hierarchy Show answer Answer: A. raw facts and figures Report a mistake
Q3. In computing, what is the name for processed data that has meaning? AtableBinformationCrelational modelDfile management system Show answer Answer: B. information Report a mistake
Q4. Which description best matches information? Aprocessed data that has meaningBa row or tuple containing related fieldsCsoftware used to create, manage, access, and manipulate databasesDa database model that supports linked records with multiple relationships Show answer Answer: A. processed data that has meaning Report a mistake
Q5. Which concept refers to an organized collection of related data? Aprimary keyBdatabaseCobject-oriented database modelDDBA Show answer Answer: B. database Report a mistake
Q6. How is database best explained? Aa traditional system that stores data in separate filesBa relation consisting of rows and columnsCan organized collection of related dataDa database model that represents data using tables Show answer Answer: C. an organized collection of related data Report a mistake
Q7. What is meant by software used to create, manage, access, and manipulate databases? AfieldBDBMSCforeign keyDhierarchical model Show answer Answer: B. DBMS Report a mistake
Q8. How would you define DBMS in this context? Asoftware used to create, manage, access, and manipulate databasesBa database model that represents information as objectsCthe database administrator responsible for central database controlDa field or combination of fields that uniquely identifies a record Show answer Answer: A. software used to create, manage, access, and manipulate databases Report a mistake
Q9. What computer-science term matches this description: a traditional system that stores data in separate files? AentityBfile management systemCrecordDnetwork model Show answer Answer: B. file management system Report a mistake
Q10. A student is asked to explain file management system. Which answer is most accurate? Aa database model that organizes data in a tree-like hierarchyBa traditional system that stores data in separate filesCa key in one table referring to a primary key in another tableDan attribute or column in a table Show answer Answer: B. a traditional system that stores data in separate files Report a mistake
Q11. In computing, what is the name for the database administrator responsible for central database control? AattributeBDBACtableDrelational model Show answer Answer: B. DBA Report a mistake
Q12. Which description best matches DBA? Aa database model that supports linked records with multiple relationshipsBa row or tuple containing related fieldsCthe database administrator responsible for central database controlDa person, place, object, event, or concept about which data is stored Show answer Answer: C. the database administrator responsible for central database control Report a mistake
Q13. Which concept refers to a database model that organizes data in a tree-like hierarchy? ArelationshipBobject-oriented database modelCprimary keyDhierarchical model Show answer Answer: D. hierarchical model Report a mistake
Q14. How is hierarchical model best explained? Aa relation consisting of rows and columnsBa property or characteristic of an entityCa database model that represents data using tablesDa database model that organizes data in a tree-like hierarchy Show answer Answer: D. a database model that organizes data in a tree-like hierarchy Report a mistake
Q15. What is meant by a database model that supports linked records with multiple relationships? AcardinalityBnetwork modelCforeign keyDfield Show answer Answer: B. network model Report a mistake
Q16. How would you define network model in this context? Aan association between entitiesBa database model that represents information as objectsCa database model that supports linked records with multiple relationshipsDa field or combination of fields that uniquely identifies a record Show answer Answer: C. a database model that supports linked records with multiple relationships Report a mistake
Q17. What computer-science term matches this description: a database model that represents data using tables? AentityBnormalizationCrelational modelDrecord Show answer Answer: C. relational model Report a mistake
Q18. A student is asked to explain relational model. Which answer is most accurate? Aan attribute or column in a tableBthe maximum number of relationship instances between entitiesCa key in one table referring to a primary key in another tableDa database model that represents data using tables Show answer Answer: D. a database model that represents data using tables Report a mistake
Q19. In computing, what is the name for a database model that represents information as objects? AdataBtableCattributeDobject-oriented database model Show answer Answer: D. object-oriented database model Report a mistake
Q20. Which description best matches object-oriented database model? Aa database model that represents information as objectsBorganizing relational data to reduce redundancy and anomaliesCa row or tuple containing related fieldsDa person, place, object, event, or concept about which data is stored Show answer Answer: A. a database model that represents information as objects Report a mistake
Q21. Which concept refers to an attribute or column in a table? AinformationBprimary keyCrelationshipDfield Show answer Answer: D. field Report a mistake
Q22. How is field best explained? Aa relation consisting of rows and columnsBa property or characteristic of an entityCraw facts and figuresDan attribute or column in a table Show answer Answer: D. an attribute or column in a table Report a mistake
Q23. What is meant by a row or tuple containing related fields? AcardinalityBrecordCforeign keyDdatabase Show answer Answer: B. record Report a mistake
Q24. How would you define record in this context? Aa row or tuple containing related fieldsBprocessed data that has meaningCa field or combination of fields that uniquely identifies a recordDan association between entities Show answer Answer: A. a row or tuple containing related fields Report a mistake
Q25. What computer-science term matches this description: a relation consisting of rows and columns? AtableBentityCnormalizationDDBMS Show answer Answer: A. table Report a mistake
Q26. A student is asked to explain table. Which answer is most accurate? Aa key in one table referring to a primary key in another tableBthe maximum number of relationship instances between entitiesCa relation consisting of rows and columnsDan organized collection of related data Show answer Answer: C. a relation consisting of rows and columns Report a mistake
Q27. In computing, what is the name for a field or combination of fields that uniquely identifies a record? Afile management systemBprimary keyCdataDattribute Show answer Answer: B. primary key Report a mistake
Q28. Which description best matches primary key? Aa person, place, object, event, or concept about which data is storedBa field or combination of fields that uniquely identifies a recordCsoftware used to create, manage, access, and manipulate databasesDorganizing relational data to reduce redundancy and anomalies Show answer Answer: B. a field or combination of fields that uniquely identifies a record Report a mistake
Q29. Which concept refers to a key in one table referring to a primary key in another table? ArelationshipBinformationCforeign keyDDBA Show answer Answer: C. foreign key Report a mistake
Q30. How is foreign key best explained? Aa key in one table referring to a primary key in another tableBraw facts and figuresCa traditional system that stores data in separate filesDa property or characteristic of an entity Show answer Answer: A. a key in one table referring to a primary key in another table Report a mistake
Q31. What is meant by a person, place, object, event, or concept about which data is stored? AcardinalityBentityCdatabaseDhierarchical model Show answer Answer: B. entity Report a mistake
Q32. How would you define entity in this context? Athe database administrator responsible for central database controlBprocessed data that has meaningCa person, place, object, event, or concept about which data is storedDan association between entities Show answer Answer: C. a person, place, object, event, or concept about which data is stored Report a mistake
Q33. What computer-science term matches this description: a property or characteristic of an entity? AattributeBDBMSCnetwork modelDnormalization Show answer Answer: A. attribute Report a mistake
Q34. A student is asked to explain attribute. Which answer is most accurate? Athe maximum number of relationship instances between entitiesBa database model that organizes data in a tree-like hierarchyCan organized collection of related dataDa property or characteristic of an entity Show answer Answer: D. a property or characteristic of an entity Report a mistake
Q35. In computing, what is the name for an association between entities? ArelationshipBrelational modelCdataDfile management system Show answer Answer: A. relationship Report a mistake
Q36. Which description best matches relationship? Aan association between entitiesBa database model that supports linked records with multiple relationshipsCorganizing relational data to reduce redundancy and anomaliesDsoftware used to create, manage, access, and manipulate databases Show answer Answer: A. an association between entities Report a mistake
Q37. Which concept refers to the maximum number of relationship instances between entities? ADBABobject-oriented database modelCcardinalityDinformation Show answer Answer: C. cardinality Report a mistake
Q38. How is cardinality best explained? Aa traditional system that stores data in separate filesBraw facts and figuresCa database model that represents data using tablesDthe maximum number of relationship instances between entities Show answer Answer: D. the maximum number of relationship instances between entities Report a mistake
Q39. What is meant by organizing relational data to reduce redundancy and anomalies? AnormalizationBfieldCdatabaseDhierarchical model Show answer Answer: A. normalization Report a mistake
Q40. How would you define normalization in this context? Aa database model that represents information as objectsBthe database administrator responsible for central database controlCorganizing relational data to reduce redundancy and anomaliesDprocessed data that has meaning Show answer Answer: C. organizing relational data to reduce redundancy and anomalies Report a mistake
Q41. Hierarchical DBMS organizes data elements into: AObjectsBData departmentsCData unitsDSegments Show answer Answer: D. Segments Report a mistake
Q42. What database model represents information in the form of objects? ANetwork Database ModelBRelational Database ModelCHierarchical Database ModelDObject-Oriented Database Model Show answer Answer: D. Object-Oriented Database Model Report a mistake
Q43. Who has central control over data and programs in a database system? ADBABProgrammerCDesignerDSystem Analyst Show answer Answer: A. DBA Report a mistake
Q44. In relational terminology, an attribute is also called a: AEntityBFieldCTableDRecord Show answer Answer: B. Field Report a mistake
Q45. A row in a table is also known as a: ATupleBRelationCFieldDColumn Show answer Answer: A. Tuple Report a mistake
Q46. A set of rules describing how data can be stored, organized, and manipulated is a: ADatabase structureBDatabase architectureCDatabase designDDatabase model Show answer Answer: D. Database model Report a mistake
Q47. Which model uses tables to represent both data and relationships? AHierarchical Database ModelBNetwork Database ModelCRelational Database ModelDObject-Oriented Database Model Show answer Answer: C. Relational Database Model Report a mistake
Q48. What key uniquely identifies a record in a table? AComposite key onlyBSecondary keyCPrimary keyDForeign key Show answer Answer: C. Primary key Report a mistake
Q49. What key appears in another table to create a relationship? APrimary keyBForeign keyCSecondary keyDCandidate key Show answer Answer: B. Foreign key Report a mistake
Q50. The process of reducing duplication and anomalies in relational data is: AModalityBCardinalityCIndexingDNormalization Show answer Answer: D. Normalization Report a mistake