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 5695
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 5444
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 5244
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 5127
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 5126
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 4835
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 4773
Q:

 Legacy data is which of the following?

A) Data contained in a newly-installed system B) Data rejected during the installation of a new system
C) Data contained in a file system D) Data contained by a system used prior to the installation of a new system
 
Answer & Explanation Answer: D) Data contained by a system used prior to the installation of a new system

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

2 4686