What are partial, alternate,, artificial, compound and natural key?

What are partial, alternate,, artificial, compound and natural key?
by

1 Answer

Answer :

Partial Key:
It is a set of attributes that can uniquely identify weak entities and that are related to same  owner entity. It is sometime called as Discriminator.
Alternate Key:
All Candidate Keys excluding the Primary Key are known as Alternate Keys. Artificial Key:
If no obvious key, either stand alone or compound is available, then the last resort is to simply  create a key, by assigning a unique number to each record or occurrence. Then this is known as  developing an artificial key.
Compound Key:
If no single data element uniquely identifies occurrences within a construct, then combining  multiple elements to create a unique identifier for the construct is known as creating a  compound key.
Natural Key:
by

Related questions

What is Partial Backup ?

Description : What is Partial Backup ?

Last Answer : A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.

A new technology which provides the ability to create an artificial world and have people interact with it is called – (1) Televirtuality (2) Virtual reality (3) Alternate reality (4) 3-D reality

Description : A new technology which provides the ability to create an artificial world and have people interact with it is called – (1) Televirtuality (2) Virtual reality (3) Alternate reality (4) 3-D reality

Last Answer : (2) Virtual reality Explanation: Virtual reality (VR) is a term that applies to computer-simulated environments that can simulate physical presence in places in the real world, as well ... , but some simulations include additional sensory information, such as sound through speakers or headphones.

A new technology which provides the ability to create an artificial world and have people interact with it is called : (1) Televirtuality (2) Virtual reality (3) Alternate reality (4) 3-D reality

Description : A new technology which provides the ability to create an artificial world and have people interact with it is called : (1) Televirtuality (2) Virtual reality (3) Alternate reality (4) 3-D reality

Last Answer : Virtual reality

what are key-mode and locking mode properties? level ?

Description : what are key-mode and locking mode properties? level ?

Last Answer : Key Mode : Specifies how oracle forms uniquely identifies rows in the database.This is property includes for application that will run against NON-ORACLE datasources . Key setting unique (default.) ... locks on rows that correspond to queried records in the form. a) immediate b) delayed

What is the difference between candidate key, unique key and primary key

Description : What is the difference between candidate key, unique key and primary key

Last Answer : Candidate keys are the columns in the table that could be the primary keys and the primary key is the key that has been selected to identify the rows. Unique key is also useful for identifying the distinct rows in the table.)

Key Words Used in Oracle

Description : Key Words Used in Oracle

Last Answer : The Key words that are used in Oracle are :: a) Commiting :: A transaction is said to be commited when the transaction makes permanent changes resulting from the SQL statements. b) Rollback :: ... A Process is a 'thread of control' or mechansim in Operating System that executes series of steps.

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?

Description : If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?

Last Answer : It won't, Because SYSDATE format contains time attached with it.

What is difference between UNIQUE and PRIMARY KEY constraints?

Description : What is difference between UNIQUE and PRIMARY KEY constraints?

Last Answer : A table can have only one PRIMARY KEY whereas there can be any number of UNIQUE keys. The columns that compose PK are automatically define NOT NULL, whereas a column that compose a UNIQUE is not automatically defined to be mandatory must also specify the column is NOT NULL.

Can a primary key contain more than one columns?

Description : Can a primary key contain more than one columns?

Last Answer : Yes

What is the difference between a Function Key Trigger and Key Function Trigger ?

Description : What is the difference between a Function Key Trigger and Key Function Trigger ?

Last Answer : Function key triggers are associated with individual SQL*FORMS function keys You can attach Key function triggers to 10 keys or key sequences that normally do not perform any SQL * FORMS operations. These keys referred as key F0 through key F9.

What are the different types of key triggers ?

Description : What are the different types of key triggers ?

Last Answer : Function Key Key-function Key-others Key-startup

Is a Key startup trigger fires as result of a operator pressing a key explicitly ?

Description : Is a Key startup trigger fires as result of a operator pressing a key explicitly ?

Last Answer : No

What is cluster key?

Description : What is cluster key?

