Renewal 1D0-541 Test Questions For CIW V5 Database Design Specialist Certification

NEW QUESTION 1
Your enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS?

• A. Management of data redundancy, increased data integrity, increased data dependence, and increased application complexity
• B. Consistency of data, adherence to standards, managed concurrency, and increased software complexity
• C. Increased data access, increased data backup and recovery, data sharing, and consistency of data
• D. Increased data security, increased data integrity, increased data independence, and decentralization of data

Answer: C

NEW QUESTION 2
A theta-join can be viewed as:

• A. the intersection of two relations.
• B. a Cartesian product of two relations.
• C. a restricted Cartesian product of two relations.
• D. the Cartesian product of two union-compatible relations.

Answer: C

NEW QUESTION 3
The creation of intermediate entities occurs during the logical database design phase for an enterprise. It is used to resolve which types of relationships?

• A. One-to-many, complex, and recursive
• B. Complex, recursive, and many-to-many
• C. Redundant, recursive, and many-to-many
• D. One-to-many and one-to-one

Answer: B

NEW QUESTION 4
Which pair of relational algebraic operations requires union compatibility?

• A. Projection and Cartesian product
• B. Selection and projection
• C. Intersection and difference
• D. Cartesian product and intersection

Answer: C

NEW QUESTION 5
Which term describes the management of simultaneous transactions to prevent conflicts?

• A. Parallelism
• B. Serialization
• C. Database control
• D. Concurrency control

Answer: D

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

• A. Durability
• B. Consistency
• C. Isolation
• D. Atomicity

Answer: D

NEW QUESTION 7
Which of the following best describes a composite key?

• A. A composite key is a primary key and foreign key that consists of the first two attributes of a relation.
• B. A composite key is a primary or foreign key defined by its parent key attributes.
• C. A composite key is a foreign key that consists of the same attributes as the primary key from a related table.
• D. A composite key is a primary or foreign key that consists of two or more attributes of a relation.

Answer: D

NEW QUESTION 8
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 9
Consider the Project relation shown in the exhibit as well as the following SQL statement:

DELETE FROM Project WHERE Cust_Name = Acme;
Which of the following tables shows the Project relation after execution of this SQL statement?

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

Answer: A

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

• A. A Web browser is used as the application server.
• B. The application logic is centralized on a dedicated server.
• C. A thick client is used to perform business application logic functions locally.
• D. Database application logic and database functionality are integrated and reside on a common server.

Answer: B

NEW QUESTION 11
Which mechanism provides database users with controlled access to the database through the use of virtual tables?

• A. View
• B. Data dictionary
• C. Database control language
• D. Database management system

Answer: A

NEW QUESTION 12
Consider the entity-relation (ER) diagram shown in the exhibit. When the logical database design phase is completed, which of the following is a valid DBDL description of the base relations for the ER diagram?

• A. STUDENT(Student_Number: integer NOT NULLName: variable length character string length 20 NOT NULL) Primary Key Student_NumberCLASS(Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num
• B. STUDENT(Student_Number: integer NOT NULLName: variable length character string length 20 NOT NULL) Primary Key Student_NumberCLASS(Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_NumForeign Key Class_Num References STUDENT
• C. STUDENT(Student_Number: integer NOT NULLName: variable length character string length 20 NOT NULL) Primary Key Student_NumberSTU_CLASS(Student_Number: integer NOT NULL Class_Num: integer NOT NULL) Primary Key Student_Number CLASS(Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num
• D. STUDENT(Student_Number: integer NOT NULLName: variable length character string length 20 NOT NULL) Primary Key Student_NumberSTU_CLASS(Student_Number: integer NOT NULL Class_Num: integer NOT NULL) Primary Key Student_Number CLASS(Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num

Answer: D

NEW QUESTION 13
What is the highest normal form of the relation(s) shown in the exhibit?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 14
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 15
A relation for a construction company is shown in the exhibit. Which of the following best defines the relationship between Cust_ID and Cust_Name?

• A. Cust_Name is the determinant.
• B. Cust_Name is transitively dependent on Cust_ID.
• C. Cust_ID is transitively dependent on Cust_Name.
• D. Cust_Name is functionally dependent on Cust_ID.

Answer: D

NEW QUESTION 16
What is the highest normal form of the relation(s) shown in the exhibit?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 17
Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 18
......