BCA 4 SEMESTER OLD QUESTION 2024
Tribhuwan University
Faculty of Humanities and Social Sciences
2024
Bachelor of Computer Applications
Course Title: Database Management System
Code No: CACS255
Semester: Fourth Semester
Full Marks: 60
Pass Marks: 24
Time: 3 hours
Candidates are required to answers the questions in their own words as far as possible.
Group B
Attempt any SIX questions.
Define database system. Write the merits and demerits of DBMS.
5 marks
Draw and explain three schema architecture of the database system.
5 marks
What are an entity and its attributes? Write the differences between a strong and weak entity set wiith an examples.
5 marks
Why integrity constraints are used in databases? Explain different types of integrity constraints with examples.
5 marks
What is functional dependency? Explain its types with examples.
5 marks
Differentiate between discretionary access control and mandatory access control with example.
5 marks
Write the ACID properties of transactions. Explain the concepts of serializability in database transactions.
5 marks
Group C
Attempt any TWO questions.
5 marks
Why normalization is required in database ? Explain the 1NF, 2NF and 3NF of normalization with example.
10 marks
How participation constraints are used in ER diagram? Explain. Also Construct an E-R diagram for a car insurance company whose customer own one or more cars each.Each car has associated with it zero to any number of recorded accidents. Each insurance policy covers one or more cars and has one or more premium payments associated with it. Each payment is for a particular period and has an associated due date, and the date when the payment was received.
10 marks
Consider the following employee database, where primary keys are underlined
Supplier(supplier-id, supplier-name, city)
Suppliers (Supplier-id, parts-id, quantity)
Parts(part-id, color, weight)
a) Write a SQL query to create above table.
b) Find the name of all suppliers who has supplied parts with quantity more than 10.
c) Find the name of all parts supplied by “RD Traders”
d) Find the number of parts supplied by “SO2”.
e) Find the name of all suppliers located in the city “KTM”.
Tribhuwan University
Faculty of Humanities and Social Sciences
OFFICE OF THE DEAN
2024
Bachelor of Computer Applications
Course Title: Operating System
Code No: CACS251
Semester: Fourth Semester
Full Marks: 60
Pass Marks: 24
Time: 3 hours
Candidates are required to answers the questions in their own words as far as possible.
Group B
Attempt any SIX questions. [6 * 5 = 30]
Define Kernel. Explain different types of kernel in operating system.
5 marks
What is PCB? What are different information that are included in a PCB?
5 marks
How paging can be used for memory management? Also differentiate it with segmentation.
5 marks
What are page faults and thrashing? Explain demand paging with protection bit?
5 marks
How deadlock can be prevented ? Explain in detail?
5 marks
Explain different file access methods in detail.
5 marks
What is distributed system? Explain the role of clock synchronization in distributed system.
5 marks
Group C
Attempt any TWO questions. [2 * 10 = 20]
What is critical section problem? How semaphores can be used to solve critical section problem.Also explain producer consumer problem with its solution using Mutex.
10 marks
What is belady’s Anomaly in page replacement Algorithm? Explain with example. Consider the following page reference string: 7,2,3,1,2,5,3,4,6,7,7,1,0,5,4,6,2,3,0,1. How many page faults will occur if the program has four page frames available to it and uses the following page replacement algorithm? a)FIFO replacement b) LRU replacement c) Optimal replacement
10 marks
What is the use of DMA controller? Consider the following process and answer the following questions.
| Process | Allocation | Max | Available |
| [A,B,C,D] | [A,B,C,D] | {A,B,C,D] | |
| P0 | 0 0 1 2 | 0 0 1 2 | 1 5 2 0 |
| P1 | 1 0 0 0 | 1 7 5 0 | |
| P2 | 1 3 5 4 | 2 3 5 6 | |
| P3 | 0 6 3 2 | 0 6 5 2 | |
| P4 | 0 0 1 4 | 0 6 5 6 |
a) What is the content of need matrix?
b) Is the system in safe state?
c) If P2 request (3 4 0 2) , can the request be granted immediately.
Bachelor of Computer Applications
Course Title: Numerical Methods
Code No: CACS252
Semester: Fourth Semester
Full Marks: 60
Pass Marks: 24
Time: 3 hours
Candidates are required to answers the questions in their own words as far as possible.
group B
Attempt any SIX questions. [6*5=30]
2. Explain absolute and relative error. Find the relative error of number 5.6 if both of its digits are correct.
5 marks
On what type of equations Newton’s method can be applicable –Justify.
5 marks
Solve the following equations by using Gauss-Jordan method.
2x + 3y +4z = 5
3x + 4y + 5z = 6
4x + 5y + 6z = 7
5 marks
Use the Romberg method to get an improved estimate of the integral from x = 1.8 to x = 3.4 from the data in the table with h = 0.4.
| X: | 1.6 | 1.8 | 2.0 | 2.2 | 2.4 | 2.6 | 2.8 | 3.0 | 3.2 | 3.4 | 3.6 | 3.8 |
| Y: | 4.953 | 6.050 | 70389 | 9.025 | 11.023 | 13.464 | 16.445 | 20.056 | 24.533 | 290964 | 36.598 | 44.701 |
5 marks
Write a program to compute integral using Simpson’s 1/3 rule.
5 marks
Use Runge-Kutta method of 4th order solve the following equation taking each step h = 0.1 for dy/dx = [4x/y – xy] given y(0) = 3 calculate y at x = 0.1 and 0.2.
5 marks
Solve the Laplace equation Uxx + Uyy = 0 for the following square mesh with the boundary values as shown in the figure below.
5 marks
Group C
Attempt any TWO questions.
Solve the given set of linear equations using Dolittle LU decomposition method:
3×1 + 2×2 + x3 = 10
2×1 +3×2 + 2×3 = 14
x1 + 2×2 + 3×3 = 14
10 marks
Define initial value problems and final value problems. Using Heun’s method, find value of y when x = 0.3 given that dy/dx = x+y and y = 1.
10 marks
How can we use interpolation techniques (methods) to approximate the value of the integral for the functions whose antiderivatives can’t be found? Explain. Wrin a program to solve sinx -2x +1 = 0 using Bisection Method.
10 marks
Tribhuwan University
Faculty of Humanities and Social Sciences
OFFICE OF THE DEAN
2024
Bachelor of Computer Applications
Course Title: Software Engineering
Code No: CACS253
Semester: Fourth Semester
Full Marks: 60
Pass Marks: 24
Time: 3 hours
Candidates are required to answers the questions in their own words as far as possible.
Group B
Attempt any SIX questions. [6 * 5 = 30]
Describe the challenges faced in software engineering.
5 marks
Explain the principles and practices of Extreme Programming (XP) in software development and discuss its significance in modern software engineering methodologies.
5 marks
What is regression testing? How test cases can be designed? Explain.
5 marks
What is user interface design? Describe its main principles and the impact of a well designed UI on user experience and software success.
5 marks
Discuss the relationship between program languages and development tools in software engineering, highlighting how they complement eachother.
5 marks
What is Capability Maturity Model (CMM)? Describe levels of CMM.
5 marks
Explain the concept of versioning in software engineering and discuss its importance in software development and maintenance.
5 marks
Group C
Attempt any TWO questions. [2 * 10 = 20]
Discuss Computer-Aided Software Engineering (CASE) tools, their types, features, and the benefits they bring to the software development process. Provide examples of popular CASE tools and explain how they are used in various stages of the software development lifecycle.
10 marks
Explain the process of requirements validation and requirements specification in the context of software development. Highlight their significance, methods used challenges encountered, and provide examples to illustrate their application.
10 marks
Discuss the concept of modular decomposition in software engineering. Explain its importance , the principles guiding effective modular decomposition, and provide examples to illustrate how modular decomposition can be applied in practice.
Tribhuwan University
Faculty of Humanities and Social Sciences
OFFICE OF THE DEAN
2024
Bachelor of Computer Applications
Course Title: Scripting Language
Code No: CACS254
Semester: Fourth Semester
Full Marks: 60
Pass Marks: 24
Time: 3 hours
Candidates are required to answers the questions in their own words as far as possible.
Group B
Attempt any SIX questions. [6 * 5 = 30]
Write JS program to highlight all of the words over eight characters long in the paragraph text (with a red background)
5 marks
What is javaScript? Explain different types of javascript with proper example.
5 marks
Write PHP function that accepts username and password as arguments and check with student table, if credentials match, redirect to dashboard page otherwise display ‘Invalid username/password’.
5 marks
What is jQuery? Explain XMLHttpRequest object with its properties and methods with relevant example.
5 marks
What is Widgets? Explain different Features of CMS.
5 marks
Write rules to create variable in PHP. How to create , store , access and destroy session in PHP?
5 marks
Write short note on (any two)
a) Types of array in PHP
b) Arrow Function in JavaScript
c) jQuery UI
5 marks
Group C
Attempt any TWO questions.
Write server side script to create and validate form with following rule and store given data into ‘patients’ table with details (name, patient-id, mobile, gender, address, dob, doctor name)
– Name, Mobile, doctor name, gender, dob: Required
– Mobile : 10 digit start with 98, 97 or 96
– DOB: YYYY-MM-DD format
10 marks
What is JavaScript Event? Explain different method that are available to access DOM element using id, class, name and selector with suitable example.
10 marks
What is inheritance? Explain different ways to implement polymorphism in PHP with proper example.
About Author
