1D0-541 Exam Dumps - CIW v5 Database Design Specialist

Question # 4

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

Entity

Domain

Primary key

Attribute group

Full Access

Question # 5

Which area of database security involves maintaining access to enterprise data?

Theft

Privacy

Availability

Confidentiality

Full Access

Question # 6

What improvement can be made to file-based databases to overcome their limitations?

Implement a tabular structure.

Gather files in a distributed repository.

Use a hierarchical database file system.

Tightly couple database structure to database application programs.

Full Access

Question # 7

Consider the following relational algebraic expression: Which of the following SQL statements is equivalent to this relational algebraic expression?

SELECT*FROM Customers,

Employees WHERE Sales_Rep_No = Cust_No;

SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM

Customers, Employees WHERE Customers.Sales_Rep_No =

Employees.Sales_Rep_No;

SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM

Customers, Employees WHERE Employees.Sales_Rep_No =

Customers.Sales_Rep_No;

SELECT * FROM Customers, Employees WHERE

Customers.Sales_Rep_No = Employees.Sales_Rep_No;

Full Access

Question # 8

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?

SELECT * FROM

Registration WHERE

Course_Code = #

SELECT * FROM

Registration WHERE

Course_Code LIKE _

SELECT* FROM

Registration WHERE

Course_Code LIKE %

SELECT * FROM

Registration WHERE

Course Code = %

Full Access

Question # 9

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?

Logical

Physical

Conceptual

Implementation

Full Access

Question # 10

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?

SELECT * FROM

Registration WHERE

Course_Code = #

SELECT * FROM

Registration WHERE

Course_Code LIKE _

SELECT * FROM

Registration WHERE

Course_Code LIKE %

SELECT * FROM

Registration WHERE

Course Code = %

Full Access

Question # 11

FROM Registration WHERE

Consider the following relational algebraic expression: Which of the following SQL Course_Code = 'A4343';

statements is equivalent to this relational algebraic expression?

SELECT Sales_Rep_No(108)

FROM Orders;

INSERT INTO Orders

VALUES(Sales_Rep_No = 108)

WHERE Sales_Rep_No = NULL;

SELECT'FROM Orders

WHERE Sales_Rep_No = 108;

SELECT'FROM Orders

WHERE Sales_Rep_No = ?08?

Full Access

Question # 12

In which phase of database design do you identify entities, attribute domains, and relationships?

Logical

Physical

Application

Conceptual

Full Access

Question # 13

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?

The database designer tests the software because he or she is able to make necessary changes to the underlying code for the software.

A user who has no knowledge of the softwares underlying code tests the software.

Someone other than the database designer tests the software. This person has no access to the underlying code and attempts to use the software only in ways not considered by the software designers.

A person tests the software and submits suggestions to the software's underlying code. This person is someone other than the database designer, but has access to the softwares underlying code.

Full Access

Question # 14

Consider the symbols shown in the exhibit. Which of the following correctly identifies these symbols when used in an entity-relationship (ER) diagram?

1 = attribute, 2 = entity, 3 = relationship

1 = entity, 2 = relationship, 3 = attribute

1 = relationship, 2 = entity, 3 = attribute

1 = relationship, 2 = attribute, 3 = entity

Full Access

Question # 15

Consider the following SQL statement and the Orders relation shown in the exhibit:

What is the output of this SQL statement?

Option A

Option B

Option C

Option D

Full Access

Question # 16

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

Parallelism

Serialization

Database control

Concurrency control

Full Access

Question # 17

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

Views

Concurrency

Locking

Integrity controls

Full Access

Question # 18

Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit: Which of the following relational algebraic expressions would result in the given table?