Test Your Concepts About Database And MS Access Application!

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Kumar_niten
K
Kumar_niten
Community Contributor
Quizzes Created: 7 | Total Attempts: 66,232
Questions: 10 | Attempts: 445

SettingsSettingsSettings
Database Concept Quizzes & Trivia

A database is defined as a systematic collection of data which is maintained by different DBMS software such as SQL, Mongo DB, Postgre, MS Access etc. The essential purpose of database management is to store retrieve and manage the information for future access. This quiz has been created to test your knowledge about the concepts of database and MS Access application. So, let's try out the quiz. All the best!


Questions and Answers
  • 1. 

    The most suitable validation rule that can be entered for the DOB(Date of Birth) field in a table that restricts the date from 1/1/1950 to 1/1/1990 is

    • A.

      Greater than 1/1/1950 And less than 1/1/1990

    • B.

      >1/1/1950 And

    • C.

      >=#1/1/1950 And

    • D.

      From 1/1/1950 to 1/1/1990

    Correct Answer
    C. >=#1/1/1950 And
  • 2. 

    What will be a suitable criteria that should be entered for a query to serach for Employee Names beginning with M?

    • A.

      Start with M

    • B.

      Like M

    • C.

      Like "M*"

    • D.

      Like 'M*'

    Correct Answer
    C. Like "M*"
    Explanation
    The suitable criteria that should be entered for a query to search for Employee Names beginning with M is "Like 'M*'". This is because the "Like" operator is used for pattern matching and the wildcard character '%' is used to represent any sequence of characters. By using the pattern 'M*', the query will retrieve all employee names that start with the letter M.

    Rate this question:

  • 3. 

    What defines the format of the data that has to be entered in a field?

    • A.

      Input mask

    • B.

      Validation rule

    • C.

      Caption

    • D.

      Format

    • E.

      Validation text

    Correct Answer
    A. Input mask
    Explanation
    An input mask is used to define the format of the data that needs to be entered in a field. It specifies the allowed characters, their placement, and any special formatting requirements. By using an input mask, users are guided to enter data correctly and consistently, reducing errors and ensuring data integrity.

    Rate this question:

  • 4. 

    Which of the following database objects allows you to search for information and then display the result?

    • A.

      Query

    • B.

      Table

    • C.

      Report

    • D.

      Forms

    Correct Answer
    A. Query
    Explanation
    A query is a database object that allows you to search for information and then display the result. It is used to retrieve specific data from one or more tables based on certain criteria. Queries can be used to filter and sort data, perform calculations, and generate reports. By specifying the desired criteria, a query helps in finding and displaying the exact information needed from the database.

    Rate this question:

  • 5. 

    Which of the following data type should be used to enter the Employee Id in an Access database? The Employee Id field consists of alphabet and numbers.

    • A.

      Text

    • B.

      Date/Time

    • C.

      Number

    • D.

      Memo

    Correct Answer
    A. Text
    Explanation
    The Employee Id field consists of both alphabets and numbers, which makes it a combination of characters. In an Access database, the data type that should be used to enter this kind of data is "Text". The Text data type allows for the storage of alphanumeric characters and is suitable for fields that contain a combination of letters, numbers, and symbols.

    Rate this question:

  • 6. 

    Diane Frye, an HR manager wants to create a database of all the employees in the organization. Diane wants to create an employees table and in turn, wants to make one of the keys as a primary key. Which of the following fields is most suitable to be a primary key field?

    • A.

      Employee_No

    • B.

      Emplyee_FirstName

    • C.

      Emplyee_LastName

    • D.

      Emplyee_Address

    Correct Answer
    A. Employee_No
    Explanation
    The most suitable field to be a primary key in the employees table is Employee_No. A primary key is a unique identifier for each record in a table, and Employee_No seems to be a field that would have a unique value for each employee. This field can be used to uniquely identify and distinguish each employee in the database.

    Rate this question:

  • 7. 

    Which of the following component contains buttons that provide easy access to the commands and functions of Access?

    • A.

      Title bar

    • B.

      Menu bar

    • C.

      Database toolbar

    • D.

      Task pane

    Correct Answer
    C. Database toolbar
    Explanation
    The database toolbar contains buttons that provide easy access to the commands and functions of Access. This toolbar typically includes buttons for common tasks such as creating a new database, opening an existing database, saving changes, and running queries. By having these buttons readily available on the toolbar, users can quickly perform common actions without having to navigate through menus or search for specific commands.

    Rate this question:

  • 8. 

    Which of the following data type enables you to insert or embed the objects created in other applications into an Access Database?

    • A.

      OLE object

    • B.

      AutoNumber

    • C.

      Currency

    • D.

      Hyperlink

    Correct Answer
    A. OLE object
    Explanation
    OLE object data type enables you to insert or embed the objects created in other applications into an Access Database. OLE (Object Linking and Embedding) allows you to incorporate objects such as images, documents, spreadsheets, etc., from other applications into your Access database. This enables you to have a more comprehensive and integrated database system where you can store and access various types of data within a single platform.

    Rate this question:

  • 9. 

    What is used when you want to temporarily change the view of a set of records?

    • A.

      Query

    • B.

      Filter

    • C.

      Forms

    • D.

      Sorting

    Correct Answer
    B. Filter
    Explanation
    When you want to temporarily change the view of a set of records, you can use a filter. A filter allows you to specify criteria or conditions that records must meet in order to be displayed. By applying a filter, you can narrow down the records that are shown based on specific attributes or values. This temporary change in view helps in focusing on specific data and simplifying the analysis or task at hand.

    Rate this question:

  • 10. 

    The DBMS acts as an interface between what two components of an enterprise-class database system?

    • A.

      Database application and the database

    • B.

      Data and the database

    • C.

      The user and the database application

    • D.

      Database application and SQL

    Correct Answer
    A. Database application and the database
    Explanation
    The DBMS acts as an interface between the database application and the database. The database application is responsible for interacting with the user and performing tasks such as data entry, retrieval, and manipulation. On the other hand, the database stores and organizes the data. The DBMS acts as a bridge between these two components, allowing the application to access and manipulate the data stored in the database efficiently and securely. It provides a set of tools and functionalities that enable the application to interact with the database effectively.

    Rate this question:

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.