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 None Q No 10 : .............. Helps us to easily store Data in Database ......... Control System File System DBMS None of Them None Q No 8 : ............... Helps us to Store Raw Data Files into Hard Disk ? File System Control System DBMS None of Them None 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 None Q 11 : ......... is the primary feature of DBMS Data Sharing Data Deleting Data Searching None of Them None Q 12: Data for Different applications is placed at .............. in DBMS Different Place Same but opposite to processor same place None of Them None Q 13 : Data and Programs are ............ to each other Dependent independent Overriding None of Them None Q No 14 : Change in Data has ........... effect on programs No Effect Both A & C Minor Effect None of Them None Q 15 : Data is .......... as compare to information organized unorganized Both None of Them None Q 16 : Data does not depends on ........... Information Collection Ram None of Them None Q 18 : ............ is a collection of small programs LMS DBMS Database None of them None Q 17 : ................ Depends on Data Data Ram All of them None of Them None Q 19 : Which of them are the Advantages of Database System Consistency Data Security Faster Development All of Them None Q 20: All application programs which access data through which program.......... Data Base Database Management System File Systms None of Them None 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 None Q No 2 : A shared collection of logically related data is known as Database Data Integration DBMS None of the above None Q No 3: Database meets the information needs of .................... users Single Double Multiple None of Them None Q No 4 : A collection of Data or Information is called Database which includes ............... Part Numbers Product Codes Customer Information All of these None Q No 5 : A Database is typically design so that it is ......... Easy to Store Access Information Both of them None of them None Q No 6 : Database is a different type of calculations that vary........ simple to complex complex to simple simple to simple None of them None 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 None Q 21: ........... means to access data transparently Faster Development Data Security Concurrency Control None of Them None Q 24 : Name , Character , Datetype is included in ........ Real World Data Meta Data Digital World Data None of Them None Q 25: Users of DBMS are application programmers end users sophisticated users All of them None Q 26 : Sophisticated Users has additional rights over ........... Users End Users Naive Users Application Programmers None of Them None Q 22 : A Resource is any thing which is valuable for ...... organization building , Managers furnitures All of Them None Q 27 : ........... is responsible for the proper working of DBMS DBA DBMS DLL None of Them None Q 28 : DBA is responsible for Schema Definition Granting Data Access Routine Maintenance All of them None Q 30 : DBA is Data Base Manager Data Base Accessor Data Base Administrator None of Them None Q 32 : Characteristics of Data Processing Includes Transection Support Accessible Catalog Integrity Services All of Them None Q 31 : DBA has to monitor Disk Space Running Jobs Both A & B None of Them None Q 33: Important Function of DBMS are User Management Data Management Both A & B None of Them None Q 37 : ......... Consist of single process and describe single system Detail Diagram Context Diagram Level 0 Diagram None of Them None Q 38 : ER Data Model support following major constructs Entity Attribute Relation Ship All of Them None Q 35 : DFD are focused on Flow of Information Flow of Data Expressing Decision Points None of Them None Q 36 : Types of DFD Context Diagram Level 0 Diagram Datail Diagram ALL of Them None Q 39 : An Entity whose instance can exists independently Strong Entity Naming Entity Week Entity None of Them None Q 34 : DFD is called Data Functionality Diagram Data Feed Diagram Data Flow Diagram None of Them None Q 40 : ............... is a set of attributes that can be used to identify entity type Lock Key Bothe A & B None of Them None 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 None 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 None Q 43. The Rectangles divided into two parts represents a) Entity set b) Relationship set c) Attributes of a relationship set d) Primary key None 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 None 42. The entity relationship set is represented in E-R diagram as a) Double diamonds b) Undivided rectangles c) Dashed lines d) Diamond None 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 None 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 None 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 None Q 48 : Weak entity set is represented as a) Underline b) Double line c) Double diamond d) Double rectangle None 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 None
