Title 2018 Batch.pdf ✅

Prepared by Uni Bytes / www.unibytes.xyz Don't use our content without permission. 긬긳긮긵긯긶기긴 Tribhuvan University Faculty of Humanities and Social Science Semester: VIII Subject: Operational Research 2018 Batch Group B Attempt any SIX questions 2. What is operational research? Explain the general method of solving OR model. 3. A chair manufacturing company produces two types of chairs, A and B, by using three machines, X, Y and Z. The time required for each chair on each machine and the maximum time available on are given below? Message. Machines. Time required for each type. Maximum time available A B Per week in hrs X 6 8 120 Y 8 4 100 Z 12 4 144 The profit on the A and B are rupees 500 and rupees 300 respectively. What combination of pains should be produced to obtain maximum profit? 4. Write an algorithm to minimize the solution of LPP using simplex method. 5. Given the transportation framework, find the optimal transportation From ↓ To → A B C Plant Capacity W X Y 40 160 80 80 - 160 80 160 240 55 25 35 Requirement 35 45 35 115 6. Find the cost per period of individual replacement policy of an installation given in the following table. of 3000 street lamps a. Cost of replacing an individual bulb is rupees 5. b. Cumulative probability of failure is given below. Week 0 1 2 3 4 5 Cumulative probability of failure 0 0.1 0.3 0.5 0.7 1.0 7. Discuss single channel queuing model with suitable example? Give its assump 8. Write short notes on (any two) a. Kendall's notation b. Big M method c. Importance and advantage of duality problem Don’t Forget to Follow Uni Bytes

Prepared by Uni Bytes / www.unibytes.xyz Don't use our content without permission. 긬긳긮긵긯긶기긴 Tribhuvan University Faculty of Humanities and Social Science Semester: VIII Subject: Database Programming 2018 Batch Group B Attempt any SIX questions 2. Explain the PL/SQL block structure with an example. 3. What are records and nested records in PL/SQL? Explain benefits of using records. 4. How functions can be created can invoked in database? Explain with examples. 5. What is a cursor? Explain different types of cursors used in database. 6. Why do we need to use trigger in the database? Explain the use of triggers with proper examples. 7. How user defined exceptions can be created in PL/SQL? Explain with proper example. 8. Write short notes (any two): a) INSTEAD OF trigger b) Packages c) Parameterized cursors Group C Attempt any TWO questions. 9. Explain PL/SQL architecture. Differentiate between SQL and PL/SQL Also explain the conditional control statements used in PL/SQL. 10. Define stored procedure. Explain different parameter modes used in stored procedures. Also differentiate between functions and stored procedure with examples. 11. Explain row trigger and statement trigger with examples. Explain any five SQL*PLUS commands. Don’t Forget to Follow Uni Bytes
Prepared by Uni Bytes / www.unibytes.xyz Don't use our content without permission. 긬긳긮긵긯긶기긴 Tribhuvan University Faculty of Humanities and Social Science Semester: VIII Subject: Geographical Information System 2018 Batch Group B Attempt any SIX questions 2. What is GIS? Explain functions and applications of GIS. 3. Define map projection. Describe the techniques used for map projection. 4. What is GPS? Explain components of GPS. 5. Describe about grid-like format and coordinate format for structuring the graphics in GIS. 6. Explain the benefits of a geodetic datum based on ITRF. 7. Describe the role of GIS in agriculture for developing country like Nepal. 8. Write short note on (any two): a) Map features b) Surface Modeling c) Spatial database Group C Attempt any TWO questions. 9. Explain the term "Data is fuel to GIS". What are the types and sources of geographic data? Describe different data capturing methods. 10. Define Geodatabase. Briefly describe the steps for geodatabase design. 11. What is hydrology modeling? Explain the role of GIS to solve the challenges in hydrology. Don’t Forget to Follow Uni Bytes