What is unique key example?
What do you understand by data independence? What are its two types?
Who is end user in database?
Define cursor.
Explain the terms specialization and generalization.
Why is the use of dbms recommended? Explain by listing some of its major advantages.
What do you mean by checkpoints in dbms?
What is tuple with example?
what is GET_BLOCK property ?
What is the full meaning of dbms?
What does you mean by s4 super key?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name, price 101, LED Lights,200 102, 20 watt CFL Lights, 145 103, 30 watt CFL lights,155 Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence flat file product list has two column pro_name, price 20 watt tube light ,45 30 watt tube light ,60
Explain the difference between primary and foreign key?