FSc · Computer Science (Grade 11)

Unit 7 MCQs

50 solved multiple choice questions with answers.

Q1. What computer-science term matches this description: raw facts and figures?

  1. ADBMS
  2. Bnetwork model
  3. Cdata
  4. Drecord
Show answer
Answer: C. data
Report a mistake

Q2. A student is asked to explain data. Which answer is most accurate?

  1. Araw facts and figures
  2. Ban organized collection of related data
  3. Can attribute or column in a table
  4. Da 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?

  1. Atable
  2. Binformation
  3. Crelational model
  4. Dfile management system
Show answer
Answer: B. information
Report a mistake

Q4. Which description best matches information?

  1. Aprocessed data that has meaning
  2. Ba row or tuple containing related fields
  3. Csoftware used to create, manage, access, and manipulate databases
  4. Da 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?

  1. Aprimary key
  2. Bdatabase
  3. Cobject-oriented database model
  4. DDBA
Show answer
Answer: B. database
Report a mistake

Q6. How is database best explained?

  1. Aa traditional system that stores data in separate files
  2. Ba relation consisting of rows and columns
  3. Can organized collection of related data
  4. Da 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?

  1. Afield
  2. BDBMS
  3. Cforeign key
  4. Dhierarchical model
Show answer
Answer: B. DBMS
Report a mistake

Q8. How would you define DBMS in this context?

  1. Asoftware used to create, manage, access, and manipulate databases
  2. Ba database model that represents information as objects
  3. Cthe database administrator responsible for central database control
  4. Da 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?

  1. Aentity
  2. Bfile management system
  3. Crecord
  4. Dnetwork 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?

  1. Aa database model that organizes data in a tree-like hierarchy
  2. Ba traditional system that stores data in separate files
  3. Ca key in one table referring to a primary key in another table
  4. Dan 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?

  1. Aattribute
  2. BDBA
  3. Ctable
  4. Drelational model
Show answer
Answer: B. DBA
Report a mistake

Q12. Which description best matches DBA?

  1. Aa database model that supports linked records with multiple relationships
  2. Ba row or tuple containing related fields
  3. Cthe database administrator responsible for central database control
  4. Da 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?

  1. Arelationship
  2. Bobject-oriented database model
  3. Cprimary key
  4. Dhierarchical model
Show answer
Answer: D. hierarchical model
Report a mistake

Q14. How is hierarchical model best explained?

  1. Aa relation consisting of rows and columns
  2. Ba property or characteristic of an entity
  3. Ca database model that represents data using tables
  4. Da 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?

  1. Acardinality
  2. Bnetwork model
  3. Cforeign key
  4. Dfield
Show answer
Answer: B. network model
Report a mistake

Q16. How would you define network model in this context?

  1. Aan association between entities
  2. Ba database model that represents information as objects
  3. Ca database model that supports linked records with multiple relationships
  4. Da 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?

  1. Aentity
  2. Bnormalization
  3. Crelational model
  4. Drecord
Show answer
Answer: C. relational model
Report a mistake

Q18. A student is asked to explain relational model. Which answer is most accurate?

  1. Aan attribute or column in a table
  2. Bthe maximum number of relationship instances between entities
  3. Ca key in one table referring to a primary key in another table
  4. Da 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?

  1. Adata
  2. Btable
  3. Cattribute
  4. Dobject-oriented database model
Show answer
Answer: D. object-oriented database model
Report a mistake

Q20. Which description best matches object-oriented database model?

  1. Aa database model that represents information as objects
  2. Borganizing relational data to reduce redundancy and anomalies
  3. Ca row or tuple containing related fields
  4. Da 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?

  1. Ainformation
  2. Bprimary key
  3. Crelationship
  4. Dfield
Show answer
Answer: D. field
Report a mistake

Q22. How is field best explained?

  1. Aa relation consisting of rows and columns
  2. Ba property or characteristic of an entity
  3. Craw facts and figures
  4. Dan 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?

  1. Acardinality
  2. Brecord
  3. Cforeign key
  4. Ddatabase
Show answer
Answer: B. record
Report a mistake

Q24. How would you define record in this context?

  1. Aa row or tuple containing related fields
  2. Bprocessed data that has meaning
  3. Ca field or combination of fields that uniquely identifies a record
  4. Dan 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?

  1. Atable
  2. Bentity
  3. Cnormalization
  4. DDBMS
Show answer
Answer: A. table
Report a mistake

