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

July, 2012 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

July, 2012

A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

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 The language used application programs to request data from the DBMS is referred to as
A) DML
B) DDL
C) Query Language
D) All of the above
1.2 When two transactions run concurrently types of problems encounter are
A) Data delete Problem, Dirty read problem, Incorrect summary problem
B) Lost update problem, Dirty read problem, Incorrect summary problem
C) Lost update problem, Data delete Problem, Incorrect summary problem
D) Lost update problem, Dirty read problem, Data delete Problem