R4RIN – MCQs, Mock Tests | Data Base Management System (DBMS) Basics of Database Management System (DBMS) Set 2

It Is used to build and modify database objects and also to create new queries B. C. D.

1. Datasheet view
2. Design view
3. Print preview
4. Layout preview

✅ Correct Answer: 3

It shows the appearance and layout of a report, table or form in order to confirm what will be printed.

1. Datasheet view
2. Design view
3. Print preview
4. Layout preview

✅ Correct Answer: 2

It examines a small portion or sample of your data in a report before printing it.

1. Datasheet view
2. Design view
3. Print preview
4. Layout preview

✅ Correct Answer: 4

A report form

1. Appears on the computer monitor during data entry
2. Is used during report generation to format data
3. both (a) and (b)
4. All of the above

✅ Correct Answer: 2

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

1. Arguments column
2. Comment column
3. Conditions column
4. Actions column

✅ Correct Answer: 2

The ascending order of a data hierarchy ios:

1. Bit, byte, field, record, file, database
2. Bit, byte, record, field, file, database
3. Byte, bit, field, record, file, database
4. Byte, bit, record, field, file, database

✅ Correct Answer: 4

A good query system

1. Can accept English language commands
2. Allows non-programmers to access information stored in a database
3. Can be accessed only by data prssing professionals
4. Both (A) and (B)

✅ Correct Answer: 2

How do you freeze a field a column or field in Microsoft Access?

1. Click anywhere in the column and select Edit>Freeze Column form the menu
2. Place an ice cube in the column
3. Click anywhere in the column and click the freeze button on the toolbar
4. Right click the column and select freeze columns from the shortcut menu

✅ Correct Answer: 4

Within Table Datasheet view, how can you display associated records from another table?

1. Click the expand indicator (+) next to a record
2. Double click the record.
3. Apply the filter by form command
4. None of the above

✅ Correct Answer: 1

Which of the following is not a command to find specific word or phrases in a database?

1. Click the find button on the toolbar
2. Click the find button on the record navigation button area
3. Press Ctrl+F
4. Select Edit>Find from the menu.

✅ Correct Answer: 2

One of the type libraries that you can use to programmatically connect to Microsoft Access data is

1. Collaborative Data Objects
2. ActiveX Data Objects
3. Dynamic Data Interfaces
4. None of the above

✅ Correct Answer: 2

The data in a Pivot Table report is categorized using

1. Column headings
2. Items from the Pivot Table field list
3. Header rows
4. All of the above

✅ Correct Answer: 2

Records are deleted using

1. DELETE command followed by pack
2. DELETE command without pack
3. DELETE command followed by zap
4. DELETE command without zap

✅ Correct Answer: 1

You can enter data in a table in

1. design view
2. datasheet view
3. format view
4. None of the above

✅ Correct Answer: 3

Creating a data file means

1. Designing base and defining the structure of the database
2. Getting the information about database
3. Selecting data from database
4. Deleting data from database

✅ Correct Answer: 1

You want to keep track of addresses, phone numbers, parent/guardian names as well as class attendance, average and grades. Every so often you want to send reports home that select failing grades and excessive absences. The following of the Microsoft Office suit used in this course is best suited for this kind of information

1. Excel
2. PowerPoint
3. Access
4. Word

✅ Correct Answer: 1

Each individual data items of record is called a

1. Field
2. Data type
3. Comment
4. All of the above

✅ Correct Answer: 2

A large collections of files are called

1. Fields
2. Records
3. Databases
4. File system

✅ Correct Answer: 2

Memo field in database file is used to

1. Store lengthy number
2. Store images
3. Store audio files
4. Store long textual information

✅ Correct Answer: 4

Applications that rely on databases are

1. Supermarket stock control, theater bookings and payroll
2. Accounts, online banking, PowerPoint presentations
3. Internet shopping, robotics, computer games
4. Internet shopping, robotics, computer games

✅ Correct Answer: 1

Which of the following is not a Access database object ?

1. table
2. form
3. query
4. datasheet

✅ Correct Answer: 4

Data owners must protect their data against corruption or loss. One sensible method to achieving this is to

1. Take regular backups
2. Keep a hardcopy printout of all data
3. Keep fingers crossed at all times
4. None of the above

✅ Correct Answer: 1

Facilities offered by databases are

1. The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports
2. Easy editing, spell check, perform calculations, library of mathematical functions, replication
3. The ability to rotate images, copy and paste, fill scale
4. None of the above

✅ Correct Answer: 1

When you double click a query object, you open

1. The object in design view
2. The object in print preview
3. The result of the query
4. The underlying table on which the query is based

✅ Correct Answer: 2

Checks that are added to databases to detect unsuitable data on inpt are called

1. validation
2. verification
3. vegetation
4. None of the above

✅ Correct Answer: 1

Auto Report allows you to

1. View a subset of your data
2. Create a simple report
3. Create a data entry form
4. Enter records

