What is primary key and foreign key?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What is server name sql?

0 Answers  


Can we insert data in view?

0 Answers  


In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  


What is spool?

0 Answers  


What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,






If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  


what are string data types? : Sql dba

0 Answers  


Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  


What is difference between cursor and ref cursor?

1 Answers  


What is difference between stored function and application function?

0 Answers  


How to return more than one value from a function?

11 Answers   Satyam,


why sql is used as interpreter frequently rather than a compile?

1 Answers  


Categories