Data warehousing and Data Mining BSc CSIT 2071 Question Paper 8th Semester

Tribhuvan University
Institute of Science and Technology

Bachelor Level/Fourth Year/ Eight Semester/ Science            Full Marks: 60
Computer Science and Information Technology (CSc.451)        Pass Marks: 24
(Data warehousing and Data Mining)                Time: 3 hours

Candidates are required to give their answers in their own words as far as possible.
The figures in the margin indicate full marks.

Group A

Attempt any two questions.     (2x10=20)

1. What do you mean by representative object based clustering technique? Explain in detail with example.


2. Explain the various data mining task primitives in detail.


3. Explain the architecture of data mining system with schematic diagram.



Group B


Attempt any eight questions.     (8x5=40)

4. What are the basic stages of KDD?


5. Differentiate between DBMS and data warehouse.


6. Explain the distributed and virtual data warehouse.


7. Explain the data cube with example.


8. What are the data warehouse back and tools? Explain.


9. Explain the data mining tasks performed on a text database.


10. Define spatial database and its features.


11. Differentiate between OLTP and OLAP.


12. Explain the Apriori Algorithm.


13. Write short notes on (any two):
    1. Stars
    2. HOLAP
    3. Data specification
    4. Mining the world wide web (www)
    
    

Software Project Management (SPM) BSc CSIT 2074 Question Paper 7th Semester

Tribhuvan University
Institute of Science and Technology

Bachelor Level/Fourth Year/ Seventh Semester/ Science            Full Marks: 60
Computer Science and Information Technology (CSc.408)        Pass Marks: 24
(Software Project Management)                Time: 3 hours

Candidates are required to give their answers in their own words as far as possible.
The figures in the margin indicate full marks.

Group A

Long Answer Questions (Attempt any two)     (2x10=20)

1. What is software project management? How software project differs from other projects?


2. Differentiate between strategic Assessment and technical assessment. Explain the steps involved in cost benefit analysis?


3. Explain the risk type and also explain in details how will you managing risks.



Group B


Short Answer Question (Attempt any eight)     (8x5=40)

4. List out the activities used in SPM.


5. Explain the use of decision tree in Risk Evaluation.


6. Briefly explain about risk planning and controlling.


7. Explain the process of collecting the data.


8. How you can select the right person for the job? Explain.


9. Define software quality and its importance.


10. Explain about SCM tasks and tools.


11. Explain the visualizing progress in details with example.


12. Explain the software configuration management and its roles.


13. Write short notes on:
    1. SPM software
    2. Critical Path
    
    

Software Project Management (SPM) BSc CSIT 2075 Question Paper 7th Semester

Tribhuvan University
Institute of Science and Technology

Bachelor Level/Fourth Year/ Seventh Semester/ Science            Full Marks: 60
Computer Science and Information Technology (CSc.408)        Pass Marks: 24
(Software Project Management)                Time: 3 hours

Candidates are required to give their answers in their own words as far as possible.
The figures in the margin indicate full marks.

Group A

Long Answer Questions (Attempt any two)     (2x10=20)

1. Outline the contents of a Software Project Management plan and explain in detail.


2. Explain in detail about critical path scheduling method with example.


3. Explain the various maturity levels of SEI CMM and also discuss the key process areas for each level.



Group B


Short Answer Question (Attempt any eight)     (8x5=40)

4. Explain the SPM framework.


5. Differentiate between project life cycle and product life cycle.


6. Comparison between waterfall model with spiral model.


7. Explain the objectives of activity planning.


8. Explain the Gantt Charts in Scheduling with example.


9. What are the roles of Software Engineer in a project? Explain.


10. Explain the function of software configuration management.


11. Explain the three modes of the basic COCOMO model.


12. Explain the SQA plan with example.


13. Write short notes on:
    1. Charge Control
    2. Software Quality
    
    

Information Retrieval (IR) BSc CSIT 2076 Question Paper 7th Semester

Tribhuvan University
Institute of Science and Technology

Bachelor Level/Fourth Year/ Seventh Semester/ Science            Full Marks: 60
Computer Science and Information Technology (CSc.405)        Pass Marks: 24
(Internet Technology)              Time: 3 hours

Candidates are required to give their answers in their own words as far as possible.
The figures in the margin indicate full marks.

Attempt any ten questions.

1. How IR in web search is different from other IR systems? Discuss IR architecture with suitable example. (2+4)


2. Assume that document space is defined by four terms: Network, CSIT, Nepal, TU and Graduate. And we have three documents containing the following terms:
   • Doc1: CSIT Nepal
   • Doc2: TU CSIT
   • Doc3: CSIT TU Nepal
   If the query is "CSIT NEPAL", find top 2 documents retrieved by Boolean space model. (6)


3. What is meant by stop word removal? Explain text normalization with suitable example. (1+5)


4. Suppose the table given below lists all the documents retrieved by an algorithm. If total number of relevant documents is 6, calculate the value of recall, precision, and F-score. (6)

   sn	Doc ID	relevant
   1	D1	no
   2	D2	no
   3	D3	yes
   4	D4	no
   5	D5	yes
   6	D6	yes
   7	D7	no
   8	D8	no
   9	D9	yes



