Wednesday, 16 July 2014

DDL : MS SQL SERVER QUERIES INTERVIEW QUESTIONS FOR EXPERIENCED DEVELOPER SET-8

DDL RELATED SQL SERVER INTERVIEW QUERIES
This set contains most frequently asked ddl related interview queries, It contains query related to Identity column, Primary key and foreign key.

So lets start: SQL DDL RELATED QUERIES


--78. Write down the query to create employee table with Identity column([EmployeeID])
--ANS:
CREATE TABLE EmployeeDetail( [EmployeeID] INT IDENTITY(1,1) NOT NULL, [FirstName] NVARCHAR(50) NULL,
      [LastName] NVARCHAR(50) NULL, [Salary] DECIMAL(10, 2) NULL, [JoiningDate] DATETIME NULL, [Department] NVARCHAR(20) NULL,
      [Gender] VARCHAR(10) NULL)

--79. Write down the query to create employee table with Identity column([EmployeeID])
--ANS:
CREATE TABLE EmployeeDetail( [EmployeeID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [FirstName] NVARCHAR(50) NULL,
      [LastName] NVARCHAR(50) NULL, [Salary] DECIMAL(10, 2) NULL, [JoiningDate] DATETIME NULL, [Department] NVARCHAR(20) NULL,
      [Gender] VARCHAR(10) NULL)
     
--80. Write down the query to create employee table with primary key (EmployeeID)
--ANS:
CREATE TABLE EmployeeDetail( [EmployeeID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
    [FirstName] NVARCHAR(50) NULL,[LastName] NVARCHAR(50) NULL, [Salary] DECIMAL(10, 2) NULL, [JoiningDate] DATETIME NULL, [Department] NVARCHAR(20) NULL,
      [Gender] VARCHAR(10) NULL)
     
--81. How to set Primary key using Alter command
--ANS:
ALTER TABLE EmployeeDetail ADD PRIMARY KEY (P_EmployeeID)

--82. How to set primary key and foreignkey relationship using query(set EmployeeID column of ProjectDetail table as a foreignkey)
--ANS:
ALTER TABLE ProjectDetail
ADD CONSTRAINT fk_EmployeeDetailID_Eid FOREIGN KEY(EmployeeDetailID)REFERENCES EmployeeDetail(EmployeeID)


 
Visit Our New Site for HR Interview Questions Answers http://www.interviewboat.com/Company/GetCompany
Sponsored Ads

6 comments:

  1. kindly send the pdf on my email id amit.aryan007@gmail.com

    ReplyDelete
  2. This is not for experienced developers .. Kindly upgrade the questions.

    ReplyDelete
  3. Yes,please update the questions

    ReplyDelete
  4. kindly send the pdf on my email id anand.pandit42@gmail.com

    ReplyDelete
  5. Hi Vikas,
    This is very nice tutorials
    Please send me pdf on this email id
    ychittibabu123@gmail.ccom

    ReplyDelete