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

Question : 1

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

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

_________ is used by public and private enterprises to publish and share financial information with each other and industry analysts across all computer platforms and the Internet.

a) Extensible Markup Language (EML)

b) Extensible Business Reporting Language (XBRL)

c) Enterprise Application Integration (EAI)

d) Sales Force Automation (SFA) software

e) None of these

Question : 4

How many options does a binary choice offer?

a) One

b) Two

c) Three

d) It depends on the amount of memory in the computer

e) None of the above

Question : 5

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

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