Want to Pass 1D0-541 Exam In Next HOURS? Get it now →
January 11, 2018

Top Improve 1D0-541 practice question Reviews!

We provide real 1D0-541 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass CIW 1D0-541 Exam quickly & easily. The 1D0-541 PDF type is available for reading and printing. You can print more and practice many times. With the help of our CIW 1D0-541 dumps pdf and vce product and material, you can easily pass the 1D0-541 exam.

Q31. Which relational algebraic operation is used to select specific columns (attributes) from a relation? 

A. Union 

B. Difference 

C. Projection 

D. Intersection 

Answer:


Q32. Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return all tuples that have course codes beginning with the letter M? 

A. SELECT * FROM Registration WHERE Course_Code = # 

B. SELECT * FROM Registration WHERE Course_Code LIKE _ 

C. SELECT * FROM Registration WHERE Course_Code LIKE % 

D. SELECT * FROM Registration WHERE Course Code = % 

Answer:


Q33. 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:


Q34. 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:


Q35. What is a virtual table? 

A. A virtual table is a relation created as the result of data manipulation; it exists only in computer memory, and is not a permanent part of the database. 

B. A virtual table is a relation stored in the database; it is used when multiple users access the same relation in a database. 

C. A virtual table is a relation derived from the database data dictionary; it contains metadata about a base relation. A virtual table is a relation derived from the database?data dictionary; it contains metadata about a base relation. 

D. A virtual table is a relation that consists of primary and foreign keys for a particular set of relations in a database. 

Answer:


Q36. 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:


Q37. 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 TO Rubio, Doe; 

GRANT SELECT ON Project TO Temp; 

B. GRANT ALL PRIVILEGES ON Project TO Rubio, Doe; 

GRANT UPDATE ON Project TO Temp; 

C. GRANT SELECT ON Project 

WHERE Manager = 'Rubio' 

GRANT SELECT ON Project 

WHERE Manager = 'Doe' 

D. GRANT UPDATE ON Project 

WHERE Manager = 'Rubio' 

GRANT UPDATE ON Project 

WHERE Manager = 'Doe' 

GRANT SELECT ON Project TO Temp; 

Answer:


Q38. The exhibit shows a table called Housing Relation that relates a unique student identification number with a dormitory building and a room fee for that building. Each building charges only one fee and a student can live in only one building. The key for the Housing Relation is Student_ID. 

This table is in which normal form? 

A. S_Date and E_Date 

B. ProjJD 

C. ltem_Num and E_Date 

D. Proj_ID and Item_Num 

Answer:


Q39. Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers. Which situation would occur if new supplier information were entered in the relation before any information about specific parts? 

A. An update anomaly and an insertion anomaly would occur. 

B. An insertion anomaly would occur. 

C. A deletion anomaly would occur. 

D. A deletion anomaly and an update anomaly would occur. 

Answer:


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

WHERE Sales_Office = New York; 

B. DELETE FROM Customers WHERESales_Office = ew York?WHERE Sales_Office = ?ew York? 

C. DELETE * FROM Customers WHERESales_Office = ew York?WHERE Sales_Office = ?ew York? 

D. DELETE FROM Customers WHERESales_Office NOT LIKE ew York? WHERE Sales_Office NOT LIKE ?ew York? 

Answer:



see more free 1D0-541 exam dumps