Searching for "he"

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
 
Answer & Explanation Answer: C) Both A and B

Explanation:

Both of them are relation ship constraints

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

Q:

The relationship where both the participating entities belong to same entity type is called

A) Participation B) Recursive
C) Standard D) Normal
 
Answer & Explanation Answer: B) Recursive

Explanation:

The relationship where both the participating entities belong to same entity type is called Recursive relationship

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

Q:

The no of entities participating in a relation is called

A) Relation B) Degree of relationship
C) Recursive relationship D) None of the above
 
Answer & Explanation Answer: B) Degree of relationship

Explanation:

The no of entities participating in relation is called Degree of relationship

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

Q:

An entity is a thing in the real world with an independent existence.

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

Entity is a real world object

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

Q:

The capacity to change the conceptual schema without having to change external schemas or application programs is called

A) Physical Data Independence B) Logical Data Independence
C) Both A and B D) None
 
Answer & Explanation Answer: B) Logical Data Independence

Explanation:

LDI is the capacity to change the conceptual schema without having to change external schemas or application programs.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

Q:

What is schema?

Answer

The description of a data base is called the database schema , which is specified during database design and is not expected to change frequently . A displayed schema is called schema diagram .We call each object in the schema as schema construct.

Report Error

View answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

Q:

Physical data models describe the details of how data is stored in the computers

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

They describe the details of how data is stored in the computers

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

Q:

Representation level data models provide the concepts that are close to the way many users perceive data

A) TRUE B) FALSE
Answer & Explanation Answer: B) FALSE

Explanation:

High level data models provide the concepts that are close to the way many users perceive data

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration