data base management system (DBMS) Practice Questions Answers Test with Solutions & More Shortcuts

Question : 36

A specialist in charge of the database of an organization select the best fit for answer

a) Database management approach

b) DBMS uses

c) Database administrator

d) Query language

Question : 37

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

Question : 38

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)

Question : 39

The table wizard

a) Quickly creates a default report

b) Displays a subset of the data in a database

c) Contains sample tables and fields you can use to create a table

d) Automatically edits your data as you enter it

Question : 40

The method of file organization in which data records in a file are arranged in a specified order according to key filed is known as the

a) Direct access method

b) Queuing method

c) Predetermined method

d) Sequential access method

e) None of these