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