2nd Year Computer Chapter 6 Notes

• Important Multiple Choice Questions of 2nd year computer chapter 6 mcqs of 2nd-year Computer Science.
• Q1: How many table views are available in MS - Access? (a) 1 (b) 2 (c) 3 (d) 4
• Q2: The following is the fundamental concept of relational database: (a) Query (b) Table (c) Form (d) Report
• Q3: In a relational database, a single piece of information is called: (a) Field (b) Attribute (c) Entity (d) Both A & B 
• Q4: Following view is used to add, edit and delete records form the table:
•  (a) Design View       (b) Record view       (c) Datasheet View      (d) Edit View 
• Q5: Following menu in MS - Access contains commands that can be used to switch between table views:
•  (a) File            (b) View         (c) Edit         (d) Tool 
• Important 2nd year computer chapter 6 mcqs with answers for Intermediate part-II students.
• Q6: Following is the object of MS - Access database file: (a) Queries (b) Tables (c) Forms (d) All of these
• Q7: ___is the interface between the user and the database: (a) Data (b) Degree (c) IDE (d) Desktop
• Q8: ___object is used to enter data into the database: (a) Tables (b) Forms (c) Reports (d) Query
• Q9: Following is the default field size of Text data type in MS - Access: (a) 100 (b) 50 (c) 255 (d) 150 
• Q10: Following type of field cannot be used as key field: (a) Memo (b) Auto Number (c) Text (d) Number
• Important 2nd year computer chapter 6 important mcqs for Intermediate part-II students.
• Q11: Following type of field is used to store the URL address of any website: 
• (a) Text (b)         Hyper Link           (c) OLE object                (d) Memo
• Q12: Following controls the value of record and sets it in a specific format: 
• (a) Field Validation Rules        (b) Input Mak        (c) Caption      (d) Indexes
• Q13: Following allows to query and records faster while using MS - Access: 
• (a) Key       (b) Primary key        (c) Index     (d) All of these
• Q14: For following data type , user does not require to enter data for that field: 
• (a) Number        (b) Auto Number       (c) Automatic Number       (d) Memo
• Q15: What symbol indicates that you are editing a record ?
•  (a) Pencil        (b) Black arrow         (c) Key         (d) Asterisk
• Important 2nd year computer chapter 6 short questions for Intermediate part-II students.
• What is a table? : A table is a collection of rows and columns. Each intersection of row and column is called a cell. Cell is the place where data is placed. Table is the fundamental object of relational database. Table is also known as relation. Each row represents a tuple and each column represents an attribute of an entity. Table or relation itself represents an entity.
• Important 2nd year computer chapter 6 important long questions for Intermediate part-II students.
• What is meant by the degree of relation?
• What is meant by the cardinality of the relation?
• What are two table views available in Microsoft Access?
• What is the Test data type?
• What is the Memo data type?
• What is the Number data type?
• Important 2nd year computer chapter 6 long questions for Intermediate part-II students.
• What is the AutoNumber data type?
• What is the use of the Default view?
• What is sorting?   and What is referential integrity?
• What is a query?  and  What is a join? 
• What are wildcards?
• Important 2nd year computer chapter 6 long questions pdf download for Intermediate part-II students.
• Define criteria in a query. Ans: A condition used to limit the number of rows extracted from database is called criteria. For example, instead of viewing all the suppliers that your company uses, you can view just suppliers form China. To do this, you specify a criterion that limits the results to records whose Country field is "China".