Define the terms primary key foreign key and also the
difference between primary and the unique key
Answers were Sorted based on User's Feedback
Answer / pugal
Primary Key : The primary key of a relational table
uniquely identifies each record in the table
Foreign Key : These keys are used to create relationships
between tables.
Unique Key : In relational database design, a unique key is
a candidate key to uniquely identify each row in a table. A
unique key comprises a single column or set of columns
Difference between primary and unique key :
primary key not allows null values
unique key allows null values
Is This Answer Correct ? | 33 Yes | 12 No |
Answer / nithya
one more difference is:
a table can have only one primary key but many unique keys.
Is This Answer Correct ? | 22 Yes | 3 No |
how to find full database size
1 Answers BirlaSoft, Consultancy,
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
What is set operator oracle?
What is Data Block ?
How many memory layers are in the shared pool?
Explain a private synonyms?
What is ceil and floor in oracle?
how to get the second max val for every group in a table
How do we display rows from the table without duplicates?
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
What are the uses of a database trigger?