How will you a activate/deactivate integrity constraints ?

How will you a activate/deactivate integrity constraints ?
by

1 Answer

Answer :

The integrity constraints can be enabled or disabled by ALTER TABLE
ENABLE constraint/DISABLE constraint.
by

Related questions

Give two examples of referential integrity constraints.

Description : Give two examples of referential integrity constraints.

Last Answer : rential integrity constraints.

Where the integrity constraints are stored in Data Dictionary ?

Description : Where the integrity constraints are stored in Data Dictionary ?

Last Answer : The integrity constraints are stored in USER_CONSTRAINTS.

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.

What are various constraints used in SQL?

Description : What are various constraints used in SQL?

Last Answer : NULL -NOT NULL -CHECK -DEFAULT

How do you control the constraints in forms ?

Description : How do you control the constraints in forms ?

Last Answer : Select the use constraint property is ON Block definition screen.BLOCK

What is the use of CONSTRAINTS option in EXP command ?

Description : What is the use of CONSTRAINTS option in EXP command ?

Last Answer : A flag to indicate whether constraints on table need to be exported.

. ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations. A) Entity Integrity Constraints B) Referential Integrity Constraints

Description : . ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations. A) Entity Integrity Constraints B) Referential Integrity Constraints

Last Answer : B) Referential Integrity

………………… is preferred method for enforcing data integrity A) Constraints B) Stored Procedure C) Triggers D) Cursors

Description : ………………… is preferred method for enforcing data integrity A) Constraints B) Stored Procedure C) Triggers D) Cursors

Last Answer : A) Constraints

……………. is a preferred method for enforcing data integrity A) Constraints B) Stored procedure C) Triggers D) Cursors

Description : ……………. is a preferred method for enforcing data integrity A) Constraints B) Stored procedure C) Triggers D) Cursors

Last Answer : A) Constraints

An ER Model includes I. An ER diagram portraying entity types. II. Attributes for each entity type III. Relationships among entity types. IV. Semantic integrity constraints that reflects the business rules about data not captured in the ER diagram. (A) I, II, III & IV (B) I&IV (C) I, II & IV (D) I & III

Description : An ER Model includes I. An ER diagram portraying entity types. II. Attributes for each entity type III. Relationships among entity types. IV. Semantic integrity constraints that reflects the business rules about data not ... ; IV (B) I&IV (C) I, II & IV (D) I & III

Last Answer : (A) I, II, III & IV

Describe Referential Integrity ?

Description : Describe Referential Integrity ?

Last Answer : A rule defined on a column (or set of columns) in one table that allows the insert or update of a row only if the value for the column or set of columns (the dependent value) matches a value ... data and the action to be performed on dependent data as a result of any action on referenced data.

How many Integrity Rules are there and what are they

Description : How many Integrity Rules are there and what are they

Last Answer : There are Three Integrity Rules. They are as follows :: a) Entity Integrity Rule :: The Entity Integrity Rule enforces that the Primary key cannot be Null b) Foreign Key Integrity Rule :: ... Intigrity rule is about the complex business processes which cannot be implemented by the above 2 rules.

What is an Integrity Constraint ?

Description : What is an Integrity Constraint ?

Last Answer : Integrity constraint is a rule that restricts values to a column in a table.

What is Referential Integrity ?

Description : What is Referential Integrity ?

Last Answer : Maintaining data integrity through a set of rules that restrict the values of one or more columns of the tables based on the values of primary key or unique key of the referenced table.

How can you Enforce Referential Integrity in snapshots ?

Description : How can you Enforce Referential Integrity in snapshots ?

Last Answer : Time the references to occur when master tables are not in use. Peform the reference the manually immdiately locking the master tables. We can join tables in snopshots by creating a complex snapshots that will based on the master tables.

What is an Integrity Constrains ?

Description : What is an Integrity Constrains ?

Last Answer : An integrity constraint is a declarative way to define a business rule for a column of a table.

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.

What is Authorization and Integrity manager?

Description : What is Authorization and Integrity manager?

Last Answer : It is the program module, which tests for the satisfaction of integrity constraint and checks the authority of user to access data.

Define the “integrity rules”

Description : Define the “integrity rules”

Last Answer : There are two Integrity rules. ∙ Entity Integrity: States that “Primary key cannot have NULL value” ∙ Referential Integrity: States that “Foreign Key can be either a NULL value or should be Primary Key value of other relation.

How to deactivate or delete your Facebook account ?

Description : How to deactivate or delete your Facebook account ?

Last Answer : To deactivate or delete your Facebook account, follow these steps: Deactivating your account: Log in to your Facebook account. Click on the down arrow in the top right corner and select "Settings & ... ve deleted your account, you won't be able to reactivate it or retrieve anything you've added.

Can't they just deactivate this nuclear plant in Japan?

Description : Can't they just deactivate this nuclear plant in Japan?

