Quiz 1D0-541

Quiz 1D0-541, CIW Database Design Specialist

Which of the following ACID properties requires that a transaction be executed in its entirety or not all?

Which security technique limits access by unauthorized users to parts of an enterprise database?

A foreign key maps to a:

Which characteristic is an advantage of a database management system?

What are the referential constraints for the relations defined in these relation definitions?

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?