prathmeshyelne has Published 58 Answers

What is OLAP ?

Published on 16-Dec-2021 16:34:02
OLAP stands for Online Analytical Processing. And a class of software programs which are characterized by relatively low frequency of online transactions. Queries are often too complex and involve a bunch of aggregations.... Read More

What is Data Integrity ?

Published on 16-Dec-2021 16:32:22
Data Integrity is the assurance of accuracy and consistency of data over its entire life-cycle, and is a critical aspect to the design, implementation and usage of any system which stores, processes, or retrieves data. It also defines integrity constraints to enforce business rules on the data when it is entered into an application or a database.... Read More

What is OLTP ?

Published on 16-Dec-2021 16:30:58
OLTP stands for Online Transaction Processing. And is a class of software applications capable of supporting transaction-oriented programs. An essential attribute of an OLTP system is its ability to maintain concurrency... Read More

What are Nested Triggers ?

Published on 16-Dec-2021 16:29:11
Triggers may implement DML by using INSERT, UPDATE, and DELETE statements. These triggers that contain DML and find other triggers for data modification are called Nested Triggers.... Read More

What are the types of SQL Queries ?

Published on 16-Dec-2021 16:23:22
We have four types of SQL Queries: DDL (Data Definition Language): the creation of objects DML (Data Manipulation Language): manipulation of data DCL (Data Control Language): assignment and removal of permissions TCL (Transaction Control Language): saving and restoring changes to a database Let’s look at the different commands under DDL: Command Description CREATE Create objects in the database ALTER A... Read More

Write C Program to Find Factorial of Number Using Recursion

Published on 16-Dec-2021 16:13:59
#include stdio.h> #include conio.h> int fact(int); int main() { int factorial, num; printf("Enter the value of num :"); scanf("%d", &num); factorial = fact(num); printf("Factorial is %d", factorial); return (0); } int fact(int n) { if (n == 0) { return (1); } return (n * fact(n - 1)); } ... Read More

How to Solve Second Order Quadratic Equation Using C Program

Published on 16-Dec-2021 16:09:33
Program : To obtain solution of second order quadratic equation #include <stdio.h> #include <math.h> int main() { float a, b, c; float desc, root1, root2; printf("\nEnter the Values of a : "); scanf("%f", &a); printf("\nEnter the Values of b : "); scanf("%f", &b); printf("\nEnter the Values of c : "); scanf("%f", &c); desc = sqrt(b * b - 4 * a * c); root1 = (-b + desc) /... Read More

How to calculate sum of 5 subjects and find percentage Using C Program

Published on 16-Dec-2021 16:02:43
C Program to calculate sum of 5 subjects and find percentage #include <stdio.h> int main() { int s1, s2, s3, s4, s5, sum, total = 500; float per; printf("\nEnter marks of 5 subjects : "); scanf("%d %d %d %d %d", &s1, &s2, &s3, &s4, &s5); sum = s1 + s2 + s3 + s4 + s5; printf("\nSum : %d", sum); per = (sum * 100) / total; printf("\nPercentage : %f", per); return (0); } ... Read More

How to reverse a given number using C

Published on 16-Dec-2021 15:56:34
#include <stdio.h> int main() { int num, rem, rev = 0; printf("\nEnter any no to be reversed : "); scanf("%d", &num); while (num >= 1) { rem = num % 10; rev = rev * 10 + rem; num = num / 10; } printf("\nReversed Number : %d", rev); return (0); } Output : Enter any no to be reversed : 123 Reversed Number : 321 ... Read More

How to calculate gross salary of a person using C Program

Published on 16-Dec-2021 15:48:12
#include <stdio.h> int main() { int gross_salary, basic, da, ta; printf("Enter basic salary : "); scanf("%d", &basic); da = (10 * basic) / 100; ta = (12 * basic) / 100; gross_salary = basic + da + ta; printf("\nGross salary : %d", gross_salary); return (0); } Output : Enter basic Salary : 1000 Gross Salart : 1220 ... Read More