CIW 1D0-541 Free Practice Questions

NEW QUESTION 1
Which component in the three-tier database architecture handles the data-processing and business logic?

• A. Thin client
• B. Fat client
• C. Database server
• D. Application server

Answer: D

NEW QUESTION 2
Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

• A. INSERT INTO Employee VALUES(0005, Tim, Bogart, 03-15-77);
• B. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0004, Tim, Bogart, 03-15-77);
• C. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);
• D. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

Answer: D

NEW QUESTION 3
Consider the relation shown in the exhibit. Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_Rate of less than or equal to 80 unless the Sales_Office is located in Atlanta?

• A. SELECT *FROM CustomersWHERE Satisfaction_Rate > 80 OR Sales_Office = Atlanta;
• B. SELECT *FROM CustomersWHERE Satisfaction_Rate <= 80 AND Sales_Office = Atlanta;
• C. SELECT *FROM CustomersWHERE Satisfaction_Rate >= 80;
• D. SELECT *FROM CustomersWHERE Satisfaction_Rate >= 80 AND NOT Sales_Office = Atlanta;

Answer: A

NEW QUESTION 4
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 OrdersWHERE Order_Date LIKE _02 ORDER BY Amount;
• B. SELECT (Order_Date, Amount) FROM OrdersWHERE Order_Date LIKE %02 ORDER BY Amount;
• C. SELECT *FROM OrdersWHERE Order_Date LIKE _02 ORDER BY Order_No;
• D. SELECT *FROM OrdersWHERE Order_Date LIKE %02 ORDER BY Amount;

Answer: D

NEW QUESTION 5
What is the highest normal form of the relation(s) shown in the exhibit?

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

Answer: C

NEW QUESTION 6
A large enterprise uses a two-tier database architecture and runs complex database processing on the client. Which term best describes the client in this system?

• A. Fat client
• B. Thin client
• C. Terminal client
• D. Enterprise client

Answer: A

NEW QUESTION 7
Consider the table for an employee database shown in the exhibit. What is the degree of the table?

• A. 25
• B. 5
• C. 4
• D. 20

Answer: B

NEW QUESTION 8
Which mechanism provides database users with controlled access to the database through the use of virtual tables?

• A. View
• B. Data dictionary
• C. Database control language
• D. Database management system

Answer: A

NEW QUESTION 9
Your enterprise must decide whether to use a database management system. Which of the following best describes the overall functionality of a DBMS?

• A. A DBMS provides the ability to control data access using Data Manipulation Language.
• 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 only the database administrator to define user views.
• D. A DBMS provides the ability to define, create and maintain databases while providing controlled access to databases.

Answer: D

NEW QUESTION 10
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 Customer sWHERE Sales_Office = Atlanta);
• B. INSERT INTO Atlanta_Customers SELECT *FROM CustomersWHERE Sales_Office = Atlanta;
• C. INSERT INTO Atlanta_CustomersSELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No FROM CustomersWHERE Sales_Office = Atlanta;
• D. INSERT INTO Atlanta_CustomersSELECT Cust_No, Cust_Name, Sales_Office, Sales_Rep_No FROM CustomersWHERE Sales_Office = Atlanta;

Answer: C

Explanation:

NEW QUESTION 11
A theta-join can be viewed as:

• A. the intersection of two relations.
• B. a Cartesian product of two relations.
• C. a restricted Cartesian product of two relations.
• D. the Cartesian product of two union-compatible relations.

Answer: C

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

• A. Entity
• B. Domain
• C. Primary key
• D. Attribute group

Answer: C

NEW QUESTION 13
What is the highest normal form of the relation(s) shown in the exhibit?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 14
Consider the table for an employee database shown in the exhibit. What is the cardinality of the table?

• A. 5
• B. 20
• C. 4
• D. 25

Answer: C

NEW QUESTION 15
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

NEW QUESTION 16
Which pair of relational algebraic operations requires union compatibility?

• A. Projection and Cartesian product
• B. Selection and projection
• C. Intersection and difference
• D. Cartesian product and intersection

Answer: C

NEW QUESTION 17
......