Computer Operator
Database System – Set 6
Dear ! This is Database System – Set 6 Quiz and it contains 48 questions.
1 / 48
1. Collection of related records in a
2 / 48
2. Query design window has two parts. The upper part shows
3 / 48
3. An Attribute in a relation is a foreign key if the ————-key from one relation is used as an attribute in that relation
4 / 48
4. Which of the following term is leas related to database ?
5 / 48
5. Which one of the following attribute can be taken as a primary key ?
6 / 48
6. The size of yes No field is always
7 / 48
7. It is a database object to view, change and analyze data in different ways
8 / 48
8. It is a query that when run display its own dialog box prompting you for information such as
9 / 48
9. Which denote one to many relationship between student and class table ?
10 / 48
10. What do you mean by one to many relationships between student and class table ?
11 / 48
11. A database object in MS access that stores a question about the data in database ?
12 / 48
12. Each record is constituted by a number of individual data item which are called
13 / 48
13. This option allows you to build a new table by entering data directly into the datasheet
14 / 48
14. A small button with three dots usually displayed at the right of field properties box
15 / 48
15. It is an association established between common fields of two tables .
16 / 48
16. It is the most common type of query , It retrieves records from one or more tables and then display the
17 / 48
17. Which field type can store photos ?
18 / 48
18. When entering field name, how many character you can type in maximum ?
19 / 48
19. Unlike text data type , this can store up to maximum of 65,535 characters.
20 / 48
20. Which of the following may not be a database ?
21 / 48
21. To achieve and Effect when you entering criteria in a query design window
22 / 48
22. Both conditions display on the same row in the design grid when ___ operator in use
23 / 48
23. The database language concerned with the definition of the whole database structure and schema is ________
24 / 48
24. Which one of the following is a procedural language ?
25 / 48
25. If you write criteria values vertically(one in a row) it will mean
26 / 48
26. When a picture or other graphic image is placed in the report header section it will appear___
27 / 48
27. The size of a field with Number data type cannot be
28 / 48
28. Database Management Systems are features with:
29 / 48
29. A part of database that stores only one type of data is
30 / 48
30. Which of the following creates drop down list of values to choose form a list ?
31 / 48
31. Using which language can a user request information from a database ?
32 / 48
32. The ___operator will cause a record to be selected only if two or more conditions are satisfied
33 / 48
33. A database can be best described as
34 / 48
34. This data type allows alphanumeric characters and special symbols.
35 / 48
35. An access database object that is used to enter, view or edit records
36 / 48
36. A search value can be an exact value or it can be
37 / 48
37. The task of arranging data in order is called
38 / 48
38. It is a sign or symbol that specifies, operator, and values that produce a result
39 / 48
39. It is used to calculate and restructure data for easies analysis of your data . it calculates the sum,
40 / 48
40. We can remove a relationship defined between two tables by
41 / 48
41. A composite key is
42 / 48
42. Every table in relational database contain a field or combination of fields that can uniquely identify each records it is called
43 / 48
43. Which of the following is not a field type in Access
44 / 48
44. you can automatically include all of the field in a table in a query by ____ a strike that appear list box in query design view
45 / 48
45. Which of the following expresses correct order ?
46 / 48
46. If you need to edit a relationship
47 / 48
47. Which of the following can be an example of a database ?
48 / 48
48. What is the column in a Microsoft access table called ?
Your score is
Restart quiz Exit
You cannot copy content of this page
