July, 2010 A7-R4: INTRODUCTION TO DBMS

 July, 2010

A7-R4: INTRODUCTION TO DBMS

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 Description of data stored in database is called
A) Schema
B) Meta Data
C) Information
D) None of the above
1.2 When one transaction updates a database item and then transaction fails for some reason.
The updated item is accessed by another transaction before it is changed back to its original
value is a
A) Lost update
B) Temporary update
C) Incorrect summary
D) None of the above

January, 2011 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

January, 2011

A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 Given the relation schema:
EMPLOYEE(EMP_NUM,EMP_NAME, JOB_CODE)
JOB(JOB_CODE, JOB_DESCRIPTION)
What is the cardinality of relationship between entities EMPLOYEE and JOB?
A) One to One
B) One to Many
C) Many to One
D) Many to Many
1.2 Given the relation schema R(A,B,C,D)and functional dependencies C-->B and AB-->C,D.
What is the highest normal form of Relation R?
A) 2NF
B) 3NF
C) BCNF
D) 1NF

July, 2011 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

July, 2011

A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 A view is a
A) Base table
B) Derived table
C) Named derived table
D) None of the above
1.2 System failures are also known as
A) Soft crashes
B) Media crashes
C) Hard crashes
D) System failures are non-existent

January, 2012 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

January, 2012

A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 Which one of the following is not an example of 1:N relationship?
A) Faculty-belongsto-Department
B) BANK-has-Branches
C) University-has-Vicechancellor
D) None of the above
1.2 Consider the relation R(ABCDE) with following functional dependencies:
AB ® C, CD ® E, DE ® B
The key of the relation is
A) AC
B) AB
C) ABD
D) A