What are primary key and foreign key and how they work?


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

Post New Answer

More SQL PLSQL Interview Questions

what is Difference between Having and Where clause?

5 Answers   IBM,


What is faster join or subquery?

0 Answers  


What are the types of SQL Statement?

3 Answers  


What is join view in sql?

0 Answers  


if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,






ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,


What is TABLE SPACE?

4 Answers   ABB, TCS,


what are string data types? : Sql dba

0 Answers  


While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,


I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  


What is mutating table?

11 Answers   Saama Tech,


which operator is used in query for pattern matching? : Sql dba

0 Answers  


Categories