In the primary key have a multiple field or not?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / jivi.preethi

8 Answers
9474 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In the primary key have a multiple field or not?..

Answer / jivi.preethi

yes,it having multiple field

Is This Answer Correct ?

16 Yes

1 No

In the primary key have a multiple field or not?..

Answer / prashanth kumar

Yes , it have multiple fields.Run below query and creating
primary key on p_Id and LastName.

CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
CONSTRAINT pk_PersonID PRIMARY KEY (P_Id,LastName)
)

Is This Answer Correct ?

9 Yes

0 No

In the primary key have a multiple field or not?..

Answer / vinay

yes it multiple field

Is This Answer Correct ?

4 Yes

0 No

In the primary key have a multiple field or not?..

Answer / anubhav tyagi

Yes,it Have Multiple Field, But Not same

Is This Answer Correct ?

1 Yes

0 No

In the primary key have a multiple field or not?..

Answer / rajkumar

s primary key have the multiple filed use os composite
primary key.

Is This Answer Correct ?

1 Yes

0 No

In the primary key have a multiple field or not?..

Answer / ziyaur rahman

no,in one table there is only one primary key field

Is This Answer Correct ?

2 Yes

2 No

In the primary key have a multiple field or not?..

Answer / prasadhari_m@yahoo.com

A TABLE ALLOWS ONLY ONE PRIMARY KEY.

Is This Answer Correct ?

0 Yes

1 No

In the primary key have a multiple field or not?..

Answer / vernold

NO, we only have 1 FIELD FOR PRIMARY KEY

Is This Answer Correct ?

3 Yes

5 No

Post New Answer

More SQL Server Interview Questions

What is the meaning of sql server?

0 Answers

What is blocking and how would you troubleshoot it?

2 Answers

How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers

Can two tables have the same primary key?

0 Answers

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers Satyam,

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers

What xml support does the sql server extend?

0 Answers

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers HCL, Wipro,

Can group by be used without aggregate functions?

0 Answers

What are the properties of the transaction?

0 Answers

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers

For more SQL Server Interview Questions Click Here