31: Which term describes the management of simultaneous transactions to prevent conflicts?
A.Parallelism
B.Serialization
C.Database control
D.Concurrency control
Correct Answers: D

32: Your enterprise is developing a database system that will contain highly sensitive data. Security of the data will take priority over database processing speed. Which database protection technique should be employed?
A.Backups
B.User views
C.Encryption
D.Integrity controls
Correct Answers: C

33: Which subset of Structured Query Language (SQL) is used to limit access to a database or its data?
A.Data Definition Language
B.Data Control Language
C.Data Entity Language
D.Data Manipulation Language
Correct Answers: B

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

How many records should be returned?
A.Two records
B.Three records
C.Four records
D.Five records
Correct Answers: C

35: Consider the Orders relation shown in the exhibit. Which of the following SQL statements would return all complete tuples for order dates in 2002, arranged by amount from lowest to highest?

A.SELECT *
FROM Orders
WHERE Order_Date LIKE _02
ORDER BY Amount;
B.SELECT (Order_Date, Amount)
FROM Orders
WHERE Order_Date LIKE %02
ORDER BY Amount;
C.SELECT *
FROM Orders
WHERE Order_Date LIKE _02
ORDER BY Order_No;
D.SELECT *
FROM Orders
WHERE Order_Date LIKE %02
ORDER BY Amount;
Correct Answers: D

36: 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
Correct Answers: A

37: The database manager wants to give Rubio and Doe the ability to modify the Project Relation shown in the exhibit. A temporary employee named Temp needs to access the data in the database to generate reports. Which group of SQL statements will perform this task?

A.GRANT UPDATE ON Project TO Rubio, Doe;
GRANT SELECT ON Project TO Temp;
B.GRANT ALL PRIVILEGES ON Project TO Rubio, Doe;
GRANT UPDATE ON Project TO Temp;
C.GRANT SELECT ON Project
WHERE Manager = ‘Rubio’;
GRANT SELECT ON Project
WHERE Manager = ‘Doe’;
D.GRANT UPDATE ON Project
WHERE Manager = ‘Rubio’;
GRANT UPDATE ON Project
WHERE Manager = ‘Doe’;
GRANT SELECT ON Project TO Temp;
Correct Answers: A

38: Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

A.m:m
B.m:n
C.1:1
D.1:n
Correct Answers: B

39: What is a relational database domain?
A.A group of attributes
B.A set of permissible tuple values
C.A collection of related data items
D.A set of permissible attribute values
Correct Answers: D

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

A.1 = attribute, 2 = entity, 3 = relationship
B.1 = entity, 2 = relationship, 3 = attribute
C.1 = relationship, 2 = entity, 3 = attribute
D.1 = relationship, 2 = attribute, 3 = entity

Correct Answers: C

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