Prev 1 2 3 4 5 Next
1. In an E-R diagram, attributes are represented by ________.
A. Rectangle
B. Square
C. Ellipse
D. Circle
ANSWER:C
SOLUTION : In an Entity Relationship (ER) diagram, attributes are represented by ellipses.
2. Relationship can be divided in to __________.
A. One to one
B. Many to many
C. One to many
D. All of these
ANSWER:D
SOLUTION:In general, tables can be related in one of three different ways: one-to-one, one-to-many or many-to-many. The relationship is used to cross reference information between tables.
3. Press _____ to quit MS Access.
A. Tab +F4
B. Esc+ W
C. Ctrl +F4
D. Alt+F4
ANSWER:D
SOLUTION:To quit MS Access, you can press Alt + F4. Alt + F4 is a keyboard shortcut that closes the current active window.
4. A _____ is an area reserved for a specific piece of data.
A. Report
B. Key
C. Record
D. Field
ANSWER:D
SOLUTION:A field is an area in a table that is reserved for a specific piece of data. A field is also known as an attribute, and is a component of a record that contains a single piece of data for the record’s subject.
5. Which of the following is not a type of MS Access database object?
A. Table
B. Form
C. Worksheets
D. Modules
ANSWER:C
SOLUTION: Worksheets are not a type of Microsoft Access database object. Worksheets are a feature of Microsoft Excel, which is a separate application in the Microsoft Office suite.
6. The size of yes/no field is always ________.
A. 1 bit
B. 1 Byte
C. 1 Character
D. 1KB
ANSWER:A
SOLUTION :The size of yes/no field is always 1 bit .
7. How can we create a query in Microsoft Access?
A. Drag and drop fields
B. Type the SQL
C. Use query wizard
D. All of above
ANSWER: D
SOLUTION:In Microsoft Access, you can create queries by dragging and dropping fields, typing the SQL, or using the query wizard.
8. A single set of related data values is referred to as ________.
A. Data value
B. Record
C. Field
D. Table
ANSWER:B
SOLUTION:A single set of related data values is referred to as a record. In a database, a record represents a complete set of information about a specific entity or item.
9. What is used to uniquely identify each record in a table?
A. Foreign key
B. Field
C. Datatype
D. Primary key
ANSWER:D
SOLUTION:A primary key is used to uniquely identify each record in a table. It is a field or a combination of fields that uniquely identifies a record in a database table.
10. ___________ data type stores date and time values between the years 100 through 9999.
A. Date
B. Time
C. Date/Time
D. Memo
ANSWER:C
SOLUTION:The correct answer is Date/Time. This data type is used to store both date and time values.