PPSC Mock Test Preparation Quiz No 3 A.J. Bhatti October 6, 2020 Welcome to your PPSC Mock Test Preparation Quiz No 3 Name Email 7.Which one is not considered as CPU Unit ..... GPU FPU ALU TPU Salat was first made obligatory for: Hindus Jews Christians Muslims 8.A memory known as Register is Directly attached with ......... Monitor CPU Rom Ram The place where discussion related to Hazrat Abu Bakr selection took place: Dare Arqam Madina Makkah Saqeefa bin sadrah 9. How many types of buses are present ....... two types of buses Three types of buses Four types of buses Five types of buses Umm ul Masakeen is the title of? Hazrat Aisha Hazrat Zainab Hazrat Khadija Hazrat Fatime 10.Which one of the following is not a CPU Bus....... address bus Data bus Control Bus None of these Marhab was killed by? Hazrat Umer e Farooq Hazrat Ali Hazrat Abubakar Hazrat Usman C Language was Developed By Scientist of Bell Labs in........ 1970 1971 1965 1972 .............. is First Object Oriented Language of the World C Language C++ Java Language Machine Language Which Types of Classes are mostly Used.... Concrete Classes Abstract Classes Both A and B None of Them How many Types of Classes are Two types Three Types Four Types 5 Types A less restrictive type of real time system is a ............. real time system, where a critical real-time task gets priority over other tasks, and retains that priority until it completes hard Soft Fixed Unfixed An ,,,,,,,,,, is a signal generated by a hardware device (usually an I/O device) to get CPU’s attention Traps Software interrupt interrupts All of the above Interrupt transfers control to the interrupt service routine (ISR), generally through the interrupt Signal Traps interrupt vector table A ............. is a software-generated interrupt caused either by an error (division by zero or invalid memory access) or by a user request for an operating system service. Trap Exception Trap (or an exception) None of them Which of the one is not an Access Specifier?? Public Private Protected Lifo and Fifo object oriented principles which are related to each other are Abstraction & Inheritance Abstraction & Polimorphism Abstraction & Encapsulation None of Above The name of First Computer invented Abacus P4 P5 Core to due The Process of Placing the Data and the Functions that work on the Data in the same place is known as Abstraction Encapsulation Inheritance Polimorphism Class Employee : Public Person {}(Which is the Parent Class ) Class Employee Class Child Class Person Class The method Which structures the operating system by removing all non-essential components from the kernel and implementing as system and user level programs is known as Mini Kernals Micro Kernal s Macro Kernals short Kernals Micro kernels typically provide ............... and memory management in addition to a communication facility minimum process Maximum process smaller larger 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 Java Virtual Machine (JVM) loads, verifies, and executes programs that have been translated into ............. Java Bytecode Java Byte Java code Java Byte Process coding Each process is represented in the operating system by a process control block (PCB) – also called a Process control Board Task Control Board PCB TCUB All of the Above Micro kernels typically provide minimum process and ............. management in addition to a communication facility memory management Project management Process Management All of the above 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 Process in which once change in the Data has no or minimum effect on other File or Data is known as Data Sharing Data Retundacy Data Integrity Data Independence This information includes the amount of CPU and real time used, time limits, account numbers, job or process numbers, and so on is known as CPU Accounting information Accounting information Memory Accounting information Memory Information Data Integrity is also Known as Validity of Data Duplication of Data Multiplication of Data Division of Data This information may include such information such as the value of the base and limit registers, the page tables, or the segment tables, depending on the memory system used by the operating system. Memory-management information CPU-management information Memory-Scheduling information CPU-Scheduling information The Process in which we do not need to duplicate data unnecessarily; we do duplicate data in the databases, however, this duplication is deliberate and controlled Integrity Controlled Redundancy Data independency Data Sharing how many countries are members of SAARC 5 6 7 8 A producer process produces information that is consumed by a .......... process consumer Retailer Parent Child how many official working languages are recognized by UNO 8 6 4 none of these .......... provides a mechanism to allow processes to communicate and to synchronize their actions without sharing the same address space Interprocess Communication (IPC) Non Interprocess Communication (NIPC) IPC Both A & C The function of a message system is to allow processes to communicate without the need to resort to the ........... data Unshared Data shared Data Process Data All of the above 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 which of the following country has no boundary with Syria Iraq Iran Turkey Israel Sindh was separated from Bombay in 1929 1935 1937 1947 Q No 5 :Two important functions that the DBMS performs are: User management Data management Application management Both A & B Q No 6 :The process of creation , Storing, Deleting,Updating,accessing or arranging the data in the Database is known as ............. Data Handling Data Processing Transaction Processing Database processing Q no 7:.................... is an object or place in the DBMS which stores almost all of the information of the database, including schema information, user information right of the users Catalog A user accessible catalog Transaction Catalog Both A & B Q no 8 :A catalog is also known as Data .............. Data Processing Data Integration Data Dictionary Transaction of Data The vitamin that control the Browning in fruits by the help enzymes is Vitamin K Vitamin B Vitamin C Vitamin D The ................ is a kernel module that takes control of the CPU from the current process and gives it to the process selected by the short-term scheduler CPU dispatcher Process dispatcher dispatcher short-term scheduler CPU scheduler Functions of Dispatcher are : Switching the context (i.e., saving the context of the current process and restoring the context of the newly selected process) Switching to user mode Jumping to the proper location in the user program to restart that program 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 Preemptive and Non-Preemptive Scheduling | CPU scheduling can take place under Which of the following the following circumstances: When a process switches from the running state to the waiting state (for example, an I/O request is being completed) 2. When a process switches from the running state to the ready state (for example when an interrupt occurs) 3. When a process switches from the waiting state to the ready state (for example, completion of I/O) 4. When a process terminates 5. When a process Resumes or Continue or in the waiting state All of them Option 1,2,3,4 are correct 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 CPU fetches instructions from memory according to the value of its program counter and other memory management registers such as ................... in Intel CPUs segment registers segment bits segment memory segment bytes A typical instruction-execution cycle, e.g., first fetches an instruction from memory, which is then decoded and .......... played executed terminated both A & B The memory hierarchy not includes: Very small, extremely fast, extremely expensive, and volatile CPU registers Small, very fast, expensive, and volatile cache Hundreds of megabytes of medium-speed, medium-price, volatile main memory Hundreds of gigabytes of slow, cheap, and non-volatile secondary storage Very Big, extremely fast, extremely expensive, and volatile CPU registers The purpose of memory management is to ensure fair, secure, orderly, and ............ Small use of memory Large use of memory Extra use of memory efficient use of memory 5. Which is a join condition contains an equality operator: a) Equijoins b) Cartesian c) Natural d) Left 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 7.which of the following is true ? Every relation in 3NF is also in BCNF A relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of R Every relation in BCNF is also in 3NF No relation can be in the both 3NF and BCNF 8........for a database relation R(a,b,c,d) where domain of a,b,c and d include only automatic includes only atomic values , only the following functional dependencies and those that can be inferred from them hold a→ c b→ d The relation is in First normal form but not in second normal form Second normal form but not in third normal Third normal form None of the above 5. Which data type can store unstructured data in a column? A.RAW B.CHAR C.NUMERIC D.VARCHAR 6. Which of the following SQL clauses is used to DELETE tuples from a database table? a) DELETE b) REMOVE c) DROP d) CLEAR 7. ___________removes all rows from a table without logging the individual row deletions. a) DELETE b) REMOVE c) DROP d) TRUNCATE 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 18. A relational database contains two tables student and department in which student table has columns (roll_no, name and dept_id )and department table has columns (dept-id and dept-name). The following insert statements were executed successfully to populate the empty tables: Insert into department values (1, 'Mathematics'); Insert into department values(1, 'Physics'); Insert into department values(1, 'Navin', 1); Insert into student values (2, 'Ravi', 2); Insert into student values (3, `Gitu', 1); How many rows and columns will be retrived by the following SQL, statement? Select * from student, department; A. 0 row and 4 columns B. 3 rows and 4 columns C. 3 rows and 5 columns D. 6 rows and 5 columns Insert into student values (3, `Gitu', 1); Both A & B 19.In a ................................, the operating system simply switches to, and executes another job. When that job needs to wait, the CPU simply switches to another job and so on multiprogrammed system multiprogramming system Single programmed system multi programming system The Holy Book bestowed upon Hazrat Essa (A.S)? Torat Zaboor Injeel Quran e Majeed On which tribe Zakat is prohibited? Banu Umaid Banu Hashim. Banu Hatim All of the above Computer system is a (A) Hardware (B) Software (C) Bioware (D) Virtual ware A workflow model represents (A) Sequence of activities (B) Role of users involved (C) Set of activities (D) None of these Which one is not the non-functional activity ? (A) Reliability (B) Performance (C) Coordination (D) Maintainability Which one is functional component ? (A) Reliability (B) Maintainability (C) Computation (D) Performance In software system requirements, the functional requirement for the system describes (A) Services the system is expected to provide (C) Reliability, response time or system capacity (B) Factors of system development (D) None of these In Windows operating system the ———— ——— is the main screen area that one sees after he turn on a computer and log on to Windows. (A) Desktop (B) Icons (C) Taskbar (D) None of these In Windows operating system these are small pictures that represent files, folders, programs, and other items. Each one is used to make the computer do something. (A) Sidebar (B) Icons (C) Taskbar (D) None of these In Windows operating system it is a very important part of Windows, clicking on it opens up what is called the start menu (A) Start button (B) Sidebar (C) Icons (D) None of these In Windows operating system the clock in windows xp sits on the ————— and displays the system time. (A) Taskbar (B) Start menu (C) Desktop (D) None of these Microsoft Windows provides a graphics application named (A) Paint (B) Adobe Photoshop (C) Jasc Paint Shop (D) None of these In Windows operating system to display or hide the Start menu (A) Windows Logo (B) Windows Logo + BREAK (C) Windows Logo + D (D) Windows Logo + M In Windows operating system the shortcut key Windows Logo+E is used for (A) Restore the minimized windows (B) Open My Computer (C) Search for a file or a folder (D) Search for computers In Windows operating system shortcut key CTRL+Windows Logo+F (A) Restore the minimized windows (B) Open My Computer (C) Search for a file or a folder (D) Search for computers In Windows operating system shortcut key Windows Logo+ L (A) Display Windows Help (C) Open the Run dialog box (B) Lock the keyboard (D) Open Utility Manager In Windows operating system to Display the System Properties dialog box (A) Windows Logo (B) Windows Logo + BREAK (C) Windows Logo + D (D) Windows Logo + M In Windows operating system to minimize all of the windows (A) Windows Logo (B) Windows Logo + BREAK (C) Windows Logo + D (D) Windows Logo + M Microsoft Office is an office suite, for the (A) Microsoft Windows operating systems (B) Mac OS X operating systems (C) Both A and B are true (D) None is true Microsoft Word, Microsoft Excel, and Microsoft PowerPoint are the part of (A) Microsoft Office Suite (B) Microsoft Windows (C) Mac OS X (D) None of these In Microsoft Word shortcut DELETE is for (A) Undo something (B) Delete something (C) Paste something (D) None of these What type of software is used for creating letters papers and other documents? (A) Database (B) Word Processor (C) Spreadsheet (D) Operating Program What is the file extension of Ms-Word972003 document? (A) Dot (B) Doc (C) Dom (D) Txt in database, a(n) ____ field is a group of related fields. (a) Table (b) Key (c) Record (d) Primery field (e) Non of these _______ is a network technology that defines how messages are routed from one end of a network to other, ensuring the datat arrives correctly by dividing it into packets. (a) HTML (b) XML (c) HTTP (d) TCP/IP (e) none of these When a computer sends data over the internet, the data is divided into small pieces , or _______ (a) Bundles (b) packets (c) slices (d) baskets (e) none of these The amount of data, instructions and information that can travel over a communication channel somtimes is called _______ (a) broadband (b) baseband (c) latency (d) bandwidth (e) none of these fiber optic cables have all of the following advantages over cables that used wire except _______ (a) lower costs & easier installation and modification (b) Faster data transmission & smaller size (c) Less susceptible to noise from other divices (d) Better security for signals during transmission (e) none of these A_____ is a network that connects compter and divices in a limited geographical area, such as home, school computer laboratory , or office building (a) LAN (b) MAN (c) WAN (d) VAN (e) none of these Which of the following devices can be sued to directly image printed text? a. OCR b. OMR c. MICR d. All of above Two Buildings with a long distance between each other are connected with each other through a network ... the Network is known as ?? IntraNetwork InterNetwork Both A & B All of these A collection of hyperlinked documents on the internet forms the ?.? World Wide Web (WWW) E-mail system Mailing list Hypertext markup language The Correct Date of PPSC CS Examination is ? 16 October 17 October 18 October Which will officially announced by PPSC Author: A.J. Bhatti
