PPSC Mock Test Preparation Quiz no 8 A.J. Bhatti October 19, 2020 Welcome to your PPSC Mock Test Preparation Quiz no 8 Email Name 21.A time-sharing system is interactive system multi-user multi-process Both A ,b and C None of the above 22. In ...........................A user can run one or more processes at the same time and interact with his/her processes. Time Sharing Multi User Single User Batch System 23.A ......................system uses multiprogramming and CPU scheduling to provide each user with a small portion of a time-shared computer. Each user has at least one separate program in memory. To obtain a reasonable response time, jobs may have to be swapped in and out of main memory Single User Time Shared Multi User Batch system 24.A .............. system has well defined, fixed time constraints, and if the system does not produce output for an input within the time constraints, the system will fail real time Time Shared both A & B none of these 25.A hard real time system guarantees that critical tasks be completed on ........ on Time at that place on the day after the day A Function is also known as class Method Calculation Behavior The Process of Function Call is also known as ........... A passing of Call An passing of Object A passing of class A passing of Message The Function of any class which is same as the Name of its Class is a Constructor , What is the name of the constructor......... Default Constructor Simple Constructor Real Constructor Get Constructor In Literature the Classes are also Known as ........ System Defined Data Types User Defined Data Types Only Data Types None of above How many Parameters you are able to Pass using Default Constructors 1 2 3 0 The Constructor in which 1 or more then 1 Parameter is Passed is known as .'..... Default Constructor Parameterized constructor Simple constructor Both A & B Abstraction is also Known as ..... Information Processing Information Gathering Information Hiding Just Information The of Object Oriented Language Principles are..... 3 4 5 6 The Principle of OOP Which allows to provide only essential information outside the world is....... Abstraction Encapsulation Inheritance None of the above .................is any mechanism for controlling the access of programs, processes or users to the resources defined by a computer system protection.. Processing Security Firewall Potection ........... is a system Which is a collection of processors that do not share memory, peripheral devices or a clock A distributed system A Networking system A Management system All of them The processors in a communication system are connected through a ................ network Networking Network Shared Network Communication Network Virtual Private network ......... is the interpreter which is the which is the interface between the user and operating system Command line interpreter Command area interpreter command processing interpreter Command interpreter The Inheritance in Which Class A is the Base class , Class B is Derived from Class A, and another class C which is the Child Class of Class B is known as Multi-Laval Inheritance Single Inheritance Multi Inheritance Hierarchical Inheritance The Inheritance in which all types of inheritance are Present is know as Multi Laval inheritance Multi inheritance Single inheritance Hybrid inheritance Types of Inheritance Public inheritance Private inheritance Protected inheritance Both A B & C In Public Inheritance the Derived Class Contains Which features of Parent Class or Base Class Public + Protected Public + Private Protected + Private Public + Private + Protected The ability to use an operator of function in different ways in other words giving different meanings or functions to the operators or functions is known as Abstraction Encapsulation Inheritance Polimorphism Poly Which is the First word of Polymorphism Means....... one more then one less then 2 none of above A single Function or an operator functioning in many ways different upon the usage is known as Poly Morphism Polymorphism Abstraction and Encapsulation Principle of Polymorphism is achieved through the Method known as Class Object Method Overloading The process in which Derived Class can overload an Base class Function is Know as .... Overriding Riding Absraction Underriding Is it possible to overload a constructor...... Yes No How many types or Operators are: 1 2 3 4 The Correct Syntax of Overloading an Operator is... Student :: SetRno(){} Student :: Operator(){} Student :: Operator_(){} Student :: Operator+(){} Which of the Following focuses on the Discovery of unknown Properties of Data Data Mining Big Data Data Wrangling Machine learning The ............ call suspends the calling process until one of the immediate children terminate, or until a child that is being trainterestced stops because it has hit an event of wait system wait system call not wait system Both a and b The Class of Database user which is the most technical class of db users and are responsible manage as well as design the database is known as Naive Sophisticated Db incharge Database administrator How to Cut selected item in computer .... ctrl+x ctrl+v ctrl+r ctrl+s The actions includes in the duties of Database Administrator are Schema Definition Granting Data Access Routine maintenance All of the Above Dynamite invented by...x Alfred Nobel Einstein edison all of them, ....................is the person who create all the meta data information for the organization End User Sophisticated User DB in charge DBA 1 kilo byte= 1020 bytes 1000 bytes 1024 bytes 1200 bytes How many layers are there in Database Architecture........ 1 2 3 4 Q no 21 : What is the name of the shape use to express the external entities in DFD Circle Rectangle Triangle Arrow Q no 22 : This operator is used when data from a source process must flow to all the connected sinks And operator OR NOR XOR Q no 23 : Which one of the following is not the type of DFD? context Diagram Level 0 Diagram Detail Diagram None of the above Q no 25 : The level 0 Diagram in the DFD is used to describe the working of the Half System Whole System Entire System Both b&C Q No 24 :The level of DFD which provides the least amount of details about the working of the system i known as Context Diagram Level o Diagram Detailed Diagram All of the above Q No 26 : Which of the following is not the Type of Data base Conceptual Database Design Logical Database Design Physical Database Design All of the above Q no 27: ...............is a semantic data model that is used for the graphical representation of the conceptual database design DFD ERD Relational Model All of the above Q no 28: The E-R data model supports following major constructs Entity Attribute Relationship All of the above Q No 29:E-R model does not tells the Flow of Data Representation of Data Graphical Representation of Data All of the above Q No 30 :What is Entity .........??? Any Real World Object any object any class All of above Q no 31:Which one of the following is not the type of Entity Weak Entity Strong Entity Hard Entity Both A & B Q no 32 : A Rectangle with Entity name in Capital represents which type of Entity? Weak Entity Strong Entity Lazy Entity All of the above Q No 33 : The properties of Entity is known as ........ Attributes Properties Instances None of the above Q no 34:An "Attribute" can be ........??? Simple or composite Single Valued or Multi Valued Stored or Derived All of the above Q No 35:A ............... is a set of one or more attributes which taken collectively, allow us to identify uniquely an entity instance in the entity set Primary Key Foreign Key Secondary Key Super Key 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 The set of all logical addresses generated by a program form the logical address space of a process; the set of all physical addresses corresponding to these logical addresses is a ............ space of the process Logical address Virtual address physical address All of them The total size of physical address space in a system is equal to the size of its ................ main memory Secondary memory hard Disk All of the above Q No 27 :Binary relationships are those, which are established between One Entity Type Two Entity Type Three Entity Type Four Entity Type The run-time mapping from virtual to physical addresses is done by a piece of hardware in the CPU, called the ./....... memory management unit MMU MNU Both A & B 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 Base Register is also known as ........... Memory Register Relocation Register Short memory Register Location Register 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 21.The database design prevents some data from being stored due to _______. a. Deletion anomalies b. Insertion anomalies c. Update anomalies d. Selection anomalies 22.Consider the schema R(S,T,U,V) and the dependencies S→T, T→U, U→V, V→S. Let R= {R1,R2} such that R1∩R2=Φ. Then the decomposition is : a. not in 2NF b. in 2NF but not in 3NF c. in 3NF but not in 2NF d. in both 2NF and 3NF Consider the schema R(S,T,U,V) and the dependencies S→T, T→U, U→V, V→S. Let R= {R1,R2} such that R1∩R2=Φ. Then the decomposition is : a. not in 2NF b. none of the above c. in 3NF but not in 2NF d. in both 2NF and 3NF 24. 5NF is designed to cope with : a. Transitive dependency b. Join dependency c. Multi valued dependency d. None of these 25.Consider a relation R(A, B, C, D) with the following functional dependencies: A -> (B, C, D), (A, D) -> (B, C) and (C, D) -> (A, B). Identify the candidate key(s). a. {A} b. {A}, {C, D} c. {A}, {C, D}, {A, D} d. {C, D} 26. Consider the relation Sale(Date, Customer, Product, Vendor, VendorCity, SalesRep) {Date, Customer, Product} is the composite candidate key and the following functional dependencies are also given: Vendor -> VendorCity, Product -> Vendor What is the highest normal form of the sale relation? a. 0NF b. 1NF c. 2NF d. 3NF 27. R(A,B,C,D) is a relation, Which of the following does not have a lossless join dependency preserving BCNF decomposition a. A->B, B->CD b. A->B, B->C,C->D c. AB->C, C->AD d. A->BCD 29. Which functional dependency types is/are not present in following dependencies? StaffNo, BranchNo -> StaffName, BranchName, Position, DOB StaffNo -> StaffName, Position, DOB BranchNo -> BranchName a. Full functional dependency b. Partial functional dependency c. Transitive functional dependency d. Both B and C 30. Which of the following columns in a table cannot be updated? a. DATE type columns in the table b. Columns which allows NULL values in the table c. A primary key column which also serves as foreign key reference in another table d. All of the above 31.The three language components of a database management system (DBMS) like DDL, DCL, DML. Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DB a. DDL b. DML c. DDL And DCL d. DCL And DML 32. Cuticular transpiration is --------- of total transpiration ? 6-8% 5-7% 7-9% 4-6% 20. Consider a database table T containing two columns X and Y each of type integer. After the creation of the table, one record (X=1, Y=1) is inserted in the table. Let MX and My denote the respective maximum values of X and Y among all records in the table at any point in time. Using MX and MY, new records are inserted in the table 128 times with X and Y values being MX+1, 2*MY+1 respectively. It may be noted that each time after the insertion, values of MX and MY change. What will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7; (A) 127 (B) 255 (C) 129 (D) 257 21. Let R and S be relational schemes such that R={a,b,c} and S={c}. Now consider the following queries on the database: IV) SELECT R.a, R.b FROM R,S WHERE R.c=S.c.........Which of the above queries are equivalent? Let R and S be relational schemes such that R={a,b,c} and S={c}. Now consider the following queries on the database: IV) SELECT R.a, R.b FROM R,S WHERE R.c=S.cWhich of the above queries are equivalent? A) I and II (B) I and III (C) II and IV (D) III and IV 22.Assume that relations corresponding to the above schema are not empty. Which one of the following is the correct interpretation of the above query? Consider the following relational schema: Suppliers(sid:integer, sname:string, city:string, street:string) Parts(pid:integer, pname:string, color:string) Catalog(sid:integer, pid:integer, cost:real) Consider the following relational query on the above database: SELECT S.sname FROM Suppliers S WHERE S.sid NOT IN (SELECT C.sid FROM Catalog C WHERE C.pid NOT IN (SELECT P.pid FROM Parts P WHERE P.color 'blue')) (A) Find the names of all suppliers who have supplied a non-blue part. (B) Find the names of all suppliers who have not supplied a non-blue part. (C) Find the names of all suppliers who have supplied only blue parts. (D) Find the names of all suppliers who have not supplied only blue parts 23. How many vertebrae are present in coccyx ? A. 7 12 9 D. 4 Which of the following pairs of fins in a fish body are paired ? A. Dorsal and ventral. Pectoral and Pelvic. C. Tail and anal All of these 25. Which one of the following is an example of a non-elastic connective tissue ? Ligaments. Tendon Muscles. None of these 1.A computer is known as the combination of ................. Hardware Operation System Application Programs Users All of Them Bastille day is the Commemoration of the storming of the bestille Fortress-prison which was seen as a symbol of the Revolutionary up-Rising in? Belgium USA France Canada Servile is the opposite of? Puerile futile haughty foul. Out of the Following, the the largest ethnic group by population without having a state of its own is? Kurdish Welsh Uighurs Sikhs The famous book "East of Eden" is the work of John steinbeck R.W. Emerson Russell Ernest Hemingway John steinbeck R.W. Emerson Russell Ernest Hemingway In the election of the president of the United States of America the largest number of members of the electoral college are elected from the state of? New York Texas California Florida The imaginary line of 0 degree longitude which passes through Greenwich is called? Meridian equator Tropic of Cancer Tropic of Capricorn Sui Generis is a Latin term of? Unique generous generous common sui gas "Rand" is the Currency of? South Africa tanzania america Somalia The Strait of Hormuz fall between UAE and Oman Iran and Iraq Iran oman and UAE UAE and Qatar which one of the following statement is false? 'Unenforceable' means that there is no remedy for breach of a convention the laws of the Constitution are enforceable in the courts the conventions of the constitutions are binding political rules which are not enforceable in the courts constitutional conventions are not binding on anyone America Cup is associated with which of the following sports? Canocing yachting American football paragliding The number of working children according to ILO estimates in developing countries is? 300 million 250 million 320 million 80 million In torts , the principal "Restitutio ad integrum" means? compensation for damages restoration to the original condition restriction on integration none of the above . Sylhet district at the time of partition was part of the province of United provinces Assam Bihar Bengal Who created the famous character of "Dracula"? Stanley Kubrick John Polidori James Cameron Bram Stoker 'Contours' are lines connecting places having? Equal temperature equal pressure equal height equal rainfall In Human body flat bones are found in? Neck Skull leg chest Which is the highest military award of Italy? Medal of Honor medal of valour military cross iron cross Which country Is called the cockpit of Europe? Belgium Canada UK Sweden Author: A.J. Bhatti
