Sunday, August 12, 2018

What is SQL.

 1.  What is Sql.?
Ans: SQL Stands for structure Query Language.
         SQL programming can be effectively used to insert, search, update, delete database records.

2. RDMS:( Relational database management system)

RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM  DB2, Oracle, MySQL, and Microsoft Access.

The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.



        
   

- No comments:
Subscribe to: Posts (Atom)

How to use SQL pagination using LIMIT and OFFSET

  How to extract just a portion of a larger result set from a SQL SELECT. LIMIT n is an alternative syntax to the FETCH FIRST n ROWS ONLY. T...

  • Difference between Unique Key and Primary Key.
    Difference Between Primary key & Foreign key Primary Key Foreign Key Helps you to uniquely identify a record in the table. It is...
  • What is Trigger and Why we use It.
    Ans: A trigger is a special kind of Stored Procedure or stored program that is automatically fired or executed when some event (insert, d...
  • TUPLE
    A tuple is a data structure that contains a sequence of elements of different data types.  It can be used where you want to have a data s...