Last Answer : The related columns of the tables in a cluster are called the cluster key.

What is a cluster Key ?

Description : What is a cluster Key ?

Last Answer : The related columns of the tables are called the cluster key. The cluster key is indexed using a cluster index and its value is stored only once for multiple tables in the cluster.

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

Description : What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

Last Answer : A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls.

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

Description : What are the Referential actions supported by FOREIGN KEY integrity constraint ?

Last Answer : UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.

HOW MANY SEGMENTS ARE THERE IN THE KEY FLEXFIELD(S) IN ORACLE GENERAL LEDGER?

Description : HOW MANY SEGMENTS ARE THERE IN THE KEY FLEXFIELD(S) IN ORACLE GENERAL LEDGER?

Last Answer : - Oracle GL Key flexfield can have 15 columns each representing a segment. However, the segments type can be:  Cost Center segment  Balancing segment  Account segment  Intercompany segment

WHAT IS A KEY FLEXFIELD QUALIFIER?

Description : WHAT IS A KEY FLEXFIELD QUALIFIER?

Last Answer : - A qualifier is a label attached to a particular key flexfield segment so it can be located by the application requiring its information. A key flexfield qualifier can be of 2 types: · Flexfield qualifiers identify a segment in a flexfield. · Segment qualifiers identify a value set in a segment.

KEY AND DEXCRIPTIVE FLEXFIELD COMPARISON

Description : KEY AND DEXCRIPTIVE FLEXFIELD COMPARISON

Last Answer : KEY FLEXFIELD DESCRIPTIVE FLEXFIELD  Owned by one application; used by many Associated with tables in a specific ... Identifies entities Captures additional information only

HOW MANY KEY FLEXFIELDS ARE THERE IN ORACLE FINANCIALS?

Description : HOW MANY KEY FLEXFIELDS ARE THERE IN ORACLE FINANCIALS?

Last Answer : · General Ledger o Accounting Flexfield · Assets o Asset Key Flexfield o Location Flexfield o Category Flexfield · Service o Service Item Flexfield · Receivables o Territory ... Inventory o Item Categories o System Items o Sales Orders o Item Catalogs

What is Domain-Key Normal Form?

Description : What is Domain-Key Normal Form?

Last Answer : A relation is said to be in DKNF if all constraints and dependencies that should hold on the the constraint can be enforced by simply enforcing the domain constraint and key constraint on the relation.

Can you disable and enable Primary key?

Description : Can you disable and enable Primary key?

Last Answer : You can use the ALTER TABLE statement to enable, disable, modify, or drop a constraint. When the database is using a UNIQUE or PRIMARY KEY index to enforce a constraint, and constraints associated ... and any FOREIGN KEY constraints that depend on it: ALTER TABLE dept DISABLE PRIMARY KEY CASCADE;

............. is a combination of two of more attributes used as a primary key A) Composite Key B) Alternate Key C) Candidate Key D) Foreign Key

Description : ............. is a combination of two of more attributes used as a primary key A) Composite Key B) Alternate Key C) Candidate Key D) Foreign Key

Last Answer : A) Composite Key

Which of the following statement is true? (1) A Primary key is also a candidate key (2) Each relation has at least one foreign key (3) Foreign keys can’t have null values (4) A Primary key is also an alternate key

Description : Which of the following statement is true? (1) A Primary key is also a candidate key (2) Each relation has at least one foreign key (3) Foreign keys can’t have null values (4) A Primary key is also an alternate key

Last Answer : Foreign keys can’t have null values

What kind of environment is strategic in artificial intelligence? a) Deterministic b) Rational c) Partial d) Stochastic

Description : What kind of environment is strategic in artificial intelligence? a) Deterministic b) Rational c) Partial d) Stochastic

Last Answer : a) Deterministic

What kind of observing environments are present in artificial intelligence? a) Partial b) Fully c) Learning d) Both Partial & Fully

Description : What kind of observing environments are present in artificial intelligence? a) Partial b) Fully c) Learning d) Both Partial & Fully

Last Answer : d) Both Partial & Fully

