Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home CIW 1D0-541

CIW 1D0-541 Exam Practice Questions (P. 2)

  • Full Access (124 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #6
Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create a set difference of the two relations with the widest variety of Structured Query Language dialects?

  1. A
    SELECT * FROM Dept1_Parts EXCEPT(SELECT PartJD FROM Dept2_Parts);
  2. B
    SELECT * FROM Dept1_Parts MINUS (SELECT Part_ID FROM Dept2_Parts);
  3. C
    SELECT * FROM Dept1_Parts DIFFERENCE (SELECT Part_ID FROM Dept2_Parts);
  4. D
    SELECT * FROM Dept1_Parts WHERE Part_ID NOT IN (SELECT Part_ID FROM Dept2_Parts);

Correct Answer:
D

Question #7
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?

  1. A
    CREATE TABLE RESIDENT ( R_ID INTEGER NULL PRIMARY KEY, Room_Num FLOAT, Res_Name VARCHAR, Building_ID INTEGER NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));
  2. B
    CREATE TABLE RESIDENT ( R_ID INTEGER NOT NULL PRIMARY KEY, Room_Num BINARY, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));
  3. C
    CREATE TABLE RESIDENT ( R_ID INTEGER NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL);
  4. D
    CREATE TABLE RESIDENT ( R_ID INTEGER NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

Correct Answer:
D

Question #8
Which term describes one or more database operations that are executed as a single unit?
  1. A
    Update
  2. B
    Transaction
  3. C
    Encapsulation
  4. D
    Operational group

Correct Answer:
B

Question #9
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?

  1. A
    Information Engineering (IE) data model
  2. B
    Corporate data model
  3. C
    Database requirements model
  4. D
    ERD model

Correct Answer:
B

Question #10
Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

  1. A
    SELECT * FROM Customers WHERE Satisfaction_Rate <= 80 OR Satisfaction_Rate >= 90;
  2. B
    SELECT * FROM Customers WHERE Satisfaction_Rate IN (80 AND 90);
  3. C
    SELECT *FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89;
  4. D
    SELECT * FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);

Correct Answer:
C

Previous Questions Next Questions

All Pages