0%

Computer Operator

Database System – Set 6

Dear ! This is Database System – Set 6  Quiz and it contains 48 questions.



Happy Learning!

1 / 48

1. This option allows you to build a new table by entering data directly into the datasheet

2 / 48

2. Which of the following is not a field type in Access

3 / 48

3. A composite key is

4 / 48

4. Unlike text data type , this can store up to maximum of 65,535 characters.

5 / 48

5. The size  of yes No field is always

6 / 48

6. Which of the following creates drop down list of values to choose form a list ?

7 / 48

7. What do you mean by one to many relationships between student and class table ?

8 / 48

8. Collection of related records in a

9 / 48

9. Which denote one to many relationship between student and class table ?

10 / 48

10. A part of database that stores only one type of data is

11 / 48

11. Which of the following can be an example of a database ?

12 / 48

12. It is the most common type of query , It retrieves records from one or more tables and then display the

13 / 48

13. This data type allows alphanumeric characters and special symbols.

14 / 48

14. Which one of the following attribute can be taken as a primary key ?

15 / 48

15. Every table in relational database contain a field or combination of fields that can uniquely identify each records it is called

16 / 48

16. Which field type can store photos ?

17 / 48

17. It is a sign or symbol that specifies, operator, and values that produce a result

18 / 48

18. It is used to calculate and restructure data for easies analysis of your data . it calculates the sum,

19 / 48

19. A database object in MS access that stores a question about the data in database ?

20 / 48

20. It is an association established between common fields of two tables .

21 / 48

21. A small button with three dots usually displayed at the right of field properties box

22 / 48

22. It is a database object to view, change and analyze data in different ways

23 / 48

23. Query design window has two parts. The upper part shows

24 / 48

24. Which one of the following is a procedural language ?

25 / 48

25. When entering field name, how many character you can type in maximum ?

26 / 48

26. Which of the following expresses correct order ?

27 / 48

27. When a picture or other graphic image is placed in the report header section it will appear___

28 / 48

28. If you need to edit a relationship

29 / 48

29. Which of the following may not be a database ?

30 / 48

30. It is a query that when run display its own dialog box prompting you for information such as

31 / 48

31. The size of a field with Number data type cannot be

32 / 48

32. The ___operator will cause a record to be selected only if two or more conditions are satisfied

33 / 48

33. Both conditions display on the same row in the design grid when ___ operator in use

34 / 48

34. Each record is constituted by a number of individual data item which are called

35 / 48

35. 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

36 / 48

36. We can remove a relationship defined between two tables by

37 / 48

37. The task of arranging data in order is called

38 / 48

38. Which of the following term is leas related to database ?

39 / 48

39. A search value can be an exact value or it can be

40 / 48

40. The database language concerned with the definition of the whole database structure and schema is ________

41 / 48

41. An access database object that is used to enter, view or edit records

42 / 48

42. To achieve and Effect when you entering criteria in a query design window

43 / 48

43. An Attribute in a relation is  a foreign key if the ————-key from one relation is used as an attribute in that relation

44 / 48

44. Using which language can a user request information from a database ?

45 / 48

45. What is the column in a Microsoft access table called ?

46 / 48

46. A database can be best described as

47 / 48

47. If you write criteria values vertically(one in a row) it will mean

48 / 48

48. Database Management Systems are features with:

Your score is

Share this Quiz with your friends! 

LinkedIn Facebook
0%

Exit

You cannot copy content of this page

Scroll to Top