Searching for "constraint"

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

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 is the self-referencing constraint?

Answer

A31. The self-referencing constraint limits in a single table the changes to a primary key that the related foreign key defines. The foreign key in a self referencing table must specify the DELETE CASCADE rule.

Report Error

View answer Workspace Report Error Discuss

Q:

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

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.

Report Error

View answer Workspace Report Error Discuss

Q:

Explain unique Constraint.

Answer

A unique constraint on a column uniquely identifies the record by a combination of one or more fields. Few unique constraint fields can have a NULL value as long as the combination of values is unique.


Example:
create table employee ( id number NOT NULL, dob DATE, professor_id NOT NULL, Name varchar(200) Constraint id_unique UNIQUE(id,dob) );

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

Explain foreign key constraint.

Answer

A foreign key is a reference to another table. It is used to establish relationships between tables. For example, relationship between employee and professor table. One employee can have multiple professors. The Primary key of employee becomes foreign key of professor.
Example:
create table employee ( id number NOT NULL, professor_id NOT NULL, Name varchar(200) Constraint prim_id Foreign key(id) references professor(professor_id) );

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

Explain primary key constraint.

Answer

Primary key constraint ensures that the column(s) always has a unique value to identify the record.
Example:
Below, the primary key is created for column id with name prim_id.
create table employee ( id number NOT NULL, Name varchar(200) Constraint prim_id primary key(id) );

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle