What is primary key and foreign key?
No Answer is Posted For this Question
Be the First to Post Answer
What is server name sql?
Can we insert data in view?
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
What is spool?
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.
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)
what are string data types? : Sql dba
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is difference between cursor and ref cursor?
What is difference between stored function and application function?
How to return more than one value from a function?
why sql is used as interpreter frequently rather than a compile?