Interested to Buy Any Domain ? << Click Here >> for more details...
Give two examples of referential integrity constraints.
- 2 Answers
- 8622 Views
- I also Faced
- E-Mail Answers
Answer Posted / kalyan maddipati
Emp and Dept tables is the good example fro referential integrity as DeptNo in Dept table refers DeptNO of Emp table.
ie. You have a PK(Primary key) on Deptno of Dept table and FK(Foreign key) on Deptno of EMP Table
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what do you understand by flashback feature of oracle?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you find out if a table can be redefined?
What happens on checkpoint? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Explain materialized views and how they are used.
what is asm?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how can you schedule a job in database?
how can you get actual data change values from previous transactions in oracle?
what are the differences of where and if in SAS?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
