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

The following term applies to a collection ofrelated records in a database

1. File
2. Layout
3. File
4. Field

✅ Correct Answer: 1

This set of related data items is known as a

1. File
2. Record
3. Table
4. None of the above

✅ Correct Answer: 2

The framework for storing records in database is a

1. Form
2. Report
3. Query
4. Table

✅ Correct Answer: 3

The following command is used to search the record that satisfies the specified criteria

1. FOUND
2. SEARCH
3. GET
4. LOCATE

✅ Correct Answer: 1

The data in a record is of the following types

1. four text fields and three numeric fields
2. two integer fields and five text fields
3. three text fields and four numeric fields
4. none of the above

✅ Correct Answer: 2

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

1. Hierarchical database structure
2. Relational database structure
3. Multidimensional database structure
4. Sequential database access

✅ Correct Answer: 1

The following language used by most of the DBMSs for helping their users to access data

1. High level language
2. Query language
3. SQL
4. 4GL

✅ Correct Answer: 1

What is a largest collection of data stored in a computer? You might use this type of program to keep a record of all the friends in your address book.

1. Information Processing
2. Spreadsheet
3. Operating system
4. Database

✅ Correct Answer: 4

Which command is used to replace ?

1. REPLACE
2. REPLACE ALL
3. Add record from edit menu
4. None of the above

✅ Correct Answer: 3

The following part of a database that holds only one type of information

1. Report
2. Query
3. Record
4. Field

✅ Correct Answer: 4

All of the following terms are related to computerized databases except which one?

1. Search
2. Sort
3. Field names
4. Record grab

✅ Correct Answer: 1

Need to see all the information from two tables on one form. Insert

1. A page break
2. A subform
3. A linked command button
4. None of the above

✅ Correct Answer: 2

What is the primary difference between a pivot table report and a cross tab query?

1. A pivot table report can contain sums, counts, and averages while a cross tab query cannot.
2. You can’t pivot a cross tab query
3. A cross tab query lets you group similar items. A pitot table report does not
4. None of the above

✅ Correct Answer: 2

The largest unit of a database is

1. A record
2. A field
3. A subfield
4. None of the above

✅ Correct Answer: 2

What’s the best Access object for an invoice you’ll mail to customers?

1. A report
2. A form
3. A table
4. All of the above

✅ Correct Answer: 1

What is a Grouped Report?

1. A type of report that can be generated by the Report Wizard
2. A report that displays data that has been sorted in ascending or descending order
3. A report that displays data grouped by fields you specify
4. None of the above

✅ Correct Answer: 3

What is a Grouped Report?

1. type of report that can be generated by the Report Wizard
2. A report that displays data that has been sorted in ascending or descending order C.
3. A report that displays data grouped by fields you specify
4. None of These

✅ Correct Answer: 4

What did the first Table Analyzer do?

1. Analyze the data in a set of flat files and automatically create a relational database system from that information
2. Provide a graphic way to design relational databases
3. Automate process of connecting tables to SQL Server
4. None

✅ Correct Answer: 1

Pivot Table reports are good for

1. Analyzing large amounts of data
2. Turning tables upside down
3. Breaking spreadsheet data into multiple worksheet
4. None of above

✅ Correct Answer: 1

Which of the following are common ways to enforce data validation when entering data into an Access form?

1. Create an input mask to restrict the kind of value that can be entered in positions across the field.
2. Define a validation rule for that field
3. A and B
4. none of the above

✅ Correct Answer: 3

Sub-schema can be used to

1. Create very different, personalized views of the same data
2. Present information in different formats
3. Hide sensitive information by omitting fields from the subschema’s description
4. All of the above

✅ Correct Answer: 4

If you are entering data in a form, a quick way to cpy a value from the previous record is to press

1. Ctrl+’
2. F6
3. Ctrl+D
4. None of the above

✅ Correct Answer: 4

DBMS is

1. Collection of data
2. Set of programs to access those data
3. Set of programs to update those data
4. All of the above

✅ Correct Answer: 4

COPY STRUCTURE command is used to

1. Copy contents of an active database to a new file
2. Copy all records of an active database to disk
3. Copy contents of an active database to disk
4. Copy structure of an active database to a new file

✅ Correct Answer: 4

COUNT command is used to

1. Count the number of data fields in an active database file
2. Count the number of data files which are active
3. Count the records which are updated
4. Count the number of records in an active database file

✅ Correct Answer: 4

What is the term to ask the computer to pt information in order numerically or alphabetically ?

1. Crop
2. Report
3. Sort
4. Organize

✅ Correct Answer: 3

What is the term to ask the computer to pt information in order numerically or alphabetically ?

1. Crop
2. Report
3. Sort
4. Organize

✅ Correct Answer: 3

The raw facts are called

1. Data
2. Programs
3. Commands
4. Responses

✅ Correct Answer: 1

The term refers to a collection of related information

1. Database
2. List
3. Outline
4. Record

