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