what is the difference between first normal form & second
normal form?
Answers were Sorted based on User's Feedback
Answer / shri
first normal form contains repating groups
second normal form all key attributes dependent on non-key
attributes
| Is This Answer Correct ? | 14 Yes | 22 No |
How do we know whether an index is created on a table ???
Difference between varchar and varchar2 data types?
What does `(+)` do in a where clause?
Why do you create or replace procedures rather that drop and recreate.
What are the different approaches used by Optimizer in choosing an execution plan ?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
What is oracle join syntax?
What is flashback Query ? And Use ?
How to execute a stored procedure in oracle?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What is the use of aggregate functions in oracle?
How do you tell what your machine name is and what is its IP address?