Similar Collections

    No collections found

questions

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

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

  1. File
  2. Layout
  3. Field
discuss
This set of related data items is known as a

This set of related data items is known as a

  1. File
  2. Record
  3. Table
  4. None of the above
discuss
The framework for storing records in database is a

The framework for storing records in database is a

  1. Form
  2. Report
  3. Query
  4. Table
discuss
The following command is used to search the record that satisfies the specified criteria

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

  1. FOUND
  2. SEARCH
  3. GET
  4. LOCATE
discuss
The data in a record is of the following types

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
discuss
The data in a record is of the following types

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
discuss
A treelike structure of records in a database.Select the best fit for answer

 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
discuss
The following language used by most of the DBMSs for helping their users to access data

 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
discuss
What is a largest collection of data stored in a computer?

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
discuss
Which command is used to replace ?

Which command is used to replace ?

  1. REPLACE
  2. REPLACE ALL
  3. Add record from edit menu
  4. All of above
discuss
The following part of a database that holds only one type of information

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

 

  1. Report
  2. Query
  3. Record
  4. Field names
discuss
Need to see all the information from two tables on one form. Insert

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
discuss
What is the primary difference between a pivot table report and a cross tab query?

 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 above
discuss
The largest unit of a database is

The largest unit of a database is

  1. A record
  2. A field
  3. A subfield
  4. None of above
discuss
What’s the best Access object for an invoice you’ll mail to customers?

 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
discuss
What is a Grouped Report?

 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
discuss
Which field allow to select items from drop down list?

 Which field allow to select items from drop down list?

  1. An OLE field
  2. A Memo Field
  3. A lookup Field
  4. A hyperlink field
discuss
What did the first Table Analyzer do?

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
discuss
Pivot Table reports are good for

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
discuss
Which of the following are common ways to enforce data validation when entering data into an Access form?

 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
discuss
total MCQs: 160

MCQs

160

Views

224

Best Answers

299

Points

5