COPA Mock Test 8 - Database Management Systems

1. What is the maximum number of characters allowed in a text field in Access?

a) 255 b) 256 c) 64000 d) 65000

2. What is the expansion of OLE in Access?

a) Object Linking and Embedding b) Object Linking and Encrypting c) Object Linking and Editing d) Object Linking

3. What is the maximum length of the field name in Access?

a) 16 characters b) 32 characters c) 64 characters d) 128 characters

4. Which view is used to arrange table data in different graphical layouts to summarize data?

a) Table view b) Design view c) Data sheet view d) Pivot chart view

5. Which view allows you to modify a table's structure in Access?

a) Design view b) Datasheet view c) Pivot table view d) Pivot chart view

6. Which object stores information about related data?

a) Document b) Table c) Page d) Screen

7. Which keystroke is used to move the active cell towards right in an Access table?

a) Ctrl + Tab b) Alt + Tab c) Tab d) Shift + Tab

8. Which keystroke moves the active cell towards left in an Access table?

a) F2 b) F5 c) Tab d) Shift + Tab

9. Which combination of keys zooms the content of the active cell in an Access table?

a) Ctrl + F2 b) Ctrl + F5 c) Shift + F2 d) Shift + F5

10. Which combination of keys allows the user to move to the first field in the first record in an Access table?

a) Ctrl + Tab b) Shift + Tab c) Shift + Home d) Ctrl + Home

11. Which command quickly locates data in an Access table?

a) Find b) Locate c) Search d) Edit

12. Which technique prevents invalid data from being saved in an Access table?

a) Index b) Filter c) Validation rule d) Input mark

13. Which validation rule accepts only 'a' to 'z' letters for fields in Access?

a) Is null or NOT like “*[! a - z]*” b) Is null or NOT like “*[a - z ]*” c) Is null or NOT like “*![a - z]*” d) Is null or NOT like “[! a - z]”

14. Which validation rule allows only '0' to '9' for fields in Access?

a) Is Null or Not Like “*[ ! 0 - 9 ]*” b) Is Null or Not Like “[! 0 - 9]” c) Is Null or Not Like “*[0 - 9]*” d) Is Null or Not Like “*[!0-9]*”

15. Which validation rule allows only positive numbers for fields in Access?

a) Is Null or >= 0 b) Is Null or Positive c) Is Null or < 0 d) Is Null or = “+”

16. What is allowed by the input mark symbol '#' in Access?

a) Letter or digit b) Letter A through Z c) A digit 0 - 9 with +/- sign d) A digit 0 - 9 without +/- sign

17. Which validation rule allows exactly digits for number fields in Access?

a) Is Null or Between 100000 and 99999 b) Is Null or Like “????” c) Is Null or >= 0 AND <= 99999 d) Is Null or <= 99999

18. What is the output when the data '1678.95' is set to the number format '###0.00' in Access?

a) 1670.00 b) 1670.95 c) 1678.00 d) 1678.95

19. Which of the following is a valid time format in Access?

a) hh:mm:ss AM/PM b) hh.mm.ss AM/PM c) hh-mm-ss AM/PM d) hh/mm/ss AM/PM

20. Write the output when the data 'Primary Key' is set to the text format < in Access?

a) Primary key b) primary key c) PRIMARY KEY d) Primary Key

21. What is the output when the data 'FOREIGN key' is set to the text format > in Access?

a) foreign key b) FOREIGN KEY c) Foreign Key d) Foreign key

22. What is the reason for not accepting zero in the fields of Access tables?

a) Fields are set with Is Null or > 0 b) Fields are set with Is Null or <= 0 c) Fields are set with Is Null or ![0] d) Fields are set with Is Null or like "?"