PPSC Lecturer Computer Science Syllabus Quiz 4 A.J. Bhatti September 1, 2020 Welcome to your PPSC Lecturer Computer Science Syllabus Quiz 4 Name Email Q No 1 :The Word Mapping is Used for ............. in Database Conversion Diversion intrusion Both A & B Q No 2: The data independence is that type of independence that provides us changes transparency between the conceptual and internal levels Physical Data Independence Logical Data independence Conceptual Data Independence External Data independence Q No 3: The Functions Of DBMS are............... A user accessible Catalog Transaction Support Concurrency Control Services All of the Above Q no 4 : Which of the following is not the function of Database Management System Data Processing Data Duplication Recovery Services Authorization Services 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 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 Q no 13 : The process of to allow or restrict different database users to interact with the database is known as Database Management Services Authorization of Data Authorization Services of DBMS All of the above Q No 14 : if the system is working for such an organization which is spread across the country and it is deployed over a number of offices throughout the country, then the DBMS should be able to communicate to the central database station. This Service of DBMS is known as......... Transaction Processing Data communication Support Data integrity Data processing Q no 15:Data Integrity a Service of DBMS responsible for Originality of Data Duplication of Data Bogus Data Both B & C Q no 16 :In a Client Server System An End User is Directly Connected with ........... Server Administerator Client Remote offices Qno 17:In ................. Servers Each client of the network runs its own copy of the DBMS and the database resides in the Server Client Server File Server Client & File Server All of the above Q no 18 : A DBMS server machine which runs the DBMS and to this machine are connected the clients having application programs running for each user........ File Server Database Server Client Server Client File Server Q no 19:Which of the following is / are the rules or functions of Data Flow Diagram? DFDs show the flow of data between different processes o a specific system. DFDs are simple, and hide complexities. DFDs are Descriptive and links between processes describe the information flow All of the above Q no 20: Which of the following is / are considered as the limitation of DFD They do not provide us a way of expressing decision points. DFDs are focused on flow of information only There are a limited number of symbols which are used for design process in DFDs All of them 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 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 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 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 36: Endoskeleton is secreted by ? Ectoderm. Endoderm. Mesoderm. All of these Q No 37: How many bones are present in the wrist ? 4 bones 6 bones 8 bones 14 bones Q No 38:Balouch Culture Day 2018 was observed on:------------? A. 2nd january B. 2nd February C. 2nd March D. 2nd April Q no 39: How many Pakistani blue helmets have embraced martyrdom while serving under the UN umbrella.? 150 156 160 165 Q No 40 :Name the Wrestler, who won first gold medal for Pakistan in the 86kg freestyle wrestling in Common Wealth Games 2018? A. Muhammad Inam Butt B. Muhammad Sajjad C. Jansher khan D. Samiullah Khan Author: A.J. Bhatti
