Database Table and queries Solved MCQs

Database Table and queries Solved MCQs

1. An actual data of the database is stored in?
A. Table
B. field
C. query
D. report2
Ans: A
2. A signal piece of information in the relational database is stored in
A. entity
B. relationship
C. object
D. field
Ans: D
3. The default data types in MS-Access is
A. text
B. auto number
C. currency
D. none of these
Ans: A
4. The following type of field is used to store numeric data?
A. field
B. column
C. text
D. currency
Ans: D
5. The relation or table a number of fields are called?
A .state of relation
B. cardinality of the relation
C. Degree of relation
D. none of these
Ans: C
6. Text type field maximum length is
A.160 character
B.255 character
C.200 character
D.A&B both
Ans: B
7. The memo is stored the more than………….character?
A.64
B.4600
C.6400
D.640
Ans: C
8. The following type of field is used for?
A. memo
B. text
C. character
D. currency
Ans: B
9. All the data in a table is entered in
A. design view
B. datasheet view
C. access view
D. edit view
Ans: B
11. How many types of relationships?
A.6
B.3
C.5
D.1
Ans: B
12. The wild character is represented as?
A. <
B. –
C. *
D.?
Ans: C
13. The following type of file can be indexed in?
A.E-R diagram
B. number
C. hypertext
D. hyperlink
Ans: B
14. The fundamental concept of the relational database is?
A. table
B. relationship
C. text
D. form
Ans: A
15. Which field helps to store the name of the student in MS-Access?
A. memo
B. number
C. currency
D. text
Ans: D
16. The object of MS-Access in the database is?
A. form
B. relationship
C. tables
D.A & C both
Ans: D
17. The logical data type in MS-Access is represented as?
A. yes \ no
B. auto number
C. currency
D. none of these
Ans: A
18. The table views are available in MS-Access how many?
A.6
B.2
C.3
D.8
Ans: B
19. In a table, the number of rows or records is called?
A. Cardinality relation
B. relationships
C. degree of relation
D. state of relation
Ans: A
20. That one is not considered as the example of data type in MS-Access?
A. form
B. text
C. menu
D. currency
Ans: C
21. This is not the example of an action query?
A. select
B. update
C. modify
D. delete
Ans: A
22. The following menus contain s find and replace command?
A. view
B. edit
C. delete
D. find
Ans: B
23. The result collection of the record is called?
A. query
B. dynamic
C. form
D. table
Ans: B
24. The association established between common fields in two tables is called:
A. integrity constraints
B. integrity
C. relationship
D. entity
Ans: C
25. How we can create the sequence of numbers in MS-Access automatically?
A. number
B. currency
C. auto number
D. text
Ans: C