Tuning SQL Index

In a database, SQL indexes are used to accelerate the query searching process. But using indexes will consume a lot of space and require regular maintenance. The regular maintenance on indexes will ensure the smooth running of database. This article will provide you some guidelines and tips to properly utilize indexes without any hassles. MySQL […]

SQL REVOKE Command

REVOKE command in SQL is used to remove one or more privileges assigned to a database user. The basic syntax for REVOKE command is given below. REVOKE priv_type [(col_list)] [, priv_type [(col_list)]]… ON [obj_typ] priv_level FROM user [, user_name] The list of privileges that need to be revoked is mentioned right after the REVOKE statement. […]

SQL GRANT Command

GRANT command in SQL is used grant one or more privileges to a database user. The basic syntax for GRANT statement in a SQL is given below. GRANT privilege_name ON object_name TO {user_name |PUBLIC |role_name} [WITH GRANT OPTION]; privilege_name: is the privilege provided to the user. The access right for a user includes ALL, SELECT […]

How to Prevent SQL Injection?

SQL injection attack is a threat to even the most secured database in the world. Even the most secure database of CIA, Citi bank, MI6 were subjected to SQL attack. This article will guide through the steps to prevent your databases from basic SQL injection attacks. Read: More Interview Questions Input Sanitization The basic step […]

Difference Between Primary, Foreign and Unique Keys

In SQL, keys are used to identify records present in a database. The keys used in SQL may look identical but their behaviour is entirely different. The difference between primary, unique and foreign keys is one of the most important concepts in relational database management. The difference between keys is also a common SQL interview […]

Difference Between HAVING Clause and GROUP BY Statements

The difference between the HAVING Clause and GROUP BY statement is common question asked in the database interviews. Both HAVING and GROUP BY are used as an extension of SQL queries. These extended SQL queries are used to filter the rows and return a particular value. HAVING clause and GROUP BY statements play an important […]

Why Inner Class is Used in Java?

The main reason behind the use of inner class is to group the classes with particular logic. This process of grouping classes is called as encapsulation. Increased use of encapsulation in a program will make the code more readable. Why the Use of Inner Class is Necessary in Java? Consider you are using a chat […]

STUDENTS 3K