What is Relational Algebra in DBMS ?
A procedural query language which is used widely is known as Relational Algebra. Instances of relation are given as input...
What do you understand by Query Optimization ?
It is a phase which identifies a plan for evaluation query that has the least estimated cost. We can use query optimizer...
Explain levels of abstraction in DBMS ?
There are 3 levels of abstraction in DBMS Physical Level It is the lowest level of data abstraction and is managed by DBMS....
What is Hierarchical model in DBMS ?
Features of Hierarchical Model This model is based on the tree structure. This model contains a collection of records that...
What is Join in DBMS and what are its types ?
DBMS join is a binary operation that allows combining join products and selecting in one single statement. If data needs to...
Difference Between malloc() and calloc()
calloc malloc We need to split and pass the memory we want We can pass how much memory we want. Ex: p=calloc(5,sizeof(int)...
What is constant and variable in C ?
Constant A constant is a value or identifier whose value is fixed and does not change, in the entire program. Constant is...
What is Dynamic data structure ?
We need a dynamic data structure to data efficiently into memory. Memory spaces in a program can be accessed using dynamic...
What are the types of data types in C ?
C language supports 3 data types: Primary Data Types User Defined Data Types Secondary Data Types Primary Data Types:...
What do you mean by Data Type in C ?
Data type is type of the value that a variable can store. Each variable has its own data type and each data type occcupies...
Difference between getc(), getchar(), getch() and getche()
getc() This function gets single character as input and returns an integer value. If this fails, it returns EOF. Syntax of...
What is the difference between puts() and printf() ?
Printf() Puts() Declared in the header file stdio.h Declared in the header file stdio.h Function to print a formatted string...
What is l-value and r-value in C ?
L Value L value or locator value represents an object that occupies some identifiable location in memory. In an assignment...
What is a header file in C ? What will happen if we include a header file twice in a C program ?
Header files store the definitions and rules for different built-in functions in the C program. For example, printf(),...
Explain break and continue statements with examples
Break This statement is used with switch statement. Can also be used with while loop, do – while loop and for loop. When the...
What is dangling Pointer in c ?
The most common bugs related to pointer & memory management is called dangling or wild pointers. Sometimes programmer...
What are called and calling functions ?
A function call is very important in programming. When we need to call a function, it is called inside a program. A function...
How many types of data type in C Language ?
C language supports 3 data types: Primary Data Types User Defined Data Types Secondary Data Types Primary Data Types Integer...
What is the use of printf() and scanf() functions ?
Scanf() Scanf() is the most commonly used in C langauage. They are inbuilt functions in the c program which is in the...
What is While Loop in C Language with example ?
While loop evaluates the conditions inside the brackets. If the condition returns true, the statements inside the while loop...
