Prathmesh Yelne has Published 62 Answers

What is SQL injection ?

Updated on 16-Dec-2021 16:43:22

SQL injection is a hacking technique which is widely used by black-hat hackers to steal data from your tables or databases. Let’s say, if you go to a website and give in your user information and password, the hacker would add some malicious code over there such that, he can get the user information and password directly from the database. If your database contains any vital information, it is always better to keep it secure from SQL injection attacks.... Read More

What is a unique key in SQL ?

Updated on 16-Dec-2021 16:40:54

Unique Key is a constraint in SQL. So, before understanding what exactly is a primary key, let’s understand what exactly is a constraint in SQL. Constraints are the rules enforced on data columns on a table. These are used to limit the type of data that can go into a table. Constraints can either be column level or table level. Unique Key:  Whenever we give the constraint of unique key to a column, this would mean that the column cannot have any duplicate values present in it. In other ... Read More

How to delete a column in SQL ?

Updated on 16-Dec-2021 16:39:14

To delete a column in SQL we will be using DROP COLUMN method: ALTER TABLE employees DROP COLUMN age; We will start off by giving the keywords ALTER TABLE, then we will give the name of the table, following which we will give the keywords DROP COLUMN and finally give the name of the column which we would want to remove.... Read More

What is a schema in SQL ?

Updated on 16-Dec-2021 16:35:48

Our database comprises of a lot of different entities such as tables, stored procedures, functions, database owners and so on. To make sense of how all these different entities interact, we would need the help of schema. So, you can consider schema to be the logical relationship between all the different entities which are present in the database. Once we have a clear understanding of the schema, this helps in a lot of ways: We can decide which user has access to which tables in the data... Read More

What is OLAP ?

Updated 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 ?

Updated 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 ?

Updated 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 ?

Updated 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 ?

Updated on 19-Dec-2021 16:56:21

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 Alters the structure of the database object DR... Read More

Write C Program to Find Factorial of Number Using Recursion

Updated 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

Previous 1 2 3 4 57 Next