Interested to Buy Any Domain ? << Click Here >> for more details...
what is candidate key & super key
- 1 Answers
- 3938 Views
- I also Faced
- E-Mail Answers
Answer / naresh
Cnadidate Key:
A Candidate Key (CK) is a column or group of columns that
uniquely describe every row in a table. The difficult thing
with this is that there may be exceptions in almost every
case. For instance, it is possible to have two people who
share the same name and birthdate but are really two
different people.
Super Key:
a superkey is a set of composite columns forming a key that
may be used to uniquely identify a row in a table
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the implicit cursor in oracle?
How to view the tablespaces in the current database?
What suggestions do you have to reduce the network traffic?
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
What is a heap related to database ?
1 Answers TCS, University of Edinburgh,
How to define a cusotmer as a supplier in ORACLE R12
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
How can I create database in oracle?
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
query to find the maximum no persons with same age(age colomn) from emp table
What is the difference between online and offline backups?
Oracle General 
