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. 5)

  • 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 #21
Consider the table for an employee database shown in the exhibit. What is the degree of the table?

  1. A
    25
  2. B
    5
  3. C
    4
  4. D
    20

Correct Answer:
B

Question #22
What improvement can be made to file-based databases to overcome their limitations?
  1. A
    Implement a tabular structure.
  2. B
    Gather files in a distributed repository.
  3. C
    Use a hierarchical database file system.
  4. D
    Tightly couple database structure to database application programs.

Correct Answer:
A

Question #23
NULL) Primary Key Class_Num -
Consider the Information Engineering diagram shown in the exhibit. Which DBDL definition best describes this diagram?

  1. A
    BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key Building_ID RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key R_ID
  2. B
    BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key RESIDENT
  3. C
    BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING Foreign Key BUILDING(Building_ID) references RESIDENT (Building_ID) RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key RESIDENT
  4. D
    BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key Building_ID RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key R_ID Foreign Key Building_ID references BUILDING(Building_ID)

Correct Answer:
D

Question #24
Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT. What is the relationship between BUILDING and
RESIDENT?

  1. A
    1:1
  2. B
    1:N
  3. C
    N:1
  4. D
    M:N

Correct Answer:
B

Question #25
You enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS?
  1. A
    Management of data redundancy, increased data integrity, increased data dependence, and increased application program flexibility.
  2. B
    Consistency of data, adherence to standards, managed concurrency, and increased software complexity.
  3. C
    Increased data access, increased data backup and recovery, data sharing, and consistency of data.
  4. D
    Increased data security, increased data integrity, increased data independence, and decreased data separation.

Correct Answer:
C

Previous Questions Next Questions

All Pages