C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !





Posted By: http://dotnetvj.blogspot.com       Member Level: Diamond       Posted Date: 19 Apr 2008       Category: SQL Server

You are designing an inventory and shipping database for Contoso,Ltd.
You create the logical database design shown below:
You must ensure that the referential integrity of the database is
maintained. Which three types of constraints should you apply to your
design

Select Answer:

Create a FOREIGN KEY constraint on the Products table that references the Suppliers table
Create a FOREIGN KEY constraint on the Order Details table that references the Order table
Create a FOREIGN KEY constraint on the Order Details table that references the Products table
All of the above




      
Your Test Score: 0 / 0



Next Question: With SQL, how do you select all the columns from a table named "Persons"
Previous Question: DBCC stands for
Related Questions:
  • Which of the following argument prevents the View from being published as a part of SQL Server replication?


  • Which of the following is true with locking?


  • Difference between view and stored procedure?


  • What is Index Tuning?


  • You are a database developer for a organization that sells garden gnomes. You are creating a database that will store a history of each order. Orders are entered directly from the customer in an online system. For each new order in the system, a unique order number must be assigned. Order numbers must be assigned in ascending order. On a normal day, 1,000 orders are entered into the system. When creating the order table, you create a OrderID column to store the order number. What is the best thing to do nex


    		•

    Categories

    ASP.NET C# VB.NET 
    .NET Framework SQL Server Other 

    Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program

    Want to prepare for an interview? Try our aptitude tests and standard interview questions first.

    dotNet Slackers   BizTalk Adaptors    Web Design

    Contact Us    Privacy Policy    Terms Of Use