Interested to Buy Any Domain ? << Click Here >> for more details...
Give two examples of referential integrity constraints.
- 2 Answers
- 8606 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
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what are the differences of where and if in SAS?
how can you schedule a job in database?
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.
what functionality does oracle provide to secure sensitive information?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
what is the use of recording information about current session?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How to start SQL Server in minimal configuration mode?
how can you record information about current session?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
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.
how can you initialize log miner?
