RGPV Civil Engineering (Semester 5)
Advanced Surveying
December 2015
Total marks: --
Total time: --
INSTRUCTIONS
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary


1(a) Define GPS.
2 M
1(b) Explain uses of digital planimeter.
2 M
1(c) Discuss digital levels.
3 M
Solve any one question from Q.1(d) & Q.1(e)
1(d) Discuss the principle of electronic distance measurement system.
7 M
1(e) What are the functions of the microprocessor in the total station?
7 M

2(a) Define Terrestrial poles and Equator.
2 M
2(b) Explain sensible horizon and visible horizon.
2 M
2(c) Explain declination and hour angle system.
3 M
Solve any one question from Q.2(d) & Q.2(e) & Q.2(f)
2(d) Derive an expression for calculating the spherical excess of a spherical triangle.
7 M
2(e) Explain the characteristics of relation. Also explain the relation databases.
7 M
2(f) What are DDL, DML and DCL? Differentiate among the three and give one command for each of these
7 M

3(a) What do you mean by the term loss-less decomposition?
2 M
3(b) What is multivalued dependencies?
2 M
3(c) Write a brief notes on trival and non-trival dependencies.
3 M
Solve any one question from Q.3(d) & Q.3(e)
3(d) Prove that a relation which is in 4NF must be in BCNF.
7 M
3(e) What is normalization? Justify the need for normalization with examples.
7 M

4(a) What is web databases?
2 M
4(b) Compare OODBMS and DBMS.
2 M
4(c) What are challenges in designing object-oriented data bases? Discuss
3 M
Solve any one question from Q.4(d) & Q.4(e)
4(d) What problems occur in the database when transactions do not satisfy AC/is properties? Explain explicitly using suitable examples.
7 M
4(e) Explain the significance of multimedia and mobile database. Also give two examples for each.
7 M

5(a) What is inline queries? Where it is used?
2 M
5(b) How the "GROUP BY" clause works?
2 M
5(c) Differentiate between Implicit and Explicit cursor.
3 M
Solve any one question from Q.5(d) & Q.5(e)
5(d) What is Triggers? Write various types of triggers.
7 M
5(e) What is PL/SQL exception handling and why it is needed?
7 M



More question papers from Advanced Surveying
SPONSORED ADVERTISEMENTS