PPSC MOCK Test Preparation Quiz no 5 A.J. Bhatti October 8, 2020 Welcome to your PPSC MOCK Test Preparation Quiz no 5 Email Name 10.Which one of the following is not a CPU Bus....... address bus Data bus Control Bus None of these 11. If a CPU wants to read or access a particular byte from the memory then CPU uses which bus and give it the address of that particular byte COntrol Bus Data Bus Address Bus All of them 12.Which Bus is used for the Reading of Data ......... Control Bus Data Bus Address Bus None of Them 13.Which one of the following is not a Service of Operating System.......? Manage secondary storage devices Manage primary storage Manage processes Allow a user to manage his/her files and directories properly None of these A signal is an event generated to get attention of ........ A CPU A Process An Interrupts an Execution A process may get the CPU and never relinquish it. So the issues of hardware protection are: I/O protection, memory protection CPU protection. All of them A user process may disrupt the normal operation of the system by issuing illegal I/O instructions, by accessing memory locations within the operating system itself, or by Set user mode Interrupt/ fault User Monitor 9 refusing to relinquish the CPU this process is known as I/O Protection Hardware Protection Software protection All of the above The region in the memory that a process is allowed to access is known as process address space process address space None of them 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 What are the two ways of Object Creation............? With New operator In Traditional Way Employe = new Employe , + , Book book1; The Third option is Wrong 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 who is the owner of Microsoft Mark Zuker Burg Bilgates Trump Vijay Disai One of the most Usable aspect of Object Oriented Programming is ............. Code Re-usability Class Re-usability Object Re-usability None of the Above Microsoft Office is (A) Desktop applications (B) Operating system (C) Command window D) N(one of these The Process of Forming the New Class from Existing Class in Known as Abstraction Encapsulation Information Hiding Inheritance The very first version of Microsoft Office was released for (A) Windows operating system (B) Apple Macintosh OS (C) Unix (D) None of these A program by itself is not a process: a program is a .............. Passive entity Passive activity Passive file Passive Coding A program by itself is not a process: a program is a passive entity, such as contents of a file stored on disk, whereas a process is an .............. Passive Entity Active Entity Passive activity Active Activity ............spend more time doing IO than computations, have many short CPU bursts. I/O Bound Processes CPU Bound Processes Both A & B None of them ................spend more time doing computations, few very long CPU bursts. CPU Bound Processes I/O Bound Processes None of Them All of Them The information includes the list of I/O devices allocated to the process, a list of open files, and so on is known as CPU Process information Memory Process Information Monitor Process Information I/O status information The objective of multiprogramming is to have some process running all the time so as to ....................... maximize CPU utilization minimize CPU utilization maintain CPU utilization All of the above Switching the CPU from one process to another requires saving of the context of the current process and loading the state of the new process,This is called content switching context switching contact switching Process switching As processes enter the system, they are put into a job queue. This queue consists of all processes in the .......... CPU Monitor Scheduling system The main Disadvantages of Flat File Database System Duplication of Data inconsistency of Data Vulnerability All of Above What is Database? Add description here! A shared collection of logically related data, designed to meet the information needs of multiple users in an organization. A Private collection of logically related data, designed to meet the information needs of multiple users in an organization. A Protected collection of logically related data, designed to meet the information needs of multiple users in an organization. None of These Among the options below , Which is not an advantage of a Modern Database Data Sharing Consistency Inconsistency Data Integrity The data for different applications or subsystems is placed at the same place data Sharing data Independence Controlled Redundancy data Integrity If processes P and Q want to communicate, a ............. link must exist between them and they must send messages to and receive messages from each other through this ........ communication, Commitee Communication, Link Communication , Process Communication , Progress With ........................., each process that wants to communicate must explicitly name the recipient or sender of the communication direct communication In-direct communication Message Passing Inter Process Communication IPC With ......................., messages can be sent to and received from mailboxes. Here, two processes can communicate only if they share a mailbox indirect communication direct communication Message Passing IPC The Process of Communication between processes takes place by calls to send and receive primitives (i.e., functions). A-Synchronization Synchronization Buffering Un Bounded Capacity Q No 9 : ..................... is an action that is used to perform some manipulation on the data stored in the database Transaction Transaction Failure Transaction Support Transaction History Q no 10 :The process of Dealing with one or more transaction Simultaneously or at a time is known as Transaction Control Transaction concurrency Concurrency All of the above Q no 11 :Concurrency support means to support a number of transactions to be executed at the same time one after another Simultaneously Both A & C Q no 12 : The process of getting back the data lost because in case a database gets an inconsistent state to get corrupted due to any invalid action of someone is known as Data Redundancy Data Recovery Data Support Data integrity The sending process sends the message and resumes operation is called blocking send Non-blocking recieve Non-blocking send All of them In ......... receive: The receiver blocks until a message is available Blocking Process Non Blocking Recieve All of the above In .......... receiver: The receiver receives either a valid message or a null Blocking NonProccess-blocking Non-blocking None of these The Process in Which Whether the communication is direct or indirect, messages exchanged by the processes reside in a temporary queue is known as ....... Buffering buttering Synchronization A-Synchronization In 1 and 4, there is no choice in terms of scheduling; a new process must be selected for execution. There is a choice in case of 2 and 3. When scheduling takes place only under 1 and 4, we say, scheduling is ...............; otherwise the scheduling scheme is ................ non-preemptive,preemptive preemptive,non-preemptive non-preemptive,non-preemptive preemptive,preemptive Under non-preemptive scheduling once the CPU has been allocated to a process the process keeps the CPU until either it switches to the .........., finishes its CPU burst, or terminates Non waiting state Executing state waiting state All of the above Preemptive scheduling incurs a ........ Process Long Process Short Process cost In ....... utilization: We want to keep CPU as busy as possible. In a real system it should range from 40 percent (for a lightly loaded system) to 90 percent (for a heavily used system) CPU Process Cost System 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 CTRL+A is the short key to (Select all) (un Select all) (Delete all) Copy All Q No 9 : A Relational Database Model is Based on Table known as Relation Relative No More Relation More Relation Choose Correct the Sentence for : We bought a Japanee print We bought a Japanee print We bought a Japanese print We buy a Japan print Bot A & C Q No 10 :The Base of Relational Model Diagram is .......... Simple Functions Mathematical Functions Simplicity Functions Simplicity Translation of a source program in a high-level or assembly language involves compilation and ..................... Execution of the program De-linking of the program Extra linking of the program linking of the program Memory Management is also responsible for swapping processes in and ................. out of main memory In of main memory Extra of main memory more to main memory The collection of processes that is waiting on the disk to be brought into the memory for execution forms the ;........... input queue output queue Processing input queue Processing Output Queue if you know at compile where the process will reside in memory, the absolute addresses can be assigned to instructions and data by the compiler....This process is known as ... Load Time Compile Time Execution Time Memory Management if it is not known at compile time where the process will reside in memory, then the compiler must generate re-locatable code. In this case the final binding is delayed until ....... Compile Time Execution Time load time Memory management LRU stands for? line-replaceable unit linement-replaceable unit line-replacement unit work All of these 9. in “many to many relationship” one instance of first entity can be mapped with many instances of second entity Select correct option: a. true b. false 10. Compute R ⋈ S. Which of the following records will be in the result? Assume each record has the schema (A, B, C, D). (a) (3, 3, 1, 6) (b) (6, 4, 4, 1) (c) (2, 3, 3, 5) (d) (3, 5, 3, 1) 11. Compute R ⋈R.A<S.C S. (this is theta join). Which of the following records will be in the result? Assume each record has the schema (A, B, C, D). (a) (2, 3, 3, 5) (b) (6, 4, 4, 1) (c) (6, 4, 3, 1) (d) (3, 5, 1, 6) 12. Compute R ⋈R.B < S.D AND R.A<S.C S. [this is theta join]. Which of the following records will be in the result? Assume each record has the schema (A, B, C, D). Add description here! (a) (3, 3, 3, 5) (b) (6, 4, 3, 1) (c) (2, 3, 3, 5) (d) (3, 5, 1, 6) 9. Which of the following statement is true? a) DELETE does not free the space containing the table and TRUNCATE free the space containing the table b) Both DELETE and TRUNCATE free the space containing the table c) Both DELETE and TRUNCATE does not free the space containing the table d) DELETE free the space containing the table and TRUNCATE does not free the space containing the table 10. What is the purpose of the SQL AS clause? a) The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column b) The AS clause is used with the JOIN clause only c) The AS clause defines a search condition d) All of the mentioned 11. ______________ function returns current date and time. a) SET DATEFIRST b) SYSDATETIME c) Cert_ID d) GETDATE 12. Which of the following is not a mathematical function? a) ATN2 b) POWER c) PI d) CEIL Q 50 : last advice of holy Prophet peace be upon him was about Namaz Rights Man Women How many aircrafts by mm Alam downed in one go? 5 6 4 3 What is the total area of Pakistan? 8609 12 square kilometer 796 960 square kilometer 79098 square kilometer 8819 13 square kilometer How many years Jahangir Khan remained unbeaten? A. 3 years b. 7 years C. 8 years d. 5 years Ricket is a disease due to the deficiency of A. Vitamin B. vitamin K C. vitamin A D. Vitamin D What is the unit of pressure? Length Coulomb Ampere Pascal how many surah's start with Bismillah in the Holy Quran? A. 111 B.113 C.114 D.11 1 The capital of Chechenia is Helsinki Suvah Paris Grozny world polio Day celebrated on A 22nd September B 23rd December C 22nd March D 24th October who was the second prime minister of Pakistan a Nazim Uddin B Malik Ghulam Mohammad C Iskandar Mirza D Quaid e Azam 4 Antarctica is located in a North Pole B South Pole C both A and B D none of these what is the capital of Jamaica A Kingston B Brussels C protocol D none of these total length of Durand line is a 2422 kilometer b 2421 kilometer C 2423 kilometer D 2430 kilometer how many projects under one belt one road are A 3 B 4 C 5 D 6 In which year Musharraf became president A 1999 B 2006 C 2001 d 2000 Bhutto was the ........- Prime Minister of Pakistan A six b 8 c 9th D 10th 12 which is the largest country by population A China b USA C Russia D Canada the highest waterfall is a angel B Victoria C Iguazu Falls D none of these which is the largest country by area ? A China b Russia C USA D Canada when did zia ul haq died during plane crash A 1985 B 1986 C 1987 D 1988 The data lines provide a path for moving data among .................. system modules CPU system modules Memory system modules All of the above Well-engineered software consists of which characteristics.? • It is reliable It has acceptable performance • It has good user-interface • • It is of good quality • It is cost-effective All of the above Name the Software related activities Defined by Caper Jones •Project Management • Requirement Engineering • Design • Coding • Testing All of the above How many basic phases of software development 2 3 6 4 Which one of the following is not a Software development phase Vision Definition Development Maintainance None of these The prototyping paradigm begins with ....... Functional Requirements requirements gathering requirements engineer requirements document How many Requirement Statement Characteristics 4 5 7 9 The Term Complete in the Requirements Statement Characteristics means - No requirement or necessary information should be missing - No requirement or necessary information should be avoided - No requirement or necessary information should be late - No requirement or necessary information should be ambigous Data Flow Model • Captures the flow of data in a system • Captures the flow of energy in a system • Captures the flow of states in a system • Captures the flow of time in a system The IP network 192.168.50.0 is to be divided into 10 equal sized subnets. Which of the following subnet masks can be used for the above requirement? 255.243.240 255.255.0.0 255.255.0 255.255.255 When the mail server sends mail to other mail servers it becomes ___ ? SMTP client SMTP server Peer Master The length of an IPv6 address is? 32 bits 64 bits 128 bits 256 bits The term WAN stands for? Wide Area Net Wide Access Network Wide Area Network Wide Access Net Which layer of the TCP / IP stack corresponds to the OSI model transport layer? Host to host Application Internet Network Access On a simplex data link, which of the following is a possible error recovery technique? Backward error correction (BEC) The use of hamming codes Downward error correction (DEC) Automatic Repeat Request (ARQ) The Term Consistent in the Requirements Statement Characteristics means No requirement should conflict with other software or higher-level system No requirement should conflict with other Website or higher-level system No requirement should conflict with other Company or higher-level system None of these Author: A.J. Bhatti