✅ Correct Answer: 3

A form that is used to collect data in a structured manner for entry to a database is called a

1. Database deign form
2. Systems flowchart
3. Data capture form
4. None of above

✅ Correct Answer: 3

The following command is used for inserting records

1. INSERT
2. ADD
3. Both of the above
4. None of the above

✅ Correct Answer: 1

The Query is a statement requesting for

1. Insertion of information
2. Deletion of information
3. Update of information
4. Retrieval of information

✅ Correct Answer: 4

The activity of a file A.

1. Is a low percentages of number of records added or deleted from a file
2. If high, reduces processing efficiency for sequential and non sequential files
3. Is a measure of the percentage of existing records updated during a run
4. Refers to how closely the files fit into the allocated

✅ Correct Answer: 4

The following statement is not valid about indexing

1. it stores the index fields
2. it stores the corresponding record number
3. it maintains the alphabetically order
4. it duplicate the database file

✅ Correct Answer: 4

The following devices can be used to input data into a database

1. Keyboard, fax roller ball
2. Mouse, keyboard, monitor
3. Mouse, keyboard, touch screen
4. None of the above

✅ Correct Answer: 3

The following command is used for sorting

1. list
2. browse
3. index
4. Sort

✅ Correct Answer: 3

List command is used to get

1. List of database contents
2. List of database contents
3. List of variables used in database file
4. None of the above

✅ Correct Answer: 1

A field that uniquely identifies a record is called a

1. Main field
2. Header
3. Key field
4. None of above

✅ Correct Answer: 3

Corrupted index file is corrected using

1. Modifyindex
2. Recreateindex
3. Reindex
4. None of the above

✅ Correct Answer: 3

The navigation buttons enable you to

1. move from record to record in a table or form
2. move from page to page in report
3. (A) and (B) both
4. None of the above

✅ Correct Answer: 3

Different levels of access are assigned to personnel records in the health and fitness gym. Only the system manager is able to create delete or edit records. Certain other personnel are allowed to view all the records, whereas others are not permitted to view complete records. The levels of access are controlled by

1. Password
2. User id’s
3. Status
4. None of the above

✅ Correct Answer: 1

You can switch back and forth betweendesign and datasheet view by clicking the

1. queries object tab
2. switch command on the view menu
3. view button
4. select query title bar

✅ Correct Answer: 3

The table wizard

1. Quickly creates a default report
2. Displays a subset of the data in a database
3. Contains sample tables and fields you can use to create a table
4. Automatically edits your data as you enter it

✅ Correct Answer: 4

The names, address, and account balance of all of your customers, select the best fit for answer

1. record
2. file
3. database
4. key field

✅ Correct Answer: 4

An integrated collection of all of the data about your customers. Select the best fit for answer

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

✅ Correct Answer: 2

An identification field in a record. Select the best fit for answer

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

✅ Correct Answer: 3

What is part of database that holds all of the information about one item or subject?

1. Record
2. File
3. Query
4. Chart

✅ Correct Answer: 1

What is a stored question about information in a database?

1. Record
2. Field
3. Report
4. Query

✅ Correct Answer: 4

RDBMS stands for

1. Relational Database Management System
2. Relation Data Module System
3. Right Data Base Management System
4. None of the above

✅ Correct Answer: 1

Pack command is used to

1. Remove records permanently
2. Remove records temporarily
3. Restore records permanently
4. Restore records temporarily

✅ Correct Answer: 1

Modules are

1. selection of commands used to automate repetitive tasks
2. programs written in Visual C++
3. Object tabs
4. Group of records

✅ Correct Answer: 1

APPEND command is used to

1. Add record to the end of active database file and starts full screen data entry
2. Add Record to the start of active database file
3. Add record to the start of active database file and starts full screen data entry
4. Add record to the end of database file

✅ Correct Answer: 1

Append from command is used to

1. Add records from information in an array
2. Adds records from a file
3. Add records from a variable
4. Add records from stock

✅ Correct Answer: 1

New record is added using

1. Append record from browse menu
2. Append record into from browse menu
3. Add record from edit menu
4. All of the above

✅ Correct Answer: 1

When a customer makes an online hotel booking, the database is updated in

1. Batch mode
2. Pseudo real-time
3. One month
4. All of above

✅ Correct Answer: 2

A database that contains tables linked by common fields is called a

1. Centralized database
2. Flat file database
3. Relational database
4. None of the above

✅ Correct Answer: 4

The use of integrated collections of database records and files for data storage and processing. The best fit for answer:

1. Database management approach
2. DBMS uses
3. Database administrator
4. Query language

✅ Correct Answer: 4

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

1. Database management approach
2. DBMS uses
3. Database administrator
4. Query language

✅ Correct Answer: 2

The ….. presents data in a way similar to an excel spreadsheet

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

✅ Correct Answer: 3

It Is used to build and modify database objects and also to create new queries

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

✅ Correct Answer: 3