Creating A Database
- 1.
When planning a database, which of the following should you determine first?
- A.
The attributes and properties of each field.
- B.
An appropriate name for the database.
- C.
How many tables to create.
- D.
What fields to create?
Correct Answer
B. An appropriate name for the database. -
- 2.
What is a relational database?
- A.
A database that contains several tables which are linked by certain fields.
- B.
Any database that contains information about related people or organisations.
- C.
A database that contains only one table.
- D.
A database that stores the same records in multiple tables
Correct Answer
A. A database that contains several tables which are linked by certain fields. -
- 3.
Access provides three different ways to create a new database table. If you select the “Create table in Design view” option, how will the table be created?
- A.
A simple table with no fields or attributes will be automatically created.
- B.
A predefined wizard will assign fields names and attributes to the table.
- C.
You will manually enter the name and attributes of each field in the table
- D.
An existing table stored on your computer will be used.
Correct Answer
C. You will manually enter the name and attributes of each field in the table -
- 4.
Once you have assigned a primary key for a table, you can enter duplicate data in any field of the table.
- A.
True
- B.
False
Correct Answer
B. False -
- 5.
It is possible to save a database without assigning a primary key for it.
- A.
True
- B.
False
Correct Answer
A. True -
- 6.
What is an index?
- A.
A presentation window that contains data entry fields.
- B.
Any field in a database table.
- C.
A feature that matches different fields in a database.
- D.
A feature that speeds up searching and sorting in a table based on key values.
Correct Answer
D. A feature that speeds up searching and sorting in a table based on key values. -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jan 25, 2013Quiz Edited by
ProProfs Editorial Team -
Jun 02, 2011Quiz Created by
Busi1
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top