Saturday, October 10, 2015

Relational DBMS B.Com Kakatiya University 2011 to 2013 Question Paper

What question paper you are searching in internet? Kakatiya University B.Com Question Papers? Then you can spare your time in looking at the question paper of RELATIONAL DATABASE MANAGEMENT SYSTEMS (RDBMS) asked in the years from 2011 to 2013. Collect the contents in text form provided below.

Kakatiya University, Faculty of Commerce and Management, B.Com 3rd Year, RDBMS March 2011 Question Paper Free Download

Kakatiya University March 2011 Question

FACULTY OF COMMERCE AND BUSINESS MANAGEMENT

B.Com. (III Year) Examination

RELATIONAL DATABASE MANAGEMENT SYSTEMS
(computers)

Paper -VII

Time :3 Hours] [Max. Marks :70

Section A -(Marks : 5 x 4 = 20)

I. Answer any five of the following in not more than 1 page each:-

(a) Define DBMS.

(b) What are the stages of database development life cycle?

(c) What is E-R model?

(d) Define attributes and explain its types.

(e) Define a table.

(f) What is DDL ? List out DDL commands.

(g) What are the goals of DBA ?

(h) What is a distributed database system ?

Section B- (Marks : 5 x 10 = 50)

Answer all questions in about five pages each.

2.(a) Explain the database management systems components.

OR

(b) Explain the risks and costs of database.

3.(a) Explain the principles of conceptual database design.

OR

(b) What is normalization ? Explain 1NF,2NF,3NF

4.(a) Explain the various data types in SQL.
OR

(b) Write about client /server database system.

5.(a) Explain various files organizations.

OR

(b) Discuss data storage formats on disk.

6.(a) Write about distributed query processing .

OR

(b) Explain the different DBMS functions and capabilities.

Kakatiya University, Faculty of Commerce and Management, B.Com 3rd Year, RDBMS November 2011 Question Paper Free Download

Kakatiya University November 2011 Question

FACULTY OF COMMERCE AND BUSINESS MANAGEMENT

B.Com. (III Year) Examination

RELATIONAL DATABASE MANAGEMENT SYSTEMS
(computers)

Paper -VII

Time :3 Hours] [Max. Marks :70

Section A -(Marks : 5 x 4 = 20)

I. Answer any five of the following in not more than 1 page each:-

(a) What is metadata?

(b) What is data sharing?

(c) What is a strong entity and weak entity ?

(d) What is a foreign key?

(e) What is Schema?

(f) What is SQL ?

(g) What are the goals of DBA ?

(h) What is a distributed database system ?

Section B- (Marks : 5 x 10 = 50)

Answer all questions in about five pages each.

2.(a) Explain the structure of a DBMS.

OR

(b) Explain the components of DBMS.

3.(a) Define E-R model. Explain the different symbols used in ERD.

OR

(b) What is normalization ? Explain different forms of normalization ?

4.(a) Explain the various types of operators in SQL.
OR

(b) Describe the various aggregate(or group ) functions in SQL.

5.(a) Explain various files organizations.

OR

(b) Explain the differences between views and tables.

6.(a) Explain the general model of DDS.

OR

(b) Write about client /server systems.

Kakatiya University, Faculty of Commerce and Management, B.Com 3rd Year, RDBMS March 2012 Question Paper Free Download

Kakatiya University March 2012 Question

FACULTY OF COMMERCE AND BUSINESS MANAGEMENT

B.Com. (III Year) Examination

RELATIONAL DATABASE MANAGEMENT SYSTEMS
(computers)

Paper -VII

Time :3 Hours] [Max. Marks :70

Section A -(Marks : 5 x 4 = 20)

I. Answer any five of the following in not more than 1 page each:-

(a) Define RDBMS.

(b) Write any two limitations of traditional file system.

(c) What is a domain?

(d) What is a constraint?

(e) What is DDL and DML ?

(f) List out various data types in SQL ?

(g) What do you mean by QBE ?

(h) What do you mean by data fragmentation?

Section B- (Marks : 5 x 10 = 50)

Answer all questions in about five pages each.

2.(a) Explain the advantages of DBMS over file system.

OR

(b) Explain briefly the phases of systems development life cycle.

3.(a) What is a relationship ? Explain unary, binary and ternary relationships

OR

(b) What is an attribute ? Explain the different types of attributes.

4.(a) Explain different DML commands in SQL.

OR

(b) What is a trigger ? Explain its characteristics , types , advantages and syntax with an example.

5.(a) Explain the various disk performance factors.

OR

(b) What is DBA ? Explain the functions of DBA.

6.(a) What is DDS ? Explain its advantages and disadvantages.

OR

(b) Write about distributed query processing .

Kakatiya University, Faculty of Commerce and Management, B.Com 3rd Year, RDBMS October 2012 Question Paper Free Download

Kakatiya University October 2012 Question

FACULTY OF COMMERCE AND BUSINESS MANAGEMENT

B.Com. (III Year) Examination

RELATIONAL DATABASE MANAGEMENT SYSTEMS
(computers)

Paper -VII

Time :3 Hours] [Max. Marks :70

Section A -(Marks : 5 x 4 = 20)

I. Answer any five of the following in not more than 1 page each:-

(a) Define RDBMS.

(b) What are the advantages of database planning ?

(c) What is relationship type and relationship instance?

(d) What is relational calculas?

(e) Define SQL ?

(f) Differentiate SQL inner join and outer join.

(g) What do you mean by database integrity?

(h) What is Distributed database. ?

Section B- (Marks : 5 x 10 = 50)

Answer all questions in about five pages each.

2.(a) Explain advantages of DBMS over traditional file management system.

OR

(b) Explain the structure of a DBMS.

3.(a) Explain the Conceptual data model.

OR

(b) Define normalisation . Write about 1NF, 2NF and 3NF.

4.(a) Explain the various types of operators in SQL.

OR

(b) Explain the various functions in SQL.

5.(a) Explain the various disk performance factors.

OR

(b) Explain the recovery procedure of databases.

6.(a) Explain the Distributed Database System Design.

OR

(b) Explain the various DBMS implementation issues.

Kakatiya University, Faculty of Commerce and Management, B.Com 3rd Year, March 2013 Question Paper Free Download

Kakatiya University April 2013 Question

University: Kakatiya University
Question Paper Code: 9538/8
FACULTY OF COMMERCE AND BUSINESS MANAGEMENT
Course: B.Com. (III Year) Examination
Exam Year: 2013
Subject of Question Paper: RELATIONAL DATABASE MANAGEMENT SYSTEMS (Computers)
Paper -VII
Time :3 Hours
Max. Marks :70

Section A - (Marks : 5 x 4 = 20)
I. Answer any five of the following in not more than 1 page each:

(a) What is a Data Model?

(b) What is database system?

(c) What do you mean by constraint.

(d) What is a Primary Key?

(e) What is SQL ? Explain its features.

(f) What is DML?

(g) Define Data Transfer Rate.

(h) What is Data Replication?

Section B - (Marks : 5 x 10 = 50)
Answer all questions in about five pages each.

2. (a) What is Relational Model? Explain its advantages and disadvantages

OR

(b) Explain the risks and costs involved in database.

3.(a) Explain the principles of conceptual database design.

OR

(b) What is an Attribute? Explain different types of attributes.

4.(a) Explain Data Manipulation Commands.

OR

(b) Explain Aggregate functions in SQL.

5.(a) Explain various Physical Storage Media.

OR

(b) Explain various File Organisations and Addressing Methods.

6.(a) Explain Distributed Database System Design.

OR

(b) Explain the functions and capabilities of DBMS. 
Share This
Previous Post
Next Post

B.E Civil Engineer Graduated from Government College of Engineering Tirunelveli in the year 2016. She has developed this website for the welfare of students community not only for students under Anna University Chennai, but for all universities located in India. That's why her website is named as www.IndianUniversityQuestionPapers.com . If you don't find any study materials that you are looking for, you may intimate her through contact page of this website to know her so that it will be useful for providing them as early as possible. You can also share your own study materials and it can be published in this website after verification and reviewing. Thank you!

0 comments:

Pen down your valuable important comments below

Search Everything Here