Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers

Q: What are logical databases? What are the advantages/disadvantages of logical databases?

Add comment
Views: 643
Votes: 0
Comments: 0

A: LDB consists of logically related tables grouped together – used for reading and processing data.
Advantages

No need of programming for retrieval , meaning for data selection
Easy to use standard user interface, have check completeness of user input.
Disadvantages Fast in case of lesser no. of tables But if the table is in the lowest level of hierarchy, all upper level tables should be read so performance is slower. 
 

 

Others in this Category
document How to copy the tables, schema and views from one SQL Server to another?
document Which TCP/IP port does SQL Server run on? How can it be changed?
document What is a Scheduled Jobs or What is a Scheduled Tasks?
document Q: Please explain Outer Join in SQL
document Q: Which is more faster - IN or EXISTS?
document What are the basic functions for master, msdb, model, tempdb and resource databases?
document What is SQLCMD?
document What are different types of Collation Sensitivity?
document What is use of DBCC Commands?
document What is a Linked Server?
» More articles



RSS