data base management system (DBMS) set 4 Detailed Explanation And More Example

Question : 1

The number of logical records in a physical record is

a) group

b) blocking factor

c) sector

d) field

Question : 2

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

Question : 3

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

Question : 4

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 Pivot Table report to be filtered

c) It displays a title for the Pivot Table report

d) None of the above

Question : 5

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

a) Arguments column

b) Comment column

c) Conditions column

d) Actions column

Question : 6

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

a) Hierarchical database structure

b) Relational database structure

c) Multidimensional database structure

d) Sequential database access