1.
Tables are the basic database object
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.
2.
Programs made with Visual Basic to manipulate the Database
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.
3.
Which are examples of relational database creation tools? (pick 2)
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.
4.
Which definition best defines a database?
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.
5.
A Record is the most basic database object
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.
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)?
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.
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".
8.
Which of the following are Database Objects ( pick 3)
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.
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.
10.
I allow you to view, edit or add records in a convenient and attractive way
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.
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.
12.
You use this to set one or more actions that perform a particular operation
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.
13.
Tables, forms, and Mo-max objects are all apart of database interscope
Correct Answer
B. False
Explanation
No such thing as database interscope!!!