1D0-541 무료 덤프문제 온라인 액세스

With regard to databases, what is normalization?

• A.The process of reducing the cardinality of a relation
• B.The process of limiting data stored in a table to a specific range of values
• C.The process of duplicating data to reduce the number of tables
• D.The process of organizing and refining relations

Which relational algebraic operation is used to select specific columns (attributes) from a relation?

• A.Intersection
• B.Union
• C.Projection
• D.Difference

The exhibit shows a table called Activity Relation that relates a unique student identification number with a sports activity and a fee for participating in that activity. A student can participate in only one activity. The key for the relation is Student_ID. What consequence would occur if the tuple for Student_ID 1001 were removed?

• A.An insertion anomaly would occur.
• B.A deletion anomaly would occur.
• C.Both an insertion anomaly and a deletion anomaly would occur.
• D.An update anomaly would occur.

What is a relational database domain?

• A.A collection of related data items
• B.A set of permissible attribute values
• C.A set of permissibletuple values
• D.A group of attributes

Which subset of Structured Query Language (SQL) is used to create and name database entities?

• A.Data Definition Language
• B.Data Query Language
• C.Database Entity Language
• D.Data Manipulation Language