KEMBAR78
2nd Com-Ch5test2 | PDF | Relational Database | Microsoft Access
Scribd
Upload
206 views3 pages

2nd Com-Ch5test2

This document contains a test for a Computer Science student consisting of multiple choice questions and essay questions about databases and Microsoft Access. The multiple choice section contains 10 questions worth 1 mark each. The essay sections contain short answer questions worth 2 marks each and longer answer questions worth 8 marks each, requiring descriptions of database concepts and advantages of using MS Access. The test is out of a total of 75 marks and covers database topics like objects, tables, queries, forms and reports.

Uploaded by

Mohammad Ashfaq
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
206 views3 pages

2nd Com-Ch5test2

This document contains a test for a Computer Science student consisting of multiple choice questions and essay questions about databases and Microsoft Access. The multiple choice section contains 10 questions worth 1 mark each. The essay sections contain short answer questions worth 2 marks each and longer answer questions worth 8 marks each, requiring descriptions of database concepts and advantages of using MS Access. The test is out of a total of 75 marks and covers database topics like objects, tables, queries, forms and reports.

Uploaded by

Mohammad Ashfaq
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

BRAIN TEST SYSTEM

FOR SOLUTION PURCHASE BRAIN 042-37113344


QUESTION BANK
Name: Subject: Computer Science-12
Roll # : Unit(s): 5,
Class: Inter Part-II Test: Type 15 - Full Test -
Marks=75
Date: Time:
Q.1 Four possible answers A, B, C & D to each question are given. Circle the correct one.
(15x1=15)
1 Which shortcut key is used to open an existing database in MS-Access?
(A) CTRL+ N (B) CTRL+ S (C) CTRL+ O (D) CTRL+ Z
2 It makes very simple to create a database:
(A) Sample database (B) Wizard (C) Common standard (D) Easier programming
3 MS Access saves the database with the extension:
(A) .mbdq (B) .msdb (C) .ppt (D) .mdb
4 In relational database, a table is called:
(A) Tuple (B) Reaction (C) File (D) Schema
5 Which object is the output of a database application?
(A) Form (B) Query (C) Table (D) Report
6 A database consists of various components called:
(A) Tools (B) Properties (C) Entities (D) Objects
7 Which objects is used to store data in database?
(A) Macro (B) Table (C) Form (D) Report
8 The output of the query is in the form of:
(A) Table (B) Form (C) Report (D) Query
9 A request for information from a database in database terminology is called:
(A) Report (B) Letter (C) Table (D) Query
10 Which of the following is not a database object?
(A) Table (B) Query (C) From (D) MS-Word
BRAIN TEST SYSTEM
FOR SOLUTION PURCHASE BRAIN 042-37113344
QUESTION BANK
Name: Subject: Computer Science-12
Roll # : Unit(s): 5,
Class: Inter Part-II Test: Type 15 - Full Test -
Marks=75
Date: Time:
ESSAY TYPE (SECTION-I) MAXIMUM MARKS-36
Q.2 Write short answers to any SIX (6) of the following questions.
(6x2=12)
(i) List down any two advantages of Microsoft Access.
(ii) What is the use of MS-Access?
(iii) What is Database wizard?
(iv) Name any four parts of MS-Access application window.
(v) What is the role of query in database?
(vi) How Query is written?
(vii) Define a Form.
(viii) Differentiate between Form and Report.
(ix) Differentiate between Query and Report.
Q.3 Write short answers to any SIX (6) of the following questions.
(6x2=12)
(i) What is Microsoft ACCESS?
(ii) Define the term RDBMS.
(iii) List advantages of RDBMS.
(iv) List any four properties of relational databse management system.
(v) What is sample database?
(vi) Differentiate between Menu bar and Toolbar.
(vii) Write down two database objects in MS-Access.
(viii) Define two database objects.
(ix) List any two uses of Reports.
Q.4 Write short answers to any SIX (6) of the following questions.
(6x2=12)
(i) Describe the Data Redundancy.
(ii) Describe Menu Bar.
(iii) Define Scroll Bar.
(iv) List different buttons available on Access Database Window.
(v) Enlist two uses of Form.
(vi) Write definition of Reports.
ESSAY TYPE SECTION-II) (MAXIMUM MARKS-24
NOTE: Attempt any THREE (3) questions.
(8x3=24)
5. Briefly describe the advantages of using MS-ACCESS.
MCQs Ans Key
Q:1 (C) Q:2 (B) Q:3 (D) Q:4 (B) Q:5 (C) Q:6 (D)
Q:7 (B) Q:8 (A) Q:9 (D) Q:10 (D)

You might also like