Practice Test

Q1) The most widely supported standard database language is ________ which has been developed for the relational model. Show Answer

Q2) A ___________ is a person responsible for the design, operation, maintenance and restoration of an organization's database. Show Answer

Q3) In the relational database, the method of organizing database relations to decrease redundancy is called __________. Show Answer

Q4) _____________ is a process of representing the essential features without including implementation details. Show Answer

Q5) In computing, a ____________ is a database used for reporting. Show Answer

Q6) ____________ the extraction of hidden predictive information from large database, is a powerful new technology with great potential to analyze important information in data warehouse. Show Answer

Q7) In weather forecasting, __________ process used to predict reliable information about the current state of the atmosphere with the help of collected quantitative data. Show Answer

Q8) _________ is a technique in which a computer program extracts data from human-readable output coming from another program. Show Answer

Q9) A __________ is an integrated collection of database records, files, and other database objects. Show Answer

Q10) Database management system (DBMS) are designed to use one of _________ database structure to provide unsophisticated access to information stored in databases. Show Answer

Q11) Which of the following are the application of DBMS?
(i) In Universities: For student information, course details and grades.
(ii) In Airlines: For reservation and schedule information.
(iii) In credit card transactions: For purchase on credit cards and generation of monthly statements.
(iv) In Human resources: For information about employees, salaries, payroll taxes, benefits and for generation of paychecks.
(v) In Banking: For customer information, accounts, and banking transactions. Show Answer

Q12) __________ is a relational database management system that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. Show Answer

Q13) ___________ is the process of moving / copying and restructuring data from an existing system to the ERP system. Show Answer

Q14) ___________ is a widely-implemented strategy for managing a company interaction with customers clients and sales prospectus Show Answer

Q15) __________ is helps to design, planning, execution, control, and monitoring of supply chain activities with the object of creating net value, leveraging worldwide logistics, synchronizing supply with demand and measuring performance globally. Show Answer

Q16) _____________ is the access layer of the data warehouse (DW) environment that is used to get data out to the users. Show Answer

Q17) OLAP stands for _________ Show Answer

Q18) A ___________ is a computer program whose primary purpose is entering and retrieving information from a computer-managed database. Show Answer

Q19) Today's most widely used social networking site Facebook, which was built on top of ____________ Show Answer

Q20) An ___________ is a database management system in which information is represented in the form of objects-oriented programming. Show Answer

Q21) A _____________ is a database management system (DBMS) that is based on the relational model . Show Answer

Q22) A / An ___________ is a database designed to integrate data from multiple sources for additional operation on the data. Show Answer

Q23) ___________ is the process of abstracting, transforming, federating and delivering data contained within a variety of information sources. Show Answer

Q24) __________ involves combining data residing in different sources and providing users with a unified view of these data. Show Answer

Q25) __________ is the theoretical foundation of a database and fundamentally determines in which manner data can be stored, organized, and manipulated in a database system Show Answer

Q26) Main memory contains ? Show Answer

Q27) Computing systems can be effective in generating strategic information because Show Answer

Q28) For the purposes of defining data needs, a responsibility area is Show Answer

Q29) Data systems for planning are often called Show Answer

Q30) The product of data processing is Show Answer

Q31) Which computer memory is used for storing programs and data currently being processed by the CPU ? Show Answer

Q32) Often computers users have information in two different files which they want to combine in one common file. When the two files are combined on after the other and end to end it is called Show Answer

Q33) The model base would most likely be organized Show Answer

Q34) The principal advantage of the centralized approach to organizing a computer facility is Show Answer

Q35) The retrieval of information from the computer is defined as Show Answer

Q36) Data system management has long-term viability as a separate business function because Show Answer

Q37) To be information, data must be Show Answer

Q38) Data entry can be performed with all of the following except Show Answer

Q39) Data management systems may be implemented as Show Answer

Q40) A data system for calculating measures used in statistical inference is an example of a Show Answer

Q41) Which of the following storage and retrieval methods would be well suited to your processing requirements if you only need to retrieve records one at a time and there is no fixed pattern to requests for data and records? Show Answer

Q42) Currently the most popular form of secondary storage is Show Answer

Q43) Which of the following fields in a student file can be used as a primary key? Show Answer

Q44) The two basic types of record-access methods are Show Answer

Q45) Data processing is Show Answer

Q46) The processing capability of a microcomputer can be enhannced with the help of Show Answer

Q47) Which of the following is not a practical data-processing approach ? Show Answer

Q48) The temporary or volatile memory of a computer is erased when the computer is turned off. Accordingly, the computer user before turning off the machine must transfer anything in the memory which is important to Show Answer

Q49) The arranging of data in a logical sequence is called Show Answer

Q50) Where have the program and data to be located before the ALU and control unit of a computer can operate on it ? Show Answer

Q51) What is the fundamental unit of storage in digital computers ? Show Answer

Q52) The microprocessor of a computer cannot operate on any information if that information is not in its Show Answer

Q53) In some computer applications, the data is processed almost simultaneously as it is generated. What is this processing called? Show Answer

Q54) The computer stores its program and data in its Show Answer

Q55) The word size of a microprocessor refers to Show Answer

Q56) What are the typical operations in Memory Management? Show Answer

Q57) The memory management scheme which allows the execution of a process which is partially loaded into physical memory is Show Answer

Q58) The operating system groups all information that it needs about a particular process into a data structure is known as Show Answer

Q59) Operating system commands are statement written in _____. Show Answer

Q60) A transition between two memory-resident process in a multiprogramming system is called a Show Answer

Q61) Wasting of memory within a partition, due to a difference in size of a partition and of the object resident within it, is known as Show Answer

Q62) Fragmentation problem in memory management is caused by creation of Show Answer

Q63) In fragmentation, affected process must be suspended and actually copied from one area of memory into another, it is important to decide when and how this process called .........is to be performed Show Answer

Q64) Virtual memory is a memory-management scheme where only a portion of the virtual address space of a resident process may actually be loaded into ....... Show Answer

Q65) Virtual memory system provide the automatic migration of portions of address spaces between ........ and ........ Show Answer

Q66) Which scheduling policy is most suitable for a time-shared operating system ? Show Answer

Q67) A program that generally has more user friendly interface than a DBMS is called a Show Answer

Q68) The full form of DBMS is Show Answer

Q69) Where does a computer add and compare data? Show Answer

Q70) A data warehouse is which of the following- Show Answer

Q71) The issues that deal with the collection and use of data about individuals is Show Answer

Q72) How do businesses protect their databases? Show Answer

Q73) The main purpose(s) of a database management program is to- Show Answer

Q74) Reusable optical storage will typically have the acronym Show Answer