Database Management System Using Ms Access 2010 printable pdf download

Database Management System Using Ms Access 2010

Model Paper “DATABASE MANAGEMENT SYSTEM USING

MS ACCESS 2010”

For DIT Semester-I

Annual Examination 2016 & Onward

OBJECTIVE

(PART-A)

Roll No: _____________

Time: 20Minutes

Marks: 10

Note: This part is compulsory. It should be attempted on question paper and returned to

the supervisory staff after the prescribed time. Cutting overwriting and use of led pencil

is not allowed. Supervisory staff is required to attach it with the answer book.

Q.1:

Choose the correct answer and encircle it.

1x10=10

1. DBMS is a collection of ………….. that enables user to create and maintain a

database.

A) Keys

B) Translators

C) Program D) Language Activity

2. In a relational schema, each tuple is divided into fields called

A) Relations

B) Domains

C) Queries D) All of the above

3. In an ER model, ……………. is described in the database by storing its data.

A) Entity

B) Attribute

C) Relationship

D) Notation

4. DFD stands for

A) Data Flow Document

B) Data File Diagram

C) Data Flow Diagram

D) Non of the above

5. A top-to-bottom relationship among the items in a database is established by a

A) Hierarchical schema

B) Network schema

C) Relational Schema

D) All of the above

6. ……………… table store information about database or about the system.

A) SQL

B) Nested

C) System

D) None of these

7. …………..defines the structure of a relation which consists of a fixed set of

attribute-domain pairs.

A) Instance

B) Schema

c) Program

D) Super Key

8. ……………… clause is an additional filter that is applied to the result.

A) Select

B) Group-by

C) Having

D) Order by

9. A logical schema

A) is the entire database

B) is a standard way of organizing information into accessible parts.

C) Describes how data is actually stored on disk.

D) All of the above

10. ………………… is a full form of SQL.

A) Standard query language

B) Sequential query language

C) Structured query language

D) Server side query language

----------------------------------------------------------------------------------------------------------------------

Database Management System Using Ms Access 2010

Related Articles

Related forms

Related Categories