Go Back   2020-2021 StudyChaCha > StudyChaCha Discussion Forum > General Topics





  #1  
Old April 25th, 2014, 12:32 PM
Sashwat's Avatar
Super Moderator
 
Join Date: Jun 2011
Default DOEACC A Level Introduction to Database Management Systems Previous Years Question Pa

Can you please give me the DOEACC A Level Introduction to Database Management Systems previous years question papers A7-R3 as it is very urgent for me?

As you want to get the DOEACC A Level Introduction to Database Management Systems previous years question papers A7-R3 so here is the information of the same for you:

Some content of the file has been given here:

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. (1 x 10)

1.1 In a relational database, two records are linked by
A) cell addresses.
B) Inter-record gaps.
C) cross correlation matrices.
D) key fields.

1.2 In a database, another name for Locate and Display is
A) sort
B) calculate and format
C) query
D) search and destroy

1.3 Form that is used to collect data in a structured manner for entry to a database is called a
A) database design form
B) systems flowchart
C) data capture form
D) none of the above

1.4 If there are no repeating attributes or groups of attributes, data are said to be:
A) Redundant
B) First Normal Form
C) Second Normal Form
D) Third Normal Form

1.5 Which one of the following is NOT likely to be found in a database dictionary?
A) Names of fields
B) Frequency of back ups
C) Programs to access the data
D) Security of the data

1.6 Which one of these functions would be carried out by the database management system?
A) Design of tables
B) Normalization the data
C) Data backup
D) Determination of entity relationships

1.7 Which of these queries processes the data in some way?
A) Sort query
B) Select Query
C) Cross tab query
D) Update query

1.8 A relation schema R is in 3rd normal form if
A) each nonprime attribute in R is fully dependent on every key
B) all attributes in R have atomic domains
C) R satisfies 2nd normal form and no nonprime attribute of R is transitively dependent on the
primary key
D) R contains only 3 keys

1.9 In SQL, if we want to designate that column A, B and C are all candidate keys we can add
the following constraint to each column definition
A) unique
B) primary key
C) foreign key
D) not null

1.10 When we map an n-ary relationship (where n > 2) from the ER Model to the relational
model we
A) create a table with n foreign keys
B) create a table with a primary key but no foreign keys
C) create n tables
D) none of the above

2. Each statement below is either TRUE or FALSE. Choose the most appropriate one
and ENTER in the “tear-off” sheet attached to the question paper, following
instructions therein. (1 x 10)

2.1 The relational database model is a logical representation of data that allows relationships
among data to be considered without concern for the physical structure of the data.
2.2 Providing duplicate values for the primary-key field of multiple rows causes the DBMS to
terminate.
2.3 There is a one-to-one relationship between a primary key and its corresponding foreign
key.
2.4 The results of a query can be arranged in ascending or descending order using the
optional ORDER BY clause.
2.5 Each time the user performs a sorting operation, the program is not performing another
query on the database.
2.6 When creating a database you must know the physical location of the information you
want to use.
2.7 An instance is an occurrence of an entity class that can be uniquely described.
2.8 One disadvantage of databases is that they are static; that is, once the database structure
is established, it cannot be changed.
2.9 A field that contains numbers should be specified as a numeric field, regardless of the type
of data it contains.
2.10 Hierarchical databases are better than most at minimizing data redundancy.

3. Match words and phrases in column X with the closest related meaning/
word(s)/phrase(s) in column Y. Enter your selection in the “tear-off” answer sheet
attached to the question paper, following instructions therein. (1 x 10)

