Proper study guides for Avant-garde CIW CIW v5 Database Design Specialist certified begins with CIW 1D0-541 preparation products which designed to deliver the Pinpoint 1D0-541 questions by making you pass the 1D0-541 test at your first time. Try the free 1D0-541 demo right now.
Q49. Which component in the three-tier database architecture handles the data-processing and
business logic?
A. Thin client
B. Fat client
C. Database server
D. Application server
Answer: D
Q50. Which term best defines a database system in which data records are stored in one or more files with no structured relationship?
A. Flat-file database
B. Relational database
C. Distributed database
D. Object-oriented database
Answer: A
Q51. A foreign key maps to a:
A. prime key.
B. indirect key.
C. parent key.
D. composite key.
Answer: C
Q52. Which database security technique prevents invalid data from being entered into the database?
A. File locking
B. User authorization
C. Parity checks
D. Integrity controls
Answer: D
Q53. In which situation would the DBMS use a serial schedule to execute the transactions?
A. Concurrent transactions read data from the same data structure.
B. Concurrent transactions write data to different data structures.
C. Concurrent transactions read or write the same data structure.
D. Concurrent transactions read or write from different data structures.
Answer: C
Q54. The exhibit shows a table called Recreation Relation that relates a unique student identification number and a sports activity with a fee for participating in that activity. The Student_ID and Activity columns in the table are used together as a composite key. Which statement about the relation is correct?
A. Activity_Fee is a determinant of Activity.
B. Activity_Fee is partially dependent on the key.
C. The table contains a transitive dependency.
D. Activity_Fee is a determinant of Activity and Student_ID.
Answer: B
Q55. Consider the table shown in the exhibit. Which relational algebraic operation would return Row 3?
A. Union
B. Selection
C. Projection
D. Difference
Answer: B
Q56. Consider the Information Engineering diagram shown in the exhibit for a building management company. Referential integrity must be maintained such that a building cannot be deleted when it has residents. 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 relations shown in this diagram?
Building_ID INTEGER NOT NULL PRIMARY KEY,
Bldg_Name VARCHAR (20),
Location VARCHAR (20),
Room_Count INTEGER );
CREATE TABLE RESIDENT (
R_ID NOT NULL PRIMARY KEY,
Room_Num INTEGER,
Res_Name VARCHAR (20),
Building_ID INTEGER NOT NULL,
FOREIGN KEY Building_ID REFERENCES RESIDENT (Building_ID)
ON DELETE NO CHECK);
B. CREATE TABLE BUILDING (
Building_ID INTEGER NOT NULL PRIMARY KEY,
Bldg_Name VARCHAR (20),
Location VARCHAR (20),
Room_Count INTEGER );
CREATE TABLE RESIDENT (
R_ID NOT NULL PRIMARY KEY,
Room_Num INTEGER,
Res_Name VARCHAR (20),
Building_ID INTEGER NOT NULL,
FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID)
ON DELETE NO CHECK
ON UPDATE CASCADE);
C. CREATE TABLE BUILDING (
Building_ID INTEGER NOT NULL PRIMARY KEY,
Bldg_Name VARCHAR (20),
Location VARCHAR (20),
Room_Count INTEGER );
CREATE TABLE RESIDENT (
R_ID NOT NULL PRIMARY KEY,
Room_Num INTEGER,
Res_Name VARCHAR (20),
Building_ID INTEGER NOT NULL,
FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID)
ON DELETE NO CHECK
ON UPDATE CASCADE);
D. CREATE TABLE BUILDING (
Building_ID INTEGER NOT NULL PRIMARY KEY,
Bldg_Name VARCHAR (20),
Location VARCHAR (20),
Room_Count INTEGER );
CREATE TABLE RESIDENT (
R_ID NOT NULL PRIMARY KEY,
Room_Num INTEGER,
Res_Name VARCHAR (20),
Building_ID INTEGER NOT NULL,
FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID)
ON DELETE NO CHECK
ON UPDATE CASCADE);
Answer: C