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

A. Data acquisition

B. Data bank

C. Real time

D. Database

Correct : B. Data bank

2. A notation for defining the form and structure of data is known as

A. Data description language

B. Binary language

C. Data channels

D. Data definition language

Correct : D. Data definition language

3. A data item, which is not broken down into smaller units, is

A. Data element

B. Elementary data item

C. Data entry

D. Database management

Correct : B. Elementary data item

4. Which of the following terms refers to the degree to which data in database system are accurate and correct?

A. Data security

B. Data validaity

C. Data independence

D. Data integrity

Correct : D. Data integrity

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

A. Database

B. Data requisition

C. Data bank

D. Data collection

Correct : C. Data bank

6. A set of programs that handle firm’s data base responsibilities is called a

A. Database Management System (DBMS)

B. Database Processing System (DBPS)

C. Data Management System (DMS)

D. All of above

Correct : D. All of above

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

A. dBase IV

B. 4th Dimension

C. FoxPro

D. Reflex

Correct : D. Reflex

8. Which is used to provide the sight information to the right person at the right time for proper decision making ?

A. DBMS

B. MIS

C. ISO

D. PSO

Correct : B. MIS

9. Dbase-III was developed by

A. Dec

B. IBM

C. Ashton-tate

D. All of the above

Correct : C. Ashton-tate

10. Which of the following database objects asks a question of information in a database and then displays the result?

A. Tables

B. Reports

C. Queries

D. Forms

Correct : C. Queries

11. What data type should you choose for a zip code field in a table?

A. Text

B. Number

C. Memo

D. All of above

Correct : A. Text

12. A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be

A. The pin code

B. The last name

C. A compound key consisting of the first name and the last name

D. All of the above

Correct : C. A compound key consisting of the first name and the last name

