DESCRIPTIVE PART - II - DATABASE MANAGEMENT

DESCRIPTIVE PART - II

Year 2011

Time allowed : 2 Hours Maximum Marks : 30

Attempt any four questions out of the six. All questions carry 7½ marks each.



1. (a) How can you say that the database management system is better than the file processing system? Explain.

(b) What do you understand by Data Abstraction and Data Independence? Explain 2. (a) What is Domain integrity, Referential Integrity and entity integrity? Explain

each by giving suitable examples.

(b) What do you understand by Functional Dependencies? Explain by giving suitable example.

3. Consider the following schema to write queries given ahead:

(1) emp (emp_no, emp_name, address, city, pin, dept_no.) (2) dept (dept_no., dept_name, dept_location)

(3) Works (emp_no, dept_no.)

(i) Create emp tabl with emp_no primary key and dept_no. as foreigh key.

(ii) List names of all the departments and number of employees working under it.

(iii) List all the employee who live in the cities starting from either „A‟ or „B‟

(iv) Update address and city for employee having emp_no = 1011.

(v) Delete records from emp table where wmp_name start with „A‟ or „B‟

4. How does normalization play a major role in designing of RDBMS? Discuss “Every schema in their normal form (3NF) must be in BCNF” with suitable example.

5. Discuss the naming convention and notation used for represent E-R diagram. Explain E-R model with suitable example.

6. Write notes on any three:

(a) Aggregate Function

(b) Security Vs. Integrity

_______

DATA BASE MANAGEMENT SYSTEM

Year - 2010

Time allowed : One Hour Maximum Marks : 20

The question paper contains 40 multiple choice questions with four choices and student will have to pick the correct one (each carrying ½ mark).

1. What is the RDBMS terminology for a row?

5. Which of the following Language includes:

(a) Specialization (b) Generalization

(a) C.J. Dale (b) E.F. Codd

(d) None of the above ( )

7. Margin of safety is:

(a) Projected sales–BEP sales (b) Actual sales – BEP sales (c) BEP–Projected sales

(d) Actual sales – Cost of goods sold ( )

9. In Network model which type of relationship exist?

(a) Parent Child relationship

(b) Owner-member type relationship (c) Member member type relationship 12. Which of the following is a legal expression?

(a) Select Null from employee (b) Select name from employee

(d) None of the above ( )

13. Which of the following clauses is usually together with aggregate function?

(a) Order by ASC (b) Order by DESC

(a) No Duplicate (b) Unique

(a) IN

(b) BETWEEN

(d) All of the above ( )

16. Which of the following is a cursor operation?

(a) Declare (b) Open and fetch

19. For select operation in relational algebra we use:

(a) (b)

(a) Sequential query language (b) Select query language (c) Structured query language

(d) None of the above ( )

22. In E-R diagram a rectangle represents:

(a) Relationship among entity set (b) Attribute

(a) DDL 26. The level of data abstraction which describes what relationship exists among data is:

(a) Physical level (b) View level

(a) Physical level (b) View level (c) Conceptual level

(d) Storage level ( )

28. Which of the following is a procedural language?

(a) SQL (b) TRC

30. Which normal form shows non-transitive dependency?

(a) 1NF

32. Degree of a relation is a :

(a) Number of attribute in a relation (b) Number of row in a relation (c) Number of unique row in a relation

(d) None of the above ( ) 33. The locking in a concurrent transaction are following type:

(a) Shared

37. Which of the following is not a transaction state?

(a) Active (b) Failed (c) Partial Failed

(d) Committed ( )

38. The first action the system must in query processing is:

(a) Estimate the cost of query

(b) Translate a query into its internal form (c) Verify the execution plan

(d) None of the above ( )

39. Failure can be classified as:

(a) Transaction failure (b) System Crash

(a) 1 NF (b) 2 NF (c) 3 NF

(d) 4 NF ( )

Answer Key

