Quiz 1D0-541

Quiz 1D0-541, CIW Database Design Specialist

Which of the following best describes the information contained in the data dictionary (or system catalog)?

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

Which of the following describes two desirable characteristics of a primary key?

which data records are stored in one or more files with no structured relationship?

Which of the following best describes the two-tier database architecture?

Which term describes an attribute or combination of attributes that uniquely identifies a row in a relation?

Which of the following is a characteristic of the three-tier database architecture?

Which statement best describes a candidate key?

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

Which of the following best describes the functionality of a DBMS?