0%

Computer Operator

Database System – Set 1

Dear ! This is Database System – Set 1  Quiz and it contains 50 questions.



Happy Learning!

1 / 50

1. Which of the following statement is true ?

2 / 50

2. To create relationship between two tables

3 / 50

3. What does the show check box in query design window indicate ?

4 / 50

4. Following is not a database model

5 / 50

5. The default and maximum size of text field in access

6 / 50

6. To create a new table , in which method you don’t need to  specify the field type and size ?

7 / 50

7. When  creating a new table  which method can be used to switch between the field names and properties panels ?

8 / 50

8. Which of the following is not a type of relationship that can be applied in Access Database?

9 / 50

9. What are the different views to display a table

10 / 50

10. The relational database environment has all of the following components except

11 / 50

11. What are the difference between ‘open’ and ‘open exclusively ‘ ?

12 / 50

12. Which of the filed has width 8 bytes ?

13 / 50

13. What is the maximum length a text field can be ?

14 / 50

14. A ———- enables you to view data from a table based on a specific criterion

15 / 50

15. Database management systems are intended to

16 / 50

16. Queries in Access can be used as

17 / 50

17. Microsoft Access is a

18 / 50

18. A top-to -bottom relationship among the item in a database is established by a

19 / 50

19. The management information system (MIS) structure with one main computer system is called a

20 / 50

20. Overall design of database is called …….

21 / 50

21. which of the following statement is true ?

22 / 50

22. The language used application programs to request data from the DBMS is referred to as the

23 / 50

23. To create queries in Access

24 / 50

24. One approach to standardization  storing of data ?

25 / 50

25. The third stage in designing a database is when we analyze our tables more closely and create a ——– between tables

26 / 50

26. Referential integrity means

27 / 50

27. Choose the RDBMS which supports full – fledged client sever application development

28 / 50

28. It is an association established between common

29 / 50

29. ………….. is an interface between users and the various databases

30 / 50

30. A database  language concerned with the definition of the whole database structure and schema is ————-

31 / 50

31. The highest level in the hierarchy of data organization is called

32 / 50

32. What are the columns in a Microsoft access table called ?

33 / 50

33. While creating relationship , when you drag a field of a field to drop into another table the mouse pointer changes into

34 / 50

34. Which of the following creates a drop down list of values to choose from ?

35 / 50

35. What is a form in ms ACCESS ?

36 / 50

36. DCL provides commands to perform actions like

37 / 50

37. In a database table , the category of information is called ———–

38 / 50

38. In one-to-many relationship the table in ‘one’ side is called ———— and on ‘many’ side is called ———–

39 / 50

39. A form defined

40 / 50

40. The database language that allows you to access or maintain data in a database

41 / 50

41. This is the stage in database design where one gathers and lists all the necessary fields for the database project .

42 / 50

42. Query design window has two parts . the Upper part shows

43 / 50

43. Report generator are used to

44 / 50

44. Which of the following is a method to create a new table in ms access ?

45 / 50

45. The command center of access file that appears when you create or open the my access Database file

46 / 50

46. Two Tables can be linked with relationship so that the data integrity can be enforced. where can you find relationship Command ?

47 / 50

47. In table design view what are the first column of buttons used for

48 / 50

48. This key uniquely identifies each record in table

49 / 50

49. Which of the following is not  a database object ?

50 / 50

50. Which of the following database object produces the final result to present

Your score is

Share this Quiz with your friends! 

LinkedIn Facebook
0%

Exit

You cannot copy content of this page

Scroll to Top