1D0-541 - CIW v5 Database Design Specialist

Go back to CIW

Example Questions

Which of the following best describes a composite key? A Composite Solution With Just One Click ­ Which mechanism provides database users with controlled access to the database through the use of virtual tables? To create a view, what are the minimal privileges that a user must have for the relations used to make the view? Your company must choose which type of database to use for a new project. Which of the following lists three characteristics of file-based database systems? Which database architecture is best suited to implementation in the World Wide Web environment? Which of the following best describes the information contained in the data dictionary (or system catalog)? Your enterprise has reached the conceptual design phase for a database project. What is the desired goal at the end of this design phase? In which phase of database design do you identify entities, attribute domains, and relationships? What is a relational database domain? Which of the following best describes the ON DELETE NO ACTION referential integrity constraint? Which of the following definitions applies to all types of databases? Consider the following database information: domain s_id: integer domain grd: fixed length character string length 1 STUDENT_GRADE( Student_Number: s_id NOT NULL Grade: grd ) Primary Key Student_Number During which phase of the database design process would this information be developed? In a relational database, which term describes a single table consisting of rows and columns? A Composite Solution With Just One Click ­ Which of the following ACID properties requires that a transaction be executed in its entirety or not all? With regard to databases, what is normalization? Your enterprise must decide whether to use a database management system. Which of the following best describes the functionality of a DBMS? A Composite Solution With Just One Click ­ Which term describes the rejoining of relations that have been decomposed? Which pair of relational algebraic operations requires union compatibility? Which component in the three-tier database architecture handles the data-processing and business logic? Which type of entity must reference another entity for its data to be meaningful? Which term describes an attribute or combination of attributes that uniquely identifies a row in a relation? What is a virtual table? Which statement accurately describes a characteristic of attributes? Which statement best describes a procedural data manipulation language command? Consider the following four database design activities: A Composite Solution With Just One Click ­ 1 - Design user views. 2 - Select a DBMS. 3 - Apply normalization. 4 - Determine entities. Which choice shows the correct ordering of these activities, from first to last, by assigned numbers? Which of the following best describes the two-tier database architecture? You enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS? Consider the following DBDL description of an entity: Teachers (teach_num: variable length character string length 10 NOT NULL teach_name: variable length character string length 10 NOT NULL) Primary Key: teach_num which integrity constraint is satisfied? Which subset of Structured Query Language (SQL) is used to create and name database entities? A foreign key maps to a: Which subset of Structured Query Language (SQL) is used to limit access to a database or its data? Which statement best describes a candidate key? Which term describes the management of simultaneous transactions to prevent conflicts? What is a domain? Which relational algebraic operation is used to select specific columns (attributes) from a relation? Which security technique limits access by unauthorized users to parts of an enterprise database? Your enterprise has created a database and database application. The testing phase for the project has started. Which of the following best describes white-box testing of the projects software? Which of the following describes two desirable characteristics of a primary key? Consider the following four database design activities: 1 - Design user views. 2 - Select a DBMS. 3 - Apply normalization. 4 - Determine entities. Which choice shows the correct ordering of these activities, from first to last, by assigned numbers? What is the most important service provided by a database management system? Your enterprise must decide whether to use a database management system. Which of the following best describes the functionality of a DBMS? Which of the following definitions best describes an entity? What is a data dictionary? Which concurrency control method should be used only when conflicts between transactions rarely occur? Which characteristic is an advantage of a database management system? Which type of dependency occurs when one attribute of a composite key is removed and the dependency still exists? Consider the following relation definition: STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number A Composite Solution With Just One Click ­ HOUSING( Housing_ID: integer NOT NULL Student_Number: integer NOT NULL Building: variable length character string length 25 NOT NULL) Primary Key Housing_ID Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO CHECK ON UPDATE Which integrity constraint is violated in this relation definition? Your database administrator has disallowed a group of users from making alterations to the Employees table in your corporate database. The users, known as Group_2, previously had full privileges with the Employees table. Which of the following SQL statements properly removes any alteration privileges from Group_2? A Composite Solution With Just One Click ­ Which statement is used to define a named group of related tables, views, domains and other database objects? A Composite Solution With Just One Click ­ Which database architecture is best suited to implementation in the World Wide Web environment?

Study Guides