最新的CIW 1D0-541免費考試真題

問題1

Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

A. SELECT * FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);

B. SELECT *FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89;

C. SELECT * FROM Customers WHERE Satisfaction_Rate <= 80 OR Satisfaction_Rate >= 90;

D. SELECT * FROM Customers WHERE Satisfaction_Rate IN (80 AND 90);

正確答案: B

問題2

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

A. Proj_ID and Item_Num

B. ltem_Num and E_Date

C. S_Date and E_Date

D. ProjJD

正確答案: A

問題3

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 ofdenormalized relations

B. A set of normalized relations

C. A reviewed entity-relationship (ER) model

D. An entity-relationship (ER) model with no redundant data

正確答案: C

問題4

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

B. (Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No (Sales_Rep X Customer))

C. Customer.Sales_Rep_No = Sales.sales_Rep_No (Customer X Sales_Rep)

D. (Customer X Sales_Rep) ? Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No

正確答案: A

問題5

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 *
FROM Orders
WHERE Order_Date LIKE _02
ORDER BY Order_No;

C. SELECT (Order_Date, Amount)
FROM Orders
WHERE Order_Date LIKE %02
ORDER BY Amount;

D. SELECT *
FROM Orders
WHERE Order_Date LIKE %02
ORDER BY Amount;

正確答案: D

問題6

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
WHERE Manager = 'Rubio';
GRANT UPDATE ON Project
WHERE Manager = 'Doe';
GRANT SELECT ON Project TO Temp;

B. GRANT UPDATE ON Project TO Rubio, Doe;
GRANT SELECT ON Project TO Temp;

C. GRANT ALL PRIVILEGES ON Project TO Rubio, Doe;
GRANT UPDATE ON Project TO Temp;

D. GRANT SELECT ON Project
WHERE Manager = 'Rubio';
GRANT SELECT ON Project
WHERE Manager = 'Doe';

正確答案: B

最新的CIW v5 Database Design Specialist - 1D0-541免費考試真題

聯系我們

站內鏈接

最新更新