1. (a) 2. (d) 3. (b) 4. (d) 5. (b) 6. (b) 7. (b) 8. (c) 9. (a) 10. (c) 11. (a) 12. (b) 13. (c) 14. (b) 15. (c) 16. (d) 17. (a) 18. (d) 19. (a) 20. (c) 21. (c) 22. (c) 23. (c) 24. (c) 25. (c) 26. (c) 27. (d) 28. (d) 29. (a) 30. (d) 31. (d) 32. (a) 33. (d) 34. (d) 35. (a) 36. (d) 37. (c) 38. (b) 39. (d) 40. (d)

___________

DESCRIPTIVE PART - II

Year 2010

Time allowed : 2 Hours Maximum Marks : 30

Attempt any four questions out of the six. All questions carry 7½ marks each.

Q.1 (a) What is DBMS? Why DBMS is better than file processing system?

(b) Explain the overall system structure with diagram.

Q.2 (a) What is the difference between centralized and distributed database models?

(b) Solve the following query in Relational Algebra using the following scheme:

Emp (Ecode, Ename, Address, City, Salary) Debt (Dno, Dname, Ecode)

(i) Find all employees name, city who get salary > 10,000.

(ii) Display Ecode, Dno, Dname, for all employee where department name is

"Computer Science".

(iii) Find the employee who get maximum salary.

(iv) Find the employee's who live in city Jaipur and salary greater than 25,000.

Q.3 (a) What is Normalization? Explain different normal forms with suitable example.

(b) Suppose that we decompose the schema R (A, B, C, D, E) into (A, B, C) and (A, D, E). Show that this decomposition is a losses decomposition if the following set F of functional dependencies holds.

Q.4 (a) Explain the DBTG Network Data Model. How we represent many to many relationship in network model.

(b) What is oriented model? How does the concept of an object in object-oriented model differ from the concept of an entity in entity relationship model?

Q.5 (a) What is encryption? Explain in different encryption techniques.

(b) Explain log based recovery techniques.

Q.6 Write short notes on the following:

(a) Joint in SQL

(b) DBA (Database Administrator) (c) QBEL

________

DATA BASE MANAGEMENT SYSTEM

Year - 2009

Time allowed : One Hour Maximum Marks : 20

The question paper contains 40 multiple choice questions with four choices and student will have to pick the correct one (each carrying ½ mark).

1. Which normal form is considered adequate for relational database design:

(a) 2 NF relation relation will be in:

(a) First N. Form

5. Given the functional dependencies:

X W; X Y; Y Z and Z PQ Which of the following does not hold good?

(a) X Z (b) W Z

6. Which of the following desired features are beyond the capability of Relational

8. In an E-R diagram, ellipses represent:

(a) entity sets

(b) relationship among entity sets (c) Attributes

12. An attribute of one table matching the primary key of another table, is called:

(a) foreign key (b) secondary key

(a) Referential constraint (b) Integrity constraint

16. Which of the following group function ignores null values:

(a) Max (b) Count (c) Sum

(d) All of the above ( )

17. Which of the following must be enclosed in double gouts:

(a) Dates (b) Column alias

18. In SQL, 10/NULL will evaluate to:

(a) False (b) 1

19. Which of the following is considered to be a fourth generation language?

(a) COBOL (b) VB

20. PL/SQL does not support arrays however equivalent construct which is:

(a) Records (b) Packages

21. Trigger code is written in:

(a) SQL (b) PL/SQL

22. Which of the following is not a valid relational database?

(a) SYBASE (b) IMS

23. Data about data is termed as:

(a) Meta data (b) Directory

24. The data model, which describes how the data is actually stored, is:

(a) Internal model (b) Logical model

(c) External model (d) None of the above ( ) 25. A view of the database that appears to an application program is known is:

(a) Schema (b) Subschema

(a) Logical (b) Conceptual

(d) None of the above ( )

27. Collection of information stored in a database at a particular moment is:

(a) View (b) Instance (c) Scheme

(d) All of the above ( )

28. A collection of data items organized and manageable is:

(a) Attribute

(a) Physical level (b) Storage level

33. Which of the following command is used to get all the columns in a table?

(a) # (b) %

34. Which of the following aggregate functions does not ignore nulls in its results:

(a) Count (b) MAX