`XeF_6` on partial hydrolysis with water produces a compound ‘X’. The same compound ‘X’ is formed when `XeF_6` reacts with silica. The compound ‘X’ Is

Description : `XeF_6` on partial hydrolysis with water produces a compound ‘X’. The same compound ‘X’ is formed when `XeF_6` reacts with silica. The compound ‘X’ Is

Last Answer : `XeF_6` on partial hydrolysis with water produces a compound X'. The same compound X' is formed when `XeF_6` ... XeF_4` C. (3)`XeF_2` D. (4)`XeOF_4`

Ammonia synthesis gas is produced from natural gas by (A) Thermal cracking (B) Steam reforming (C) Partial oxidation (D) Hydrogenation

Description : Ammonia synthesis gas is produced from natural gas by (A) Thermal cracking (B) Steam reforming (C) Partial oxidation (D) Hydrogenation

Last Answer : (B) Steam reforming

Presence of nitrogen in high concentration in contaminated air reduces partial pressure of oxygen in lungs, thereby causing asphyxia (suffocation) leading to death from oxygen deficiency. Concentration of N2 in contaminated air at which it acts as a natural asphyxiate is ≥ __________ percent. (A) 84 (B) 88 (C) 80 (D) 92

Description : Presence of nitrogen in high concentration in contaminated air reduces partial pressure of oxygen in lungs, thereby causing asphyxia (suffocation) leading to death from oxygen deficiency. Concentration of N2 in contaminated air at ... asphyxiate is ≥ __________ percent. (A) 84 (B) 88 (C) 80 (D) 92

Last Answer : (A) 84

Are there any peer-reviewed scientific studies that show gender roles are artificial & that being gay is natural?

Description : Are there any peer-reviewed scientific studies that show gender roles are artificial & that being gay is natural?

Last Answer : You want to look in an academic journals database that allows you to search for peer-reviewed journals and tyr keywords such as “homosexuality” and “normal” or “biology” and “sexual orientation.” Don’t confuse gender roles with sexual orientation but do do your own research.

Does the prevalence of digital media (videos, photos, etc.) improve our natural memory or create an artificial memory?

Description : Does the prevalence of digital media (videos, photos, etc.) improve our natural memory or create an artificial memory?

Last Answer : You can remember a video or a picture easier than you can remember an unrecorded moment because you can look back on that video or picture whenever you want. It’s artificial memory that helps our natural memory.

What is the difference between artificial light and natural light?

Description : What is the difference between artificial light and natural light?

Last Answer : Artificial light needs energy to generate light. Natural light is self-generated light with or without energy.

Artificial diamonds are worth far less than natural diamonds, if Gold could be artificially made in a lab somehow would it be worth less than naturally mined Gold?

Description : Artificial diamonds are worth far less than natural diamonds, if Gold could be artificially made in a lab somehow would it be worth less than naturally mined Gold?

Last Answer : The only current way to make gold artificially in in microgram quantities and it is of a radioactive form, not something you would wish to possess. Even if a stable isotope could be produced, it would be discernable from “natural” gold, thus not affected the value of bullion.

Why do so many people think that natural pharmaceutical ingredients (taken from plants) are safer than artificial pharmaceutical ingredients?

Description : Why do so many people think that natural pharmaceutical ingredients (taken from plants) are safer than artificial pharmaceutical ingredients?

Last Answer : You are so right. People have an aversion to the word chemicals , that's been programmed into them through media histrionics. What they forget is that air and water and eveyrhting we eat are also chemicals. ... about all this kind of thing, as well as the perception of fear. It's a great book.

What artificial flavor tastes better than its natural counterpart and why?

Description : What artificial flavor tastes better than its natural counterpart and why?

Last Answer : For me, watermelon. I know my opinion may be unpopular but I ask you to please respect it. I think real watermelon is boring but I love artificial watermelon.

What artificial flavor tastes better than its natural counterpart and why?

Description : What artificial flavor tastes better than its natural counterpart and why?

Last Answer : For me, watermelon. I know my opinion may be unpopular but I ask you to please respect it. I think real watermelon is boring but I love artificial watermelon.

Give one difference between natural harbours and artificial harbours. -Geography

Description : Give one difference between natural harbours and artificial harbours. -Geography

Last Answer : The natural harbours generally occur along a fairly indented coastal line. If an inlet or a backwater bay penetrates inland for longer distance, it facilitates the transportation of large cargo ... harbours are constructed by dredging and erecting a wall against the sea along the coastline.

Difference between artificial and natural classification systems -Biology

Description : Difference between artificial and natural classification systems -Biology

Last Answer : answer:

How is artificial selectio different than natural selection?

Description : How is artificial selectio different than natural selection?

Last Answer : Feel Free to Answer

Which of the following is a feature of fifth generation computers? A) Use of natural language B) artificial intelligence C) bio-chips D) All of above

Description : Which of the following is a feature of fifth generation computers? A) Use of natural language B) artificial intelligence C) bio-chips D) All of above

Last Answer : Answer : D

How are natural and artificial pearls created?

Description : How are natural and artificial pearls created?

Last Answer : Pearls are made from small strange particles that deposit between the shell and the mantle of the oyster. These particles trigger a defense process by the organism and they are gradually covered by ... an oyster and a pearl is formed around the graft. Mollusca - Image Diversity: cultured pearls

Carolus Linnaeus System of classification is – (1) Natural (2) Artificial (3) Binomial (4) Phylogenetic

Description : Carolus Linnaeus System of classification is – (1) Natural (2) Artificial (3) Binomial (4) Phylogenetic

Last Answer : (3) Binomial Explanation: Swedish naturalist Carl Linnaeus established the binomial system of naming living organisms, setting a format and a structured process for classifying the interrelationships between plants ... that it will mean the same thing to informed readers anywhere else in the world.

What is the field of Natural Language Processing (NLP)? a) Computer Science b) Artificial Intelligence c) Linguistics d) All of the mentioned

Description : What is the field of Natural Language Processing (NLP)? a) Computer Science b) Artificial Intelligence c) Linguistics d) All of the mentioned

Last Answer : d) All of the mentioned

Which of the following task/tasks Artificial Intelligence could not do yet? a) Understand natural language robustly b) Web mining c) Construction of plans in real time dynamic systems d) All of the mentioned

Description : Which of the following task/tasks Artificial Intelligence could not do yet? a) Understand natural language robustly b) Web mining c) Construction of plans in real time dynamic systems d) All of the mentioned

Last Answer : d) All of the mentioned

Natural or artificial can be category of A : Localization B : Landmarks classes C : Pose evalution D : Robot

Description : Natural or artificial can be category of A : Localization B : Landmarks classes C : Pose evalution D : Robot

Last Answer : B : Landmarks classes

Natural or artificial can be category of A : Localization B : Landmarks classes C : Pose evalution D : Robot

Description : Natural or artificial can be category of A : Localization B : Landmarks classes C : Pose evalution D : Robot

Last Answer : B : Landmarks classes

Natural or artificial can be category of A : Localization B : Landmarks classes C : Pose evalution D : Robot

Description : Natural or artificial can be category of A : Localization B : Landmarks classes C : Pose evalution D : Robot

Last Answer : B : Landmarks classes

When a natural predator (living being) is applied on the other pathogen organism to control them, this process is called (a) artificial control (b) confusion technique (c) biological control (d) genetic engineering.

Description : When a natural predator (living being) is applied on the other pathogen organism to control them, this process is called (a) artificial control (b) confusion technique (c) biological control (d) genetic engineering.

Last Answer : (c) biological control

Classification given by Bentham and Hooker is (a) artificial (b) natural (c) phylogenetic (d) numerica

Description : Classification given by Bentham and Hooker is (a) artificial (b) natural (c) phylogenetic (d) numerica

Last Answer : (b) natural

System of classification used by Linnaeus was (a) natural system (b) artificial system (c) phylogenetic system (d) asexual system

Description : System of classification used by Linnaeus was (a) natural system (b) artificial system (c) phylogenetic system (d) asexual system

Last Answer : (a) natural system