CIW 1D0-541 Online Practice Questions and Exam Preparation

CIW 1D0-541 Online Questions & Answers

• Question 81:

  Consider the following SQL statement and the Orders relation shown in the exhibit: How many records should be returned?

  

  A. Two records
  B. Three records
  C. Four records
  D. Five records
  C. Four records

• Question 82:

  Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

  

  A. INSERT INTO Employee VALUES(0005, Tim, Bogart, 03-15-77);
  B. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0004, Tim, Bogart, 03-15-77);
  C. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);
  D. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);
  D. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

• Question 83:

  Which statement accurately describes a characteristic of attributes?

  A. The ordering of attributes in a table is significant.
  B. An attribute contains values from multiple domains.
  C. An attribute name can be used only once per table.
  D. An attribute name can be used only once in a relational database system with multiple tables.
  C. An attribute name can be used only once per table.

• Question 84:

  Consider the Employee relation shown in the exhibit. A database manager wants to set up a view called Emp_Dept that allows users to find employees and their department ID numbers. Which SQL statement will accomplish this?

  

  A. CREATE VIEW Emp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee;
  B. UPDATE VIEW Emp_Dept AS SELECT * FROM Employee;
  C. UPDATE VIEW Emp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee;
  D. CREATE VIEW Emp_Dept AS SELECT * FROM Employee WHERE ID = 0001 AND ID = 0002 AND ID = 0003 AND ID = 0004;
  A. CREATE VIEW Emp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee;

• Question 85:

  Your enterprise is involved in planning a database project. The exhibit shows the result of one phase of the database design life cycle. Which term best describes the diagram shown in the exhibit?

  

  A. Information Engineering (IE) data model
  B. Corporate data model
  C. Database requirements model
  D. Entity Relation Data (ERD) model
  B. Corporate data model

• Question 86:

  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?

  

  A. 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 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);
  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);

• Question 87:

  Consider the following database information: domain s_id: integer domain grd: fixed length character string length 1 STUDENT_GRADE( Student_Number: s_id NOT NULL Grade: grd ) Primary Key Student_Number

  During which phase of the database design process would this information be developed?

  A. Logical
  B. Physical
  C. Conceptual
  D. Implementation
  A. Logical

• Question 88:

  Your company must choose which type of database to use for a new project. Which of the following lists three characteristics of file-based database systems?

  A. Repetition of data, application program flexibility, and data centralization
  B. Incompatibility of files, tabular data structures, and data dependence
  C. Separation of data, repetition of data, and data independence
  D. Application program inflexibility, data dependence, and separation of data
  D. Application program inflexibility, data dependence, and separation of data

• Question 89:

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

  A. Data Definition Language
  B. Data Control Language
  C. Data Entity Language
  D. Data Manipulation Language
  B. Data Control Language

• Question 90:

  Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create an intersection of the two relations with the widest variety of Structured Query Language dialects?

  

  A. SELECT * FROM Dept1_Parts AND (SELECT * FROM Dept2_Parts);
  B. SELECT * FROM Dept1_Parts INTERSECTION (SELECT * FROM Dept2_Parts);
  C. SELECT * FROM Dept1_Parts WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;
  D. SELECT * FROM Dept1_Parts WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;
  D. SELECT * FROM Dept1_Parts WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;