✅ Correct Answer: 2

The asterisk (*) is sometimes used in database queries. This character is then called a

1. Wildcard
2. Dummy
3. Ditto
4. All of the above

✅ Correct Answer: 1

When performing a look-up operation using a form

1. you enter the search value into the form
2. You look at each form sequentially until you see the one you want
3. You type the key in an entry line, and the correct form is displayed
4. All of the above

✅ Correct Answer: 4

Which custom date format displays the numeric day of the year when a date is entered?

1. YY
2. YYYY
3. Y
4. All of the above

✅ Correct Answer: 3

When you save an Access project, what fileformat do you use?

1. .adp
2. xm
3. mdb
4. All of above

✅ Correct Answer: 1

Which of the following criterion would find records whose personality field does not equal “Nice”?

1. <>Nice
2. NOT Nice
3. <>”Nice”
4. IS NOT Nice

✅ Correct Answer: 3

What is the maximum character field size you can set for a field that has a text data type?

1. 64
2. 255
3. 512
4. All of the above

✅ Correct Answer: 2

Which of the following fields would not make a suitable primary key ?

1. A date field
2. An invoice number
3. An autoNumber field
4. A customer’s social security number

✅ Correct Answer: 1

Auto reports can contain each of the following elements except

1. A detail section
2. A page footer
3. A group header
4. All of the above

✅ Correct Answer: 4

What is the abbreviation used for a software package that permits the user to create, retrieve and maintain records in a database? A. DASD B. FMS C. EMMS D. What is the abbreviation used for a software package that permits the user to create, retrieve and maintain records in a database?

1. EMMS
2. FMS
3. EMMS
4. DBMS

✅ Correct Answer: 4

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

1. Data acquisition
2. Data bank
3. Real time
4. Database

✅ Correct Answer: 2

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

1. Data acquisition
2. Data bank
3. Real time
4. Database

✅ Correct Answer: 2

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

1. Data acquisition
2. Data bank
3. Real time
4. Database

✅ Correct Answer: 2

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

1. Data description language
2. Binary language
3. Data channels
4. Data definition language

✅ Correct Answer: 4

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

1. Data element
2. Elementary data item
3. Data entry
4. Database management

✅ Correct Answer: 2

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

1. Data security
2. Data validaity
3. Data independence
4. Data integrity

✅ Correct Answer: 4

A repository for data, usually covering specific topic is

1. Database
2. Data requisition
3. Data bank
4. Data collection

✅ Correct Answer: 3

A set of programs that handle firm’s database responsibilities is called a

1. Database Management System (DBMS)
2. Database Processing System (DBPS)
3. Data Management System (DMS)
4. All of above

✅ Correct Answer: 4

Which of the following is not a relational database?

1. dBase IV
2. 4th Dimension
3. FoxPro
4. Reflex

✅ Correct Answer: 4

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

1. DBMS
2. MIS
3. ISO
4. PSO

✅ Correct Answer: 2

Dbase-III was developed by

1. Dec
2. IBM
3. Ashton-tate
4. All of the above

✅ Correct Answer: 3

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

1. Text
2. Number
3. Memo
4. All of above

✅ Correct Answer: 1

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

1. The pin code
2. The last name
3. A compound key consisting of the first name and the last name
4. All of the above

✅ Correct Answer: 3

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

1. The table will not include any fields from the table
2. B. The query sorts the table’s record in the order you specify
3. The query will include every field from the table*
4. The query uses the records from the table without displaying them

✅ Correct Answer: 3

The modify operation is likely to be done after

1. delete
2. look up
3. insert
4. All of the above

✅ Correct Answer: 2

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

1. Display records between the dates 1/2/ 99 and 1/1/00
2. Display records between the dates 1/1/ 99 and 12/31/99
3. Display records whose dates equaled 1/1/99 or 12/31/99
4. All of the above

✅ Correct Answer: 2

DDP stands for

1. Distributed Double Processing
2. Double Decimal Processing
3. Distributed Data Programming
4. Distributed Data Processing

✅ Correct Answer: 4

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

1. Drop column fields here
2. Drop row fields here
3. Drop data items here
4. None of the above

✅ Correct Answer: 3

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

1. Dynamic web data
2. Data access pates
3. Html data pages
4. None of the above

✅ Correct Answer: 2

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

1. Field
2. Record
3. Row
4. None of the above

✅ Correct Answer: 1

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

1. Field
2. Bead
3. Database
4. Data collection

✅ Correct Answer: 2

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

1. File
2. Record
3. Key field
4. Label

✅ Correct Answer: 4

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

1. File name
2. Database
3. Label
4. Group

✅ Correct Answer: 3

In Form view, which command displays records alphabetically?

1. Find
2. Advanced Filter/Sort
3. Sort
4. All of the above

✅ Correct Answer: 3

Where do report and forms get their information form?

1. Forms
2. Modules
3. Tables
4. Queries

✅ Correct Answer: 3