Interested to Buy Any Domain ? << Click Here >> for more details...
What is Primary Key?
- 4 Answers
- 10357 Views
- Ramco, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ashis kumar jena
A primary key is one which uniquely identifies a row
of a table.
This key does not allow null values and also
does not allow duplicate values.
Each table should have a primary key, and each table can
have only one primary key.
| Is This Answer Correct ? | 16 Yes | 2 No |
Answer / perumal
1. Primary Key Doesn't allow the NULL values and also
does not allow duplicate values.
2. Primary Key has the Unique Columns.
3. Primary Key Uniquely Identify the each row of the tables.
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / hannan oca
primary key =notnull+unique value in column
a table consist of only one primary key.
Example
a primary key is like a father in house, like only one but
there may be a lot of childs just like columns.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / satheeh
Primary key is nothing but restriction or condition or constraint given to a specific column to avoid the null and duplicate values.
primary key=not null+unique
that means primary key performs both operations at a time.
primary key plays vital role when relationship between two or more tables
| Is This Answer Correct ? | 2 Yes | 1 No |
Is sql better than excel?
What is a function in oracle pl sql?
What is a scalar value in sql?
What can sql server reporting services do?
What is pl sql block in dbms?
type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...
Is sql harder than python?
What are the new features in Oracle 10g. Compared to Oracle 9i?
How to count the no of records of a table without using COUNT function?
What is the usage of the distinct keyword?
What is optimistic concurrency control? : Transact sql
Explain table and field in sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
