2nd Year Computer Chapter 2 Notes

• Important Multiple Choice Questions of 2nd year computer chapter 2 mcqs of 2nd-year Computer Science.
• Q 1: The concept of database evolved from: (a) Computers (b) Traditional File management system (c) Software (d) Hardware
• Q 2: The number of characters in fixed - length field is: (a) Constant (b) 5 (c) 255 (d) Variable 
• Q 3: The number of characters in variable - length field is: (a) Constant (b) 5 (c) 255 (d) Variable
• Q 4: A Insert command is used to insert: (a) A new record (b) new column (c) A view (d) A new table
• Q 5: The row of table is also called: (a) Entity (b) Attributes (c) Cell (d) Record
• Important 2nd year computer chapter 2 mcqs with answers for Intermediate part-II students.
• Q 6: An attribute is also known as: (a) Record (b) Row (c) Field (d) Tuple
• Q 7: Atomicity means:
• (a) Individual value in a cell (b) Individual value in a table (c) Individual value in a row (d) Individual value in a tuple
• Q 8: Another name for the file is called: (a) Collection records (b) Row (c) Dataset (d) Tuple
• Q 9: The column(s) of a relation correspond to: (a) Table (b) Cell(s) (c) Field(s) (d) Records
• Q10: The columns of a table correspond to: (a) Table (b) Record (c) Field (d) Cell
• Important 2nd year computer chapter 2 important mcqs for Intermediate part-II students.
• Q11: The following represents an entity: (a) Car (b) Student (c) House (d) All of these
• Q12: Teachers, students and cars are example of: (a) Relationships (b) Entity (c) Attributes (d) Identifier
• Q13: A table is also called: (a) Two-dimensional array (b) Relation (c) Both A & B (d) Key
• Q14: A table is a two - dimensional array that consists of:
• (a) Matrix elements       (b) x and y coordinates       (c) Intersection of data      (d) Columns and rows   
• Important 2nd year computer chapter 2 short questions for Intermediate part-II students.
• Define relation. 
• What is an Entity?: Ans: Anything about which we want to store data is called an entity. It can be a person, place or event, etc. Entity always has a unique name with in a domain.
• What is the use of views?
• What is a key?
• Define sort key. Ans: A field or a set of fields in a record that dictates the sequence of the file according to our requirement. For example the sort keys STATE and NAME arrange the table data alphabetically by name within state. STATE is the major sort key, and NAME is the minor sort key.
• Important 2nd year computer chapter 2 important long questions for Intermediate part-II students.
• Define the primary key. Ans: In a relation the attribute or a combination of attributes that uniquely identifies a row or a record. e.g. A social security number, ISBN, student roll number, etc.
• Define the primary key and secondary key.
• Define candidate key and Define composite key.
• Define sort key and  What is the use of the index file.
• Important 2nd year computer chapter 2 long questions for Intermediate part-II students.
• Who is the end user?
• Who is the data administrator?:  Ans: The DA department is responsible for the definition, organization, supervision and protection of data in order to provide good quality, shareable and accessible data throughout the enterprise. The Data Administrator manages a staff that is responsible for establishing and implementing the Data Administration Program. 
• Important 2nd year computer chapter 2 long questions pdf download for Intermediate part-II students.
• Who is the database administrator?
• What is the use of index file? Ans: Indexes are stored in index file. DBMS uses index files to speed up the sorting and searching operations.
• List two properties of a relation.
• Discuss the data manipulation in the DBMS system.