Computer Operator
Database System – Set 1
Dear ! This is Database System – Set 1 Quiz and it contains 50 questions.
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
Restart quiz Exit
You cannot copy content of this page