Prev 1 2 3 4 5 Next
11. The attribute means _______.
A. Row
B. Column
C. Entity
D. None of the above
ANSWER:B
SOLUTION : A column can also be called an attribute. Each row would provide a data value for each column and would then be understood as a single structured data value.
12. Which command is used to update existing row in table?
A. Insert
B. Delete
C. Update
D. None of the above
ANSWER:C
SOLUTION:The UPDATE command is used to update existing rows in a table.
13. MS access create files are stored with ____ extensions.
A. .docx
B. .xlsx
C. .accdb
D. .pptx
ANSWER:C
SOLUTION:Microsoft Access files are stored with the .accdb extension by default. This file format was introduced in Access 2007 and is used for versions of Microsoft Access from 2007 to 2016. The .accdb file format supports features like attachments and calculated fields.
14. Default table name when database is created in MS Access _______.
A. Table1
B. Database1
C. Database
D. Spreadsheet
ANSWER:A
SOLUTION:When a database is created in MS Access, the default table name is Table1.
15. Default first column of MS Access table is named as ___
A.Name
B. Date
C. Null
D. Id
ANSWER:D
SOLUTION:The default first column of an MS Access table is named “ID”. .
16. Maximum number of characters allowed in text field in MS access _________.
A. 255
B. 256
C. 512
D. None of these
ANSWER:A
SOLUTION : Microsoft Access’s Short Text field can store up to 255 characters by default.
17. OLE stands for ________.
A. Object Linking & Embedding
B. Object Linking & Encrypting
C. Object linking and Editing
D. Object Linking
ANSWER: A
SOLUTION:OLE stands for Object Linking and Embedding. It’s a Microsoft technology that allows users to create and edit documents that contain items from multiple applications.
18. Which of the following database object hold data?
A. Reports
B. Tables
C. Forms
D. All of these
ANSWER:B
SOLUTION:Tables are the database objects that hold data in a database.
19. MS access provides visual environment for design of ___ _______.
A. Tables
B. Reports
C. Forms
D. All of these
ANSWER:D
SOLUTION:Microsoft Access provides a visual environment for designing tables, forms, reports, and queries.
20. A collection of interrelated record is called a ______.
A. Utility file
B. Management information system
C. Database
D. Spreadsheet
ANSWER:C
SOLUTION:A collection of interrelated records is called a database.