Sawaal

 Database Questions

Popular Latest Rated
Q:

 To drop a column that is used as a foreign key, first:

A) drop the primary key. B) drop the table containing the foreign key..
C) drop the foreign key constraint. D) All of the above must be done.
 
Answer & Explanation Answer: C) drop the foreign key constraint.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 4326
Q:

 A supertype/subtype hierarchy has which of the following features?

A) Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype. B) Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
C) Attributes are assigned at the highest logical level. D) Attributes are assigned at the lowest logical level.
 
Answer & Explanation Answer: C) Attributes are assigned at the highest logical level.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 4285
Q:

 What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

A) ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0); B) ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
C) ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0); D) None of the above is correct.
 
Answer & Explanation Answer: C) ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 4233
Q:

 The process of reading a database schema and producing a data model from that schema is known as:

A) data modeling. B) database design.
C) reverse engineering. D) None of the above is correct.
 
Answer & Explanation Answer: C) reverse engineering.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 4230
Q:

 When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?

A) Disjoint with total specialization B) Disjoint with partial specialization
C) Overlap with total specialization D) Overlap with partial specialization
 
Answer & Explanation Answer: C) Overlap with total specialization

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

2 4182
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

1 4082
Q:

 The first step in database development is which of the following?

A) Enterprise data modeling B) Logical database design
C) Physical database design and definition D) Database Implementation
 
Answer & Explanation Answer: A) Enterprise data modeling

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3998
Q:

 In a 1:N relationship, the foreign key is placed in:

A) the parent table. B) the child table.
C) either table without specifying parent and child tables. D) either the parent table or the child table.
 
Answer & Explanation Answer: B) the child table.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3955