X Y
3.1 Refers to the validity, accuracy, and consistency of the
data in a database.
A. Field
3.2 A person, place, thing, or event about which we want to
record information; an object we’re interested in.
B. Data Definition
Language (DDL)
3.3 The smallest structure in a relational database used to
store the individual pieces of data about the object;
stores a single fact about an object that we’re interested
in; represents an attribute.
C. Hierarchical data
3.4 Uniquely identifies each record in a table and the field
lives in the table for which it operates.
D. SQL
3.5 Establishes a connection or correspondence or link
between a pair of tables in a database, or between a pair
of entities in an entity-relationship diagram (ERD).
E. Primary Key
3.6 The language used to define objects in a database:
CREATE TABLE, CREATE INDEX, and so on.
F. Ascending Sort
3.7 Any sort which arranges records from highest value to
lowest value
G. Insert
3.8 Data that is organized into categories and subcategories H. Relationship
3.9 Used to query a database and have a result set
returned.
I. Data Integrity
3.10 A SQL command used to add a new record to a table
within a database.
J. Update
K. Entity
L. Data
M. foreign Key
N. Descending Sort

4. Each statement below has a blank space to fit one of the word(s) or phrase(s) in the
list below. Enter your choice in the “tear-off” answer sheet attached to the question
paper, following instructions therein. (1 x 10)

A. NULL B. Candidate C. Functional
D. Queries E. Data F. Tuple
G. Normalization H. Keys I. Append
J. MySQL K. Data Flow Diagram
(DFD)
L. Boyce-Codd Normal
Form (BCNF)
M. Locks N. An entity-relationship
(ER)

4.1 ________ the process of organizing data to minimize redundancy and remove ambiguity.
4.2 The ________ SQL keyword is used to represent a missing value.
4.3 ________ are the main way to make a request for information from a database.
4.4 ________ are used by Database management systems to facilitate concurrency control.
4.5 ________ is an open source relational database management system.
4.6 A(n) ________ key is a combination of attributes that can be uniquely used to identify a
database record without any extraneous data.
4.7 A relation is in ________ if every determinant is a candidate key.
4.8 A(n) ________ is a specialized graphic that illustrates the interrelationships between
entities in a database.
4.9 A(n) ________ dependency occurs when one attribute in a relation uniquely determines
another attribute.
4.10 ________ refers to a collection of one or more attributes.

PART TWO
(Answer any FOUR questions)

5.
a) What are the differences between the terms: CANDIDATE KEY, PRIMARY KEY, SUPER
KEY and COMPOSITE KEY?
b) Let R(A,B,C,D) be a relation schema with
• the FDs A→BCD and B→CD and
• the MVD A →→B.
Answer the following:
i) Find all possible keys of R.
ii) Is the relation in 4NF?
c) Explain, how the object-oriented database model varies from the relational database
model.
(4+(4+3)+4)

6. Consider the following tables:

EMPLOYEE PROJECT ASSIGNMENT

EID ENAME
1 Tom
2 Bill
3 Mary
4 Alice

PID PNAME
100 A
200 B
300 C
400 D

EID PID HOURS
1 200 10
1 300 20
2 100 25
3 400 35
4 100 20
4 200 15

Determine the result of the following SQL queries:
i) SELECT PNAME, COUNT(*) AS CNT
FROM PROJECT, ASSIGNMENT
WHERE PROJECT.PID = ASSIGNMENT.PID
GROUP BY PID;

ii) SELECT ENAME, SUM(HOURS) AS TOTAL_HOURS
FROM EMPLOYEE, ASSIGNMENT
WHERE EMPLOYEE.EID = ASSIGNMENT.EID
GROUP BY EID;

iii) SELECT ENAME, PNAME
FROM EMPLOYEE, PROJECT, ASSIGNMENT
WHERE PROJECT.PID = ASSIGNMENT.PID
AND EMPLOYEE.EID = ASSIGNMENT.EID;
(5+5+5)

7. A company has several departments. Each department has a supervisor and at least one
employee. Employees must be assigned to at least one, but possibly more departments.
At least one employee is assigned to a project, but an employee may be on vacation and
not assigned to any projects. The important data fields are the names of the departments,
projects, supervisors and employees, as well as the supervisor and employee number and
a unique project number.
a) Identify the Entities in the above case.
b) What are relationships between the identified entities?
c) Draw an Entity Relationship diagram to demonstrate the connectivity between the various
entities.
(4+4+7)

