Plants and Flowers

Database System Architecures and Distributed Database - Quiz 2

✔ Scroll down and test yourself — answers are hidden under the “View Answer” button.

Distributed Database and Database System Architectures - Quiz

1. Which of the following is more suitable for parallelizing a single query?

Coarse-granularity parallelism
Fine-granularity parallelism
Both
None of them

2. A regular desktop machine (with two to four processors) can be mentioned as ________________ machine.

Fine-grain parallel
Coarse-grain parallel
Massively parallel
None of the above

3. If we parallelize the execution of large number of small transactions in a database system, then which of the following would be increased?

Response time
Rotational latency
Throughput
All of the above

4. If the speed of a parallel system is N when the larger system has N times the resources of the smaller system, then the speedup is __________

Linear Speedup
Sublinear Speedup
Superlinear Speedup
None of the above

5. Which of the following can affect the speedup and scaleup of a database system?

Startup costs
Interference
Skew
All of the above

6. Which of the following situation would cause a skew?

Huge amount of records in a table
Even distribution of records in multiple sites
Both
None

7. In which of the following architectures memory bus is not a bottleneck?

Shared memory and shared disk
Shared disk and shared nothing
Shared memory and shared nothing
All of the above

8. Which of the following would improve the availability of resources especially for reading in a distributed database system?

Fragmentation of database
Replication of database
Defragmentation of database
Tuning of database

9. ______________ is very much required to process a query in a distributed database.

Global System Catalog
Database Views
Triggers
None of the above

10. Reliability and availablity of a Centralized Data Allocation method is ___________ when compared to a Completely Replicated Data Allocation .

Highest
Average
Lowest
Not applicable

Score =

Correct answers:

Go to Distributed database home

MC 9213/MC 913 – DATABASE MANAGEMENT SYSTEMS - May/June 2013

MC 9213/MC 913 – Database Management Systems - May June 2013 Question Paper / Anna University MCA Exam May June 2013 Question Paper / MC9213 DBMS May June 2013 Question Paper / MC9213 Database Management Systems Previous Year Question Paper / Anna University Affiliated Colleges MCA Question Papers / MC9213 Database Management Systems Previous Year Question Paper according to Regulation 2009

Question Paper Code : 70705

M.C.A DEGREE EXAMINATION, MAY/JUNE 2013

First Semester

MC 9213/MC 913 – DATABASE MANAGEMENT SYSTEMS

(Regulation 2009)

Time : Three Hours                                                         Maximum : 100 marks

Answer ALL Questions

PART A – (10 X 2 = 20 marks)

1. What is logical data independence?

2. List out the functionalities of DBA.

3. What is a candidate key? Give example.

4. Define view in SQL.

5. What do you mean by hashing?

6. What is data dictionary?

7. What is database tuning?

8. Define normalization.

9. List the desirable properties of transaction.

10. What is concurrency control?

PART B – (5 X 16 = 80 marks)

11. (a) Explain the architecture of a DBMS with diagrammatic illustration. (16)

Or

(b) Model a ER diagram for a library management system. State the functional requirements you are taking into consideration. (16)

12. (a) Explain Cartesian product. Natural join, left outer join, right outer join and full outer join in relational algebra with examples. (16)

Or

(b) Explain with examples in SQL the following:

(i) Aggregate functions. (8)

(ii) GROUP BY (2)

(iii) ORDER BY (2)

(iv) Trigger (4)

13. (a) Describe in detail about sequential file organization and random file organization. (16)

Or

(b) Explain B+ tree index files and B tree index files with examples. (16)

14. (a) Explain 1NF, 2NF, and 3NF with examples. (16)

Or

(b) Explain with an example the steps involved in processing a query. (16)

15. (a) (i) What is meant by concurrent execution of database transactions in a multi-user system? Discuss why concurrency control is needed? Give suitable example. (8)

(ii) Explain two phase locking protocol with an example. (8)

Or

(b) (i) Draw a state diagram and discuss the typical states that a transactions goes through during execution. (8)

(ii) Explain with examples read only transaction and read write transaction. (4)

(iii) What is crash recovery? Discuss. (4)

_____________________