Interested to Buy Any Domain ? << Click Here >> for more details...
Give two examples of referential integrity constraints.
- 2 Answers
- 8503 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / monal
RELATIONSHIP BETWEEN CUSTOMERS AND ORDERS &
RELATIONSHIP BETWEEN ORDERS AND ORDERDETAILS
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
What the different topologies in which replication can be configured? : sql server DBA
what is rebuild index??
How would you go about generating an EXPLAIN plan?
What the different components in replication and what is their use? : sql server DBA
1)how to Take Backup in sql server 2005 from Flash Drive
What authentication modes does sql server support? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is blocking and how would you troubleshoot it?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
What happens on checkpoint? : sql server DBA
what are the performance views in an oracle rac environment?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
