Making Changes To A Database: Quiz!
(220).jpg "Making Changes To A Database: Quiz! - Quiz")
.
- 1.
Once you add records to a database table, you cannot rearrange the order of the fields in the table.
- A.
True
- B.
False
Correct Answer
B. False -
- 2.
Why might you want to change the attributes of a field in a database table?
- A.
To change the order in which fields appear in the table.
- B.
To assign a primary key.
- C.
To set a character limit for that field.
- D.
To change the data in a certain field.
Correct Answer
C. To set a character limit for that field. -
- 3.
What is the function of the Required property of a field?
- A.
To specify whether or not a value is necessary in a field.
- B.
To specify whether or not a primary key has been assigned to a table.
- C.
To specify whether or not a field is a primary key.
- D.
To specify whether or not a field is indexed.
Correct Answer
A. To specify whether or not a value is necessary in a field. -
- 4.
How do you select an entire record in a database table in Datasheet view?
- A.
Click the primary key field for that record.
- B.
Click the grey box to the left of that record.
- C.
Click any field in that record.
- D.
Click and indexed field in that record.
Correct Answer
B. Click the grey box to the left of that record. -
- 5.
You can delete records in a database at any time.
- A.
True
- B.
False
Correct Answer
A. True -
- 6.
Table relationships work by matching data in key fields-usually a field with the same name in both tables.
- A.
True
- B.
False
Correct Answer
A. True -
- 7.
What is a one-to- one table relationship?
- A.
A table relationship that pings the external database.
- B.
A table relationship that compiles the database index.
- C.
A table relationship that requires two tables only have one matching record.
- D.
A table relationship[ that sorts only one data record at a time.
Correct Answer
C. A table relationship that requires two tables only have one matching record. -
- 8.
A one-to-one table relationship is the most common database relationship.
- A.
True
- B.
False
Correct Answer
B. False -
- 9.
In a one-to-many relationship, each record in Table A can have only one matching record in Table B and each record in Table B can have only one matching record in Table A.
- A.
True
- B.
False
Correct Answer
B. False -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2022Quiz 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