Last Answer : answer:It is my understanding that the plant has been deactivated , but it's not possible to simply close the doors and walk away from a nuclear power plant, or any other type of power plant, for that ... , eventually, but I doubt that they wanted that to be a high priority item. It may become so.

How do you delete or deactivate a question on Fluther?

Description : How do you delete or deactivate a question on Fluther?

Last Answer : Flag it and/or ask a mod for help.

How do I deactivate Norton's automatic submission function?

Description : How do I deactivate Norton's automatic submission function?

Last Answer : answer:I've used Norton 360 ever since version 2. They're up to v. 6 now. But I don't know what you mean by automatic submission . What is automatically being submitted? If all else fails, you ... control of your computer remotely, as if he/she were in your home, and fix the problem. Good luck!

Should I deactivate my iPhone acct and wait for my company to transfer my number?

Description : Should I deactivate my iPhone acct and wait for my company to transfer my number?

Last Answer : you would have to pay $ 175 for cancelling your contract. But you can call up at&t; and ask them to transfer your number

can i deactivate my recently added airtime minutes on a stolen tracfone

Description : can i deactivate my recently added airtime minutes on a stolen tracfone

Last Answer : Need Answer

How do I deactivate my DeviantArt account when I forgot the password to it and the eMail I had used?

Description : How do I deactivate my DeviantArt account when I forgot the password to it and the eMail I had used?

Last Answer : The account will reside in the system unless you can prove itwas your account in all instances. You can contact Deviant Art andexplain to their moderators your issue but they will most certainlyask for and expect conclusive proof of your account. In most casesyou would leave it unused

What is the benefit of the expertise of a licensed architect in a virtual environment that does not have the inherent constraints of physics.

Description : What is the benefit of the expertise of a licensed architect in a virtual environment that does not have the inherent constraints of physics.

Last Answer : Infinite proportions.

The tensor product technique constraints surfaces by two curves. a.2 b.1 c.3 d.4

Description : The tensor product technique constraints surfaces by two curves. a.2 b.1 c.3 d.4

Last Answer : b.1

Mention three constraints explaining why cultivable waste land is not being used for cultivation at present. -Geography

Description : Mention three constraints explaining why cultivable waste land is not being used for cultivation at present. -Geography

Last Answer : The constraints are : 1. Due to human neglect, large tracts of land of U.P., Punjab and Haryana turned infertile due to salinity or alkalinity of soil. 2. Due to extensive soil ... the soil resulting from faulty agricultural practices, large tracts of land now, can not be used for agriculture.

What Difference between disjoint and overlapping constraints?

Description : What Difference between disjoint and overlapping constraints?

Last Answer : Need answer

What is a criteria and constraints.?

Description : What is a criteria and constraints.?

Last Answer : Your criteria is(goals) and constraints are(limits).

Taxes are as certain as the death, because - (1) They constitute the major source of government revenue. (2) Government have no other source of revenue. (3) Most PSUs are run inefficiently. (4) Government has its own budget constraints.

Description : Taxes are as certain as the death, because - (1) They constitute the major source of government revenue. (2) Government have no other source of revenue. (3) Most PSUs are run inefficiently. (4) Government has its own budget constraints.

Last Answer : (1) They constitute the major source of government revenue. Explanation: Benjamin Franklin's utterance, "In this world nothing can be said to be certain, except death and taxes," when applied ... draws on the actual inevitability of death to highlight the difficulty in avoiding the burden of taxes.

What are the operating constraints imposed in the load flow studies?

Description : What are the operating constraints imposed in the load flow studies?

Last Answer : The operating constraints imposed in load flow studies are reactive power limits for generator buses and allowable change in magnitude of voltagefor load buses.

Which of these is not one of the constraints of a project? a. Scope b. Resources c. Team d. Budget

Description : Which of these is not one of the constraints of a project? a. Scope b. Resources c. Team d. Budget

Last Answer : c. Team

What is the first step in project planning? Select one: a. Establish the objectives and scope. b. Determine the budget. c. Select the team organizational model. d. Determine project constraints. e. Inspect the deliverables.

Description : What is the first step in project planning? Select one: a. Establish the objectives and scope. b. Determine the budget. c. Select the team organizational model. d. Determine project constraints. e. Inspect the deliverables.

Last Answer : a. Establish the objectives and scope.

According to the Project Management Institute (PMI), the scope statement should address all of the following issues EXCEPT: Select one: a. project constraints. b. project assumptions c. project exclusions. d. code of conduct for the team members working on the project. e. project deliverables.

Description : According to the Project Management Institute (PMI), the scope statement should  address all of the following issues EXCEPT: Select one: a. project constraints. b. project assumptions c. project ... d. code of conduct for the team members working on the project. e. project deliverables.

Last Answer : d. code of conduct for the team members working on the project.

What is the first step in project planning? Select one: a. Establish the objectives and scope. b. Determine the budget. c. Select the team organizational model. d. Determine project constraints. e. Inspect the deliverables.

