PPSC Lecturer Computer Science Syllabus Quiz no 5 A.J. Bhatti September 2, 2020 Welcome to your PPSC Lecturer Computer Science Syllabus Quiz no 5 Name Email Q No 1:The Relationships in E-R Diagram are shown in Diamond Shape Circle Shape Rectangle Shape None of the Above Q No 2:IN E-R Diagram ..................... Relationship is an ENTITY TYPE linked with itself, also called recursive relationship Unary Relationship Binary Relationship Ternary Relationship Both A & B Q No 3 : In E-R Diagram A.............relationship is the one that links two entities sets e.g. STUDENT-CLASS. Relationships can be formally described in an ordered pair form. Unary Binary Ternary All of the above Q No 4:A mapping R from X to Y is ................ if each entity in X is associated with at most one entity in Y and vice versa. One-to-one One-to-many Many-to-many Both A & B Q NO 5 : A mapping R from X to Y is .................. if each entity in X is associated with at most one entity in Y but each entity in Y is associated with many entities in X. On -to-one many-to-many many-to-one one to many Q No 6 : A mapping R from X to Y is ............. if each entity in X is associated with many entities in Y but each entity in Y is associated with one entity in X. One-To-One Many to Many Many to One On to Many Q NO 7 : A mapping R from X to Y is ................ if each entity from X is associated with many entities in Y and one entity in Y is associated with many entities in X. On to one One to Many Many to Many Many to One Q No 8 : The Relational Database Model is popular due to its two major strengths and they are: Simplicity strong mathematical foundations Simple foundations Both A & B Q No 9 : A Relational Database Model is Based on Table known as Relation Relative No More Relation More Relation Q No 10 :The Base of Relational Model Diagram is .......... Simple Functions Mathematical Functions Simplicity Functions Simplicity Q No 11: The First Prototype Relational Database system is Developed in ........... 70's 80's 90's 60's Q No 12: The First Prototype Relational Database Management system is Developed in mid ......... by ........... 70's by IBM 80's by IBM and UC Barkely 70's by IBM and UC Barkely 60's by IBM and UC Barkely Q No 13 : All of the Strong and Current Database Management Systems like Oracle, Fox Base , Microsoft Access are.......... Relational Database Systems Conceptual Database Systems Strong Database Systems All of the above Q No 14 : A Relational Database is ............... Dimensional Two Three Four One Q No 15 : In a Relational Data Base Each cell of a table must contains atomic/single value . Is it True? True False Q No 16 : In Relational Database The values of the attributes did not come from the same domain True False Q No 17 :In a Relational Database If the order of the columns in a table is changed, the table still remains the .......... Change altered affected same Q No 18 :In a Relational Database If the order of the Record in a table or in Database is changed, then the data base will be affected or not? No ,There will be no any effect on the Database Yes , The Data Base will be affected Database duplicate the data None of the above Q no 19 : In a Relational Database, Two rows of a table cannot be same. The value of even a single attribute has to be different that makes the entire row distinct. True or False? False False in some aspects True in some aspects True Q No 20 : Which Database "Table Key " is responsible to stop duplication of the Data ? Foreign Key Primary Key Secondary Key All of the above Q no 21:There are three components of the RDM, which are construct (relation) manipulation language (SQL) integrity constraints (two) Both A & C & B Q No 22: In Relational Database Mathematical Relations ................is a set that consists of ordered pairs where first element of the ordered pair belongs to set A where as second element belongs to set B Cartesian Product of Set A & B Cartasian Product of Set A Cartasian Product of Set B All of the Above Q No 23 :b In Relational Database The number of rows present in a relation is called as ................ cardinality of that relation cardinality of that attribute cardinality of that Entity All of the avbove Q No 24:An attribute of a table B that is primary key in another table A is called as ...................... Key Primary Key Secondary Key Foreign Key None of them Q no 25 : There can be more than ............or multiple foreign keys in a table, depending on how many tables a particular table is related with 1 2 3 4 Q No 26:Through .................... we can monitor whether an attribute can have Null value or not Null constraint Null attribute Null Foreign Key Null Primary Key Q No 27 :Binary relationships are those, which are established between One Entity Type Two Entity Type Three Entity Type Four Entity Type Q no 28: It states that in a relation no attribute of a primary key (PK) can have null value. If a PK consists of single attribute, this constraint obviously applies on this attribute, so it cannot have the Null value Entity Integrity Constraint Referential Integrity Constraint Constraints Significance of Constraints Q No 29: The Constraint in Which if a foreign key exists in a relation, either the foreign key value must match the primary key value of some tuple in its home relation or the foreign key value must be completely null is known as Integrity Constraint Referential Constraint Both A & B All of Above Q No 30 :These are the relationships, which involve a single entity Unary Relationships Ternary Relationships Binary Relationships All of the above Q No 31: Bilawal Bhutto inaugurated the first Tharparkar Airport on 11th April 2018 named-----------? A. Fatima Bibi Airpoet B. Benazir Bhutto Airport C. Maai Bakhtawar Airport D. Bibi Noreen Airport Q No 32: Which country’s diplomat was briefly detained for killing a motorcyclist in a hit and run case on 7th April 2018? A. USA B. China C.Japan D.Russia Q No 33: Who is leading Pashtun tahafuz movement,demanding security for Pakistani ethnic pashtun minority? A. Abu bakar siddique B. Manzoor Pashteen C. Said Alam D. Ali Wazir Q No 34: Punjab Government approved construction of Dadhocha Dam in---------. Faisalabad Mianwali Rawalpindi Chiniot Q No 35: Pakistan President announced a new medal on 23-March-2018? Tamgha-i-Shuja Tamga-i-Azam Tamgha-i-Imtiaz Tamgha-I-QUAID-E-AZAM Related Author: A.J. Bhatti
