FSc · Computer Science (Grade 11)

Unit 8 MCQs

50 solved multiple choice questions with answers.

Q1. Identify the concept that refers to the creation, organization, management, and manipulation of database systems.

  1. AOpenOffice Base
  2. Bdatabase development
  3. Creport
  4. DAutoNumber
Show answer
Answer: B. database development
Report a mistake

Q2. Which option gives the correct meaning of database development?

  1. Aa relational database management system used to store and retrieve data
  2. Bthe creation, organization, management, and manipulation of database systems
  3. Ca field type used for numeric values
  4. Da database object used to retrieve or manipulate data according to criteria
Show answer
Answer: B. the creation, organization, management, and manipulation of database systems
Report a mistake

Q3. A student encounters a relational database management system from Microsoft. Which term should be used for it?

  1. Atext data type
  2. BMicrosoft Access
  3. Ctable
  4. DYes/No data type
Show answer
Answer: B. Microsoft Access
Report a mistake

Q4. What does Microsoft Access refer to?

  1. Athe database module of OpenOffice
  2. Ba relational database management system from Microsoft
  3. Ca database object used to present and print information
  4. Da numeric field whose value is filled automatically for new records
Show answer
Answer: B. a relational database management system from Microsoft
Report a mistake

Q5. Choose the term associated with a relational database management system used to store and retrieve data.

  1. Amemo data type
  2. BDate/Time data type
  3. CSQL Server
  4. Dform
Show answer
Answer: C. SQL Server
Report a mistake

Q6. In a computer system, what role does SQL Server play?

  1. Aa database object used to store data in rows and columns
  2. Ba logical data type represented by True/False
  3. Ca field type for text, with a maximum size of 255 characters in the textbook
  4. Da relational database management system used to store and retrieve data
Show answer
Answer: D. a relational database management system used to store and retrieve data
Report a mistake

Q7. Which computing concept is defined by the following idea: the database module of OpenOffice?

  1. Anumber data type
  2. Bquery
  3. COpenOffice Base
  4. DOLE Object
Show answer
Answer: C. OpenOffice Base
Report a mistake

Q8. What is the primary function or meaning of OpenOffice Base?

  1. Aa field type for dates and times
  2. Ba database window used for viewing, entering, and editing data
  3. Cthe database module of OpenOffice
  4. Da field type for longer descriptive text
Show answer
Answer: C. the database module of OpenOffice
Report a mistake

Q9. Identify the concept that refers to a database object used to store data in rows and columns.

  1. Ahyperlink
  2. Breport
  3. CAutoNumber
  4. Dtable
Show answer
Answer: D. table
Report a mistake

Q10. Which option gives the correct meaning of table?

  1. Aa field type used for numeric values
  2. Ba data type for linked or embedded objects from other applications
  3. Ca database object used to retrieve or manipulate data according to criteria
  4. Da database object used to store data in rows and columns
Show answer
Answer: D. a database object used to store data in rows and columns
Report a mistake

Q11. A student encounters a database window used for viewing, entering, and editing data. Which term should be used for it?

  1. Aprimary key
  2. BYes/No data type
  3. Ctext data type
  4. Dform
Show answer
Answer: D. form
Report a mistake

Q12. What does form refer to?

  1. Aa numeric field whose value is filled automatically for new records
  2. Ba field type used for document paths or web addresses
  3. Ca database object used to present and print information
  4. Da database window used for viewing, entering, and editing data
Show answer
Answer: D. a database window used for viewing, entering, and editing data
Report a mistake

Q13. Choose the term associated with a database object used to retrieve or manipulate data according to criteria.

  1. Aforeign key
  2. BDate/Time data type
  3. Cmemo data type
  4. Dquery
Show answer
Answer: D. query
Report a mistake

Q14. In a computer system, what role does query play?

  1. Aa unique key field in a table
  2. Ba database object used to retrieve or manipulate data according to criteria
  3. Ca field type for text, with a maximum size of 255 characters in the textbook
  4. Da logical data type represented by True/False
Show answer
Answer: B. a database object used to retrieve or manipulate data according to criteria
Report a mistake

Q15. Which computing concept is defined by the following idea: a database object used to present and print information?

  1. AOLE Object
  2. Bselect query
  3. Creport
  4. Dnumber data type
Show answer
Answer: C. report
Report a mistake