8.
a) Which is a higher quality database design: 1st normal form or 3rd normal form? Explain.
b) Assuming you are using DBMS that provides locking facilities. How programs are to be
written to:
i) avoid deadlock
ii) guarantee correct results
c) Explain third normal form with example.
(4+6+5)

9.
a) List Codd’s rules to qualify a database as relational.
b) Write short note on ill effects of concurrency.
c) Explain briefly distributed databases.
(5+5+5)

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. (1 x 10)
1.1 Which one is an incorrect statement about a view?
A) A view is derived from other tables.
B) It can be updated like a table.
C) DROP VIEW is used to dispose it.
D) All are correct statements.

1.2 To represent many to many relationship between two entity types A and B in a relational
model
A) put identifying attribute(s) of A in the relation representing B.
B) put identifying attribute(s) of B in the relation representing A.
C) create a new relation to represent the relationship.
D) It can not be represented.

1.3 Which one is lowest level data model?
A) physical data model
B) logical data model
C) external data model
D) none of the above

1.4 Which one is not a version of JOIN?
A) Equi join
B) outer join
C) natural join
D) all are versions of JOIN.

5 Read the following statements.
Relational calculus is
i) equivalent to relational algebra in its capabilities.
ii) it is stronger than relational algebra.
iii) it is weaker than relational algebra.
iv) it is based on predicate calculus of formal logic.
Now answer which one is a correct option?
A) i) and iv) are true
B) ii) and iv) are true
C) only iii) is true
D) iii) and iv) are true

1.6 A deletion anomaly means
A) A constraint that does not allow to delete some rows from a table.
B) Unauthorized user is not allowed to delete data from the database.
C) Unintentional loss of data due to deletion of other data.
D) None of the above

1.7 Which of these is not TRUE in case of responsibilities of Data Base Administrator (DBA).
A) Acquiring hardware and software resources.
B) Authorizing access to database.
C) Data entry in to the database.
D) All the above statements are true.

1.8 An alias is
A) An alternate name given to a relation.
B) An alternate name given to an inner query
C) An alternate name given to a user.
D) None of the above

1.9 Statement that uses a condition to control iterative execution of a statement block
A) IF statement
B) WHILE statement
C) BREAK statement
D) None of the above

1.10 If a relation A has m attributes and relation B has n attributes and A divide by B is possible
then A divide by B has
A) m*n attributes
B) m-n attributes
C) n-m attributes
D) m / n attributes

Each statement below is either TRUE or FALSE. Choose the most appropriate one
and ENTER in the “tear-off” sheet attached to the question paper, following
instructions therein. (1 x 10)
2.1 Fourth normal form deals with join dependencies.
2.2 Shared lock allows more than one transactions to update an item concurrently.
2.3 Null values are allowed in a primary key.
2.4 Relational algebra is a procedural language.
2.5 Dead-lock does not occur in time stamping scheme.
2.6 A foreign key can not refer to its own relation.
2.7 A UNION B can be defined for any two relations A and B.
2.8 A view is a table whose rows are computed as needed.
2.9 If GROUP BY is omitted in
a SELECT command; entire table is taken as a group.
2.10 All relations are in 1 NF.
3. Match words and phrases in column X with the closest related meaning/
word(s)/phrase(s) in column Y. Enter your selection in the “tear-off” answer sheet
attached to the question paper, following instructions therein. (1 x 10)
X Y

3.1 Query A. Media failure
3.2 Trigger B. Shared lock
3.3 Aggregation C. Discretionary access control
3.4 Prime attributes D. A desired property of a schedule
3.5 Disk crash E. Member of a primary key
3.6 Not (∃x) (not p(x)) F. Exclusive lock
3.7 Read lock G. Relationship between an object and its parts.
3.8 Durability H. Members of primary key.
3.9 GRANT I. A desired property of a transaction
3.10 Foreign key J. Entity integrity
K. Members of any key
L. Question about data
M. (∀x) (p(x))
N. Referential integrity
O (∃ x) (p(x))
P A procedure automatically invoked in response to a specified
event

