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 ____________.
--------------------
--------------------
************************************👉👉👉Computer Science 11th Class Notes (Main Page)
************************************
Shortcut Links For:
1. 5th Class All Subjects Notes
2. 8th Class All Subjects Notes
3. Easy English Grammar Notes
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 & onwards Academic Skills and Knowledge (ASK)
Note: Write me in the comments box below for any query and also Share this information with your class-fellows and friends.
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 & onwards Academic Skills and Knowledge (ASK)
Note: Write me in the comments box below for any query and also Share this information with your class-fellows and friends.
0 Comments
Start Tuition (in Pakistan or Abroad) from Experienced Online Teachers.
Contact WhatsApp for tutoring and Assignment help on +923339719149