Basics of Database Management Mock Test

1. The following term applies to a collection of related records in a database

2. The following language used by most of the DBMSs for helping their users to access data

3. This set of related data items is known as a

4. The data in a record is of the following types

5. The framework for storing records in database is a

6. The following command is used to search the record that satisfies the specified criteria

7. A treelike structure of records in a database. Select the best fit for answer

8. The largest unit of a database is

9. All of the following terms are related to computerized databases except which one?

10. Whats the best Access object for an invoice youll mail to customers?

11. Need to see all the information from two tables on one form. Insert

12. What is a Grouped Report?

13. What is the primary difference between a pivot table report and a cross tab query?

14. COPY STRUCTURE command is used to

15. The following command is used for sorting

16. What is the term to ask the computer to pt information in order numerically or alphabetically ?

17. List command is used to get

18. The term refers to a collection of related information

19. The purpose of the Add-in Manager is to

20. A field that uniquely identifies a record is called a

21. COUNT command is used to

22. Sub-schema can be used to

23. The raw facts are called

24. The following statement is not valid about indexing

25. The following devices can be used to input data into a database

26. Modules are

27. In access, the best types of queries to use for data analysis are:

28. Append from command is used to

29. To see sales amount figures totaled, into which drop area would you drag that field?

30. How can you add a table to the relationship window?

31. Which access feature do you use to develop applications that host access data on the web?

32. The ascending order of a data hierarchy ios:

33. Examples of centralized multi-user databases are

34. New record is added using

35. In a large DBMS

36. Which of the following columns can not be found in the macro design window?

37. What is the maximum character field size you can set for a field that has a text data type?

38. Which of the following fields would not make a suitable primary key ?

39. A good query system

40. APPEND command is used to

41. When you double click a query object, you open

42. A repository for data, usually covering some specific topic is called

43. How do you update Pivot Table report data after changes are made to the source data?

44. Checks that are added to databases to detect unsuitable data on inpt are called

45. A repository for data, usually covering specific topic is

46. A set of programs that handle firms data base responsibilities is called a

47. Which of the following is not a relational database?

48. How do you freeze a field a column or field in Microsoft Access?

49. A computer language for informing the DBMS regarding the data structure used is

50. The arranging of data in a logical sequence is called

Computer Science Engineering Mock Tests with Answers
Distributed Computing System Mock Test
Software Project Management Mock Test
Artificial Intelligence and Robotics Mock Test
Basics of Database Management Mock Test
C# Programming Mock Test
C#.NET Programming Mock Test
Cloud Computing Mock Test
Communication Network Mock Test
Computer Architecture Mock Test
Computer Architecture and Organization Mock Test
Computer Fundamentals Mock Test
Computer Networking Mock Test
Computer Networks Mock Test
CPP Programming Mock Test
Data Analysis Mock Test
Data Communication and Computer Network Mock Test
Data Compression and Data Retrieval Mock Test
Data Mining and Business Intelligence Mock Test
Data Mining and Data Warehouse Mock Test
Data Structure and Algorithms Mock Test
Data Structures Mock Test
DataBase Management System Mock Test
Design and Analysis of Algorithms Mock Test
Digital Electronics and Logic Design Mock Test
Digital Logic Circuits Mock Test
Digital Principles and System Design Mock Test
Discrete Mathematics Mock Test
Discrete Structure Mock Test
DotNet Technology Mock Test
Embedded Real Time Operating System Mock Test
Green Computing Mock Test
High Performance Computing Mock Test
Information Cyber Security Mock Test
Information and Network Security Mock Test
Information Retrival Techniques Mock Test
Information Systems and Engineering Economics Mock Test
Machine Learning Mock Test
Microprocessor and Interfacing Technique Mock Test
Microprocessors Mock Test
Muli core Architectures and Pro Mock Test
Multi core processors Mock Test
Network Security Mock Test
Neural Networks and Fuzzy Control
Object Oriented Programming Mock Test
Operating System Architecture Mock Test
Operating System Mock Test
Problem Solving and Python Programming Mock Test
Programming for Problem Solving Mock Test
Python Programming Mock Test
Soft Computing Mock Test
Software Design Modeling Mock Test
Software Engineering Mock Test
Software Testing Mock Test
Software Testing and Quality Assurance Mock Test
Theory of Computation and Compiler Design Mock Test
Theory of Computation Mock Test
Ubiquitous Computing System Mock Test