Database Management System – Set 5 January 28, 2025 by aasi 0% Report a question What’s wrong with this question? You cannot submit an empty report. Please add some details. 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 Database Management System – Set 5 Dear ! This is Database Management System – Set 5 Quiz and it contains 50 questions. Keep Learning! 1 / 50 1) A set of tools to help application developers to complete software development quickly and accurately is CAD CAM CASE CIM 2 / 50 2) In a relational database , this is a data structure that organizes the information about a single topic into rows and columns block record tuple table 3 / 50 3) A Database Management System (DBMS) may be used by , or combined with , this type of transaction manager DB2 CICS Oracle Cognos 4 / 50 4) When data changes in multiple lists & all lists are not updated , this causes ; data redundancy information overload duplicate data data inconsistency 5 / 50 5) Encapsulation , types , classes , inheritance , overriding combined with late binding and extensibility are all features of this type of database Multidimensional database relational database object-oriented open source 6 / 50 6) Overall design of database is called ……. Structure Architect Schema Layer 7 / 50 7) ………….. is a collection of logically related records and files Folder Application Database Field 8 / 50 8) A file containing relatively permanent data is —- master file random file sequential file None 9 / 50 9) In MIS , SDLC stands for …….. Software Development Labour Cost Software Development Life Cycle System Development Labour cost System development Life Cycle 10 / 50 10) Lowest level of schema in a database is physical schema Logical schema subschema None of these 11 / 50 11) ………….. is an interface between users and the various databases Application programmers DB Administers DBMS All of these 12 / 50 12) A program tool allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report. pivot table PERT chart quad tree ODBC 13 / 50 13) Analyzing data from different sources and perspectives and summarizing it into useful information is Data Warehousing Data Mining Data Digging Data Banking 14 / 50 14) Restructuring and transforming a business process by a fundamental rethink and redesign to achieve dramatic improvement in cost , quality etc ………… Automation Business process Reengineering ERP Modernization 15 / 50 15) Which of the following is an object in MS Access Query Forms Report Any of these 16 / 50 16) In ………. models data are connected in the form of table Hierarchical database Network database Relational database None of these 17 / 50 17) A system which record and reports business transactions , flow of funds and generate financial statements is ……….. Management Information system Financial information system Accounting Information system Executive information system 18 / 50 18) In DBMS …… ensures the validity of the relationship between two table remain intact Referential integrity primary key Relation Tuple 19 / 50 19) A system of creating , delivering and receiving electronic message is …………. Information system Communication system Electronic system Any of these 20 / 50 20) Information currently stored in the database is called ………… Instance Record Data Files 21 / 50 21) ………..means “data about data” Processed data Mined data Meta data Mega data 22 / 50 22) In Ms Access , action can be automated by using ……….. Arguments Macro Query All of these 23 / 50 23) A system that stores , retrieves , manages or otherwise manipulates a massive amounts of data from organization’s database and external sources . Data mining Data banking DBMS Data warehousing 24 / 50 24) A software package to implement a data base is — system analysis dBMS DASD File system 25 / 50 25) Questions can be raised in Ms Access by using ……………… Queries Form Report Find 26 / 50 26) The activity of keeping a database up to date by adding , changing or deleting data Data updating Data control Data banking Data maintenance 27 / 50 27) A table in a relational database is known as Field Record Entity Relation 28 / 50 28) This is the job title of someone who directs or performs all activities related to maintaining a successful database environment . DBA MOLAP PHP RFC 29 / 50 29) In MS Access rows are technically called …………. Record Attributes Tuples Field 30 / 50 30) Controls that are used to prevent incorrect data from being entered into database Data administration Data validation Data Data warehousing 31 / 50 31) This is a type of program that lets one or more computer users create , manage and access data in a database. B2B DBMS multidimensional database None 32 / 50 32) Highest level of schema in a database is physical schema Logical schema Subschema None of these 33 / 50 33) The automatic transfer and positioning of work by machine without significant human intervention or operation is ……… Updating Automation Computerization Mechanization 34 / 50 34) The ——- contains data descriptions & defines the name , data type , & length of each of field in the database . data dictionary data table data record data field 35 / 50 35) Which of the following is/are file organization type ? pile Sequential Indexed All of these 36 / 50 36) This is a central repository for all or significant parts of the data that an enterprise’s various business system collect . data warehouse business information warehouse knowledge warehouse None 37 / 50 37) Data storage in MS Access is as ……………… Table Diagram Chart Commands 38 / 50 38) Information currently stored in the database is called ………… Instance Record Data Files 39 / 50 39) In DBMS … is a field or combination of field that uniquely identify each record in a table Referential integrity primary key Relation Tuple 40 / 50 40) which of the following tree structures is unique in that the tree organization varies depending on which nodes are most frequently accessed ? B-tree binary tree quad tree splay tree 41 / 50 41) ……….. gives information about information schema Data Dictionary DML DDL 42 / 50 42) MIS professional responsible for planning , designing and maintaining database is Application programmers DB manage Database Administrators All of these 43 / 50 43) A primary key which is appeared in related tables is known as ……. of related or secondary table Super key Candidate key Foreign key Alternate key 44 / 50 44) MS Access is a …………… application Spreadsheet Word Slide presentation DBMS 45 / 50 45) An information system within business organisation that support the traditional functions such as marketing , finance or production is ……….. MIS BIS FIS EIS 46 / 50 46) The purpose of the primary key in a database is to ….. unlock the database provide a map of the data uniquely identify a record none 47 / 50 47) DBMS is a collection of …………. Hardware and Software Hardware only Software only Hardware , software , human ware 48 / 50 48) In MS Access columns are technically called ……….. Record Attributes Tuples Field 49 / 50 49) ………….. is an interface between users and the various database Application programmers DB Administers DBMS All of these 50 / 50 50) Which of the following is/are components of DBMS DML DDL Data dictionary All of these Your score isThe average score is 0%🎉 Challenge alert! 💡 Share this quiz with your friends and see who scores the highest! 🏆🤩🔥 LinkedIn Facebook Follow Us @ 0% Restart quiz Exit We’d love to hear your thoughts! 📝 Share your valuable review with us. 🙌 🌟 Thank you for your support! Your feedback means the world to us. 🙏💖 Send feedback
