1D0-541 Exam - CIW v5 Database Design Specialist

NEW QUESTION 1
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?

• A. The database designer tests the software because he or she is able to make necessary changes to the underlying code for the software.
• B. A user who has no knowledge of the softwares underlying code tests the software.
• C. Someone other than the database designer tests the softwar
• D. This person has no access to the underlying code and attempts to use thesoftware only in ways not considered by the software designers.
• E. A person tests the software and submits suggestions to the software's underlying code.This person is someone other than the databasedesigner, but has access to the softwares underlying code.

Answer: D

Explanation:

NEW QUESTION 2
Which component in the three-tier database architecture handles the data-processing and business logic?

• A. Thin client
• B. Fat client
• C. Database server
• D. Application server

Answer: D

NEW QUESTION 3
Which type of relational integrity is violated if a primary key in a database has a null value?

• A. Entity integrity
• B. Domain integrity
• C. Domain constraints
• D. Referential integrity

Answer: A

NEW QUESTION 4
Which of the following best describes the ON DELETE NO ACTION referential integrity constraint?

• A. If a parent key is deleted, any child keys referenced by the parent key are automatically deleted.
• B. If a parent key is deleted, no test is made for referential integrity.
• C. If any child key references a parent key, the record containing the parent key cannot be deleted.
• D. If a parent key is deleted, all child keys are automatically set to a specified value.

Answer: C

NEW QUESTION 5
What is a candidate key?

• A. The primary key for an entity
• B. The key that identifies every instance of an entity
• C. Multiple primary keys that are joined together to form a composite key
• D. A key that may be used to form the primary key

Answer: D

NEW QUESTION 6
Which statement accurately describes a characteristic of attributes?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 7
What is a virtual table?

• A. A virtual table is a relation created as the result of data manipulation, and is not a permanent part of the database.
• B. A virtual table is a relation stored in the databases memory; it is used when multiple users access the same relation in a database.
• C. A virtual table is a relation created from a defined base table; it contains metadata about the base relation.
• D. A virtual table is a relation that consists of primary and foreign keys for a particular set of relations in a database.

Answer: A

NEW QUESTION 8
Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT. What is the relationship between BUILDING and RESIDENT?

• A. 1:1
• B. 1:n
• C. n:m
• D. m:n

Answer: B

NEW QUESTION 9
Which term best defines a database system in which data records are stored with no structured relationships between the records?

• A. Flat-file database
• B. Relational database
• C. Distributed database
• D. Object-oriented database

Answer: A

NEW QUESTION 10
Consider the relation shown in the exhibit. Which of the following SQL statements would
properly remove all tuples for New York customers?

• A. DELETE *FROM CustomersWHERE Sales_Office = New York;
• B. DELETEFROM CustomersWHERE Sales_Office = New York;
• C. DELETE *FROM CustomerWHERE Sales_Office <> New York;
• D. DELETEFROM CustomersWHERE Sales_Office NOT LIKE New York;

Answer: B

NEW QUESTION 11
Which of the following definitions best describes an entity?

• A. A single relation
• B. Data about data
• C. Data stored in a table column
• D. An item about which information is stored

Answer: D

NEW QUESTION 12
Consider the relations shown in the exhibit. Due to restructuring, the sales department has been eliminated and the employees working in that department have been dismissed. All ID information is stored as integers. Which SQL statement would be used to return a relation with all information for the employees who have been dismissed?

• A. SELECT *FROM Employee;
• B. SELECT ID, Last_Name FROM Employee;WHERE ID = 0004;
• C. SELECT *FROM Employee WHERE Dept_ID = 022;
• D. SELECT *FROM Employee WHERE Dept_ID = 022;

Answer: C

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

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

Answer: C

NEW QUESTION 14
Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

• A. SELECT *FROM RegistrationWHERE Course_Code = M#;
• B. SELECT *FROM RegistrationWHERE Course_Code LIKE M_;
• C. SELECT *FROM RegistrationWHERE Course_Code LIKE M%;
• D. SELECT *FROM RegistrationWHERE Course_Code = M%;

Answer: C

NEW QUESTION 15
To create a view, what are the minimal privileges that a user must have for the relations used to make the view?

• A. GRANT
• B. REVOKE
• C. SELECT
• D. CREATE VIEW

Answer: C

NEW QUESTION 16
Consider the following relational algebraic expression as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit:


Which of the following relations would result from the given relational algebraic expression?

• A.
• B.
• C.
• D.

Answer: C

NEW QUESTION 17
Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?

• A. Degree of a relation
• B. Cardinality of a relation
• C. Primary key of a relation
• D. Determinant of a relation

Answer: B

NEW QUESTION 18
Which term best describes one or more database operations that are executed as a single unit?

• A. Update
• B. Transaction
• C. Procedure
• D. Singleton

Answer: B

NEW QUESTION 19
......