Mock Test Preparation Quiz No 1 A.J. Bhatti October 1, 2020 Welcome to your Mock Test Preparation Quiz No 1 Email Name 2 ............ Provides basic computer computing resources(CPU,IO devices) Hardware Software Application Programs None of Them 3.............. Manages the use of hardware among various application programs among various users. Hardware Software Operating System I/O Devices 4. ......... Defines the ways in which system resources are used to solve the computing problems of the users Hardware I/O Devices Application Programs Users 5.The Term User in Operating System can be defined as .......... users people computers All of them 15.A computer system that allows only one user to use the computer at a given time is known as a Multi-User Systems Batch Systems Single User Systems Both A & B Type of Structure Programming in Which a program is divided in Small units and then converted them into Functions Single Entry Single Exist Structured Programming Top-Down Structured Programming Divide and Conquer Structure Programming Simple Structured Programming 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 1.A computer is known as the combination of ................. Hardware Operation System Application Programs Users All of Them 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 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 15. ntext data type falls under which category? a) Exact numerics b) Character strings c) Unicode character strings d) None of the mentioned 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 3.The virtual table that its created by data from the result of an SQL 'Select' statement is called _________ A.View B.Synonym C.Sequence D.Transaction 32. Cuticular transpiration is --------- of total transpiration ? 6-8% 5-7% 7-9% 4-6% 24. 5NF is designed to cope with : a. Transitive dependency b. Join dependency c. Multi valued dependency d. None of these 18. Compute π B (R) U π B (S). Which of the following records will be in the result? Add description here! (a) (6) (b) (1) (c) (2) (d) (5) 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) 6:If matching tuples are not found, the kind of OUTER JOIN operation which keeps all the tuples of first and second relation is classified as LEFT OUTER JOIN FULL OUTER JOIN HALF OUTER JOIN DOWNWARD JOIN مشہور ڈرامہ انار کلی کس نے لکھا A. امتیاز علی تاج B. اشفاق احمد C. بانو قدسیہ D. سعادت منٹو مشہور کہانی اوور کوٹ کے مصنف کون ہیں A. منٹو B. غلام عباس C. حسینہ معین D. امتیاز علی تاج 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 where as the physical address refers to a main memory location where instruction or ................ data resides logical data resides Physical data resides Process data resides An address generated by the CPU is commonly referred to as a ......... Theoretical logical address Bus logical address Data logical address logical address 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 16 : In Relational Database The values of the attributes did not come from the same domain True False 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 10 :The Base of Relational Model Diagram is .......... Simple Functions Mathematical Functions Simplicity Functions Simplicity 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 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 SRTF Stands for Shortest Remaining Time First Scheduling Shortest Remaining Time Former Scheduling Shortest Remaining Time Frontier Scheduling Shortest Remaining Time Frame Scheduling Q No 38:Balouch Culture Day 2018 was observed on:------------? A. 2nd january B. 2nd February C. 2nd March D. 2nd April The interval from the time of submission to the time of completion is the ........ CPU Utilization Throughput waiting time turnaround time 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 The time it takes for the dispatcher to stop one process and start another running is known as the .......... dispatch latency dispatcher time dispatch CPU dispatch latency The ........... in the ready queue are generally the process control blocks (PCBs) of processes Process (nodes) Fifo (nodes) Queue (nodes) records (nodes) Whenever the CPU becomes idle, the operating system must select ............ of the processes in the ready queue to be executed Five One Two More Then One Davis Cup is associated with A. Badminton B. Cricket C. Volleyball D. Tennis Communicating processes typically have sibling or ............ relationship parent-child child parents-childs 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 The sending process sends the message and resumes operation is called blocking send Non-blocking recieve Non-blocking send All of them 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 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 Q No 1 :The Word Mapping is Used for ............. in Database Conversion Diversion intrusion Both A & B Who said that Zakat is treasure of Islam? Rasool Ullah (P.B.U.H) Hazrat Umar Farooq (R.A) Imam Abu Hanifa (R.A) None of them I am now quite--------------and hearty. Hail Hale Hell Hall The actions includes in the duties of Database Administrator are Schema Definition Granting Data Access Routine maintenance All of the Above How many types of Users can use a Database......... 2 3 1 all of the above The Term Data About the Data is use to specify which level of Data? Real Data Meta Data Existing Data None of above A process migrates between the various scheduling queues throughout its .......... Progressing lifetime CPU Time All of Them 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 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 This information includes a process priority, pointers to scheduling queues, and any other scheduling parameters CPU Scheduling CPU Scheduling information CPU Scheduling Process CPU Scheduling Project The main Disadvantages of Flat File Database System Duplication of Data inconsistency of Data Vulnerability All of Above Largest Continent Asia Africa America Austrailia He is now ashamed -------- his conduct. A. from with of at Is it possible to overload a constructor...... Yes No In Which Process State ?The process is waiting for some event to occur (such as an I/O completion or reception of a signal. New Waiting Running Ready Types of Inheritance Public inheritance Private inheritance Protected inheritance Both A B & C A program by itself is not a process: a program is a .............. Passive entity Passive activity Passive file Passive Coding By using CPU scheduling and virtual memory techniques an operating system can create the illusion that a process has its own memory with its own Memory Virtual Reality (virtual) memory (virtual) machine In Layered Approach , A typical OS layer (layer-M) consists of data structures and a set of routines that can be invoked by .......... layers Low-Level High Level Middle level higher-level ..............provide the interface between a process and the OS. These calls are generally available as assembly language instructions System Calls CPU Calla Process Calls All of them Who Launched the Indian Weekly English magazine Named as The Comrade...... Moulana Muhammad ALi Johar Moulana Zafar ali khan Chouhdary Rehmat ALi khan Abdul Kalam Azad ......... 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 .................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 The OS is responsible for Which of the following activities in connection with memory management: Keeping track of free memory space Keeping track of which parts of memory are currently being used and by whom Deciding which processes are to be loaded into memory when memory space becomes available Deciding how much memory is to be allocated to a process Insuring that a process is not overwritten on top of another Allocating and deallocating memory space as needed All of these The of Object Oriented Language Principles are..... 3 4 5 6 How many Parameters you are able to Pass using Default Constructors 1 2 3 0 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 Main Function of Object Oriented Language is ........ Data Members + Member Functions Only Data Members Only Functions Only Classes The Classes Which are not Exist in Real World are ....? Concrete Classes Abstract Classes Both A & B None of the Above The Function Which are used for performing some other Functions are Utility Functions Accessor Functions Public Functions Private Functions OOP is a Computer Programming Model that organizes Software Designs around Data Data or Object Functions Functions or Logics How many Types of Classes are Two types Three Types Four Types 5 Types C Language was Developed By Scientist of Bell Labs in........ 1970 1971 1965 1972 The Main Limitation of Structured Programming is the Data its requires to Process Lies Outside the program Inside the program Between the program Both A and B The concept of Berger is called the ..................of sociology “unmasking tendency” “masking tendency” “ tendency” none of these ...................affect large numbers of people and have their origins in the institutional arrangements and history of a society (Mills). Happiness argument irritation wrong policies issues 6 . How many control units a CPU have ? 3 2 1 5 The program or code itself is definitely included in the software is known as Program Software Virus Worms The data on which the program operates is also considered as part of the software is known as Data Program Statement ALL of them “The process of productive use of scientific knowledge is called engineering.” Engineering Software Engineering Practical Work All of these ”This is the process of utilizing our knowledge of computer science in effective production of software systems.” Sotware Engineering Engineering Chemical Engineering Productive Engineering MIPS stands for? Modeling Inter-Organizational Systems Modeling Intera-Organizational Systems Modeling Inter-Institutional Systems Moderating Inter-Organizational Systems LRU stands for? line-replaceable unit linement-replaceable unit line-replacement unit work All of these which is faster Cach or Register? Cache Register None of these All of these Prince William visit to Pakistan on 16 October 2019 14 October 2020 14 October 2018 14 October 2019 Versions of window 8 1 2 3 4 title of saif ullah belongs to which caliph Hazrat Khalid Bin Walid Hazrat Umer bin Abdul Aziz Hazrat Umer Hazrat usman C in Hexadecimal? 13 14 15 12 If 1 octal number can be converted into Binary number then what is the binary number 002 001 110 101 Screenshot key in Windows 10? Press PrtScn Alt + PrtScn Windows key + Shift + S All of above Pakistan bough gawadar from? Qatar India Oman Afghanistan Ka'abah was built by which prophet? Hazrat Ibrahim A.S Hazrat Ismail A.S Hazrat Adam A.S Hazrat Musa A.S Current national assembly of Pakistan? 13th 12th 11th 14th Davis Cup is associated with A. Badminton C. Cricket C. Volleyball D. Tennis What comes next in the following series 64,48,40,36,34 A. 30 B. 31 C. 32 D. 33 آقاۓ دو جہاں صلی اللہ علیہ وسلم نے بچپن میں کس ملک کا سفر فرمایا تھا A. عراق B. کوفہ C. مصر D. شام Author: A.J. Bhatti