11th Class (HSSC-I) Computer SLO Based Key Point Notes
(National Book Foundation - As Federal Textbook Board, Islamabad Based on National Curriculum Pakistan 2023-2024 and Onward prescribed by Federal Board of Intermediate and Secondary Education, Islamabad, and All Pakistan Boards) (Contact WhatsApp # 03339719149 for a full book PDF Notes)
(National Book Foundation - As Federal Textbook Board, Islamabad
Based on National Curriculum Pakistan 2023-2024 and Onward prescribed by Federal Board of Intermediate and Secondary Education, Islamabad, and All Pakistan Boards)
(Contact WhatsApp # 03339719149 for a full book PDF Notes)
************************************
👉👉👉Computer Science 11th Class Notes (Main Page)
************************************
1. Duplication of data in different files is called ____________
... Answer is B. Redundancy
--------------------------
2. If data is not updated in a file in 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. 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
--------------------
1. Duplication of data in different files is called ____________
--------------------------
2. If data is not updated in a file in file-based data management system what types of problems will it cause?
----------------------
3. A record is also called ___________
---------------------------
4. An attribute is also called:
--------------------------------
5. What is a thing of interest to an organization called about which data is to be held?
------------------------
------------------------
--------------------------
-------------------------
------------------------
----------------------
------------------------------
-------------------------
------------------------
6. In which type of database data is held in tables and tables are linked by a common field.
------------------------
7. In which database model data is organized in a tree-like structure. :
--------------------------
8. What refers to the maximum number of items an instance in one entity can be associated with instances in the related entity.
-------------------------
9. What refers to the minimum number of items an instance in one entity can be associated with instances in the related entity.
------------------------
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?
----------------------
11. Each item of information within a record is called ____________.
------------------------------
12. Each separate piece of information stored in a database is known as ____________.
-------------------------
13. Which key shows the uniqueness of a table?
-------------------------
----------------------------
--------------------------
---------------------------
--------------------------
-------------------------
------------------------
----------------------
--------------------------
--------------------
---------------------------
--------------------
-------------------------
14. The collection of programs that enables users to create and maintain a database is called ______________.
----------------------------
15. The columns of a table correspond to____________.
--------------------------
16.. Which of the following is handled by DBMS.
---------------------------
17. Which of the following is not an advantage of DBMS. :
--------------------------
18. What is a table in a relational database called?
-------------------------
19. In RDBMS, a table must have:
------------------------
20. Which of the following is used to describe the characteristics of any entity.
----------------------
21. In an ER diagram, an entity is represented by
--------------------------
22. In the ER diagram, an attribute is represented by:
--------------------
23. In ER diagram a relationship is represented by:
---------------------------
24. The binary relationship can be;
--------------------
25. Which of the following is an example of one-to-one?
--------------------
--------------------
--------------------
-------------------------
--------------------
----------------------
--------------------
26. Which of the following is the one-to-many relationship?
--------------------
27. A relationship between countries and capitals is an example of ____________ relationship. :
--------------------
28. Which form of dependency is removed in 3NF?
-------------------------
29. Which form of anomaly is removed in 1NF?
--------------------
30. Which form of anomaly is removed in 2NF?
----------------------
31. Which form of anomaly is removed in 3NF?
--------------------------
----------------------
--------------------
--------------------
--------------------------
32. In 3NF non-key attribute must not depend on a ____________
----------------------
33. The goal of normalization is to;
--------------------
34. A functional dependency between two or more non-key attributes is called.
--------------------
35. In ERD, entities are connected to form relationships using ____________.
--------------------
--------------------
0 Comments
Note: Write me in the comments box below for any queries and also Share this information with your class-fellows and friends.