What are delete-connected tables ?
Tables related with a foreign key are called delete-connected because a deletion in the primary key table can affect the contents of the foreign key table.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Which two commands can you use to delete directories ? 14.11.08
You can use rmdir or rm -rf to delete a directory. Answer a is incorrect, because the rm command without any specific flags will not delete a directory, it will...What are different types of Tables? 03.11.08
There are 4 types of tables in siebel 1) Base Table (Ex: s_contact, s_user) 2) Extension table ( Ex: s_contact_x) 3) EIM tables 4) Intersection...What does the delete operator do? 11.10.08
The delete operator is used to delete all the variables and objects used in the program ,but it does not delete variables declared with var keyword....Cascade Delete Property for Link ? 26.09.08
This property is to clear the relation or unmapped child date to be removed from the DB. Cascade Delete has 3 types of values. 1) None 2) Clear 3) Delete 1)...What is the difference between star schema and snow flake schema ?and when we use those schema’s? 20.09.08
Star Schema : Star Schema is a relational database schema for representing multimensional data. It is the simplest form of data warehouse schema that contains...What is the difference between Truncate and Delete interms of Referential Integrity? 14.05.08
DELETE removes one or more records in a table, checking referential Constraints (to see if there are dependent child records) and firing any DELETE triggers....Difference between Dynaset and Snapshot? 17.04.07
All Recordset objects are constructed using records (rows) and fields (columns). There are five types of Recordset objects: Table-type Recordset :: represen...How many types of tables exist ? 01.04.07
Four Types of Tables: 1. Transparent tables - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields. B...List some optimization techniques in EIM. 06.12.06
1) Limit base tables and columns to be processed by using : only base Tables,ignore base Tables,only base Columns,ignore base Columns. 2) Always delete batches...What does the delete operator do? 06.07.06
The delete operator is used to delete all the variables and objects used in the program ,but it does not delete variables declared with var keyword....