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 *