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

Top 5 Contributors of the Month
david stephan
Gaurav Pal

Home >> Interview Question >> Others >> Post New Question Subscribe to Interview Questions

What are the properties of relational tables?

Posted By :shankey     Posted Date :July 19, 2011    Points :40   Category :Others 
.Values are atomic
.Column values are of same kind
.Column sequence is insignificant
.Row sequence is insignificant
.Each column is unique
.each row is unique

You can also find related Interview Question to What are the properties of relational tables?  below: 

What Are The Properties Of The Relational Tables?

Relational tables have six properties:
· Values are atomic.
· Column values are of the same kind.
· Each row is unique.
· The sequence of columns is insignificant.
· The sequence of rows is insignificant.
· Each column must have a unique name. (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...)

What is Relational Algebra?

It is procedural query language. It consists of a set of operations that take one or two relations as input and produce a new relation. (More...)

How many types of tables are present in SQL SERVER?

There are 2 types of temporary tables, local and global in sql server.

Local temporary tables are created using a single pound (#) sign and are visible to a single connection and automatically dropped when that connection ends.

Global temporary tables are created using a double pound (##) sign and are visible across multiple connections and users and are automatically dropped when all SQL sessions stop referencing the global temporary table. (More...)

Name two properties common in every validation control?

ControlToValidate property and Text property are two properties that are common in every validation control. (More...)

What are magic tables?

Sometimes we need to know about the data which is being inserted/deleted by triggers in database. With the insertion and deletion of data, tables named "INSERTED" and "DELETED" gets created in SQL Server which contains modified/deleted data.
Here "INSERTED" and "DELETED" tables are called magic tables. (More...)

Name two properties common in every validation control?

ControlToValidate property and Text property. (More...)

How do you retrieve the customized properties of a .NET application from XML .config file?

Initialize an instance of AppSettingsReader class. Call the GetValue method of AppSettingsReader class, passing in the name of the property and the type expected. Assign the result to the appropriate variable. (More...)

Is it possible to have tables in the dataset that are not bound to any data source?

Yes, I can create table object in code and add it to the dataset. (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