What is Domain-Key Normal Form?

What is Domain-Key Normal Form?
by

1 Answer

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.
by

Related questions

How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?

Description : How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?

Last Answer : The tuple-oriented calculus uses a tuple variables i.e., variable whose only permitted values are tuples of that relation. E.g. QUEL The domain-oriented calculus has domain variables i.e., variables that range over the underlying domains instead of over relation. E.g. ILL, DEDUCE.

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 are partial, alternate,, artificial, compound and natural key?

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

Last 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 ... create a unique identifier for the construct is known as creating a compound key. Natural Key:

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;

What is BCNF (Boyce-Codd Normal Form)?

Description : What is BCNF (Boyce-Codd Normal Form)?

Last Answer : A relation schema R is in BCNF if it is in 3NF and satisfies an additional constraint that for every FD X A, X must be a candidate key.

What is 1 NF (Normal Form)?

Description : What is 1 NF (Normal Form)?

Last Answer : The domain of attribute must include only atomic (simple, indivisible) values.

Give the stages of instance startup to a usable state where normal users may access it.

Description : Give the stages of instance startup to a usable state where normal users may access it.

Last Answer : STARTUP NOMOUNT - Instance startup STARTUP MOUNT - The database is mounted STARTUP OPEN - The database is opened

What is the difference between normal views and RAC views?

Description : What is the difference between normal views and RAC views?

Last Answer : RAC views has the prefix ‘G’. For example, GV$SESSION instead of V$SESSION

Explain the differences between SHUTDOWN, SHUTDOWN NORMAL, SHUTDOWN IMMEDIATE AND SHUTDOWN ABORT.

Description : Explain the differences between SHUTDOWN, SHUTDOWN NORMAL, SHUTDOWN IMMEDIATE AND SHUTDOWN ABORT.

Last Answer : SHUTOWN NORMAL = SHUTDOWN : It waits for all sessions to end, without allowing new connections. SHUTDOWN IMMEDIATE : Rollback current transactions and terminates every session. SHUTDOWN ABORT : Aborts all ... in an inconsistent state. It's the fastest method, but can lead to database corruption.

Which if the following is not the type of data integrity. A) Key integrity B) Domain integrity C) Entity integrity D) Referential integrity

Description : Which if the following is not the type of data integrity. A) Key integrity B) Domain integrity C) Entity integrity D) Referential integrity

Last Answer : A) Key integrity

………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs. A) Instance B) Schema c) Program D) Super Key

Description : ………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs. A) Instance B) Schema c) Program D) Super Key

Last Answer : B) Schema

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Description : When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Last Answer : Break. SYSTEM VARIABLES

What package procedure is used for calling another form ?

Description : What package procedure is used for calling another form ?

Last Answer : Call (E.g. Call(formname)

When a form is invoked with call_form, Does oracle forms issues a save point?

Description : When a form is invoked with call_form, Does oracle forms issues a save point?

Last Answer : Yes

Can u run the report with out a parameter form

Description : Can u run the report with out a parameter form

Last Answer : Yes it is possible to run the report without parameter form by setting the PARAM value to Null

What is call form stack?

Description : What is call form stack?

Last Answer : When successive forms are loaded via the CALL_FORM procedure, the resulting module hierarchy is known as the call form stack.

Difference between database triggers and form triggers?

Description : Difference between database triggers and form triggers?

Last Answer : Data base trigger(DBT) fires when a DML operation is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screen -Can be row ... other database triggers to fire.Can cause other database triggers to fire, but not other form triggers.

Give the Types of modules in a form?

Description : Give the Types of modules in a form?

Last Answer : Form Menu Library

Is it possible to attach same library to more than one form?

Description : Is it possible to attach same library to more than one form?

Last Answer : Yes

What is the maximum size of a form ?

Description : What is the maximum size of a form ?

Last Answer : 255 character width and 255 characters Length.

Name the two files that are created when you generate the form give the filex extension ?

Description : Name the two files that are created when you generate the form give the filex extension ?

Last Answer : INP (Source File) FRM (Executable File)

Can we create two blocks with the same name in form 3.0 ?

Description : Can we create two blocks with the same name in form 3.0 ?

Last Answer : No

How many pages you can in a single form ?

Description : How many pages you can in a single form ?

Last Answer : Unlimited

How can a group in a cross products be visually distinguished from a group that does not form a cross product?

Description : How can a group in a cross products be visually distinguished from a group that does not form a cross product?

Last Answer : A group that forms part of a cross product will have a thicker border.

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

Description : Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

Last Answer : False

What are different types of modules available in oracle form?

Description : What are different types of modules available in oracle form?

Last Answer : Form module - a collection of objects and code routines Menu modules - a collection of menus and menu item commands that together make up an application menu library module - a collection of user named procedures, functions and packages that can be called from other modules in the application

How many windows in a form can have console?

Description : How many windows in a form can have console?

Last Answer : Only one window in a form can display the console, and you cannot change the console assignment at runtime.

what are difference between post database commit and post-form commit?

Description : what are difference between post database commit and post-form commit?

Last Answer : Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts, updates and deletes have ... The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions.

An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Description : An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Last Answer : True

How do you create a new session while open a new form?

Description : How do you create a new session while open a new form?

Last Answer : Using open_form built-in setting the session option Ex. Open_form('Stocks ',active,session). when invoke the mulitiple forms with open form and call_form in the same application, state whether the following are true/False

Does a Before form trigger fire when the parameter form is suppressed?

Description : Does a Before form trigger fire when the parameter form is suppressed?

Last Answer : Yes.

What does "jumps off the screen" mean?

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?