Query to find 2nd largest value in a column in Table
Problem: Write a SQL query to find the 2nd largest value in a column in a table. Examples: In the 1st example find the 2nd… Read More »
Category Archives: DBMS
Comparisons between Oracle vs SQL Server
Among several electronic database Management System, the 2 most well liked and wide used are: Oracle and SQL Server. Oracle supports the operating systems such… Read More »
Difference between Schema and Database
Database: Database may be a common term in today’s life. several enterprises, firms, organisation, institutes, etc. needs a system to store their information in a… Read More »
Difference between Star Schema and Snowflake Schema
Star Schema: Star schema is the type of multidimensional model which is used for data warehouse. In star schema, The fact tables and the dimension… Read More »
Difference between RAID 0 and RAID 1
RAID stands for Redundant Array of Independent Disk, is the technique used for disk organisation for reliability and performance. Both RAID 0 stands for Redundant… Read More »
Difference between ROLAP and MOLAP
Relational Online Analytical Processing (ROLAP): ROLAP is used for large data volumes and in this data is stored in relation tables. In ROLAP, Static multidimensional… Read More »
Difference between Data Warehouse and Data Mart
Both Data Warehouse and Data Mart are used for store the data. The main difference between Data warehouse and Data mart is that, Data Warehouse… Read More »
Difference between Relational Algebra and Relational Calculus
Both Relational Algebra and Relational Calculus are the formal query languages. Relational Algebra: Relational Algebra is a Procedural language. In Relational Algebra, The order is… Read More »
Difference between Strong and Weak Entity
Prerequisite – ER Model Strong Entity: Strong entity is not dependent of any other entity in schema. Strong entity always has primary key. Strong entity… Read More »
Difference between Super Key and Candidate Key
Prerequisite – Keys in Relational Model Super Key: Super Key is an attribute (or set of attributes) that is used to uniquely identifies all attributes… Read More »
Difference between Normalization and Denormalization
Normalization: Normalization is the method used in a database to reduce the data redundancy and data inconsistency from the table. It is the technique in… Read More »
Difference between Primary and Candidate Key
Prerequisite – DBMS | Keys in Relational Model Both Primary Key and Candidate Key are the attributes that are used to access tuples from a… Read More »
Domain Relational Calculus in DBMS
Domain Relational Calculus is a non-procedural query language equivalent in power to Tuple Relational Calculus. Domain Relational Calculus provides only the description of the query… Read More »
Security Management System
Security Management System (ISMS) is defined as an efficient method to managing sensitive company information so that it remains secure. The security management system is… Read More »
Attribute Subset Selection in Data Mining
Attribute subset Selection is a technique which is used for data reduction in data mining process. Data reduction reduces the size of data so that… Read More »
