Operate Database Application (Basic)
This Quiz is for everyone who needs to understand more with skill in learning Microsoft Access 2007.
- 1.It refers to the processed data
- 2.A collection of related information that is organized in a table with rows and columns
- 3.Its store and organize data in a database
- 4.____________ ask questions.
- 5.The row in the table is ____________
- 6.Microsoft Access is a
- A.
Operating System
- B.
Spreadsheet Solution
- C.
Database Management System
- D.
None of the above
- 7.____________ Ensures that the relationship between a primary and related tables is maintained
- A.
Primary Key
- B.
Foreign Key
- C.
Referential Integrity
- 8.A report header will display
- A.
On all the pages
- B.
On the first page of the report
- C.
On the last page of the report
- 9.Which of he following is NOT a part of a database?
- A.
Tables
- B.
Records
- C.
Fields
- D.
Worksheets
- 10.In a database, each _________________ contains a collection of related data.
- A.
Table
- B.
Record
- C.
Field
- D.
None of the above
- 11.In a database, a _____________ is a unit of information about one individual or item.
- A.
Table
- B.
Record
- C.
Field
- D.
File
- 12.In a record, each separate piece of data, such as a last name, a first name, or an address, is called a _____________.
- A.
File
- B.
Field
- C.
Record
- D.
Table
- 13.What does GIGO stand for?
- A.
Get in, get out
- B.
Garbage in, garbage out
- C.
Good information in, good information out
- D.
Garbage input, garbage output
- 14.Which of the following is a way to sort data?
- A.
Chronologically
- B.
Alphabetically
- C.
Numerically
- D.
All of the above
- E.
None of the above
- 15.If you sort data in order of decreasing value such as Z-A, or 10-1, what type of sort are you using?
- A.
Ascending
- B.
Descending
- C.
Incremental
- D.
Exponential
- 16.What is a query?
- A.
A question you ask a database
- B.
A question you ask a record
- C.
A question you ask a table
- D.
A question you ask a field
- 17.What does SQL stand for?
- A.
Structured query language
- B.
Stated question language
- C.
System query lingo
- D.
Status query language
- 18.A database is an organized collection of information.
- A.
True
- B.
False
- 19.A field's data type determines what kind of information can be stored there.
- A.
True
- B.
False
- 20.A computerized database can store millions of telephone numbers.
- A.
True
- B.
False
- 21.A database is a collection of related information, but a database management system is a type of software program.
- A.
True
- B.
False
- 22.A query lets you speed up the prowsing process by finding information that matches specifically to your criteria.
- A.
True
- B.
False
- 23.It is a relationship that can be established when one record in a table has only one matching record in another table.
- A.
Relationship
- B.
One-to-One Relationship
- C.
One-to-many Relationship
- D.
Many-to-many Relationship
- 24.It is an association between two tables in which one record in either table can relate to many records in other table.
- A.
Relationship
- B.
One-to-One Relationship
- C.
One-to-many Relationship
- D.
Many-to-many Relationship
- 25.It is an association established between common fields in two tables.
- A.
Ctrl key
- B.
Primary key
- C.
One to one
- D.
Relationship
Questions: 9 | Attempts: 8339 | Last updated: Apr 2, 2021
-
Sample QuestionWhich of the following makes it possible for entities toshare a relationship?
Questions: 31 | Attempts: 6441 | Last updated: May 6, 2021
-
Sample Question-------------------------------responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software, and hardware resources, controlling its use, andmonitoring efficiency of operations.
Questions: 22 | Attempts: 6452 | Last updated: Jan 28, 2013
-
Sample QuestionWhat are the basic components of a linked list?
Back to top