Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 116068 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / unknown
If for any table, we have more than one primary key, viz If
the table can be uniquely identified by the help of more
than one attribute, the collection is called 'Composite
Key'. If only one key can act as the unique key, it is the
Primary key, rest of the keys are called alternate keys.
Individual keys of the composite key are the candidate keys.
| Is This Answer Correct ? | 18 Yes | 28 No |
Answer / mustafa
How do we specify an ALTERNATE KEY while creating a table?
| Is This Answer Correct ? | 15 Yes | 30 No |
Answer / jheelum
A CANDIDATE KEY ISA PRIMERY KEY. OTHER ARE ALTERNATE KEY
| Is This Answer Correct ? | 26 Yes | 82 No |
Differnce between sel server 2000 and 2005
What type of locking occurs during the snapshot generation? : sql server replication
How to create an multi-statement table-valued function?
what is the diffrence between Snap Shot and Transaction Replication
How can sql server instances be hidden?
What information is maintained within the msdb database?
What are points to remember while using the fillfactor argument?
difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
How to select some specific columns from a table in a query in ms sql server?
what is raid and what are different types of raid configurations? : Sql server database administration
-
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)
