constraints Search

Q:

The basic structure doctrine with regard to the Constitution of India relates to

1.the power of judicial review

2.the judgment in Kesavananda Bharati case (1973)

3.the constraints on Article 368 of the Constitution of India

4.the judgment in Golaknath case (1967)

Select the correct answer using the code given below.

A) 1, 2 and 3 only	B) 1, 2, 3 and 4
C) 1 and 3 only	D) 2 and 4 only

Answer & Explanation Answer: A) 1, 2 and 3 only

Explanation:

The Golaknath Case of 1967 relates to the power of the Parliament to curtail the Fundamental Rights provided in the Constitution.In 1967, the Supreme Court reversed its earlier decisions in Golaknath v. State of Punjab. It held that Fundamental Rights included in Part III of the Constitution are given a "transcendental position" and arebeyond the reach of Parliament. It also declared any amendment that "takes away or abridges" a Fundamental Right conferred by Part III as unconstitutional. By 1973, the basic structure doctrine triumphed in Justice Hans Raj Khanna's judgment in the landmark decision of Kesavananda Bharati v. State of Kerala.

Report Error

View Answer Report Error Discuss

Filed Under: Indian History
Exam Prep: Bank Exams

Q:

Data integrity constraints are used to

A) Ensure that duplicate records are not entered into the table	B) Prevent users from changing the values stored in the table
C) Control who is allowed access to the data	D) Improve the quality of data entered for a specific property like table column

Answer & Explanation Answer: D) Improve the quality of data entered for a specific property like table column

Explanation:

Integrity constraints are used to ensure accuracy and consistency of data in a relational database. Data integrity is handled in a relational database through the concept of referential integrity. Many types of integrity constraints play a role in referential integrity (RI).

Hence, Data integrity constraints are used to Improve the quality of data entered for a specific property i.e, table column.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Analyst , Database Administration , IT Trainer

Q:

The triple constraints of Project Management are frequently discussed in other contextx such as marketing classes and a variety of other subjects. The interaction between _____, ______, and _______can be seen as a triangle, with the three sides impacting the others.

A) quality, resources, time	B) money, resources, quality
C) scope, quality, planning	D) time, scope, cost

Answer & Explanation Answer: D) time, scope, cost

Explanation:

Scope, quality, and cost are the triple constraints. Quality is a function of these three areas and can impact them; however it is not considered one of the components of the triple constraint. Therefore, Answer A, B, and C are incorect.

Report Error

View Answer Report Error Discuss

Filed Under: PMP Certification

Q:

What are the types of constraints avaialable in oracle?

Answer

Oracle constraints are used to maintain consistent of data and ensure the data is properly maintained. A constraint is more or less a restriction we try to apply on a table.
Types of constraints:
- Check constraints
- NOT NULL constraint
- PRIMARY KEY constraint
- REFERENCES constraint
- UNIQUE constraint

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

What are constraints? Mention the different types of constraints?

Answer

Constraints enable the RDBMS to enforce the integrity of the database automatically, without the need to create triggers, rule or defaults.

Types of Constraints: NOT NULL, CHEQUE, UNIQUE, PRIMARY KEY, FOREIGN KEY.

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:

A) first step.	B) second step.
C) third step.	D) fourth step.

Answer & Explanation Answer: C) third step.

Explanation:

Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an
application. The application connects to a Microsoft SQL Server database. The application has two DataTable objects that reference the Customers and Orders tables in the database. The application contains the following code segment. (Line numbers are included for reference only.)

01DataSet customerOrders = new DataSet();
02customerOrders.EnforceConstraints = true;
03ForeignKeyConstraint ordersFK = new ForeignKeyConstraint("ordersFK",
04customerOrders.Tables["Customers"].Columns["CustomerID"],
05customerOrders.Tables["Orders"].Columns["CustomerID"]);
06
07customerOrders.Tables["Orders"].Constraints.Add(ordersFK);

You need to ensure that an exception is thrown when you attempt to delete Customer records that have related Order records. Which code segment should you insert at line 06?

A) ordersFK.DeleteRule = Rule.SetNull;	B) ordersFK.DeleteRule = Rule.None;
C) ordersFK.DeleteRule = Rule.SetDefault;	D) ordersFK.DeleteRule = Rule.Cascade;

Answer & Explanation Answer: B) ordersFK.DeleteRule = Rule.None;

Explanation:

Report Error

View Answer Report Error Discuss

Filed Under: MCSD-Microsoft Certified Solutions Developer

Q:

Which among the following is the relationship constraints

A) Cardinality ratio	B) Participation constraints
C) Both A and B	D) None of the above

Searching for "constraints"

Quick Links