.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

What is a Database system?

Posted By :Shashi Ray     Posted Date :October 23, 2008    Points :10   Category :Sql Server 
The database and DBMS software together is called as Database system.

You can also find related Interview Question to What is a Database system?  below: 

What are the System Database in Sql server

Master - Stores system level information such as user accounts, configuration settings, and info on all other databases.

Model - database is used as a template for all other databases that are created

Msdb - Used by the SQL Server Agent for configuring alerts and scheduled jobs etc

Tempdb - Holds all temporary tables, temporary stored procedures, and any other temporary storage requirements generated by SQL Server. (More...)

Database Concurrency in Sql Server.

When two or more user try to update same type of data in a table then Database Concurrency helps in this situation.

There are 2 types of Database Concurrency

Pessimistic: When one user try to change the data with pessimistic concurrency then a lock is placed on the data in a table so that another user cannot change data. when one user finishes then other user can able to change.

Optimistic: When two user works on the same data in a table and one change that data first then second user cannot change that same data becasue the which he have using is allready changed so he cannot do the change becasue change apply to another data that is changed by first user. (More...)

What is type system unification?

The goal of type system unification is to bridge the gap between value types and reference types that exists in most languages. For example, a Stack class can provide Push and Pop methods that take and return object values.

public class Stack
public object Pop() {...}
public void Push(object o) {...}
Because C# has a unified type system, the Stack class can be used with elements of any type, including value types like int. (More...)

What is the common type system (CTS)?

The common type system is a rich type system, built into the Common Language Runtime, that supports the types and operations found in most programming languages. The common type system supports the complete implementation of a wide range of programming languages. (More...)

Disadvantage in File Processing System?

1.Data redundancy & inconsistency.
2.Difficult in accessing data.
3.Data isolation.
4.Data integrity.
5.Concurrent access is not possible.
6.Security Problems. (More...)

What is System R? What are its two major subsystems?

System R was designed and developed over a period of 1974-79 at IBM San Jose Research Center. It is a prototype and its purpose was to demonstrate that it is possible to build a Relational System that can be used in a real life environment to solve real life problems, with performance at least comparable to that of existing system.
Its two subsystems are
1.Research Storage
2.System Relational Data System. (More...)

How is the data structure of System R different from the relational structure?

Unlike Relational systems in System R
1.Domains are not supported
2.Enforcement of candidate key uniqueness is optional
3.Enforcement of entity integrity is optional
4.Referential integrity is not enforced (More...)

Where is window Service Entries located in the system

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services (More...)

Where is GAC located in the system

Global Assembly Cache (GAC) Located in



C:\windows\assembly (In Windows XP) (More...)

where is global assembly cache location in system?

The .NET Framework ships with a Windows shell extension for viewing the assembly cache. Navigating to % windir%\assembly with the Windows Explorer activates the viewer. (More...)

How can I look up a parent class method or property of any System-level object?

Use the Class View window, accessed from the standard toolbar by clicking View | Class View. (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend