Sawaal

 Database Questions

Popular Latest Rated
Q:

 A reason for using an SQL view to hide columns is:

A) to simplify a result only. B) to prevent the display of sensitive data only.
C) to accomplish both of the above. D) None of the above are reasons for using an SQL view.
 
Answer & Explanation Answer: C) to accomplish both of the above.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 5963
Q:

 A transitive dependency is which of the following?

A) A functional dependency between two or more key attributes. B) A functional dependency between two or more nonkey attributes.
C) A relation that is in first normal form. D) A relation that is in second normal form.
 
Answer & Explanation Answer: B) A functional dependency between two or more nonkey attributes.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

4 5704
Q:

The benefits of object-oriented modeling are which of the following?

A) The ability to tackle more challenging problems B) Reusability of analysis, design, and programming results
C) Improved communication between users, analysts, etc. D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

5 5490
Q:

The ODBC core API consists of which of the following functions?

A) Commit or rollback transactions only B) Connect to data sources only
C) Connect to data sources with driver-specific information only D) Both 1 and 2 above are in the OBDC core API.
 
Answer & Explanation Answer: D) Both 1 and 2 above are in the OBDC core API.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 5471
Q:

A ternary relationship involves how many entities?

A) 3 or less B) 3
C) More than 3 D) 3 or more
 
Answer & Explanation Answer: B) 3

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 5345
Q:

A shared database should:

A) be accurate and available. B) provide for backup and recovery.
C) be secure. D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

3 5328
Q:

For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

A) Two B) Three
C) Four D) Six
 
Answer & Explanation Answer: D) Six

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

3 5279
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 5256