Q26. A student is asked to explain table. Which answer is most accurate?

  1. Aa key in one table referring to a primary key in another table
  2. Bthe maximum number of relationship instances between entities
  3. Ca relation consisting of rows and columns
  4. Dan 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?

  1. Afile management system
  2. Bprimary key
  3. Cdata
  4. Dattribute
Show answer
Answer: B. primary key
Report a mistake

Q28. Which description best matches primary key?

  1. Aa person, place, object, event, or concept about which data is stored
  2. Ba field or combination of fields that uniquely identifies a record
  3. Csoftware used to create, manage, access, and manipulate databases
  4. Dorganizing 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?

  1. Arelationship
  2. Binformation
  3. Cforeign key
  4. DDBA
Show answer
Answer: C. foreign key
Report a mistake

Q30. How is foreign key best explained?

  1. Aa key in one table referring to a primary key in another table
  2. Braw facts and figures
  3. Ca traditional system that stores data in separate files
  4. Da 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?

  1. Acardinality
  2. Bentity
  3. Cdatabase
  4. Dhierarchical model
Show answer
Answer: B. entity
Report a mistake

Q32. How would you define entity in this context?

  1. Athe database administrator responsible for central database control
  2. Bprocessed data that has meaning
  3. Ca person, place, object, event, or concept about which data is stored
  4. Dan 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?

  1. Aattribute
  2. BDBMS
  3. Cnetwork model
  4. Dnormalization
Show answer
Answer: A. attribute
Report a mistake

Q34. A student is asked to explain attribute. Which answer is most accurate?

  1. Athe maximum number of relationship instances between entities
  2. Ba database model that organizes data in a tree-like hierarchy
  3. Can organized collection of related data
  4. Da 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?

  1. Arelationship
  2. Brelational model
  3. Cdata
  4. Dfile management system
Show answer
Answer: A. relationship
Report a mistake

Q36. Which description best matches relationship?

  1. Aan association between entities
  2. Ba database model that supports linked records with multiple relationships
  3. Corganizing relational data to reduce redundancy and anomalies
  4. Dsoftware 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?

  1. ADBA
  2. Bobject-oriented database model
  3. Ccardinality
  4. Dinformation
Show answer
Answer: C. cardinality
Report a mistake

Q38. How is cardinality best explained?

  1. Aa traditional system that stores data in separate files
  2. Braw facts and figures
  3. Ca database model that represents data using tables
  4. Dthe 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?

  1. Anormalization
  2. Bfield
  3. Cdatabase
  4. Dhierarchical model
Show answer
Answer: A. normalization
Report a mistake

Q40. How would you define normalization in this context?

  1. Aa database model that represents information as objects
  2. Bthe database administrator responsible for central database control
  3. Corganizing relational data to reduce redundancy and anomalies
  4. Dprocessed 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:

  1. AObjects
  2. BData departments
  3. CData units
  4. DSegments
Show answer
Answer: D. Segments
Report a mistake

Q42. What database model represents information in the form of objects?

  1. ANetwork Database Model
  2. BRelational Database Model
  3. CHierarchical Database Model
  4. DObject-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?

  1. ADBA
  2. BProgrammer
  3. CDesigner
  4. DSystem Analyst
Show answer
Answer: A. DBA
Report a mistake

Q44. In relational terminology, an attribute is also called a:

  1. AEntity
  2. BField
  3. CTable
  4. DRecord
Show answer
Answer: B. Field
Report a mistake

Q45. A row in a table is also known as a:

  1. ATuple
  2. BRelation
  3. CField
  4. DColumn
Show answer
Answer: A. Tuple
Report a mistake

Q46. A set of rules describing how data can be stored, organized, and manipulated is a:

  1. ADatabase structure
  2. BDatabase architecture
  3. CDatabase design
  4. DDatabase model
Show answer
Answer: D. Database model
Report a mistake

Q47. Which model uses tables to represent both data and relationships?

  1. AHierarchical Database Model
  2. BNetwork Database Model
  3. CRelational Database Model
  4. DObject-Oriented Database Model
Show answer
Answer: C. Relational Database Model
Report a mistake

Q48. What key uniquely identifies a record in a table?

  1. AComposite key only
  2. BSecondary key
  3. CPrimary key
  4. DForeign key
Show answer
Answer: C. Primary key
Report a mistake

Q49. What key appears in another table to create a relationship?

  1. APrimary key
  2. BForeign key
  3. CSecondary key
  4. DCandidate key
Show answer
Answer: B. Foreign key
Report a mistake

Q50. The process of reducing duplication and anomalies in relational data is:

  1. AModality
  2. BCardinality
  3. CIndexing
  4. DNormalization
Show answer
Answer: D. Normalization
Report a mistake