Introduction to Database System – Online MCQs Test – Computer Science 9th

1. Flat file database usually store data as:

2. The shape that is used to represent an attribute in an ERD is:

3. Usually a third entity known as "junction table" is used to create the:

4. In a database table of “Students”, the particulars of a single student will be a:

5. In database, relationships make use of:

6. This shape is used to define an entity in ERD.

7. The most common type of relationship used in relational databases is:

8. It is the smallest component in a database:

9. It is a collection of data elements organized in shape of rows and columns:

10. Tick the correct match:

11. There are three most important components of data models, which are:

12. (5.6, 3.14, 554.9) are the examples of the data types called:

13. The data types which holds only whole numbers is called:

14. (145, -35, 74586) are the examples of the data types called:

15. Several data records make up a:

16. In ERD, relationships are symbolically represented by:

17. Floating point data type holds:

18. A contact list is one of the simplest example of a:

19. (1,0) are the example of the data types called:

20. Data Redundancy means:

21. The basic limitation of a flat file database is that:

22. Several data tables make up a:

23. A single entry in a table is called:

24. A _______ stores data in an organized form.

25. It is process of developing conceptual representation of data objects and their relations.

26. A database is composed of ______ which contain rows and columns.

27. The relationship that matches one record of an entity with only one record of another entity is called:

28. Which of the following Microsoft Office packages is a DBMS?

29. The marks record prepared by a class teacher is also an example of a table.

30. A key that defines a relationship between two entities is called:

31. Multiple fields make up a:

32. String data type can store:

33. A key that allows only unique entries in a field is called:

34. With the help of a junction table, many-to-many relationship is a combination of two:

35. In a relational database, keys are used to create a:

36. They are used to express how the information will be stored in database.

37. A database is composed of rows and columns which are called:

38. The Components of ERD include:

39. In a database table of “Students”, the address of the student will be a:

40. (01-01-2020 11:30 ) are the example of the data types called:

41. This type of relationship is used to divide larger entities into smaller ones.

42. A field that stores the names of students should be defined as: