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

PHP Hardware Institute Website Free Download

Girfa Hardware Institute is a website that Is suitable for all types institution or university or any educational body who running hardware courses. You can launch your business globally on web with a professional way. Content of this website is highly standardized by the expert. A comprehensive syllabus material has been added which will help you to design your course material. Online certificate verification enhances your working standard. So I am representing a tangible solution to you if you want to make such type of website.

Feature

• All necessary content based of live project
• PDF syllabus
• Online Certificate Verification
• Digital certificate download facility

January, 2013 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS (DBMS)

January, 2013

A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS (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 A database user manually notes that “The file contains two hundred records, each record
containing nine fields”. Translating this statement in database terminology means
A) 200 attributes and 9 rows
B) 200 rows 9 tuples
C) 200 tuples and 9 attributes
D) 200 attributes and 9 tuples
1.2 Given the following relation schemas
EMPLOYEE (EMP_CODE, EMP_NAME, JOB_CODE)
PLAN (PLAN_CODE,PLAN_DESCRIPTION)
BENEFIT(EMP_CODE,PLAN_CODE)
Attribute PLAN_CODE in relation BENEFIT is
A) Primary Key
B) Foreign Key
C) Candidate Key
D) Alternate Key

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

July, 2013

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 “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 A view is a
A) Base table
B) Derived table
C) Named Derived table
D) Soft table
1.2 Which of the following do you need to consider when you make a table in SQL?
A) Data types
B) Primary Keys
C) Default Keys
D) All of the above