Unit-7: Database Fundamental  (35 MCQs)

11th Class Computer Science MCQs Preparation 

National Book Foundation
as
Federal Text Boards, Islamabad, Pakistan

for board examination 2023-24 and Onwards all over Pakistan and abroad, ECAT, FPSC, PPSC, JOB Exam, Physics Lecturer, SSC, HSSC (F.Sc.), BS, MS Exams NTS, ETS, etc.

(Contact WhatsApp # 03339719149 for PDF Notes)

1. Duplication of data in different files is called ____________




... Answer is B. Redundancy
--------------------------


2. If data is not updated in a file in a file-based data management system what types of problems will it cause?




... Answer is A. Data inconsistency
----------------------


3. A record is also called ___________




... Answer is D. Relation
---------------------------


4. An attribute is also called:




... Answer is D. Tuple
--------------------------------


5.  What is a thing of interest to an organization called about which data is to be held?




... Answer is C. Entity
------------------------


6. In which type of database data is held in tables and tables are linked by a common field.




... Answer is C. Relational
------------------------


7. In which database model data is organized in a tree-like structure. :




... Answer is A. Hierarchical
--------------------------


8. What refers to the maximum number of items an instance in one entity can be associated with instances in the related entity.




... Answer is B. Cardinality
-------------------------


9. What refers to the minimum number of items an instance in one entity can be associated with instances in the related entity.




... Answer is C. Modality
------------------------


10. What is a key field called that is used in the relationship between tables whose value matches a primary key in the other table?




... Answer is D. Foreign key`
 ----------------------


11. Each item of information within a record is called ____________.




... Answer is C. Field
------------------------------


12. Each separate piece of information stored in a database is known as ____________.




... Answer is B. Record
-------------------------


13. Which key shows the uniqueness of a table?​




... Answer is D. Both a and b
-------------------------


14.  The collection of programs that enables users to create and maintain a database is called ______________.




... Answer is C. DBMS
----------------------------

15. The columns of a table correspond to____________.




... Answer is A. Field
--------------------------


16.. Which of the following is handled by DBMS.




... Answer is D. All
---------------------------

17. Which of the following is not an advantage of DBMS. :




... Answer is A. Redundant data
--------------------------


18. What is a table in a relational database called?




... Answer is A. Relation
-------------------------


19. In RDBMS, a table must have:




... Answer is A. Primary key
------------------------


20. Which of the following is used to describe the characteristics of any entity.




... Answer is B. Attribute
----------------------

21. In an ER diagram, an entity is represented by




... Answer is B. Rectangle
--------------------------


22. In the ER diagram, an attribute is represented by:




... Answer is A. Ellipse
--------------------


23. In ER diagram a relationship is represented by:




... Answer is C. Diamond
---------------------------


24. What  The binary relationship can be;




... Answer is D. All
--------------------


25.  Which of the following is an example of one-to-one?




... Answer is A. Student-Reg No
--------------------


26. Which of the following is the one-to-many relationship?




... Answer is C. both b and c
--------------------


27. A relationship between countries and capitals is an example of ____________ relationship. :




... Answer is A. One-to-one
--------------------


28. Which form of dependency is removed in 3NF?




... Answer is D. Transitive
-------------------------


29. Which form of anomaly is removed in 1NF?




... Answer is B. Repetition
--------------------


30. Which form of anomaly is removed in 2NF?




... Answer is C. Partial Functional Dependency
----------------------


31. Which form of anomaly is removed in 3NF?





... Answer is D. Transitive Functional Dependency
--------------------------


32. In 3NF non-key attribute must not depend on a ____________




... Answer is A. Non-key attribute
----------------------


33. The goal of normalization is to;




... Answer is A. Get a stable data structure
--------------------


34. A functional dependency between two or more non-key attributes is called.




... Answer is C. Transitive functional dependency
--------------------


35.  In ERD, entities are connected to form relationships using ____________.




... Answer is D. Line
--------------------


************************************

************************************

Shortcut Links For 


1. Website for School and College Level Physics   
2. Website for School and College Level Mathematics  
3. Website for Single National Curriculum Pakistan - All Subjects Notes 

© 2023 Academic Skills and Knowledge (ASK)     

Note:  Write to me in the comments box below for any query and also Share this information with your class-fellows and friends.