1: Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples for Student_ID 1003 must be performed. It is necessary to change one of the activities from swimming to tennis. The Student_ID and Activity attributes make up the primary key for the Recreation relation. All related information must be altered, as well. Which SQL statement or statements would best accomplish this?

A.UPDATE Recreation
SET Activity, Activity_Fee (‘Tennis’, 100)
WHERE Student_ID = 1003;
B.UPDATE TABLE Recreation
SET ACTIVITY = ‘Tennis’, Activity_Fee = 100
WHERE Student_ID = 1003
AND Activity = Swimming;
C.UPDATE Recreation
SET Activity = ‘Tennis’, Activity_Fee = 100
WHERE Student_ID = 1003
AND Activity = ‘Swimming’;
D.DELETE Activity
FROM Recreation
WHERE Student_ID  = 1003;
INSERT INTO Recreation
VALUES (1003, ‘Tennis’, 100);
Correct Answers: C

2: 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?
A.1, 2, 3, 4
B.3, 4, 1, 2
C.4, 1, 3, 2
D.4, 2, 3, 1
Correct Answers: D

3: Your enterprise is involved in planning a database project. The exhibit shows the result of one phase of the database design life cycle. Which term best describes the diagram shown in the exhibit?

A.Information Engineering (IE) data model
B.Corporate data model
C.Database requirements model
D.Entity Relation Data (ERD) model
Correct Answers: B

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

What is the output of this SQL statement?

A.
B.
C.
D.
Correct Answers: D

5: The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student with the ID 1311?

A.Only an update anomaly would occur.
B.An insertion anomaly would occur.
C.A deletion anomaly would occur.
D.An update anomaly and a deletion anomaly would occur.
Correct Answers: C

6: Which of the following occurs in a relation when records are added or removed?
A.The number of domains changes.
B.The attributes in the table change.
C.The cardinality of the relation is fixed but the degree varies.
D.The degree of the relation is fixed but the cardinality varies.
Correct Answers: D

7: Which of the following describes two desirable characteristics of a primary key?
A.A primary key should be a value that may be null and may change over time.
B.A primary key should be a value that is not null and will never change.
C.A primary key should consist of meaningful data and a value that can be changed if needed.
D.A primary key should not consist of meaningful data and a value that can be changed if needed.
Correct Answers: B

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?

A.SELECT *
FROM Registration
WHERE Course_Code = M#;
B.SELECT *
FROM Registration
WHERE Course_Code LIKE M_;
C.SELECT *
FROM Registration
WHERE Course_Code LIKE M%;
D.SELECT *
FROM Registration
WHERE Course_Code = M%;
Correct Answers: C

9: Which process is used to prevent the current database operation from reading or writing a data item while that data item is being accessed by another operation?
A.Lock
B.Deadlock
C.Timestamp
D.Batch
Correct Answers: A

10: Consider the Information Engineering diagram in the exhibit showing a conceptual data model of the relations BUILDING and RESIDENT. What is the next step in refining the data model?

A.Create intermediate entities.
B.Create a logical data model.
C.Resolve many-to-many relationahips.
D.Identify and resolve complex relationships.
Correct Answers: B

If you want to pass CIW 1D0-541 successfully, donot missing to read latest lead2pass CIW 1D0-541 practice exams.
If you can master all lead2pass questions you will able to pass 100% guaranteed.