Its possible to add more than one primary key for the table

Question Posted / siri

4 Answers
6416 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Its possible to add more than one primary key for the table ..

Answer / rajesh venati

No, it is not possible, only one primary key is possible for
a table.
It is possible to create a primary key on more than one
column in a table, up to 32 columns. It is called composite
primary key.

Is This Answer Correct ?

19 Yes

2 No

Its possible to add more than one primary key for the table ..

Answer / ravi singh

No, physically its not possible to add more then one primary key on a table, although logically you can create an unique key on a column and put it as not null .

Is This Answer Correct ?

8 Yes

1 No

Its possible to add more than one primary key for the table ..

Answer / mahesh katkam

NO its not possible to add more than one primary key in one table , but using trigger we can make another non_primary column acts as primary key column.

Is This Answer Correct ?

1 Yes

0 No

Its possible to add more than one primary key for the table ..

Answer / ramesh

No not possibble add more than one primay key on the table

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

How do I filter in sql profiler?

0 Answers

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers

Difference between aggregate function and analytical function?

3 Answers Metric Stream,

How can get second highest salary in sql?

0 Answers

What is the purpose of primary key?

0 Answers

How do I view a view in sql?

0 Answers

What is the diff between Truncate table / delete <table name> purge

3 Answers TCS,

Is a table valued function object?