Q16. What is the primary function or meaning of report?

  1. Aa field type for dates and times
  2. Ba field used to create a relationship with another table
  3. Ca database object used to present and print information
  4. Da field type for longer descriptive text
Show answer
Answer: C. a database object used to present and print information
Report a mistake

Q17. Identify the concept that refers to a field type for text, with a maximum size of 255 characters in the textbook.

  1. Atext data type
  2. Bhyperlink
  3. CAutoNumber
  4. Dupdate query
Show answer
Answer: A. text data type
Report a mistake

Q18. Which option gives the correct meaning of text data type?

  1. Aa data type for linked or embedded objects from other applications
  2. Ba query used to display selected data
  3. Ca field type for text, with a maximum size of 255 characters in the textbook
  4. Da field type used for numeric values
Show answer
Answer: C. a field type for text, with a maximum size of 255 characters in the textbook
Report a mistake

Q19. A student encounters a field type for longer descriptive text. Which term should be used for it?

  1. Amemo data type
  2. Bdatabase development
  3. Cprimary key
  4. DYes/No data type
Show answer
Answer: A. memo data type
Report a mistake

Q20. What does memo data type refer to?

  1. Aan action query used to change records according to criteria
  2. Ba field type used for document paths or web addresses
  3. Ca numeric field whose value is filled automatically for new records
  4. Da field type for longer descriptive text
Show answer
Answer: D. a field type for longer descriptive text
Report a mistake

Q21. Choose the term associated with a field type used for numeric values.

  1. Anumber data type
  2. BDate/Time data type
  3. Cforeign key
  4. DMicrosoft Access
Show answer
Answer: A. number data type
Report a mistake

Q22. In a computer system, what role does number data type play?

  1. Athe creation, organization, management, and manipulation of database systems
  2. Ba field type used for numeric values
  3. Ca logical data type represented by True/False
  4. Da unique key field in a table
Show answer
Answer: B. a field type used for numeric values
Report a mistake

Q23. Which computing concept is defined by the following idea: a numeric field whose value is filled automatically for new records?

  1. ASQL Server
  2. Bselect query
  3. CAutoNumber
  4. DOLE Object
Show answer
Answer: C. AutoNumber
Report a mistake

Q24. What is the primary function or meaning of AutoNumber?

  1. Aa relational database management system from Microsoft
  2. Ba field used to create a relationship with another table
  3. Ca numeric field whose value is filled automatically for new records
  4. Da field type for dates and times
Show answer
Answer: C. a numeric field whose value is filled automatically for new records
Report a mistake

Q25. Identify the concept that refers to a logical data type represented by True/False.

  1. AYes/No data type
  2. Bupdate query
  3. Chyperlink
  4. DOpenOffice Base
Show answer
Answer: A. Yes/No data type
Report a mistake

Q26. Which option gives the correct meaning of Yes/No data type?

  1. Aa logical data type represented by True/False
  2. Ba query used to display selected data
  3. Ca data type for linked or embedded objects from other applications
  4. Da relational database management system used to store and retrieve data
Show answer
Answer: A. a logical data type represented by True/False
Report a mistake

Q27. A student encounters a field type for dates and times. Which term should be used for it?

  1. Aprimary key
  2. BDate/Time data type
  3. Ctable
  4. Ddatabase development
Show answer
Answer: B. Date/Time data type
Report a mistake

Q28. What does Date/Time data type refer to?

  1. Aa field type for dates and times
  2. Ban action query used to change records according to criteria
  3. Ca field type used for document paths or web addresses
  4. Dthe database module of OpenOffice
Show answer
Answer: A. a field type for dates and times
Report a mistake

Q29. Choose the term associated with a data type for linked or embedded objects from other applications.

  1. AMicrosoft Access
  2. Bforeign key
  3. Cform
  4. DOLE Object
Show answer
Answer: D. OLE Object
Report a mistake

Q30. In a computer system, what role does OLE Object play?

  1. Aa data type for linked or embedded objects from other applications
  2. Ba database object used to store data in rows and columns
  3. Cthe creation, organization, management, and manipulation of database systems
  4. Da unique key field in a table
Show answer
Answer: A. a data type for linked or embedded objects from other applications
Report a mistake

Q31. Which computing concept is defined by the following idea: a field type used for document paths or web addresses?

  1. Aselect query
  2. Bhyperlink
  3. Cquery
  4. DSQL Server
Show answer
Answer: B. hyperlink
Report a mistake