37. The principle means of identifying entities within an entity set, in a relational database is:

(a) Tuple (b) Pointer

38. ...is a hierarchical database system:

(a) DBMS (b) IMS

39. In an E-R model, oval represents:

(a) entity sets (b) relationship

40. Key to represent relationship between tables is called:

(a) Primary key (b) foreign key (c) Secondary key

(d) Tertiary key ( )

Answer Key

1. (b) 2. (d) 3. (b) 4. (b) 5. (b) 6. (c 7. (a) 8. (c) 9. (c) 10. (d) 11. (a) 12. a) 13. (b) 14. (d) 15. (a) 16. (b) 17. (c) 18. (c) 19. (d) 20. (d) 21. (b) 22. (b) 23. (a) 24. (a) 25. (b) 26. (d) 27. (b) 28. (c) 29. (d) 30. (a) 31. (a) 32. (d) 33. (c) 34. (d) 35. (b) 36. (c) 37. (b) 38. (b) 39. (c) 40. (b)

_________

DESCRIPTIVE PART - II

Year 2009

Time allowed : 2 Hours Maximum Marks : 30

Attempt any four questions out of the six. All questions carry 7½ marks each.

Q.1 (a) What are different levels of data base architecture? Describe conceptual level in detail.

(b) What is IMS hierarchy? Write a note on Data and Information.

Q.2 (a) What are the functions performed by D.B.A.?

(b) What are object-oriented database? Write a note on entity-relationship diagrams.

Q.3 (a) What are different normalization forms? Mention the application of IT.

(b) Define scheme and subschema. Discuss the concepts of Relational Algebra.

Q.4 (a) What is database query languages? Mention few query language commands?

(b) What are nested queries? Write a note on aggregate functions.

Q.5 (a) Define are ...decryption. How are security of database maintained?

(b) What are functional dependencies? Write a note on access control.

Q.6 Write short notes on the following:

(a) Client/Server Technology (b) Generalization

________

DATA BASE MANAGEMENT SYSTEM

Year - 2008

Time allowed : One Hour Maximum Marks : 20

The question paper contains 40 multiple choice questions with four choices and student will have to pick the correct one (each carrying ½ mark).

1. Same information may be duplicated in several places (files) called:

(a) Data inconsistency (b) Data redundancy

2. Abstract view of the data means:

(a) hides certain detail from user (b) it is database view

(d) All of the above ( )

3. The lowest level of abstraction is;

(a) logical level (b) physical level

7. A user interact with the system without writing program is called:

(a) naive user

(b) application programmer (c) Sophisticated user

(d) specialized users ( )

8. OLAP stands for:

(a) Online analysis processing (b) Online analytical processing (c) Open Line application program

(d) Online application program ( )

9. ...is responsible for fetching data from into main memory (a) File manager

(b) buffer manager (c) transaction manager

(d) Integrity manager ( )

10. Which of the example of composite attribute?

(a) Name

13. Which one is the example of derived attribute:

(a) Age

(b) Data of birth (c) Middle name

(d) Last name ( )

14. Double rectangle in E-R diagram represents: (b) Universal modeling language (c) Universal markup language

(d) All ( )

17. The result of relational Algebra operation is of a type (a) Operation

(b) Relation (c) Schema

(d) Attribute ( )

18. Which of not unary operation of relational algebra?

(a) Select (b) Project (c) Rename

(d) Set different ( )

19. Which is not comparison operator of relational algebra?

(a) = (b)

(d) < > ( )

20. Which give particular attribute in relational algebra : (a)

(b) (c)

(d) X ( )

21. r is equivalent is:

24. A tuple relational calculus formula is built up out of:

(a) Formula (b) Variables

25. In SQL % represents:

(a) Character matches any substring ( b) any single character

(d) All of above ( )

26. From which key word in SQL, we eliminate duplicate records:

(a) distinct (b) distinct all

30. Which is not a join type is SQL:

32. Which one is event-condition-action model:

(a) scheme (b) triggers (c) snapshot

(d) view ( )

33. ACID stands for:

