Testking offers free demo for 1D0-541 exam. "CIW v5 Database Design Specialist", also known as 1D0-541 exam, is a CIW Certification. This set of posts, Passing the CIW 1D0-541 exam, will help you answer those questions. The 1D0-541 Questions & Answers covers all the knowledge points of the real exam. 100% real CIW 1D0-541 exams and revised by experts!
Q17. Consider the Information Engineering diagram shown in the exhibit. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name, Location and Res_Name are all represented by variable-length strings with a maximum of 20 characters.
Which SQL statement best implements the RESIDENT relation shown in this diagram?
A. CREATE TABLE RESIDENT (
R_ID INTEGER NULL PRIMARY KEY,
Room_NumFLOAT,
Res_NameVARCHAR,
Building_IDINTEGER NULL,
FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));
B. CREATE TABLE RESIDENT (
R_ID INTEGER NOT NULL PRIMARY KEY,
Room_NumBINARY,
Res_NameVARCHAR (20),
Building_IDINTEGER NOT NULL,
FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));
C. CREATE TABLE RESIDENT (
R_ID INTEGER NOT NULL PRIMARY KEY,
Room_NumINTEGER,
Res_NameVARCHAR (20),
Building_IDINTEGER NOT NULL);
D. CREATE TABLE RESIDENT (
R_ID INTEGER NOT NULL PRIMARY KEY,
Room_NumINTEGER,
Res_NameVARCHAR (20),
Building_IDINTEGER NOT NULL,
FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));
Answer: D
Q18. FROM Registration WHERE
Consider the following relational algebraic expression: Which of the following SQL Course_Code =
'A4343' statements is equivalent to this relational algebraic expression?
A. SELECTSales_Rep_No(108) FROM Orders;
B. INSERT INTO Orders VALUES(Sales_Rep_No = 108) WHERE Sales_Rep_No = NULL;
C. SELECT'FROM Orders WHERE Sales_Rep_No = 108;
D. SELECT'FROM Orders WHERE Sales_Rep_No = ?08?
Answer: C
Q19. 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
Q20. Consider the table for an employee database shown in the exhibit. What is the cardinality of the table?
A. 6
B. 20
C. 4
D. 25
Answer: C
Q21. Which type of entity must reference another entity for its data to be meaningful?
A. Weak
B. Strong
C. Foreign
D. Primary
Answer: A
Q22. Consider the Orders relation shown in the exhibit. Which of the following SQL statements would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No 108 is listed?
A. UPDATESales_Rep_No IN Orders SET(Sales_Rep_No = 110 WHERE Sales_Rep_No = 108);
B. UPDATE Orders SET Sales_Rep_No = 110 WHERE Sales_Rep_No = 108;
C. UPDATE Orders
SET Sales_Rep_No = 110;
D. UPDATE Orders
WHERE Sales_Rep_No = 108
SET Sales_Rep_No = 110;
Answer: B
Q23. 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
Q24. Which of the following best describes the information contained in the data dictionary (or system catalog)?
A. Metadata
B. Data model
C. Table data
D. Metafile
Answer: A