CIW 1D0-541 Exam - ActualPaper.com

Free 1D0-541 Sample Questions:

Q: 1
Which three pieces of information did E.F. Codd describe as necessary to retrieve a data value from a relational database?

A. Attribute, domain, and tuple
B. Entity, relation name, and domain
C. Table name, primary key, and entity
D. Attribute, relation name, and primary key

Answer: D

Q: 2
Which pair of relational algebraic operations requires union compatibility?

A. Union and join
B. Selection and projection
C. Intersection and difference
D. Cartesian product and intersection

Answer: C

Q: 3
Which term describes one or more database operations that are executed as a single unit?

A. Update
B. Transaction
C. Encapsulation
D. Operational group

Answer: B

Q: 4
Which statement best describes a candidate key?
A. It is the primary key for an entity.
B. It uniquely identifies every instance of an entity.
C. One or more keys are joined together to form a composite key.
D. One or more keys may be used to form a primary key.

Answer: D

Q: 5
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

Answer: C

Q: 6
The exhibit shows a table called Recreation Relation that relates a unique student identification number and a sports activity with a fee for participating in that activity. The Student_ID and Activity columns in the table are used together as a composite key. Which statement about the relation is correct?

A. Activity_Fee is a determinant of Activity.
B. Activity_Fee is partially dependent on the key.
C. The table contains a transitive dependency.
D. Activity_Fee is a determinant of Activity and Student_ID.

Answer: B

Q: 7
Which of the following best describes the two-tier database architecture?

A. The user accesses a database server using a terminal.
B. The user interface, data-processing logic, database access and data validation functions are performed on a mainframe server.
C. The user interface and data validation functions are performed by the client whereas the data-processing logic is performed on a server.
D. The user interface and data-processing logic are performed by the client whereas the server handles database access and data validation functions.

Answer: D

Q: 8
Your enterprise must decide whether to use a database management system. Which of the following best describes the functionality of a DBMS?

A. A DBMS provides the ability to control data access and limit the number of users at one time.
B. A DBMS provides the ability to maintain databases while providing increased security for the database.
C. A DBMS allows users to access the database while allowing the database administrator to define views particular to individual sets of users.
D. A DBMS provides the ability to define, create and maintain databases while providing controlled access to databases.

Answer: D

Q: 9
Which concurrency control method should be used only when conflicts between transactions rarely occur?

A. Locking
B. Time stamps
C. Optimistic
D. Serialization

Answer: C

Q: 10
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

Q: 11
What is the highest normal form of the relation(s) shown in the exhibit?

A. Second normal form
B. First normal form
C. Boyce-Codd normal form
D. Third normal form

Answer: A