(a) atomicity-consistency-durability-isolation (b) atomic-concurrency-dymanic-isolation (c) atomicity-condition-dynamic-isolation

(d) None ( )

34. RAID stands for:

(a) Redundant array of independent disk (b) redundant array of independent database (c) relational array of independent database

(d) None ( )

35. Which is not recovery technique:

(a) log based

(d) None ( )

37. Every non key attribute is fully dependent upon the primary key is called:

(a) 1 NF (b) 2 NG

38. Which normal form contains the concepts of multivalve dependency:

(a) 1 NF (b) 2 NG

39. IMS stands for:

(a) Information management system (b) Ideal management system (c) Information marking systems

(d) None ( )

40. The SQL command, to take any privilege from are:

(a) Grant (b) Revoke (c) Delete

(d) Modify ( )

Answer Key

1. (b) 2. (d) 3. (b) 4. (b) 5. (c) 6. (b) 7. (c) 8. (b) 9. (b) 10. (a) 11. (c) 12. (c) 13. (a) 14. (b) 15. (c) 16. (a) 17. (b) 18. (d) 19. (d) 20. (a) 21. (c) 22. (b) 23. (b) 24. (c) 25. (a) 26. (a) 27. (d) 28. (c) 29. (d) 30. (c) 31. (a) 32. (b) 33. (d) 34. (a) 35. (d) 36. (a) 37. (b) 38. (d) 39. (a) 40. (a)

_____________

DESCRIPTIVE PART - II

Year 2008

Time allowed : 2 Hours Maximum Marks : 30

Attempt any four questions out of the six. All questions carry 7½ marks each.

Q.1 (a) What do you mean by Data Abstraction and Data Independence?

(b) What are data base model? Discuss the basic concepts and structure of a relational database model.

Q.2 Explain do you term normalization and various normal from 1NF, 2 NF, 3 NF and BCNF with the help of example.

Q.3 (a) What do you understand by performance tuning of a database system? Explain (b) What is database security? Discuss different ways to achieve database security.

Q.4 Differentiate between the following:

(i) DML and DDL

(ii) Specialization and generalization Q.5 Consider the following database:

