Online Access Free 1D0-541 Exam Questions

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

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

Which pair of relational algebraic operations requires union compatibility?

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

Which of the following ACID properties requires that a transaction be executed in its entirety or not all?

• A.Isolation
• B.Durability
• C.Atomicity
• D.Consistency

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?

• A.(Customer X Sales_Rep) ? Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No
• B.(Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No (Sales_Rep X Customer))
• C.Customer X Sales_Rep
• D.Customer.Sales_Rep_No = Sales.sales_Rep_No (Customer X Sales_Rep)

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