Up to the minute CIW 1D0-541 - An Overview 61 to 70

Exam Code: 1D0-541 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: CIW v5 Database Design Specialist
Certification Provider: CIW
Free Today! Guaranteed Training- Pass 1D0-541 Exam.

Q61. Which of the following occurs in a relation when records are added or removed? 

A. The number of domains changes. 

B. The attributes in the domain change. 

C. The cardinality of the relation is fixed but the degree varies. 

D. The degree of the relation is fixed but the cardinality varies. 

Answer:


Q62. Which of the following best describes the ON DELETE NO ACTION referential integrity constraint? 

A. If a parent key is deleted, any child keys referenced by the parent key are automatically deleted. 

B. If a parent key is deleted, no test is made for referential integrity. 

C. If any child key references a parent key, the record containing the parent key cannot be deleted. 

D. If a parent key is deleted, all child keys are automatically set to a specified value. 

Answer:


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


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


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


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


Q67. Which subset of Structured Query Language (SQL) is used to limit access to a database or its data? 

A. Data Markup Language 

B. Data Control Language 

C. Data Formatting Language 

D. Data Manipulation Language 

Answer:


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


Q69. Which type of dependency occurs when one attribute of a composite key is removed and the dependency still exists? 

A. 1:1 

B. Transitive 

C. Functional 

D. Partial functional 

Answer:


Q70. Consider the following relational algebraic expression as well as the Employee and Department relations shown in the exhibit: Which of the following relations would result from the given relational algebraic expression? 

A. D 

B. C 

C. B 

D. A 

Answer: