PPSC Lecturer Preparation Database Management Systems Quiz No 2 Posted on December 26, 2021 by AsadJavaid Welcome to your PPSC Lecturer Preparation Database Management Systems Quiz No 1 Email Name Q No 7 : Database Systems are very important related to your .... Sales Transections Both A & C Product Inventory None of Them Q No 10 : .............. Helps us to easily store Data in Database ......... Control System File System DBMS None of Them Q No 8 : ............... Helps us to Store Raw Data Files into Hard Disk ? File System Control System DBMS None of Them Q 10 : ......... provides more flexibility in accessing and managing data as compare to ........... DBMS , File System Control System , File System File System , DBMS None of Them Q 11 : ......... is the primary feature of DBMS Data Sharing Data Deleting Data Searching None of Them Q 12: Data for Different applications is placed at .............. in DBMS Different Place Same but opposite to processor same place None of Them Q 13 : Data and Programs are ............ to each other Dependent independent Overriding None of Them Q No 14 : Change in Data has ........... effect on programs No Effect Both A & C Minor Effect None of Them Q 15 : Data is .......... as compare to information organized unorganized Both None of Them Q 16 : Data does not depends on ........... Information Collection Ram None of Them Q 18 : ............ is a collection of small programs LMS DBMS Database None of them Q 17 : ................ Depends on Data Data Ram All of them None of Them Q 19 : Which of them are the Advantages of Database System Consistency Data Security Faster Development All of Them Q 20: All application programs which access data through which program.......... Data Base Database Management System File Systms None of Them 1) Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation? DML(Data Manipulation Language) Query Relational Schema DDL(Data Definition Language) None of the Above Q No 2 : A shared collection of logically related data is known as Database Data Integration DBMS None of the above Q No 3: Database meets the information needs of .................... users Single Double Multiple None of Them Q No 4 : A collection of Data or Information is called Database which includes ............... Part Numbers Product Codes Customer Information All of these Q No 5 : A Database is typically design so that it is ......... Easy to Store Access Information Both of them None of them Q No 6 : Database is a different type of calculations that vary........ simple to complex complex to simple simple to simple None of them Q 23: Data at which objects exist in reality is called ....... Real World Data Digital World Data / Meta Data Both A & B None of Them Q 21: ........... means to access data transparently Faster Development Data Security Concurrency Control None of Them Q 24 : Name , Character , Datetype is included in ........ Real World Data Meta Data Digital World Data None of Them Q 25: Users of DBMS are application programmers end users sophisticated users All of them Q 26 : Sophisticated Users has additional rights over ........... Users End Users Naive Users Application Programmers None of Them Q 22 : A Resource is any thing which is valuable for ...... organization building , Managers furnitures All of Them Q 27 : ........... is responsible for the proper working of DBMS DBA DBMS DLL None of Them Q 28 : DBA is responsible for Schema Definition Granting Data Access Routine Maintenance All of them Q 30 : DBA is Data Base Manager Data Base Accessor Data Base Administrator None of Them Q 32 : Characteristics of Data Processing Includes Transection Support Accessible Catalog Integrity Services All of Them Q 31 : DBA has to monitor Disk Space Running Jobs Both A & B None of Them Q 33: Important Function of DBMS are User Management Data Management Both A & B None of Them Q 37 : ......... Consist of single process and describe single system Detail Diagram Context Diagram Level 0 Diagram None of Them Q 38 : ER Data Model support following major constructs Entity Attribute Relation Ship All of Them Q 35 : DFD are focused on Flow of Information Flow of Data Expressing Decision Points None of Them Q 36 : Types of DFD Context Diagram Level 0 Diagram Datail Diagram ALL of Them Q 39 : An Entity whose instance can exists independently Strong Entity Naming Entity Week Entity None of Them Q 34 : DFD is called Data Functionality Diagram Data Feed Diagram Data Flow Diagram None of Them Q 40 : ............... is a set of attributes that can be used to identify entity type Lock Key Bothe A & B None of Them 41. Which of the following gives a logical structure of the database graphically? a) Entity-relationship diagram b) Entity diagram c) Database diagram d) Architectural representation 4. Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality a) One to many b) One to one c) Many to many d) Many to one Q 43. The Rectangles divided into two parts represents a) Entity set b) Relationship set c) Attributes of a relationship set d) Primary key Q47. For a weak entity set to be meaningful, it must be associated with another entity set, called the a) Identifying set b) Owner set c) Neighbour set d) Strong entity set 42. The entity relationship set is represented in E-R diagram as a) Double diamonds b) Undivided rectangles c) Dashed lines d) Diamond 6. An entity set that does not have sufficient attributes to form a primary key is termed a __________ a) Strong entity set b) Variant set c) Weak entity set d) Variable set Q 45 : We indicate roles in E-R diagrams by labeling the lines that connect ___________ to __________ a) Diamond , diamond b) Rectangle, diamond c) Rectangle, rectangle d) Diamond, rectangle Q 49. If you were collecting and storing information about your music collection, an album would be considered a(n) _____ a) Relation b) Entity c) Instance d) Attribute Q 48 : Weak entity set is represented as a) Underline b) Double line c) Double diamond d) Double rectangle Q 50. What term is used to refer to a specific record in your music database; for instance; information stored about a specific album? a) Relation b) Instance c) Table d) Column
