Database Basics (Buyer Brown) Bbtas.Com

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 Buyerbrown
B
Buyerbrown
Community Contributor
Quizzes Created: 1 | Total Attempts: 136
Questions: 13 | Attempts: 136

SettingsSettingsSettings
Database Basics (Buyer Brown) Bbtas.Com - Quiz

Hi I’m buyer brown and I’m Beginning to learn about databases, so I’m creating study tools for myself and for anyone else it may help. Test is based on my video if you would like to study then take the test


Questions and Answers
  • 1. 

    Tables are the basic database object

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    Tables are the basic building blocks of a database. They are used to store and organize data in a structured manner. A table consists of rows and columns, where each row represents a record and each column represents a field or attribute. By creating tables, we can define the structure and schema of our database. Therefore, it is correct to say that tables are the basic database object.

    Rate this question:

  • 2. 

    Programs made with Visual Basic to manipulate the Database

    • A.

      Form

    • B.

      Expla-data change

    • C.

      Css

    • D.

      Modules

    • E.

      Object oop 2.3

    Correct Answer
    D. Modules
    Explanation
    Modules are used in Visual Basic programs to organize and group related code together. They contain procedures, functions, and variables that can be accessed by other parts of the program. In this context, modules can be used to manipulate the database in Visual Basic programs. They provide a way to separate the database manipulation code from the rest of the program, making it easier to manage and maintain.

    Rate this question:

  • 3. 

    Which  are examples of relational database creation tools? (pick 2)

    • A.

      Microsoft Access

    • B.

      Microsoft Sky Net

    • C.

      Oracle

    • D.

      Adobe Data Track

    Correct Answer(s)
    A. Microsoft Access
    C. Oracle
    Explanation
    Microsoft Access and Oracle are examples of relational database creation tools. Microsoft Access is a database management system that allows users to create and manage databases using a graphical interface. Oracle, on the other hand, is a widely used enterprise-level database management system that provides a comprehensive set of tools for creating and managing relational databases. Both of these tools are commonly used in the industry for designing and building relational databases.

    Rate this question:

  • 4. 

    Which definition best defines a database?

    • A.

      A block of code used in action script 3.0

    • B.

      A military station for docking data relay signals

    • C.

      Collection of data organized in a manner that allows access, retrieval, and use of that data.

    Correct Answer
    C. Collection of data organized in a manner that allows access, retrieval, and use of that data.
    Explanation
    A database is a collection of data that is organized in a way that allows users to easily access, retrieve, and use the data. It is a structured system that stores and manages information, making it easier for users to store, retrieve, update, and manipulate data. This definition accurately describes the purpose and functionality of a database.

    Rate this question:

  • 5. 

    A Record is the most basic database object

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    A record is not the most basic database object. The most basic database object is a field, which is a single piece of data within a table. A record, on the other hand, is a collection of related fields that represents a single entity or item in a table. Therefore, the correct answer is false.

    Rate this question:

  • 6. 

    A Table is the core of a database it is made from records and fields, which one can be of different data type such as (text, number, currency)?

    • A.

      Record

    • B.

      Field

    • C.

      Table

    • D.

      Basic Object

    Correct Answer
    B. Field
    Explanation
    A field is a component of a table in a database that holds data of a specific data type, such as text, number, or currency. It is used to store individual pieces of information within each record of the table. Fields are essential in organizing and categorizing data within a database and allow for efficient data retrieval and manipulation.

    Rate this question:

  • 7. 

      Each table in a database has a field which can uniquely identify each record (row) This field is called the?

    Correct Answer
    Primary Key
    Explanation
    In a database, a primary key is a field that uniquely identifies each record (row) in a table. It ensures that each record has a unique identifier, which helps in maintaining data integrity and allows for efficient retrieval and manipulation of data. By using a primary key, it becomes easier to establish relationships between tables and perform operations like joins and updates. Therefore, the correct answer is "Primary Key".

    Rate this question:

  • 8. 

    Which of the following are Database Objects ( pick 3)

    • A.

      Forms

    • B.

      ODB

    • C.

      Queries

    • D.

      DMX

    • E.

      Reports

    Correct Answer(s)
    A. Forms
    C. Queries
    E. Reports
    Explanation
    Forms, Queries, and Reports are all examples of database objects. Forms are used to input and display data, queries are used to retrieve specific data from a database, and reports are used to present data in a formatted and organized manner. ODB and DMX are not database objects, ODB stands for Object Database and DMX stands for Data Mining Extensions, which are not specific database objects but rather technologies or concepts related to databases.

    Rate this question:

  • 9. 

    I'm used to ask questions of a database, you can create me to a specific criteria what is a?

    Correct Answer(s)
    Query
    Explanation
    The given answer, "Query," is the correct answer because it directly corresponds to the question. The question states that "I'm used to ask questions of a database," which indicates that the subject being referred to is a query. A query is a request for information from a database, typically in the form of a question or a search statement. Therefore, the answer aligns perfectly with the context of the question.

    Rate this question:

  • 10. 

    I allow you to view, edit or add records in a convenient and attractive way

    • A.

      Reports

    • B.

      Macros

    • C.

      Modules

    • D.

      Forms

    • E.

      Tables

    Correct Answer
    D. Forms
    Explanation
    Forms allow users to view, edit, or add records in a convenient and attractive way. They provide a user-friendly interface that allows easy data entry and manipulation. Forms can be customized to display only the necessary fields, making data entry more efficient. They also offer various controls and features such as drop-down lists, buttons, and validation rules to ensure data integrity. Overall, forms enhance the user experience and make working with data more accessible and visually appealing.

    Rate this question:

  • 11. 

    Use me to print data from a table or a query on paper You can group your data, calculate totals, apply different formats and add graphics to make me attractive and easy to read

    Correct Answer
    Report
    Explanation
    A report is a tool that allows you to print data from a table or a query on paper. It provides various features such as grouping data, calculating totals, applying different formats, and adding graphics to enhance the presentation and make it more visually appealing and easy to read. Reports are commonly used in business and other fields to present data in a structured and organized manner.

    Rate this question:

  • 12. 

    You use this to set one or more actions that perform a particular operation

    • A.

      Ambient operation

    • B.

      Macros

    • C.

      Controls

    • D.

      DD2p

    • E.

      Castcom

    Correct Answer
    B. Macros
    Explanation
    Macros are used to set one or more actions that perform a particular operation. They are a way to automate repetitive tasks or sequences of commands in various software applications. By creating a macro, users can save time and effort by executing a series of actions with just one command or keystroke. Macros can be especially useful in complex programs or when performing repetitive tasks, as they streamline workflows and increase efficiency.

    Rate this question:

  • 13. 

    Tables, forms, and Mo-max objects are all apart of database interscope

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    No such thing as database interscope!!!

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jun 04, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 16, 2008
    Quiz Created by
    Buyerbrown

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.