Each statement below has a blank space to fit one of the word(s) or phrase(s) in the
list below. Enter your choice in the “tear-off” answer sheet attached to the question
paper, following instructions therein. (1 x 10)
A. Universal B. Backup C. Conceptual
D. Track E. Existantial F. User data
G. Aggregate H. Metadata I. Committing
J. Aborting K. Unique L. Log
M. Logical N. Cartesian product O. Owner
P. Deferred Q. Distinct R Block
S. Join T. Record

4.1 ER modeling is used in ________ design step.
4.2 COUNT is a(n) ________ function.
4.3 If ________ is contained in the SELECT clause, duplicates are removed.
4.4 When dead lock is detected, it is resolved by ________ one of the participating transactions
in the dead lock.
4.5 Data dictionary stores ________.
4.6 Divide by operation of relation algebra is equivalent to ________ quantifier.
4.7 ________ is result of joining each row of a relation with every row of other relation.
4.8 ________ is a record of all transactions and corresponding changes.
4.9 A(n) ________ is a unit of data in which data is written and read from a disk.
4.10 In ________ update scheme, updates are not written to database immediately.

PART TWO
(Attempt any FOUR questions)
5. Tourism department operates boating facility at one of its picnic spot. There are a number of
boats with different capacities. These boats are owned by a number of boatmen. A boatman
may own a number of boats but a boat is owned by only one boatman. Each boat has an
identifying number.
Tourist parties book boats according to their party size. Thus a party may book more than
one boats or several parties may book same boat. Parties are charged on number of
persons, hours booked and boat type. A record of all rides is kept to charge boatmen a
certain percentage of their income.
a) Identify entities, attributes and relationships giving functionalities and draw E-R diagram for
the system.
b) Convert this to relational tables explaining logic involved.
c) Show some important reports, which your proposed system can generate.
State your assumptions (if any).
(5+5+5)

6.
a) Explain the Codd rules regarding null values and database description.
b) List all relational algebra operations and explain one of them.
c) What is a well formed formula? How is it formed? What are its uses?
(6+4+5)
7.
a) Explain the three levels ANSI/SPARC database architecture with its significance.
b) Explain major steps in database development life cycle.
c) Explain with examples, how primary key and foreign key concepts is useful in relational data
model?
(6+6+3)

8.
a) The table emp contains following data: emp_num, countries visited and names of
dependents. What is the key to this relation? Which normal form does it belong to? Is this
relation desirable? Give reason. Split it if necessary.
b) Discuss major problems associated with concurrent processing with examples. What is the
role of locks in avoiding these problems? Name one of the protocol used with locks.
c) Discuss REDO and UNDO operations and their use in recovery methods.
(5+5+5)

9. Consider the following tables which give details of customers, trucks and packets booked by
customers, which are carried by trucks and write SQL commands to do the following:

Tables:
CUSTOMER(c_no, c_name, c_address)
TRUCK(t_no, driver_name)
PACKET(p_no, c_no, t_no, date_of_booking, weight, destination)

Queries:
i) Destinations which have received more than 10 packets.
ii) Name of Customers who have sent at least one packet of weight more than one kg to
‘BOMBAY’.
iii) Name of all Customers whose packets were delivered a driver whose name is ‘RAJA’.
iv) Three top customers (names) in terms of total packet weight sent by them. (list is to
be in descending order of total weight.)
v) Name of all Customers whose individual shipments are less than one kg.
(3x5)

