Data warehouse can be defined as the integrated, subject oriented and non volatile collection of data. The data collected in warehouse help analysts in organized decision making. The data stored can undergo frequent changes on daily basis. The warehouse data will provide an overview about a product which will further assist in improving the business. […]
Archives for July 2016
Difference Between Class and Primitive Types
All the variables declared in Java are classified into certain type. The classification of variables will help us in treating the variables according to its type. Variables in Java are classified as characters, several types of integers, floating points and types to declare a statement true or false. All the above mentioned variable types are […]
Database Roles in SQL
Database role can be defined as the collection privileges assigned one or several users. Each database role is given a name. Most RDBMS platforms have set of predefined roles assigned to a user. Every user with CREATE ROLE privilege can create his/her own database role. Roles in database allow a user to set up hierarchical […]
CASE Expression in SQL
The CASE statement is popularly known as CASE Expression, allows the user to execute a part of SQL statement conditionally. In SQL, CASE statement is used for storing the procedure or formula of a particular column. The CASE expression can be classified into two types namely: Simple CASE Statement Searched CASE Statement Basic Syntax for […]
Concurrent Update Problem
Concurrent update problem in a database can be defined as the occur when multiple sessions are allowed to update their data present in a single database. Concurrent update problem may lead to data integrity loss and data corruption. Read: More Interview Questions Example for Concurrent Update Problem Imagine that we have an application which manages […]
What is DB2 Transaction in SQL?
Transactions in database are defined as the group database operations which are combined under a logical unit. Transactions can be used to maintain consistency, integrity and control over a database. The data integrity is maintained despite the errors thrown by the system. Database transactions use several statements like SELECT, UPDATE, DELETE and INSERT. All modification […]
Difference Between Correlated and Uncorrelated Subquery
What is Correlated Subquery? Correlated subquery can be defined as the inner query referenced by the outer query. The outer query reference the inner query for repeated execution. Correlated subqueries will contain the references to the objects present in the parent statement. The operation of correlated subquery depends upon the evaluated row in the parent […]
- 1
- 2
- 3
- …
- 9
- Next Page »