13. What happens when you add the asterisk (() from any field list ot a query?

A. The table will not include any fields from the table

B. The query sorts the table’s record in the order you specify

C. The query will include every field from the table*

D. The query uses the records from the table without displaying them

Correct : C. The query will include every field from the table*

14. The modify operation is likely to be done after

A. delete

B. look up

C. insert

D. all of above

Correct : B. look up

15. The criteria BETWEEN 1/1/99 and 12/31/99 would which is proper

A. Display records between the dates 1/2/ 99 and 1/1/00

B. Display records between the dates 1/1/ 99 and 12/31/99

C. Display records whose dates equaled 1/1/99 or 12/31/99

D. All of the above

Correct : B. Display records between the dates 1/1/ 99 and 12/31/99

16. DDP stands for

A. Distributed Double Processing

B. Double Decimal Processing

C. Distributed Data Programming

D. Distributed Data Processing

Correct : D. Distributed Data Processing

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

A. Drop column fields here

B. Drop row fields here

C. Drop data items here

D. None of the above

Correct : C. Drop data items here

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

A. Dynamic web data

B. Data access pates

C. Html data pages

D. None of the above

Correct : B. Data access pates

19. What is the common name for a column of data within an Access table?

A. Field

B. Record

C. Row

D. None of the above

Correct : A. Field

20. A data structure consisting of several fields, some or all of which are instances of the same data structure, is called

A. Field

B. Bead

C. Database

D. Data collection

Correct : B. Bead

21. A group of characters used to identiry a given low level instruction is

A. File

B. Record

C. Key field

D. Label

Correct : D. Label

22. One or more characters used to identify a data field in a computer program is

A. File name

B. Database

C. Label

D. Group

Correct : C. Label

23. In Form view, which command displays records alphabetically?

A. Find

B. Advanced Filter/Sort

C. Sort

D. All of the above

Correct : C. Sort

24. Where do report and forms get their information form?

A. Forms

B. Modules

C. Tables

D. Queries

Correct : C. Tables

25. The number of logical records in a physical record is

A. group

B. blocking factor

C. sector

D. field

Correct : D. field

26. A top to bottom relationship among the items in a database is established by a

A. Hierarchical schema

B. Network Schema

C. Relational schema

D. All of the above

Correct : A. Hierarchical schema

27. A command that lets you cange one or more fields in a record is

A. Insert

B. Modify

C. Look up

D. All of the above

Correct : B. Modify

28. A logical schema

A. Is the entire database

B. Is a standard way of organizing information into accessible parts

C. Describes how data is actually stored on disk

D. All of the above

Correct : B. Is a standard way of organizing information into accessible parts

29. What is the purpose of the page field on a pivot table report?

A. It creates a new page for each type of data

B. It allows the data within the the Pivot Table report to be filtered

C. It displays a title for the Pivot Table report

D. None of the above

Correct : B. It allows the data within the the Pivot Table report to be filtered

30. What does the Special Effect button on the formatting toolbar do?

A. It lets you add animation to your forms and reports to make them more entertaining and amusing

B. It lets you select a transitional effect for how a form opens and closes.

C. It applies a 30d effect to a selected control

D. None of these

Correct : C. It applies a 30d effect to a selected control

31. Pivot Table report data must meet which of the following criteria?

A. It must be in tabular form, have unique column labels, and each row must represent a unique piece of data

B. Any dates should be formatted with the data format and blank rows or columns should be removed

C. It must be in tabular form, have unique column lagels, and all rows must be sorted

D. Both (A) and (B)

Correct : D. Both (A) and (B)

32. Customers, Orders. What’s their best relationship?

A. Many-to-many

B. One-to-one

C. One-to-many

D. All of the above

Correct : C. One-to-many

33. Which control does access use to link data access page components to access data?

A. Microsoft Dynamic Data Control

B. Microsoft Data Connection Control

C. Microsoft Office Data Source Control

D. None of the above

Correct : C. Microsoft Office Data Source Control

34. Which program do you use to edit code for data access pages?

A. Microsoft script editor

B. Microsoft code editor

C. Microsoft data access pages editor

D. None of above

Correct : A. Microsoft script editor

35. The way a particular application views the data from the database that the applicaton uses is a

A. Module

B. Relational model

C. Schema

D. Sub-schema

Correct : D. Sub-schema

36. Which of the following is a database management system?

A. Ms-Word

B. Lotus 1-2-3

C. Oracle

D. None of above

Correct : C. Oracle

37. What is the corresponding text for the <#1/1/ 95# validation rule setting?

A. Neter a value less or more than 1,195

B. Value must be less than 95 characters

C. Enter a date before 1995

D. All of above

Correct : A. Neter a value less or more than 1,195

38. What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library’s available objects and members?

A. Object Viewer

B. Object Browser

C. Type Library Spy

D. None of above

Correct : B. Object Browser

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

A. PASCAL

B. DDL

C. PROLOG

D. FORTRAN

Correct : B. DDL

40. Which of the following is not a data type ?

A. Picture/graphic

B. Data/time

C. Texst

D. Number

Correct : A. Picture/graphic

41. The executive responsible for the data processing function in an organization is

A. PM

B. DBMS

C. DP

D. DPM

Correct : B. DBMS

42. Which of the following is NOT a type of Microsoft Access database object?

A. Queries

B. Workbooks

C. Forms

D. Tables

Correct : B. Workbooks

43. A file containing relatively permanent data is

A. Random file

B. Transaction file

C. Master file

D. Sequential file

Correct : C. Master file

44. The complete picture of data stored in database is known as

A. Record

B. Scheme

C. System flowchart

D. DBMS

Correct : B. Scheme

45. A subset of characters within a data field is known as

A. Record

B. File

C. Data string

D. Byte

Correct : C. Data string

46. Data items groped together for storage purposes are called a

A. Record

B. Title

C. List

D. string

Correct : A. Record

47. Which of the following terms does not describe a database structure used by a DBMS to link data from several files?

A. Relational

B. Structural

C. Network

D. All of the above

Correct : B. Structural

48. In a relational schema, each tuple is divided into fields called

A. Relations

B. Domains

C. Queries

D. All of the above

Correct : B. Domains

49. How do you filter by selection?

A. Right click the field value and select filter by selection from the shortcut menu

B. Find and double click the value on which you want to base the filter

C. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu

D. None of the above

Correct : A. Right click the field value and select filter by selection from the shortcut menu

50. What is a fast way to adjust the width of a column?

A. Right click the left side of the column heading

B. Double click the left side of the column heading

C. Double click the right side of the column heading

D. Select tools>adjust column width from the menu

Correct : C. Double click the right side of the column heading

51. What are the columns in a Microsoft Access table called?

A. Rows

B. Fields

C. Cells

D. Records

Correct : B. Fields

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

A. Save your changes, close the workbook, and then reopen it.

B. Select the Pivot Table worksheet and press F9 on the keyboard

C. Click the report, and on the Pivot Table toolbar, click the refresh data button

D. All of the above

Correct : C. Click the report, and on the Pivot Table toolbar, click the refresh data button

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

A. Select querie

B. Parameter queries

C. Action queries

D. All of the above

Correct : A. Select querie

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

A. Select Tools>Add table from the menu

B. Select the table from the table list on the toolbar

C. Click the show table button on the toolbar

D. Select Edit>Add table from the menu

Correct : B. Select the table from the table list on the toolbar

55. What is the first step in creating a form or report with the form wizard or report wizard?

A. Selecting the fields that you want to appear in the form or report

B. Selecting the underlying table or query on which you want to base the form or report

C. Reading several screens of mostly useless information and clicking next

D. Selecting how the form or report should be formatted

Correct : B. Selecting the underlying table or query on which you want to base the form or report

56. Which action will optimize your database performance?

A. Set the record set type to Snapshot

B. Use the compact and repair database tool

C. Create a replica of the database

D. All of the above

Correct : B. Use the compact and repair database tool

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

A. Sorting

B. Classifying

C. Reproducing

D. Summarizing

Correct : A. Sorting

58. If a piece of data is stored in two places in the database, then a

A. Storage space is wasted

B. Changing the data is one spot will cause data inconsistency

C. It can be more easily accessed

D. Both (A) and (B)

Correct : D. Both (A) and (B)

59. A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file? As

A. Tables

B. Relations

C. Tuple

D. Both (A) and (B)

Correct : D. Both (A) and (B)

Quiznetik

Basics of Database Management System (DBMS) | Set 2

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

2. A notation for defining the form and structure of data is known as

3. A data item, which is not broken down into smaller units, is

4. Which of the following terms refers to the degree to which data in database system are accurate and correct?

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

6. A set of programs that handle firm’s data base responsibilities is called a

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

8. Which is used to provide the sight information to the right person at the right time for proper decision making ?

9. Dbase-III was developed by

10. Which of the following database objects asks a question of information in a database and then displays the result?

11. What data type should you choose for a zip code field in a table?

12. A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be

13. What happens when you add the asterisk (() from any field list ot a query?

14. The modify operation is likely to be done after

15. The criteria BETWEEN 1/1/99 and 12/31/99 would which is proper

16. DDP stands for

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

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

19. What is the common name for a column of data within an Access table?

20. A data structure consisting of several fields, some or all of which are instances of the same data structure, is called

21. A group of characters used to identiry a given low level instruction is

22. One or more characters used to identify a data field in a computer program is

23. In Form view, which command displays records alphabetically?

24. Where do report and forms get their information form?

25. The number of logical records in a physical record is

26. A top to bottom relationship among the items in a database is established by a

27. A command that lets you cange one or more fields in a record is

28. A logical schema

29. What is the purpose of the page field on a pivot table report?

30. What does the Special Effect button on the formatting toolbar do?

31. Pivot Table report data must meet which of the following criteria?

32. Customers, Orders. What’s their best relationship?

33. Which control does access use to link data access page components to access data?

34. Which program do you use to edit code for data access pages?

35. The way a particular application views the data from the database that the applicaton uses is a

36. Which of the following is a database management system?

37. What is the corresponding text for the <#1/1/ 95# validation rule setting?

38. What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library’s available objects and members?

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

40. Which of the following is not a data type ?

41. The executive responsible for the data processing function in an organization is

42. Which of the following is NOT a type of Microsoft Access database object?

43. A file containing relatively permanent data is

44. The complete picture of data stored in database is known as

45. A subset of characters within a data field is known as

46. Data items groped together for storage purposes are called a

47. Which of the following terms does not describe a database structure used by a DBMS to link data from several files?

48. In a relational schema, each tuple is divided into fields called

49. How do you filter by selection?

50. What is a fast way to adjust the width of a column?

51. What are the columns in a Microsoft Access table called?

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

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

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

55. What is the first step in creating a form or report with the form wizard or report wizard?

56. Which action will optimize your database performance?

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

58. If a piece of data is stored in two places in the database, then a

59. A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file? As