 |
| Computer Science 12th Chapter 2 - Basic Concepts and Terminologies of Databases Questions Bank |
Computer Science 2nd Year Chapter 2 - Basic Concepts and Terminologies of Databases Solved MCQs, Important Short Questions and Long Questions Bank
MCQs
Please select the right answer.
1. ______ are created to keep the data safe and secure from un authorized and illegal users
2. ⎯⎯⎯⎯ is known as control key :
3. ⎯⎯⎯⎯ is responsible for designing, coordinating and monitoring the database system :
4. ⎯⎯⎯⎯ is used to create data view :
5. ⎯⎯⎯⎯ is used to uniquely identify records of a relation :
6. ⎯⎯⎯⎯ represents an entity :
7. ⎯⎯⎯⎯ serves as a bridge between end users and database administrator :
8. A key is
9. A key strictly used for data retrieval purposes is called:
10. A key that consists of two or more than two attributes of a table is called
11. A non unique field is called
12. A person who is responsible for the organization of entire data of an organization
13. A person who is responsible for the security and maintenance of database
14. A person, place, event or anything about which data is collected and stored in a database is called :
15. A table is also known as :
16. A table is also known as
17. A table must have :
18. A tuple in a table is also known as
19. All the data stored on the hard disk as a combination of
20. An attribute is also known as :
21. An attribute of a relation of a database that serves as a primary key of another relation in the same database is called :
22. An index can be used to:
23. Another name for composite key is
24. Another name for file is
25. Anything in the real world that has a set of different attributes or properties is called :
26. Atomicity refers to the
27. CREATE command is used to create:
28. CREATE TABLE command is used to create a :
29. Field is another name of
30. How many primary keys can a relation have :
31. In the presence of more than one unique fields, one is primary and other one is called
32. In the Relation ___________ is insignificant
33. Insert command is used to insert.
34. SQL is used for
35. The attribute or a combination of attributes used to uniquely identify a row in a table.
36. The column of a relation is known as
37. The columns of a relation can be of order
38. The columns of a relation correspond to :
39. The columns of a table correspond to
40. The concept of database evolved from old
41. The foreign key is found in
42. The number of characters in fixed-length field is:
43. The rows of a relation can be of
44. The rows of a table or relation are known as :
45. The views are used:
46. To create view ________ statement is also used
47. To physically sequence the stored data __________ key is used
48. View is stored in the
49. Views are also called:
50. Which of the following describes the primary key?
51. Which of the following is also known as control key?
52. Which of the following is NOT a good primary key?
53. Which of the following is responsible for designing the database system.
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?