EMP (Empno#, Emname, Manager, DNo, Salary, Age) DEPT (DNo, Dname, Floor)

Write the following queries in SQL

(i) Find the names of employee that begins with g or e.

(ii) Print or list the name and average salary of each department.

(iii) Write a command to create EMP table, where EmpNo.#is primary.

Q.6 Write short notes on the following:

(i) Client/Server Database System (ii) ORDBMS

(iii) Centralized Database System

_______

DATA BASE MANAGEMENT SYSTEM

Year - 2007

Time allowed : One Hour Maximum Marks : 20

The question paper contains 40 multiple choice questions with four choices and student will have to pick the correct one (each carrying ½ mark).

1. The collection of information stored in the database at a particular movement is called:

(a) Instance (b) Schema (c) Data

(d) DBMS ( )

2. The collection of conceptual tools for describing data, data relationship data semantics and consistency constraints is called :

(a) Database (b) Metabase (c) Data model

(d) All of the above ( )

3. In E-R data model, attributes of entity sets are represented by:

(a) rectangles (b) diamonds (c) Ellipses

(d) Lines ( )

4. The model, that uses the collection of tables to represent both data and the relationship among those data is called:

(a) Relational model (b) Hierarchical model (c) Network model

(d) None of the above ( )

5. The operation, used in relational algebra as unary operations is:

(a)

(b) (c)

(d) ( )

6. The result of a relational algebra operation is of a type:

(a) Operation

8. The operational used in relational algebra, suitabled to queries that include the phase

"for all" is:

(a) (b) n (c) –

(d) U ( )

9. A tuple relational – calculus expression that generate an infinite is called:

(a) Unbounded expression (b) Infinite expression (c) Unsafe expression

(d) Any of the above ( )

10. In tuple-relational calculus formula is build up of:

(a) Formulae (b) Variables (c) Atoms

(d) Expressions ( )

11. In SQL, the clause used to specify the list of relation is:

(a) Select (b) Where (c) From

(d) Having ( )

12. To select the tuples explicitly so that duplicates are not removed in SQL the keyword

13. In SQL, the keyword used to compare two strings is:

(a) As (b) Like

14. In SQL, if we want to change a value in a tuple without changing all values in the tuple with a condition and this condition is specified with the clause:

(a) Where (b) With

(d) None of the above ( )

15. To express all the constraints on the domain variables, condition box feature is used in:

(a) QBEL (b) QUEL

16. "All actions of a transaction be executed completely or in the case of some failure, partial effects of a transaction be undone". This property of transaction is called:

(a) Durability (b) Atomicity

17. The advantage of DBMS Over centralized DBMS is:

(a) Inconsistency problem is solved (b) Increased reliability

(d) None of the above ( )

18. Which of the following will not cause any type of transaction failure?

(a) Some interval condition such as bad input (b) System crash

(d) None of the above ( )

19. The OODBMS, an object has associated, with it:

(a) Set of variables (b) Set of message

(a) Inconsistency of data

25. Which of the following is not a features of client system?

(a) Needs Powerful n/w

(b) Needs of OS capable of multitasking (c) Needs multiprocessor system

(d) Has communication capabilities ( )

26. The highest normal form in normalization is:

(a) 3 NF 29. Which of the following no called armstrong's axioms?

(a) Reflexivity rule

31. Which of the following is not the property of canonical cover FC?

(a) No functional dependency in FC contains an extraneous attribute (b) Each left side of a functional dependency in FC contains single attribute (c) Each left side of a functional dependency in FC contains single attribute

(d) None of the above ( )

32. To protect the database, we must take security measure at several levels, which of the following levels is not one of them:

(a) Database system (b) Operating system (c) Physical

(d) None of the above ( )

(b) It depends on the secrecy of the algorithm (c) Any of the above

37. If records of a relation are sorted by a field (Primary key) on which, you have created an indexed. The type of index in this case will be:

(a) Primary index

39. Which of the following has a two dimensional syntax?

(a) QUEL (b) QBE (c) SQL

(d) None of the above ( )

40. In QBE, to retrieve any field of a relation the command is indicated by:

(a) R (b) S

Answer Key

1. (a) 2. (c) 3. (c) 4. (a) 5. (d) 6. (d) 7. (a) 8. (a) 9. (d) 10. (c) 11. (c) 12. (c) 13. (b) 14. (a) 15. (a) 16. (b) 17. (c) 18. (d) 19. (d) 20. (c) 21. (b) 22. (b) 23. (b) 24. (d) 25. (c) 26. (b) 27. (c) 28. (a) 29. (d) 30. (c) 31. (a) 32. (c) 33. (c) 34. (a) 35. (b) 36. (c) 37. (c) 38. (c) 39. (b) 40. (c)

_____________

DESCRIPTIVE PART - II

Year 2007

Time allowed : 2 Hours Maximum Marks : 30

Attempt any four questions out of the six. All questions carry 7½ marks each.

Q.1 Consider the following database:

PRODUCT (Prod#, Prod_Name, Prod_Details) DEVELOPED_BY (Prod#_Emp#)

EMPLOYEE (Emp#, Ename, Address, Salary) here all the primary keys of different relations are underlined. Write the following queries in relational algebra.

(a) Find out the employee names who have developed the produce with prod#='CS001'.

(b) Find the employee names who have developed the product with Prod_Name = 'BIN'.

Q.2 Discuss different guidelines which must be satisfied by a good database design.

Discuss 1 NF with an example.

Q.3 How will you compare the early file system approach with database system approach.

Discuss in detail with suitable example.

Q.4 Define each of the following with example:

(a) Super Key and Candidate Key

(b) X⁺ and F⁺; where X is the set of attributes of relation and F is set of functional dependencies of a relation scheme.

Q.5 Write the commands in SQL for the following:

(a) View (b) Exists (c) NULL

Q.6 Write short notes on the following:

(a) DBTG (b) OODBMS (c) Data Abstraction

_______

DATA BASE MANAGEMENT SYSTEM

Year - 2006

Time allowed : One Hour Maximum Marks : 20

The question paper contains 40 multiple choice questions with four choices and student will have to pick the correct one (each carrying ½ mark).

1. The highest level seen by the application programming is called:

(a) External level

(a) Collection of any information (b) Collection of related data (c) Collection of entities

(d) None of the above ( )

4. The number of levels in data abstraction is:

(a) 1 (b) 2 (c) 3

(d) 4 ( )

5. Data redundancy is:

(a) Same information given several times (b) Mismatching of data

(d) Data in expanded form ( )

6. The capacity to change the conceptual schema without having to change external schema is:

(a) Physical data independence (b) Logical data independence (c) Data abstraction

(d) None of the above ( )

7. Which model uses tree data structure?

(a) Relational model (b) Hierarchical model (c) Network model

(d) Objective-oriented model ( )

8. In which type of database management systems, information is distribution at different sites?

10. Which one is the advantage of DDBMS over centralized DBMS?

(a) Reliability increased (b) Increased redundancy

(a) (b) (c)

(d) ( )

12. Which symbol is used for existential quantifier in reational calculus?

(a)

(b)

(c)

(d) ( )

13. The symbol not available in relational calculus is:

(a)

15. The symbol used as universal quantifier in relational calculus is:

(a)

(a) I (b) U (c) D

(d) M ( )

20. The first user friendly relational database language is:

(a) QBE (b) Structural Query Language (c) Sophisticated Query Language

(d) Schema Query Language ( )

(a) Alter table emp add primary key (SSM) (b) Alter emp add primary key (SSM)

(d) Alter table emp primary key ( )

26. The advantage of view in SQL is:

31. Designing a database, we avoid taking NULL values in the relation because:

(a) NULL requires more space (b) NULL can create inconsistency (c) NULL is not defined

(d) None of the above ( )

32. The type of data storage that does no service system crashes:

(a) Volatile storage (b) Non volatile storage (c) Stable storage

(d) None of the above ( )

33. Invalid state of a transaction is:

(a) Active (b) Read (c) Fail

(d) Commit ( )

34. A value that appears in one relation for a given set of attribute also appears for certain set of attributes in another relation. This condition is called:

(a) Domain constraint (b) Referential integrity (c) Integrity

(d) None of the above ( )

35. The protection from malicious access is called:

(a) Database (b) Database integrity

(a) Grant select on account for teller (b) Grant select on account for teller (c) Grant select with account to teller

(d) Grant select on account with teller ( ) 39. In SQL, DDL does not contain

(a) Create (b) Alter

40. SQL is an example is:

(a) DDL (b) DML

(d) None of the above ( )

Answer Key

1. (d) 2. (a) 3. (b) 4. (c) 5. (a) 6. (b) 7. (b) 8. (c) 9. ( a) 10. (a) 11. (c) 12. (a) 13. (a) 14. (b) 15. (b) 16. (a) 17. (a) 18. (d) 19. (d) 20.(b) 21. (a) 22. (a) 23. (a) 24. (c) 25. (b) 26. (a) 27. (a) 28. (b) 29. (a) 30. (b) 31. (d) 32. (a) 33. (b) 34. (b) 35. (c) 36. (d) 37. (c) 38. (c) 39. (d) 40. (c)

_________

DESCRIPTIVE PART - II

Year 2006

Time allowed : 2 Hours Maximum Marks : 30

Attempt any four questions out of the six. All questions carry 7½ marks each.

Q.1 (a) Discuss the three level architecture of DBMS.

(b) What are the advantages of a DBMS approach?

Q.2 Discuss the following operations of relational algebra with examples:

(a) Select (b) Project (c) Join Q.3 Write the use of the following in SQL:

(a) AVE (b) Primary Key (c) Alter

Q.4 What do you mean by functional dependency? Write and prove and following rules of functional dependency:

(a) Transitivity Dependency (b) Union Rule

Q.5 What do you mean by normalization? Discuss BCNF and 3 NF with examples.

Q.6 Write short notes on the following:

(i) Recovery (ii) DBA (iii) Network model

In document DATABASE MANAGEMENT (Page 155-198)