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) 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 2 / 50 2) 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 3 / 50 3) 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 4 / 50 4) 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 5 / 50 5) 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 6 / 50 6) 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 7 / 50 7) 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 8 / 50 8) When data changes in multiple lists & all lists are not updated , this causes ; data redundancy information overload duplicate data data inconsistency 9 / 50 9) In DBMS …… ensures the validity of the relationship between two table remain intact Referential integrity primary key Relation Tuple 10 / 50 10) Analyzing data from different sources and perspectives and summarizing it into useful information is Data Warehousing Data Mining Data Digging Data Banking 11 / 50 11) Overall design of database is called ……. Structure Architect Schema Layer 12 / 50 12) In MS Access rows are technically called …………. Record Attributes Tuples Field 13 / 50 13) Controls that are used to prevent incorrect data from being entered into database Data administration Data validation Data Data warehousing 14 / 50 14) ………..means “data about data” Processed data Mined data Meta data Mega data 15 / 50 15) A Database Management System (DBMS) may be used by , or combined with , this type of transaction manager DB2 CICS Oracle Cognos 16 / 50 16) A table in a relational database is known as Field Record Entity Relation 17 / 50 17) 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 18 / 50 18) In DBMS … is a field or combination of field that uniquely identify each record in a table Referential integrity primary key Relation Tuple 19 / 50 19) 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 20 / 50 20) MS Access is a …………… application Spreadsheet Word Slide presentation DBMS 21 / 50 21) ……….. gives information about information schema Data Dictionary DML DDL 22 / 50 22) In ………. models data are connected in the form of table Hierarchical database Network database Relational database None of these 23 / 50 23) Which of the following is an object in MS Access Query Forms Report Any of these 24 / 50 24) DBMS is a collection of …………. Hardware and Software Hardware only Software only Hardware , software , human ware 25 / 50 25) MIS professional responsible for planning , designing and maintaining database is Application programmers DB manage Database Administrators All of these 26 / 50 26) 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 27 / 50 27) An information system within business organisation that support the traditional functions such as marketing , finance or production is ……….. MIS BIS FIS EIS 28 / 50 28) Which of the following is/are components of DBMS DML DDL Data dictionary All of these 29 / 50 29) In MIS , SDLC stands for …….. Software Development Labour Cost Software Development Life Cycle System Development Labour cost System development Life Cycle 30 / 50 30) ………….. is a collection of logically related records and files Folder Application Database Field 31 / 50 31) The automatic transfer and positioning of work by machine without significant human intervention or operation is ……… Updating Automation Computerization Mechanization 32 / 50 32) ………….. is an interface between users and the various databases Application programmers DB Administers DBMS All of these 33 / 50 33) Lowest level of schema in a database is physical schema Logical schema subschema None of these 34 / 50 34) A set of tools to help application developers to complete software development quickly and accurately is CAD CAM CASE CIM 35 / 50 35) In MS Access columns are technically called ……….. Record Attributes Tuples Field 36 / 50 36) 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 37 / 50 37) ………….. is an interface between users and the various database Application programmers DB Administers DBMS All of these 38 / 50 38) Which of the following is/are file organization type ? pile Sequential Indexed All of these 39 / 50 39) 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 40 / 50 40) Highest level of schema in a database is physical schema Logical schema Subschema None of these 41 / 50 41) Information currently stored in the database is called ………… Instance Record Data Files 42 / 50 42) Information currently stored in the database is called ………… Instance Record Data Files 43 / 50 43) In Ms Access , action can be automated by using ……….. Arguments Macro Query All of these 44 / 50 44) The activity of keeping a database up to date by adding , changing or deleting data Data updating Data control Data banking Data maintenance 45 / 50 45) This is the job title of someone who directs or performs all activities related to maintaining a successful database environment . DBA MOLAP PHP RFC 46 / 50 46) A file containing relatively permanent data is —- master file random file sequential file None 47 / 50 47) Data storage in MS Access is as ……………… Table Diagram Chart Commands 48 / 50 48) Questions can be raised in Ms Access by using ……………… Queries Form Report Find 49 / 50 49) A software package to implement a data base is — system analysis dBMS DASD File system 50 / 50 50) A system of creating , delivering and receiving electronic message is …………. Information system Communication system Electronic system Any 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
