ALLInterview.com :: Home Page Forum9.Com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories >> Software >> Databases >> MS-Access
 
 


 

Back to Questions Page
 
Question
What’re ERD and the main elements of an ERD? Please explain 
using an ERD example.
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
ERD is Entiry Relationship diagram..
the main components are Entities, and their atributes with 
relations.
 
0
Rajput
 
 
Question
can primary key of one table be a primary key in many other 
tables
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
no we can 't do like that , the primary will be the foreign
key for the another table!!
 
0
Jayanth
 
 
Answer
The Primary Key of one table is foreign key for other 
table. The primary key of one table can be primary key of 
other tables, but there will be no use of that, it will 
break the RDBMS Rule and make the RDBMS slow.
 
0
Pramod
 
 
 
Answer
No..We can't create the primary key of one table be a 
primary key in many other tables..
Primary Key will be the foreign key of another table..
only one primary key is possible 2 table.
 
0
Chaitali
 
 
Question
how  to u retrieve  all tables along with all  the data
Rank Answer Posted By  
 Question Submitted By :: Tara Krishna Suggula
This Interview Question Asked @   Satyam
I also faced this Question!!   © ALL Interview .com
Answer
create one blank database
then go to file there u will the option external date there
select import option then select from which data base u want
to retrieve all tables , if u select the tables the data
also comes along with that
 
0
Jayanth
 
 
Question
Can you create a updatecascade, Deletecascade relation in
Ms-Access? If yes, give an example?
Rank Answer Posted By  
 Question Submitted By :: Panigrahi_saroj30
I also faced this Question!!   © ALL Interview .com
Answer
Yes. You CAN. you need to set the referential integrity in 
Relations window in MS Access. When you add a relation to a 
table, you will be prompted through Edit relations window 
where you can set the cascade updates and cascade deletions.
 
2
Upendra Agnihotram
 
 
Answer
After make ensure of having unique index for setting up 
the "Enforce referential integrity" at relationships in MS 
access we Can create a updatecascade, Deletecascade 
relation in Ms-Access.

Try and let to share.

Note:- Good Upendra.A
 
1
Susi Kumar.p
 
 
 
Back to Questions Page
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com