5. Why query expansion is important? Discuss query expansion techniques with examples. (1+5)


6. Why Hits algorithm is used? Discuss its working with example. (2+4)


7. How Bots are different from spiders? Describe simple and multithreded spidering algorithm. (1+5)


8. How text categorization is different from clustering? Explain nearest neighbor categorization algorithm. (1+5)


9. Differentiate collaborative filtering from content based filtering? Discuss content based recommender system with its strengths and drawbacks. (2+4)


10. Why TF-IDF weighting is important in information retrieval? Explain with suitable example. (6)


11. How information extraction differs from information retrieval? Discuss role of XML in information extraction. (6)


12. Write short notes on: (3+3)
    1. Latent Semantic Indexing
    2. Spiders

Internet Technology (IT) BSc CSIT 2076 Question Paper 7th Semester

Tribhuvan University
Institute of Science and Technology

Bachelor Level/Fourth Year/ Seventh Semester/ Science            Full Marks: 60
Computer Science and Information Technology (CSc.402)        Pass Marks: 24
(Internet Technology)              Time: 3 hours

Candidates are required to give their answers in their own words as far as possible.
The figures in the margin indicate full marks.

Attempt all questions.

1. What do you mean by domain name system? How DNS resolves domain name into IP address?     [2+4]


2. Discuss functionalities of TCP. What is the use of 32-bit acknowledge number and sequence number in TCP header? [3+3]


3. What is RFC? Differentiate POP from IMAP. [2+4]


4. What is universal internet browsing? What is the need for multiple protocol support? [3+3]


5. What is WML card and deck? Write a WML script illustrating card and deck. [3+3]


6. What is the use of RADIUS Server? Discuss the various services provided by the RADIUS. [2+4]


7. Why proxy servers are needed in internet system? How reverse proxy differs from forward proxy? [2+4]


8. What is VPN tunneling? How IPSec is used to ensure VPN tunneling? [2+4]


9. What are the challenges in e-commerce? What does the properties like richness and universal standard means in e-commerce? [3+3]


10. Define IP interconnection. How transit differs from peering in IP interconnection. [2+4]

Advanced Database Management System (ADBMS) BSc CSIT 2076 Question Paper 7th Semester

Tribhuvan University
Institute of Science and Technology

Bachelor Level/Fourth Year/ Seventh Semester/ Science            Full Marks: 60
Computer Science and Information Technology (CSc.401)        Pass Marks: 24
(Advanced Database Management System)              Time: 3 hours

Candidates are required to give their answers in their own words as far as possible.
The figures in the margin indicate full marks.

Attempt all questions.     (10x6=60)

1. What is query processing? How is it different from query optimization? Discuss cost estimation for relational algebra expressions.


2. What is data fragmentation? Discuss horizontal and vertical fragmentation in detail.


3. Why do we need extended ER modeling? Discuss class/subclass relationship with example.


4. How do object relational database support multi-valued and composite attributes? Discuss with example.


5. What are the uses of active database? Discuss active database with example.


6. Discuss mobile computing architecture. Discuss mobile data management in detail.


7. Why do we need temporal database? Discuss valid time, transaction time and bi-temporal relations.


8. Discuss benefits and applications of data mining. How is classification different from clustering?


9. What is web service? Discuss SOAP in detail.


10. Write short notes on:
    1. Deductive database
    2. ODMG
    
    

Advanced Java Programming (AJP) BSc CSIT 2076 Question Paper 7th Semester

Tribhuvan University
Institute of Science and Technology

Bachelor Level/Fourth Year/ Seventh Semester/ Science            Full Marks: 60
Computer Science and Information Technology (CSc.403)        Pass Marks: 24
(Advanced Java Programming)                Time: 3 hours

Candidates are required to give their answers in their own words as far as possible.
The figures in the margin indicate full marks.

Group A

Attempt any two questions.     (2x10=20)

1. What is exception handling? Discuss the use of each keyword (try, catch, throw, throws and finally) with suitable Java program.


2. Write a Java program to find the sum of two numbers using swing components. Use text fields for input and output. Your program displays output if you press any key in keyboard. Use key adapter to handle events.


3. Define servlet. Discuss life cycle of servlet. Differebtiate servlet with JSP. Write a simple JSP file to display 'IOST' 20 times.



Group B


Attempt any eight questions.     (8x5=40)

4. Define class. How do you create a class in Java? Differentiate class with interface.


5. Write a simple Java program that reads a file named "Test.txt" and displays its contents.


6. Why do we need layout management? What is GridBag layout?


7. Discuss MVC design pattern with example.


8. What are the benefits of using JDBC? What is prepared statement?


9. Write Java programs using TCP sockets that communicate with each other in a computer network.


10. Define Java Bean. How is it different from other Java programs? What is design pattern?


11. How do you handle HTTP request (GET) using servlet?


12. What are different layers of RMI architecture? Explain.


13. Write short notes on:
    1. Servlet API
    2. RMI vs CORBA