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

Go to page:

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?