what are primary key and foreign key ?
Answers were Sorted based on User's Feedback
Answer / neo devan
Primary key is the attribute which satisfies both
uniqueness and Not null constraints.
The foreign key is a attribute that points to a valid
column in a parent table.
its used for referencing primary key.
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / rukumanikhandhan
primary key is the key which follows uniqueness in the
entire table.
primary key of one table will be called as foreign key in
another table.
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / sabeena parveen
primary key is an attribute which uniquely identifies each
record in the table.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / radha
Columns acting as a primary key will always hold unique
values.
Foreign key should always be a primary key of some table
Is This Answer Correct ? | 1 Yes | 0 No |
Define normalization.
What do you understand by the view and mention the steps to create, update and drop a view?
How do you maintain a database?
What is Log Switch ?
How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?
What are the database objects?
What are the SQL clauses supported in the link property sheet ?
Differentiate between nested loop, hash loop and merge join.
Briefly describe an outer join.
Which parameters are optional in init.ora parameter file?
What is the best database for big data?
How do databases work?