Computer Operator
Database System – Set 1
Dear ! This is Database System – Set 1 Quiz and it contains 50 questions.
1 / 50
1. Overall design of database is called …….
2 / 50
2. DCL provides commands to perform actions like
3 / 50
3. While creating relationship , when you drag a field of a field to drop into another table the mouse pointer changes into
4 / 50
4. What are the difference between ‘open’ and ‘open exclusively ‘ ?
5 / 50
5. Report generator are used to
6 / 50
6. Which of the following is not a database object ?
7 / 50
7. In table design view what are the first column of buttons used for
8 / 50
8. Which of the following creates a drop down list of values to choose from ?
9 / 50
9. Which of the following is not a type of relationship that can be applied in Access Database?
10 / 50
10. When creating a new table which method can be used to switch between the field names and properties panels ?
11 / 50
11. The relational database environment has all of the following components except
12 / 50
12. In a database table , the category of information is called ———–
13 / 50
13. Which of the following database object produces the final result to present
14 / 50
14. The highest level in the hierarchy of data organization is called
15 / 50
15. The default and maximum size of text field in access
16 / 50
16. This is the stage in database design where one gathers and lists all the necessary fields for the database project .
17 / 50
17. The management information system (MIS) structure with one main computer system is called a
18 / 50
18. ………….. is an interface between users and the various databases
19 / 50
19. The language used application programs to request data from the DBMS is referred to as the
20 / 50
20. The third stage in designing a database is when we analyze our tables more closely and create a ——– between tables
21 / 50
21. What are the different views to display a table
22 / 50
22. A top-to -bottom relationship among the item in a database is established by a
23 / 50
23. Two Tables can be linked with relationship so that the data integrity can be enforced. where can you find relationship Command ?
24 / 50
24. Microsoft Access is a
25 / 50
25. To create a new table , in which method you don’t need to specify the field type and size ?
26 / 50
26. which of the following statement is true ?
27 / 50
27. What is the maximum length a text field can be ?
28 / 50
28. The database language that allows you to access or maintain data in a database
29 / 50
29. In one-to-many relationship the table in ‘one’ side is called ———— and on ‘many’ side is called ———–
30 / 50
30. Which of the following is a method to create a new table in ms access ?
31 / 50
31. What does the show check box in query design window indicate ?
32 / 50
32. Database management systems are intended to
33 / 50
33. A ———- enables you to view data from a table based on a specific criterion
34 / 50
34. One approach to standardization storing of data ?
35 / 50
35. To create queries in Access
36 / 50
36. It is an association established between common
37 / 50
37. Following is not a database model
38 / 50
38. Which of the following statement is true ?
39 / 50
39. What is a form in ms ACCESS ?
40 / 50
40. Queries in Access can be used as
41 / 50
41. Referential integrity means
42 / 50
42. A database language concerned with the definition of the whole database structure and schema is ————-
43 / 50
43. To create relationship between two tables
44 / 50
44. This key uniquely identifies each record in table
45 / 50
45. The command center of access file that appears when you create or open the my access Database file
46 / 50
46. What are the columns in a Microsoft access table called ?
47 / 50
47. Choose the RDBMS which supports full – fledged client sever application development
48 / 50
48. Query design window has two parts . the Upper part shows
49 / 50
49. A form defined
50 / 50
50. Which of the filed has width 8 bytes ?
Your score is
Restart quiz Exit
You cannot copy content of this page