Last edited by Aakashd; February 24th, 2020 at 03:50 PM.
Reply With Quote
Other Discussions related to this topic
Thread
DOEACC C Level Course Data Structure through C Language previous years question paper
Past year question papers of DOEACC B Level Course Operating Systems Exam
DOEACC B Level Course Object Oriented Database Management System Exam Papers
DOEACC A Level A5-R3 Structured System Analysis & Design previous years question pap
DOEACC C Level Course-Wireless and Mobile Networks previous years question papers
DOEACC Society B Level Course Software Project Management previous years question pap
DOEACC, C Level Course, Computer Graphics and Animation previous years question paper
DOEACC - O level, M4.2-R3 Programming Through Visual Basic previous years question pa
DOEACC - C Level Multimedia Technology and Virtual Reality previous years question pa
DOEACC B Level Course Management Fundamentals and Information Systems previous years
DOEACC, B Level Course, E- Business previous years question papers
DOEACC B Level Networking and Mobile Communications previous years question papers
DOEACC - C Level, Computer Organisation previous years question papers
DOEACC O Level Course-Introduction to ICT Resources previous year’s question papers
DOEACC C Level Network Security & Cryptography previous years question papers
DOEACC - O level, M1-R3 IT Tools and Application previous years question papers
DOEACC Society B Level Course Parallel Computing previous years question papers
M.Sc in IT 2nd sem Database Management Systems and Oracle previous year’s question pa
DOEACC A Level A5-R3 Structured System Analysis & Design Previous Years Question Pape
DOEACC C Level Course Previous Years Question Papers






  #2  
Old January 22nd, 2015, 05:07 PM
Super Moderator
 
Join Date: Nov 2011
Default Re: DOEACC A Level Introduction to Database Management Systems Previous Years Questio

Here I am providing the list of few questions of DOEACC A Level A7-R3 Introduction to Database Management Systems Paper which you are looking for .

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. (1 x 10)
1.1 A functional dependency of the form Y X ® is trivial if
A) X Y Í
B) X Y Ì
C) Y X Í
D) X Y and Y X Ì Ì
1.2 If every non-key attribute is functionality dependent on the primary key, then the relation will be
in
A) first normal form
B) second normal form
C) third normal form
D) fourth normal form
The Q1.3 and Q1.4 are based on the following details. Consider the given schemes.
Branch_scheme = (Branch_name, assets, Branch_city)
Customer_scheme = (Customer_name, street, Customer_city)
Deposit_scheme = (Branch_name, account_number, Customer_name, balance)
Borrow_scheme = (Branch_name, loan_number, Customer_name, amount)
Client_scheme = (Customer_name, banker_name)
1.3 Which of the following queries finds the clients of banker Agassi and the city they live in?
A) pClient.Customer_name.Customer_City (sClient.Customer_name=Customer.Customer_name
(sBanker_name=”Agassi” (Client ´ Customer)))
B) pCustomer_name.Customer_City (sBanker_name=”Agassi” (Client ´ Customer))
C) pClient.Customer_name.Customer_City (sBanker_name=”Agassi”
(sClient.Customer_name=Customer.Customer_name (Client ´ Customer)))
D) pCustomer_name.Customer_City (sBanker_name=”Agassi” (Client ´ Customer))

1.4 Which of the following tuple relational calculus finds all the customers who have a loan amount
of more than 1200?
A) { t (Customer_name) | t e borrow L t[amount] >1200 }
B) { t | t (Customer_name) e borrow L t[amount] >1200 }
C) { t | $ s e borrow ( t [Customer_name] = s [Customer_name] L s[amount] >1200 ) }
D) { t | $ s e borrow ( t [Customer_name] = s [Customer_name] L s[amount] >1200 ) }
1.5 Choose the most appropriate choice with respect to conceptual design.
A) Conceptual design is a documentation technique. Once the relation schemes are defined one
can draw E-R diagrams from the relation schemes for documentation.
B) Conceptual design needs data volume and processing frequencies to determine the size of the
data base.
C) Output of any conceptual design is an E-R diagram.
D) Conceptual design involves modeling the data requirements independent of the DBMS,
operating system and the hardware.









For more questions , here is the attachment
Attached Files Available for Download
File Type: pdf DOEACC A Level A7-R3 Introduction to Database Management Systems Paper.pdf (107.7 KB, 30 views)
__________________
Answered By StudyChaCha Member
Reply With Quote
Reply


Reply to this Question / Ask Another Question
Your Username: Click here to log in

Message:
Options



All times are GMT +6.5. The time now is 06:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2

1 2 3 4 5 6 7 8