Difference between primary key and unique key ?
Answer Posted / pandiyan
Primary key doesnot allow null value but unique key allows
null value.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is an oracle function?
Point out the difference between user tables and data dictionary?
How to run create database statement?
What are the database administrators utilities available?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is a sub query? What are its various types?
How to manage transaction isolation level?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What is the difference between alert log file and tarce file ?
How to count duplicated values in a column in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Explain view?
What is the scope of a local variable?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?