ALLInterview.com :: Home Page            
 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  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Databases >> MS-Access
 
 


 

Back to Questions Page
 
Question
What is the main difference between DBMS and RDBMS?
Rank Answer Posted By  
 Question Submitted By :: Kuldeep Singh
I also faced this Question!!   © ALL Interview .com
Answer
only besed on rules.
 
0
Kuldeep Singh
 
 
Answer
1)DBMS Support a single Users only but RDBMS Support Several Users.
2)RDBMS treats data as Tables internally.DBMS Treats data as Files Internally
3)RDBMS supports minimum 6 rules of E.F.CODD.DBMS  supports 3 rules of E.F.CODD Out off 12 rules
4)RDBMS requires High software and hardware requirements.DBMS require Low software & Hardware
 
0
Karthikmanoharan
 
 
Answer
In my point of view Database Management System (DBMS) is a tool that is used to manage data either manually or electrically with out using Relations(tables). On the other hand Relational Database Management System(RDBMS) is an electronical tool that use relations (tables) to manage data.
 
0
Waqas Khan Bhatti
 
 
 
Question
what do u mean by heptic shedule over india
Rank Answer Posted By  
 Question Submitted By :: Anchal Asthana
I also faced this Question!!   © ALL Interview .com
Answer
nothing to worry its simple
 
0
Anchal Asthana
 
 
Question
If you know "Access", you can capture data from "Excel" 
broadsheet, but the limitation is that, a memo data type 
of "Access" can only hold characters upto- (a)31,000; (b 
32,000; (c)33,000; (d)34,000.
Rank Answer Posted By  
 Question Submitted By :: Bb
This Interview Question Asked @   Wipro
I also faced this Question!!   © ALL Interview .com
Answer
Answer is (b) A Memo data type in access can hold upto 
32000 characters.
 
0
Ak Singh
 
 
Question
What is a diffrence between SQL, MS access and SAS?
Rank Answer Posted By  
 Question Submitted By :: Nisha_bhasker
This Interview Question Asked @   Genpact , Tt
I also faced this Question!!   © ALL Interview .com
Answer
SQL is a server based database whereas MS Access is a local 
database.
SQL can be used when the number of users is high. For 
example, considering MS Access, only 5 users can make use 
of the access database at the same time. But incase of SQL, 
many users can access the database at the same time.
 
5
Sweety
 
 
Answer
Yes SQL can be used when the number of users is high in the
database
 
5
Hussain
 
 
Question
Difference between MS Access and Oracle
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   CMC
I also faced this Question!!   © ALL Interview .com
Answer
There are many differences between Oracle and Access. First,
you need to know that Oracle and Access are both relational
database engines. Oracle is sold by Oracle Corporation and
Access is sold by Microsoft. The biggest differences between
the two are the size and number of users each supports.
Oracle is a scalable enterprise database engine that
supports from one to many (tens to hundreds of thousands) of
simultaneous users. Access on the other hand is most
commonly used as a single-user database but since the
release of Access 97, can be augmented with Visual Basic
code and can easily support 100+ simultaneous users (Top
limit of 200 users). Oracle can support very large databases
(Tens of Terabytes in size or larger), while Access is
designed for much smaller databases in the 1 to 2 gigabyte
size range.
 
0
Dessika
 
 
Answer
1.Oracle is multi-user where MS-Access is not. 

2.Oracle's features for distributed transactions, 
materialized views and replication are not available with 
MS Access. These features enable Oracle to efficiently 
store data for multinational companies across the globe. 
Also these features increase scalability of applications 
based on Oracle. 

3.We can't create sequence in Microsoft Access.We create 
sequence in Oracle. 

4.Oracle database is more secured than MS-Access. Oracle 
can handle a database having million records very 
efficiently, but MS-Access has no such quality like Oracle. 

5.oracle is client server technology based while Ms-Access 
is not. 

6.Oracle follow 11 rule of E.F CODD and access follow 7 
rule, oracle give better query performance in comparison to 
access, oracle perform high security featureĀ like system 
manager, oracle can store unlimited data in access limit.
 
0
Kani
 
 
Question
Which of the following is used to enter or display data via
Internet? Data in it is stored as HTML files, with data read
from and written to the database.
Macros
Queries
Forms
Pages
Rank Answer Posted By  
 Question Submitted By :: Shumail.mohd
This Interview Question Asked @   Wipro
I also faced this Question!!   © ALL Interview .com
Answer
Pages
 
0
Yogeshwaran Faculty
 
 
Question
what is the 4 types of validation
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
Required field validation\
custom validation 
compareto validation
regularExperation validation
 
0
Nadeem
 
 
Answer
Required field validation\
custom validation 
compareto validation
regularExperation validation
 
0
Kamlesh Kumar
 
 
Question
can ms access be used in a website instead of sql server?
Rank Answer Posted By  
 Question Submitted By :: Abc
I also faced this Question!!   © ALL Interview .com
Answer
We cannot use MS Access in a WebSite instead of SQL Serve. 
Becouse MS Access can be used for Local service. But in the 
Website we need to be Server.
 
0
Ram Birendra Jha
 
 
Answer
MS Access can be used on a website.  Although Access has its limitations. The last time I checked Access is only able to handle up to 255 consecutive users.   On low traffic MS Access is often the best approach.
 
0
Jeff Frye
 
 
Answer
MS Access can be used in a website. While creating the 
database it should be design from web access database for 
all tables, queries and Macros (FYI... VB Code does not 
work in this particular database). This particular option 
is available only in Office 2010.
 
0
Chandran Raju
 
 
Question
can we create relastionship bet 2 tables in ms-access
Rank Answer Posted By  
 Question Submitted By :: Panks
I also faced this Question!!   © ALL Interview .com
Answer
yes.
1.go "tools"
2. select "relationship"
and add table n which u want to make relationship.
now drag.
 
0
Prem
 
 
Answer
yes we can create relationship easily
 
0
Rrrr
 
 
 
Back to Questions Page
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright © 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com