1. The following term applies to a collection of related records in a database Layout Files folder File Field 2. The following language used by most of the DBMSs for helping their users to access data 4GL Query language SQL High level language 3. This set of related data items is known as a None of the options Table Record File 4. The data in a record is of the following types four text fields and three numeric fields three text fields and four numeric fields None of the options two integer fields and five text fields 5. The framework for storing records in database is a Table Query Form Report 6. The following command is used to search the record that satisfies the specified criteria SEARCH FOUND GET LOCATE 7. A treelike structure of records in a database. Select the best fit for answer Relational database structure Multidimensional database structure Hierarchical database structure Sequential database access 8. The largest unit of a database is None of above A subfield A record A field 9. All of the following terms are related to computerized databases except which one? Sort Record grab Field names Search 10. Whats the best Access object for an invoice youll mail to customers? A report A table A form All of the options 11. Need to see all the information from two tables on one form. Insert A linked command button A page break None of the options A subform 12. What is a Grouped Report? None A report that displays data that has been sorted in ascending or descending order A type of report that can be generated by the Report Wizard A report that displays data grouped by fields you specify 13. What is the primary difference between a pivot table report and a cross tab query? None of above A cross tab query lets you group similar items. A pitot table report does not You cant pivot a cross tab query A pivot table report can contain sums, counts, and averages while a cross tab query cannot. 14. COPY STRUCTURE command is used to Copy structure of an active database to a new file Copy all records of an active database to disk Copy contents of an active database to disk Copy contents of an active database to a new file 15. The following command is used for sorting sort index browse list 16. What is the term to ask the computer to pt information in order numerically or alphabetically ? Report Crop Organize Sort 17. List command is used to get List of database contents List of database contents None of the options List of variables used in database file 18. The term refers to a collection of related information Database List Record Outline 19. The purpose of the Add-in Manager is to Add or remove data in an existing database All of the options Add or remove templates, macros, and wizards Create macros and automate data processing 20. A field that uniquely identifies a record is called a Main field None of above Key field Header 21. COUNT command is used to Count the records which are updated Count the number of data fields in an active database file Count the number of records in an active database file Count the number of data files which are active 22. Sub-schema can be used to Create very different, personalized views of the same data Present information in different formats All of the options Hide sensitive information by omitting fields from the subschemas description 23. The raw facts are called Responses Data Programs Commands 24. The following statement is not valid about indexing it duplicate the database file it stores the corresponding record number it stores the index fields it maintains the alphabetically order 25. The following devices can be used to input data into a database Mouse, keyboard, monitor None of the options Mouse, keyboard, touch screen Keyboard, fax roller ball 26. Modules are Group of records selection of commands used to automate repetitive tasks programs written in Visual C++ Object tabs 27. In access, the best types of queries to use for data analysis are: All of the above Action queries Select querie Parameter queries 28. Append from command is used to Adds records from a file Add records from a variable Add records from stock Add records from information in an array 29. To see sales amount figures totaled, into which drop area would you drag that field? Drop row fields here Drop data items here Drop column fields here None of the options 30. How can you add a table to the relationship window? Select Tools>Add table from the menu Click the show table button on the toolbar Select Edit>Add table from the menu Select the table from the table list on the toolbar 31. Which access feature do you use to develop applications that host access data on the web? None of the options Dynamic web data Data access pates Html data pages 32. The ascending order of a data hierarchy ios: Byte, bit, field, record, file, database Bit, byte, field, record, file, database Bit, byte, record, field, file, database Byte, bit, record, field, file, database 33. Examples of centralized multi-user databases are Supermarket stock control, organ donor database, client database None of above Airline reservations and other national global booking systems Barclays Bank customer accounts 34. New record is added using Append record from browse menu Add record from edit menu Append record into from browse menu All of the options 35. In a large DBMS each user can access every subschema None of the options is true each user can see' only a small part of the entire database each subschema contains every field in the logical schema 36. Which of the following columns can not be found in the macro design window? Conditions column Arguments column Actions column Comment column 37. What is the maximum character field size you can set for a field that has a text data type? 64 255 All of the options 512 38. Which of the following fields would not make a suitable primary key ? A customers social security number An autoNumber field An invoice number A date field 39. A good query system All options Can be accessed only by data pressing professionals Allows non-programmers to access information stored in a database Can accept English language commands 40. APPEND command is used to Add Record to the start of active database file Add record to the end of active database file and starts full screen data entry Add record to the start of active database file and starts full screen data entry Add record to the end of database file 41. When you double click a query object, you open The object in print preview The underlying table on which the query is based The object in design view The result of the query 42. A repository for data, usually covering some specific topic is called Real time Data bank Data acquisition Database 43. How do you update Pivot Table report data after changes are made to the source data? Save your changes, close the workbook, and then reopen it. Select the Pivot Table worksheet and press F9 on the keyboard All of the options Click the report, and on the Pivot Table toolbar, click the refresh data button 44. Checks that are added to databases to detect unsuitable data on inpt are called verification validation none of above vegetation 45. A repository for data, usually covering specific topic is Data requisition Database Data bank Data collection 46. A set of programs that handle firms data base responsibilities is called a Data Management System (DMS) All of the options Database Management System (DBMS) Database Processing System (DBPS) 47. Which of the following is not a relational database? FoxPro dBase IV Reflex 4th Dimension 48. How do you freeze a field a column or field in Microsoft Access? Click anywhere in the column and click the freeze button on the toolbar Place an ice cube in the column Click anywhere in the column and select Edit>Freeze Column form the menu Right click the column and select freeze columns from the shortcut menu 49. A computer language for informing the DBMS regarding the data structure used is PASCAL FORTRAN PROLOG DDL 50. The arranging of data in a logical sequence is called Sorting Summarizing Classifying Reproducing Submit Answers Retake Test More Computer Science Engineering Study Material › Computer Science Engineering Mock Tests with Answers Distributed Computing System Mock Test Software Project Management Mock TestArtificial Intelligence and Robotics Mock TestBasics of Database Management Mock TestC# Programming Mock TestC#.NET Programming Mock TestCloud Computing Mock TestCommunication Network Mock TestComputer Architecture Mock TestComputer Architecture and Organization Mock TestComputer Fundamentals Mock TestComputer Networking Mock TestComputer Networks Mock TestCPP Programming Mock TestData Analysis Mock TestData Communication and Computer Network Mock TestData Compression and Data Retrieval Mock TestData Mining and Business Intelligence Mock TestData Mining and Data Warehouse Mock TestData Structure and Algorithms Mock TestData Structures Mock TestDataBase Management System Mock TestDesign and Analysis of Algorithms Mock TestDigital Electronics and Logic Design Mock TestDigital Logic Circuits Mock TestDigital Principles and System Design Mock TestDiscrete Mathematics Mock TestDiscrete Structure Mock TestDotNet Technology Mock TestEmbedded Real Time Operating System Mock TestGreen Computing Mock TestHigh Performance Computing Mock TestInformation Cyber Security Mock TestInformation and Network Security Mock TestInformation Retrival Techniques Mock TestInformation Systems and Engineering Economics Mock TestMachine Learning Mock TestMicroprocessor and Interfacing Technique Mock TestMicroprocessors Mock TestMuli core Architectures and Pro Mock TestMulti core processors Mock TestNetwork Security Mock TestNeural Networks and Fuzzy Control Object Oriented Programming Mock TestOperating System Architecture Mock TestOperating System Mock TestProblem Solving and Python Programming Mock TestProgramming for Problem Solving Mock TestPython Programming Mock TestSoft Computing Mock TestSoftware Design Modeling Mock TestSoftware Engineering Mock TestSoftware Testing Mock TestSoftware Testing and Quality Assurance Mock TestTheory of Computation and Compiler Design Mock TestTheory of Computation Mock TestUbiquitous Computing System Mock Test Computer Science Engineering Mock Tests