All questions
- DataBase Management System viva question What are the characteristics of databases? What is the difference between a file system and a database system? What is data abstraction and... 1
- if x is a poisson variate such that p(x=1)= p(x=2) find e(x^2) Given that P(X=1) = P(X=2), we can write: beginaligned P(X=1) &= e^(-λ)λ¹/1! \\ P(X=2) &= e^(-λ)λ²/2! endaligned Dividing the two equations,... 1
- Analysis of algorithms viva question semester 4 mumbai university What is the mathematical background required for algorithm analysis? What is the significance of performance analysis in algorithms? Define... 1
- Calculate the V number of an optical fibre having numerical aperture 0.25 NA = 0.25 Core diameter = 20 μm λ0= 1.55 μm Formula: V = ᴨd / λ0 ×NA V = 3.14×20×10⁻⁶ /1.55 ×10⁻⁶ ×0.25 V = 10.13 1
- What is pumping in LASER? Give the types of pumping. The process of raising large number of atoms from lower energy to a higher energy level is called pumping. Types of pumping: 1. Optical pump... 1
- Calculate the V number of an optical fibre having numerical aperture 0.25 and core diameter 20 μm NA = 0.25 Core diameter = 20 μm λ0= 1.55 μm Formula: V = ᴨd / λ0 ×NA V = 3.14×20×10⁻⁶ /1.55 ×10⁻⁶ ×0.25 V = 10.13 1
- What is Rayleigh’s criterion of resolution? Define resolving power of grating? According to the Rayleigh’s criterion, two closely spaced point sources of light are said to be just resolved by an optical instrument only... 2
- Why the Newton’s rings are circular and centre of interference pattern (reflected) is dark? In both air-wedge film and newton’s ring experiments, each fringe is the locus of points of equal thickness of the film. In newton’s ring ex... 2
- Create table student with required attribute and perform following query: To create the STUDENT table with the required attributes: CREATE TABLE STUDENT ( S_ID INT PRIMARY KEY, S_NAME VARCHAR(50) NOT NULL, S_EMAIL... 1
- Write SQL queries for given Database , Find total number of people who owned cars that involved in accident 2004 1. To find the total number of people who owned cars that were involved in accidents in 2004, we can join the tables Owns, Car, and Accident... 1
- Write SQL queries for given Database , Modify database so ‘jack’ is now live in ‘mumbai’ To modify the database so that 'jack' is now living in 'mumbai', you can use the following SQL query: UPDATE Employeee SET city = 'mumbai' W... 1
- Write SQL queries for given Database , Find name of employee having first letter ‘S’ in their names 1. To find the name of employees having the first letter 'S' in their names, we can use the following SQL query: SELECT empname FROM Employe... 1
- Write a program to implement Disk Scheduling algorithms like FCFS, SCAN and C- SCAN. FCFS Disk Scheduling Algorithm: #include<stdio.h> #include<stdlib.h> int main() int queue[20], n, head, i, seek = 0; float avg; printf("Ente... 2
- Write a program to implement various page replacement policies #include<stdio.h> int main() int frames[100], pages[100], n, m, i, j, k, flag, fault = 0; printf("Enter number of frames : "); scanf("%d",&n... 2
- Write a program to implement dynamic partitioning placement algorithms i.e Best Fit, First – Fit and Worst –Fit. #include<stdio.h> int main() int i, j, n, m, bsize[100], psize[100], bstatus[100], pstatus[100], fit, flag; printf("Enter number of memory b... 2
- Write a program to demonstrate the concept of deadlock avoidance through Banker’s Algorithm #include<stdio.h> int main() int n , m , i , j , k; n = 5; m = 3; int alloc[ 5 ] [ 3 ] = 0 , 1 , 0 , 2 , 0 , 0 , 3 , 0 , 2 , 2 , 1 , 1 , 0 ,... 1
- Program to simulate producer and consumer problem using semaphores #include<stdio.h> #include<stdlib.h> #include<stdbool.h> #define BUFFER_SIZE 3 int buffer[BUFFER_SIZE]; int in = 0, out = 0; bool isBufferEm... 2
- Write a program to implement CPU Scheduling algorithms like FCFS & SJF FCFS #include <stdio.h> int main() int n, i; float avg_waiting_time = 0, avg_turnaround_time = 0; printf("Enter the number of processes: ");... 2
- Er diagraam sql queries SQL Queries SQL (Structured Query Language) is a standard language used to manage and manipulate relational databases. Here are some example... 1
- Write short notes on : Longest common subsequence The longest common subsequence (LCS) of two strings is the longest sequence of characters that appears in both in the same order (not necess... 1
- Write short notes on : 8 Queen problem The 8-queen problem is to place 8 queens on an 8×8 chessboard so that no two queens attack each other; it is solved by backtracking. Constra... 1
- Write short notes on : Job sequencing with deadlines. Job sequencing with deadlines is a greedy method that picks jobs in decreasing order of profit and puts each one in the latest free time slo... 1
- Explain how backtracking is used for solving n- queens problem. Show the state space tree. Backtracking places queens one row at a time and undoes (backtracks) a placement as soon as no safe column is left for the next row. Problem... 1
- write a detailed note on Hamiltonian cycles. A Hamiltonian cycle is a cycle in a graph that visits every vertex exactly once and returns to the starting vertex. Definition. For a graph... 1