2nd Year Computer Science Chapter 2 Basic Concepts and Terminologies of Databases Notes MCQs Bank

computer 12th notes chapter No 2

1. A table is also known as : 

 
 
 
 

2. ⎯⎯⎯⎯ is used to create data view : 

 
 
 
 

3. ⎯⎯⎯⎯ serves as a bridge between end users and database administrator :  

 
 
 
 

4. The views are used:

 
 
 
 

5. The columns of a relation correspond to : 

 
 
 
 

6. The foreign key is found in 

 
 
 
 

7. A person who is responsible for the organization of entire data of an organization  

 
 
 
 

8. The rows of a relation can be of

 
 
 
 

9. A key is

 
 
 
 

10. In the presence of more than one unique fields, one is primary and other one is called 

 
 
 
 

11. An attribute of a relation of a database that serves as a primary key of another  relation in the same database is called : 

 
 
 
 

12. ⎯⎯⎯⎯ is known as control key : 

 
 
 
 

13. Which of the following is also known as control key?

 
 
 
 

14. Anything in the real world that has a set of different attributes or properties is  called : 

 
 
 
 

15. Which of the following is responsible for designing the database system. 

 
 
 
 

16. Insert command is used to insert. 

 
 
 
 

17. The rows of a table or relation are known as : 

 
 
 
 

18. How many primary keys can a relation have : 

 
 
 
 

19. ⎯⎯⎯⎯ represents an entity : 

 
 
 
 

20. The columns of a table correspond to

 
 
 
 

21. To create view ________ statement is also used 

 
 
 
 

22. An index can be used to:

 
 
 
 

23. The number of characters in fixed-length field is:

 
 
 
 

24. ______ are created to keep the data safe and secure from un authorized and illegal users  

 
 
 
 

25. Atomicity refers to the 

 
 
 
 

26. SQL is used for 

 
 
 
 

27. An attribute is also known as : 

 
 
 
 

28. View is stored in the 

 
 
 
 

29. Another name for composite key is 

 
 
 
 

30. Which of the following is NOT a good primary key?

 
 
 
 

31. Another name for file is 

 
 
 
 

32. The concept of database evolved from old 

 
 
 
 

33. A key strictly used for data retrieval purposes is called:

 
 
 
 

34. A person, place, event or anything about which data is collected and stored in a database is called : 

 
 
 
 

35. Views are also called:

 
 
 
 

36. To physically sequence the stored data __________ key is used  

 
 
 
 

37. ⎯⎯⎯⎯ is responsible for designing, coordinating and monitoring the database  system : 

 
 
 
 

38. A key that consists of two or more than two attributes of a table is called  

 
 
 
 

39. A person who is responsible for the security and maintenance of database  

 
 
 
 

40. Field is another name of 

 
 
 
 

41. A non unique field is called 

 
 
 
 

42. ⎯⎯⎯⎯ is used to uniquely identify records of a relation : 

 
 
 
 

43. Which of the following describes the primary key?

 
 
 
 

44. All the data stored on the hard disk as a combination of 

 
 
 
 

45. CREATE TABLE command is used to create a : 

 
 
 
 

46. CREATE command is used to create:

 
 
 
 

47. The attribute or a combination of attributes used to uniquely identify a row in a  table.

 
 
 
 

48. The column of a relation is known as 

 
 
 
 

49. In the Relation ___________ is insignificant 

 
 
 
 

50. A tuple in a table is also known as 

 
 
 
 

51. The columns of a relation can be of order

 
 
 
 

52. A table must have : 

 
 
 
 

53. A table is also known as 

 
 
 
 

Short Questions

1. Define composite key.
2. Define composite key/concatenate key?
3. Define foreign key.
4. Define key.
5. Define primary key.
6. Define relation.
7. Define secondary key.
8. Define sort key.
9. Define the term table or relation.
10. Define view.
11. Differentiate between candidate key and primary key.
12. Differentiate between database field and record?
13. Differentiate between parent and dependent (child) tables?
14. Differentiate between secondary key and primary key.
15. Distinguish between primary key and foreign key.
16. How a relation is formed in database?
17. How are views created?
18. How is data handled in file management system?
19. How to create a view in SQL?
20. List any four properties of a relation.
21. List different types of keys.
22. List two properties of a relation.
23. What are dependent and parent relations?
24. What are the indexes?
25. What are the properties of a relation?
26. What are the views?
27. What do you mean by candidate key and alternate key?
28. What is a database?
29. What is a file?
30. What is a foreign key?
31. What is a key?
32. What is a primary key?
33. What is a secondary key?
34. What is a sort/control key?
35. What is an entity?
36. What is secondary key?
37. What is SQL?
38. What is the advantage of index in FMS and DBMS?
39. What is the basic purpose of using views?
40. What is the candidate key / alternate key?
41. What is the composite / concatenate key?
42. What is the difference between fixed-length field and variable length field?
43. What is the purpose of index file?
44. What is the use of views?
45. Who is a data administrator?
46. Who is data administrator?
47. Who is end user?
48. Who is the Data Administrator (DA)?
49. Who is the Database Administrator (DBA)?
50. Who is the user OR end user?
51. Why are keys defined in tables?
52. Write three responsibilities of a database administrator.

Long Questions

1. What are indexes? What is their usage in FMS & DBMS?
2. Discuss data manipulation in a database management system.
3. What is a field, record and file? Also explain that how data is handled (stored and accessed) in file management system (FMS)?
4. What is relational database system? Also describe its different data elements.
5. What is a relation (table)? Also describe its different properties.
6. What are views? Also discuss their uses.
7. What is a key? Also different types of keys?
8. Define the term user? Also explain the role of data and database administrator?

Leave a Reply

Your email address will not be published. Required fields are marked *