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

Question : 1

__________ increase the accuracy of a search by fine-tuning the keywords in the search.

a) Indexes

b) Italics

c) Compounds

d) Links

e) Operators

Question : 2

Which of the following contains permanent data and gets updated during the processing of transactions?

a) Operating System File

b) Transaction file

c) Software File

d) Master file

e) None of these

Question : 3

A DBMS that combines a DBMS and an application generator is ________ .

a) Microsoft’s SQL Server

b) Microsoft’s Access

c) IBM’s DB2

d) Oracle Corporation’s Oracle

e) None of these

Question : 4

What happens when you add the asterisk (() from any field list of 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

Question : 5

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 : 6

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