Big data analysis MCQs

1. Q#1:

2. An actual data of the database is stored in?

(A) Table

(B) Field

(C) Query

(D) Report

3. A single piece of information in the relational database is stored in?

(A) Entity

(B) Relationship

(C) Object

(D) Field

4. The default data type in MS-Access is?

(A) Auto Number

(B) Text

(C) Currency

(D) None of these

5. Which of the following field types is used to store numeric data?

(A) Field

(B) Column

(C) Text

(D) Currency

6. In a table or relation, the number of fields is called?

(A) State of Relation

(B) Cardinality of the Relation

(C) Degree of Relation

(D) None of these

7. The maximum length of a text type field is?

(A) 160 characters

(B) 255 characters

(C) 200 characters

(D) A & B both

8. A memo field can store more than how many characters?

(A) 64

(B) 4600

(C) 6400

(D) 640

9. The following type of field is used for storing characters?

(A) Memo

(B) Text

(C) Character

(D) Currency

10. All the data in a table is entered in which view?

(A) Design View

(B) Datasheet View

(C) Access View

(D) Edit View

11. How many types of relationships exist in MS-Access?

(A) 3

(B) 6

(C) 5

(D) 1

12. Which symbol represents the wildcard character in MS-Access?

(A) <

(B) –

(C) *

(D) ?

13. Which type of field can be indexed?

(A) E-R Diagram

(B) Number

(C) Hypertext

(D) Hyperlink

14. The fundamental concept of a relational database is?

(A) Table

(B) Relationship

(C) Text

(D) Form

15. Which field type is used to store the name of a student in MS-Access?

(A) Memo

(B) Number

(C) Currency

(D) Text

16. Which are considered database objects in MS-Access?

(A) Form

(B) Relationship

(C) Tables

(D) A & C both

17. The logical data type in MS-Access is represented as?

(A) Yes / No

(B) Auto Number

(C) Currency

(D) None of these

18. How many table views are available in MS-Access?

(A) 6

(B) 2

(C) 3

(D) 8

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

20. Which one is not considered a data type in MS-Access?

(A) Form

(B) Text

(C) Menu

(D) Currency

21. Which is not an example of an action query in MS-Access?

(A) Select

(B) Update

(C) Modify

(D) Delete

22. Which menu contains the Find and Replace command?

(A) View

(B) Edit

(C) Delete

(D) Find

23. The result collection of records is called?

(A) Query

(B) Dynamic

(C) Form

(D) Table

24. The association between common fields in two tables is called?

(A) Integrity Constraints

(B) Integrity

(C) Relationship

(D) Entity

25. How can we create a sequence of numbers in MS-Access automatically?

(A) Number

(B) Currency

(C) Auto Number

(D) Text