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