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

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

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

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

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

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

6. In database, relationships make use of:

7. Tick the correct match:

8. Data Redundancy means:

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

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

11. Multiple fields make up a:

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

13. Flat file database usually store data as:

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

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

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

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

18. It is the smallest component in a database:

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

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

21. A single entry in a table is called:

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

23. Floating point data type holds:

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

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

26. The Components of ERD include:

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

28. String data type can store:

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

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

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

32. Several data records make up a:

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

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

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

36. A _______ stores data in an organized form.

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

38. Several data tables make up a:

39. In ERD, relationships are symbolically represented by:

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

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

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