ALLInterview.com :: Home Page KalAajKal.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  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
Explain DBMS, RDBMS?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Explain DBMS, RDBMS?
Answer
# 1
dbms is a collection of data in a database
rdms is a collection of related data in a database
 
Is This Answer Correct ?    12 Yes 7 No
Nagarajan P
 
  Re: Explain DBMS, RDBMS?
Answer
# 2
in rdbms we have relations of tables say primary 
key ,foreign keys relation ,,that involves refrential 
integrity and normalication like concepts
where as 
dbms is just collection of tables that dont have relations 
and dependencies
 
Is This Answer Correct ?    12 Yes 5 No
Ghous
 
 
 
  Re: Explain DBMS, RDBMS?
Answer
# 3
DBMS : Client Side processing 
       File Level Locking 
       Network traffic is High            
       Distributed Network not Supported
       Nomenclature
       Concept of File
RDBMS : Server Side Processing
       Row Level Locking 
       Network traffic is Low            
       Distributed Network  Supported
       Nomenclature
       Concept of Table
 
Is This Answer Correct ?    6 Yes 0 No
Sachin Patil
 
  Re: Explain DBMS, RDBMS?
Answer
# 4
Explain the DBMS, RDBMS?

DBMS: 

         DBMS is Data Base Management System. It is a 
collection of data in a database. DBMS is just collection 
of tables that dont have relations and dependencies.Client 
Side processing File Level traffic is High Distributed 
Network not supported Nomenclature concept of File. Dbms 
won't allow you share the data server to clint.Only one 
user can access the database at a time in DBMS.ADBMS is 
enabled by vector field and is "one"dimensional.

RDBMS:

        RDBMS is Relational Data Base Management System.
RDBMS is a collection of related data in a database.In 
RDBMS we have relations of tables say primary key ,foreign 
keys relation ,,that involves refrential integrity and 
normalication like concepts where as Server Side Processing 
Row Level Locking Network traffic is Low Distributed 
Network Supported Nomenclature Concept of Table.But in 
RDBMS we can share data server to client.But RDBMS allows 
simultaneous access of users to the database. RDBMS is 
enabled nu static "2"-dimensional tables.
 
Is This Answer Correct ?    11 Yes 4 No
Antony
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How can you see what type of locks used?  1
what are the problems in logshipping?  2
how can we use a composite key for two tables and how can we represent it BoA1
one table has four field id,name,design,salary. i have to find maximum salary .  6
What is SQL Profiler what is the use of it? 247Customer2
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode? HCL2
What is a Trace frag?Where can we use this?  1
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records  16
what is Constraint? How many types of constraints in SQL ? NIIT7
i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj IBM7
please tell me the query to get details of the employee having the second largest salary 247Customer8
how to delete duplicate rows from table CSC9
system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??  8
Difference Between varchar and nvarchar datatype? Satyam2
How to find the date and time of last updated table? Teledata4
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,... ADP5
Can you explain the role of each service?  1
why cluster and non clusterindex are used in sqlserver 2000? explain with example  1
What is the difference between a Local temporary table and a Global temporary table? How is each one used?  1
What are primary keys and foreign keys?  3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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