Description : What is the first step in project planning? Select one: a. Establish the objectives and scope. b. Determine the budget. c. Select the team organizational model. d. Determine project constraints. e. Inspect the deliverables.

Last Answer : a. Establish the objectives and scope.

Your company has asked you to be the project manager for the product introduction of its new DeskTop Rock media system. You recently published the project scope statement. Which of the following is not contained in D. Project configuration management requirementsthe project scope statement? A. Constraints B. Project specifications C. Requested changes

Description : Your company has asked you to be the project manager for the product introduction  of its new DeskTop Rock media system. You recently published the project scope  statement. Which ... . Constraints  B. Project specifications  C. Requested changes D. Project configuration management requirements

Last Answer : C. Requested changes

Which of these is not one of the constraints of a project? a. Scope b. Resources c. Team d. Budget

Description : Which of these is not one of the constraints of a project? a. Scope b. Resources c. Team d. Budget

Last Answer : c. Team

The Scope Statement should contain which of the following? 1. Project schedule 2. Project budget constraints 3. Summary of project tasks , deliverables and resources required 4. Project objectives

Description : The Scope Statement should contain which of the following? 1. Project schedule  2. Project budget constraints  3. Summary of project tasks , deliverables and resources required  4. Project objectives

Last Answer : 4. Project objectives

During the planning development process, at times it is necessary to make certain assumptions to enhance the project plan when the data is not available. In regard to making those assumptions, which one of the following is most true for project planning purposes? 1. The assumptions will be considered as true, real, or certain. 2. By making the assumption, it tends to reduce the project risk. 3. Project assumptions are based upon historical data used for the project. 4. Senior management predefines the budget constraints.

Description : During the planning development process, at times it is necessary to make certain assumptions to enhance the project plan when the data is not available. In regard to making those assumptions, ... upon historical data used for the project.  4. Senior management predefines the budget constraints.

Last Answer : 1. The assumptions will be considered as true, real, or certain.

Which of these is not one of the constraints of a project? A. Scope B. Resources C. Team D. Budget

Description : Which of these is not one of the constraints of a project? A. Scope B. Resources C. Team D. Budget

Last Answer : C. Team

What are the limitations of the semantic networks? a) Intractability b) Lack in expressing some of the properties c) Incomplete d) Has memory constraints

Description : What are the limitations of the semantic networks? a) Intractability b) Lack in expressing some of the properties c) Incomplete d) Has memory constraints

Last Answer : b) Lack in expressing some of the properties

Flexible CSPs relax on _______ a) Constraints b) Current State c) Initial State d) Goal State

Description : Flexible CSPs relax on _______ a) Constraints b) Current State c) Initial State d) Goal State

Last Answer : a) Constraints

____________ is/are useful when the original formulation of a problem is altered in some way, typically because the set of constraints to consider evolves because of the environment. a) Static CSPs b) Dynamic CSPs c) Flexible CSPs d) None of the mentioned

Description : ____________ is/are useful when the original formulation of a problem is altered in some way, typically because the set of constraints to consider evolves because of the environment. a) Static CSPs b) Dynamic CSPs c) Flexible CSPs d) None of the mentioned

Last Answer : b) Dynamic CSPs

To overcome the need to backtrack in constraint satisfaction problem can be eliminated by ____________ a) Forward Searching b) Constraint Propagation c) Backtrack after a forward search d) Omitting the constraints and focusing only on goals

Description : To overcome the need to backtrack in constraint satisfaction problem can be eliminated by ____________ a) Forward Searching b) Constraint Propagation c) Backtrack after a forward search d) Omitting the constraints and focusing only on goals

Last Answer : a) Forward Searching

_______________ are mathematical problems defined as a set of objects whose state must satisfy a number of constraints or limitations. a) Constraints Satisfaction Problems b) Uninformed Search Problems c) Local Search Problems d) All of the mentioned

Description : _______________ are mathematical problems defined as a set of objects whose state must satisfy a number of constraints or limitations. a) Constraints Satisfaction Problems b) Uninformed Search Problems c) Local Search Problems d) All of the mentioned

Last Answer : a) Constraints Satisfaction Problems

A model of language consists of the categories which does not include? a) Language units b) Role structure of units c) System constraints d) Structural units

Description : A model of language consists of the categories which does not include? a) Language units b) Role structure of units c) System constraints d) Structural units

Last Answer : d) Structural units

In the context of strategic management, stakeholders can be defined as: a) An individual or group with a financial stake in the organization b) An external individual or group that is able to impose constraints on the organizationInternal groups or individuals that are able to influence strategic direction of the organizationd) An individual or group with an interest in the organization's activities and who seeks to influence them

Description : In the context of strategic management, stakeholders can be defined as: a) An individual or group with a financial stake in the organization b) An external individual or group that is able to ... individual or group with an interest in the organization's activities and who seeks to influence them

Last Answer : An individual or group with an interest in the organization's activities and who seeks to influence them