2nd Year Computer Chapter 5 Notes

• Important Multiple Choice Questions of 2nd year computer chapter 5 mcqs of 2nd-year Computer Science.
• Q1: To create a new database there is a button named: (a) Open (b) Select (c) Create (d) Retrieve
• Q2: To create a new database in Microsoft Access, which command is used?
• (a) Create New Database (b) File New Database (c) Create Database Wizard (d) Open New Database
• Q3: Microsoft Access saves the database with extension: (a) .mbd (b) .msdb (c) .madb (d) None of these
• Q4: It makes very simple to create a database: (a) Sample database (b) Common standard (c) Wizard (d) Easier programming
• Q5: It is simple to create database using: (a) Query (b) Common standards (c) Easier programming (d) Wizard
• Important 2nd year computer chapter 5 mcqs with answers for Intermediate part-II students.
• Q6: Following represents wizard of DBMS: (a) Database wizard (b) Form wizard (c) Table wizard (d) All of these
• Q7: Following is not included in a database wizard: (a) Template (b) Selecting Fields (c) Customizations (d) Designing Database
• Q8: To create a database without wizard, while opening MS Access a dialog box is displayed: (a) File New Database (b) Insert Blank Database (c) Blank Access Database (d) All of these
• Q9: The ___gives you the most existing database that you have used recently: (a) Black box (b) White Box (c) Check Box (d) None of these
• Q10: To properly exit the MS Access application, Click on File Menu and choose: (a) Close (b) Exit (c) Return (d) Open
• Q11: Which of the following is not a database object? (a) Table (b) Query (c) Form (d) MS - Word
• Q12: A database consists of various components called: (a) Tools (b) Properties (c) Entities (d) Objects
• Important 2nd year computer chapter 5 important mcqs for Intermediate part-II students.
• Q13: Following is a collection of related data organized in rows and columns: (a) Table (b) Query (c) Form (d) Report
• Q14: The major database objects in MS Access is / are: (a) Two (b) Four (c) Three (d) Five
• Q15: A record is complete set of the following type of fields: (a) Distinct (b) Related (c) Designed (d) All of these
• Q16: Following is not a database object:  (a) Form (b) Table (c) Window (d) Query
• Important 2nd year computer chapter 5 short questions for Intermediate part-II students.
• What is Microsoft Access?: Ans: It is one of the most popular and powerful DBMS. It provides the features to the users to create and maintain databases. We can create tables, forms, queries and reports using MS Access.
• Important 2nd year computer chapter 5 important long questions for Intermediate part-II students.
• What is a wizard?: Ans: A wizard is a helper application that makes performing complex tasks easier. A wizard has a simple decision in a window, which has back and next buttons underneath. When you have filled in the required data, you click the next button to go to the next window, or you can click the back button to change your previous decision.
• What is a menu bar?
• Important 2nd year computer chapter 5 long questions for Intermediate part-II students.
• What is a database object?: Ans: A component of a database system is known as database object. These database objects are used to manage data.
• What is a table?
• What is a query?
• What is a form?
• What are reports?
• Important 2nd year computer chapter 5 long questions pdf download for Intermediate part-II students.
• What is an IDE? :Ans: IDE stands for integrated development environment. It is a simple and easy way to do a task. It presents graphical objects like buttons, icons and menus to perform certain operations. Using IDE a new user and programmer can easily do their jobs. MS Access also provides the same facility for its users.