Difference between SQL and PLSQL

SQL PL/SQL SQL is structural query language for database. It has no variables. Pl/SQL is a programming language using SQL for database. It has variables and data types SQL has…
View Answer

Char vs Varchar in SQL

Char VarChar Char data type is used for storing single character values It is a SQL Code that helps in storing variable character Used to store characters string of fixed…
View Answer

Types of indexes in SQL

There are various types of indexes in SQL server: Clustered Index Non-Clustered Index Column Store Index Filtered Index Hash Index Unique Index Clustered Index Rows of data are sorted and stored…
View Answer

What is a Database ?

In computing, database is an organized collection of data stored which is accessed electronically. A database is usually controlled by Data Base Management Systems(DBMS). In a computer data is stored…
View Answer

What is a primary key ?

In relational database primary key is a specific choice of minimal set of attributes that uniquely specify a relation. Primary key is a special realational database table column key that…
View Answer

What is Normalization in SQL ?

It is a rule where larger tables are divided into smaller tables and they are linked using relationships. Process of organizing data in a data base is called as Normalization.…
View Answer

What is SQL ?

SQL stands for Structured Query Language. It is used for interacting with databases. SQL is also known as standard query language which is used for maintaining relational database management systems(RDBMS).…
View Answer