Q: 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 NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
CLASS(
Class_Num: integer NOT NULL
Class_Name: integer NOT NULL)
Primary Key Class_Num
B. STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
CLASS(
Class_Num: integer NOT NULL
Class_Name: integer NOT NULL)
Primary Key Class_Num
Foreign Key Class_Num References STUDENT
C. STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
STU_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 NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
STU_CLASS(
Student_Number: integer NOT NULL
Class_Num: integer NOT NULL)
Primary Key Student_Number, Class_Num
CLASS(
Class_Num: integer NOT NULL
Class_Name: integer NOT NULL
Primary Key Class_Num

Answer: D

Q: 13
Consider the Information Engineering diagram shown in the exhibit. Which DBDL definition best describes this diagram?


A. BUILDING(Building_ID, Bldg_Name, Location, Room_Count)
Primary Key Building_ID
RESIDENT(R_ID, Room_Num, Res_Name, Building_ID)
Primary Key R_ID
B. BUILDING(Building_ID, Bldg_Name, Location, Room_Count)
Primary Key BUILDING
RESIDENT(R_ID, Room_Num, Res_Name, Building_ID)
Primary Key RESIDENT
C. BUILDING(Building_ID, Bldg_Name, Location, Room_Count)
Primary Key BUILDING
Foreign Key BUILDING(Building_ID) references RESIDENT(Building_ID)
RESIDENT(R_ID, Room_Num, Res_Name, Building_ID)
Primary Key RESIDENT
D. BUILDING(Building_ID, Bldg_Name, Location, Room_Count)
Primary Key Building_ID
RESIDENT(R_ID, Room_Num, Res_Name, Building_ID)
Primary Key R_ID
Foreign Key Building_ID references BUILDING(Building_ID)

Answer: D

Q: 14
Several SQL operations are performed by User 1 to access the Fee information for Bowling in the Act_Fee relation (shown in the exhibit). The first access returns a fee of 50. An unrelated SQL operation by another user updates the Bowling fee to 60. The second access by User 1 returns a fee of 60. What problem has occurred?


A. Rollback
B. Deadlock
C. Dirty read
D. No problem has occurred.

Answer: D

Q: 15
Consider the relation shown in the exhibit. Which of the following SQL statements would properly remove all tuples for New York customers?


A. DELETE *
FROM Customers
WHERE Sales_Office = New York;
B. DELETE
FROM Customers
WHERE Sales_Office = New York?WHERE Sales_Office = New York?
C. DELETE *
FROM Customers
WHERE Sales_Office = New York?WHERE Sales_Office = New York?
D. DELETE
FROM Customers
WHERE Sales_Office NOT LIKE New York? WHERE Sales_Office NOT LIKE New York?

Answer: B

Q: 16
Using the Customer and Sales_Rep relations shown in the exhibit, you must determine a relational algebraic expression that will result in the following relation: Which of the following relational algebraic expressions would result in this relation? Using the Customer and Sales_Rep relations shown in the exhibit, you must determine a relational algebraic expression that will result in the following relation:

Which of the following relational algebraic expressions would result in this relation?

Answer: A

Q: 17
Consider the Employee relation shown in the exhibit. A database manager wants to set up a view called Emp_Dept that allows users to find employees and their department ID numbers. Which SQL statement will accomplish this?


A. CREATE VIEW Emp_Dept
AS SELECT Last_Name, First_Name, Dept_ID
FROM Employee;
B. UPDATE VIEW Emp_Dept
AS SELECT *
FROM Employee;
C. UPDATE VIEW Emp_Dept
AS SELECT Last_Name, First_Name, Dept_ID
FROM Employee;
D. CREATE VIEW Emp_Dept
AS SELECT *
FROM Employee
WHERE ID = 0001
AND ID = 0002
AND ID = 0003
AND ID = 0004;

Answer: A

Q: 18
Consider the following relational algebraic expression as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit:

Which of the following relations would result from the given relational algebraic expression?

Answer: C

Q: 19
Consider the relations shown in the exhibit. Which of the following SQL statements would enter data from the Customers relation into the Atlanta_Customers relation?


A. INSERT INTO Atlanta_Customers
VALUES(
SELECT *
FROM Customers
WHERE Sales_Office = tlanta
B. INSERT INTO Atlanta_Customers
SELECT *
FROM Customers
WHERE Sales_Office = tlanta
C. INSERT INTO Atlanta_Customers
SELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No
FROM Customers
WHERE Sales_Office = tlanta
D. INSERT INTO Atlanta_Customers
SELECT Cust_No, Cust_Name, Sales_Office, Sales_Rep_No
FROM Customers
WHERE Sales_Office = tlanta

Answer: C

Q: 20
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?

A. Logical
B. Physical
C. Conceptual
D. Implementation

Answer: A

Q: 21
Which of the following best describes a composite key?

A. A composite key is a primary 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 keys.
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

Q: 22
Your enterprise has reached the conceptual design phase for a database project. What is the desired goal at the end of this design phase?

A. A set of normalized relations
B. A reviewed entity-relationship (ER) model
C. An entity-relationship (ER) model with no redundant data
D. A set of denormalized relations

Answer: B

Q: 23
Which subset of Structured Query Language (SQL) is used to limit access to a database or its data?

A. Data Markup Language
B. Data Control Language
C. Data Formatting Language
D. Data Manipulation Language

Answer: B

Q: 24
Which of the following definitions best describes an entity?

A. A relation
B. Data about data
C. Data stored in a table column
D. An item about which information is stored

Answer: D

Q: 25
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 domain 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.

Answer: D

Q: 26
What is the most important service provided by a database management system?

A. Provides support for a data manipulation language
B. Allows users to store data in a distributed data repository
C. Provides support for data formatting language commands
D. Translates procedural commands into non-procedural commands

Answer: A

Q: 27
Which database architecture is best suited to implementation in the World Wide Web environment?

A. Two-tier using thin client
B. Three-tier using fat client
C. Three-tier using thin client
D. Centralized mainframe with terminal client

Answer: C

Q: 28
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. Time stamp
D. Transaction

Answer: A

Q: 29
Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation form the Customers relation?

A. SELECT *
FROM Customers
WHERE Satisfaction_Rate <= 80
OR Satisfaction_Rate >= 90;
B. SELECT *
FROM Customers
WHERE Satisfaction_Rate IN (80 AND 90);
C. SELECT *
FROM Customers
WHERE Satisfaction_Rate >= 80
AND Satisfaction_Rate <= 89;
D. SELECT *
FROM Customers
WHERE Satisfaction_Rate
BETWEEN (80, 90);

Answer: C

Q: 30
The exhibit shows a relation for a company projects. Which candidate key(s) would best serve as the primary key for this relation?


A. S_Date and E_Date
B. Proj_ID
C. Item_Num and E_Date
D. Proj_ID and Item_Num

Answer: D