What are keys in sql?



What are keys in sql?..

Answer / Vineeta Gunjiyal

Keys in SQL are used to enforce uniqueness of data within a table or a combination of columns. There are two main types of keys: PRIMARY KEY and UNIQUE CONSTRAINT. The primary key is a specific type of unique constraint that identifies each row uniquely.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

describe transaction-safe table types in mysql : sql dba

1 Answers  


Types of cursors and explanation each of them ?

4 Answers   DELL,


What is example of database?

1 Answers  


what is the output of this query selet * from employee where 1=2 ??

11 Answers  


In testing where do we use sql language and how it helps in testing?

2 Answers  


when a procedure /package is getting invalidated?

4 Answers   TCS,


how to select unique records from a table? : Sql dba

1 Answers  


Is sql a oracle?

1 Answers  


i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  


What is join view in sql?

1 Answers  


How long will it take to learn pl sql?

1 Answers  


Is it possible to sort a column using a column alias?

1 Answers  


Categories