Database Concepts Exam Quiz: Trivia!
(123).jpg "Database Concepts Exam Quiz: Trivia!")
How aware are you of the various database concepts? A database is frequently conceived of as a repository of information necessary for running certain functions in an organization. This quiz involves your ability to comprehend what a single set of related data values is referred to as, as well as other pertinent information. Take this quiz and see how much you know about database concepts.
- 1.A single set of related data values is referred to as:
- A.
Data value
- B.
Record
- C.
Field
- D.
Table
- 2.What is used to uniquely identify each record in a table?
- A.
Foreign key
- B.
Field
- C.
Datatype
- D.
Primary key
- 3.___________ data type stores date and time values between the years 100 through 9999.
- A.
Date
- B.
Time
- C.
Date/Time
- D.
Memo
- 4.The ______________ of a table is used to modify the design of a table, like modifying the name of a field or changing the data type of a field.
- A.
Datasheet View
- B.
Design View
- C.
Table View
- D.
Wizard View
- 5.You can select multiple fields of a table in the design view by using the ________ key.
- A.
Alt
- B.
Spacebar
- C.
Shift
- D.
Tab
- E.
Ctrl
- 6.What does x represent in the figure?
- A.
Row Selector
- B.
Row Holder
- C.
Row Field
- D.
Row Data
- 7.What validation rule should be entered for a StudentID which should start with the letter "S"?
- A.
Like 'S*'
- B.
Like S*
- C.
Like "S"
- D.
Like "S*"
- 8.In the datasheet view of the Student table, the StudentAddress field needs to be displayed as Address. Which field property can be used to achieve this?
- A.
Caption
- B.
Validation Text
- C.
Required
- D.
Validation Rule
- E.
Default
- 9.Indicate whether the following statement is true or false. Statement: A table can have only one Primary Key.
- A.
True
- B.
False
- 10.What is the purpose of forms?
- A.
It is used to store data
- B.
It provides a user-friendly interface for entering data into tables
- C.
It is used to retrieve data from tables
- D.
It is used to print or preview data in different formats
Questions: 10 | Attempts: 6799 | Last updated: May 6, 2021
-
Sample QuestionA single set of related data values is referred to as:
Questions: 10 | Attempts: 1527 | Last updated: Oct 5, 2020
-
Sample QuestionWhat is a database?
Questions: 10 | Attempts: 740 | Last updated: Jun 23, 2019
-
Sample QuestionA table called students has to be searched to find out how many males are in the class. Which object can be used to achieve this?
Back to top