Q32. What is the primary function or meaning of hyperlink?

  1. Aa field used to create a relationship with another table
  2. Ba relational database management system from Microsoft
  3. Ca database window used for viewing, entering, and editing data
  4. Da field type used for document paths or web addresses
Show answer
Answer: D. a field type used for document paths or web addresses
Report a mistake

Q33. Identify the concept that refers to a unique key field in a table.

  1. Areport
  2. BOpenOffice Base
  3. Cprimary key
  4. Dupdate query
Show answer
Answer: C. primary key
Report a mistake

Q34. Which option gives the correct meaning of primary key?

  1. Aa database object used to retrieve or manipulate data according to criteria
  2. Ba query used to display selected data
  3. Ca relational database management system used to store and retrieve data
  4. Da unique key field in a table
Show answer
Answer: D. a unique key field in a table
Report a mistake

Q35. A student encounters a field used to create a relationship with another table. Which term should be used for it?

  1. Atable
  2. Bforeign key
  3. Ctext data type
  4. Ddatabase development
Show answer
Answer: B. foreign key
Report a mistake

Q36. What does foreign key refer to?

  1. Aa field used to create a relationship with another table
  2. Ba database object used to present and print information
  3. Can action query used to change records according to criteria
  4. Dthe database module of OpenOffice
Show answer
Answer: A. a field used to create a relationship with another table
Report a mistake

Q37. Choose the term associated with a query used to display selected data.

  1. Amemo data type
  2. Bselect query
  3. CMicrosoft Access
  4. Dform
Show answer
Answer: B. select query
Report a mistake

Q38. In a computer system, what role does select query play?

  1. Aa query used to display selected data
  2. Ba field type for text, with a maximum size of 255 characters in the textbook
  3. Cthe creation, organization, management, and manipulation of database systems
  4. Da database object used to store data in rows and columns
Show answer
Answer: A. a query used to display selected data
Report a mistake

Q39. Which computing concept is defined by the following idea: an action query used to change records according to criteria?

  1. ASQL Server
  2. Bupdate query
  3. Cquery
  4. Dnumber data type
Show answer
Answer: B. update query
Report a mistake

Q40. What is the primary function or meaning of update query?

  1. Aa database window used for viewing, entering, and editing data
  2. Ban action query used to change records according to criteria
  3. Ca relational database management system from Microsoft
  4. Da field type for longer descriptive text
Show answer
Answer: B. an action query used to change records according to criteria
Report a mistake

Q41. What database object is used to store data?

  1. ATable
  2. BQuery
  3. CForm
  4. DReport
Show answer
Answer: A. Table
Report a mistake

Q42. What database object is a window for viewing, entering, and editing information?

  1. AForm
  2. BReport
  3. CQuery
  4. DTable
Show answer
Answer: A. Form
Report a mistake

Q43. Identify the option that is a logical data type?

  1. AMemo
  2. BText
  3. CAutonumber
  4. DYes/No
Show answer
Answer: D. Yes/No
Report a mistake

Q44. Which is an open-source database application in the exercise?

  1. AMS Word
  2. BMS Access
  3. CSQL Server
  4. DOpenOffice Base
Show answer
Answer: D. OpenOffice Base
Report a mistake

Q45. What is the maximum size of a Text field according to the textbook?

  1. A253
  2. B255
  3. C254
  4. D256
Show answer
Answer: B. 255
Report a mistake

Q46. What key is a unique key field in a table?

  1. APrimary key
  2. BForeign key
  3. CSecondary key
  4. DComposite key
Show answer
Answer: A. Primary key
Report a mistake

Q47. What key is used to create a one-to-many relationship between tables?

  1. ASecondary key
  2. BPrimary key
  3. CForeign key
  4. DComposite key
Show answer
Answer: C. Foreign key
Report a mistake

Q48. Which object displays data in an organized manner so users can print it?

  1. AForm
  2. BTable
  3. CReport
  4. DQuery
Show answer
Answer: C. Report
Report a mistake

Q49. What type of query changes a set of records according to specified criteria?

  1. AUpdate Query
  2. BDelete Query
  3. CSelect Query
  4. DReport Query
Show answer
Answer: A. Update Query
Report a mistake

Q50. Which field type stores a path to a document or a web address?

  1. AMemo
  2. BOLE Object
  3. CHyperlink
  4. DAutoNumber
Show answer
Answer: C. Hyperlink
Report a mistake