SQL

Emergency Mode is a state of SQL database that allows read only access even if it is corrupted. You can use this mode to recover a database, which is in SUSPECT or RECOVERY pending state, or for other troubleshooting needs. Sometimes, SQL Server itself changes the database to EMERGENCY mode. In this article, we will

SQL is a language that is used to manage relational databases. It provides a facility for easily declaring and using variables. We can use variables for storing temporary values in memory for performing calculations. In SQL variables can be used in the same way we use in any other programming language. SQL Declare Variable In

SQL Server database is a term you’re probably already familiar with. When it comes to storing large amounts of data, databases are extremely useful. And as you’ve figured out, SQL Server’s default settings aren’t always the best. When working with new user databases, this is the case. We can define a database as, In SQL

In this article, we will have a look at the difference between Entity and Attribute, which form the core principles of the Entity-Relationship Model in Database Management System. We will look at the description of each in detail with examples and compare them for a clear idea. Entity An Entity is defined as any object

Oracle is a Database Management System that is used across the world in various companies. Oracle makes use of SQL or ‘Sequel’ language for data manipulation & operations on data. Today, in this article, we will check out the History of Oracle database. ‘SEQUEL’ was developed by IBM Corporation Ltd to use various Codd’s models

Companies everywhere are handling more data than ever and all these terabytes of data need to be stored somewhere. Should you store the data in a database, a data warehouse, or a data lake? How do you know what is best for your company? Choosing the right data storage solution will depend greatly on how

In this article we look into the difference between Primary Key and Unique Key Constraints. We will see the description of both along with how to define a schema and create attributes in a table with these constraints. Primary Key A Primary Key is a key attribute or a column which is used to uniquely

In this article we look into the difference between CLOB and BLOB datatypes in Oracle/MYSQL. We will also see about the description of each datatype and how to create attributes in a table with these datatypes. So, CLOB and BLOB are types of Large Object Datatypes (LOB). LOB’s are a set of datatypes used to