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

  • 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 #1
With regard to databases, what is normalization?
  1. A
    The process of reducing the cardinality of a relation
  2. B
    The process of organizing and refining relations
  3. C
    The process of duplicating data to reduce the number of tables
  4. D
    The process of limiting data stored in a table to a specific range of values

Correct Answer:
B

Question #2
Which three pieces of information did E.F. Codd describe as necessary to retrieve a data value from a relational database?
  1. A
    Attribute, domain, and tuple
  2. B
    Entity, relation name, and domain
  3. C
    Table name, primary key, and entity
  4. D
    Attribute, relation name, and primary key

Correct Answer:
D

Question #3
What is a virtual table?
  1. 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.
  2. B
    A virtual table is a relation stored in the database; it is used when multiple users access the same relation in a database.
  3. 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.
  4. D
    A virtual table is a relation that consists of primary and foreign keys for a particular set of relations in a database.

Correct Answer:
A

Question #4
Your enterprise has reached the conceptual design phase for a database project. What is the desired goal at the end of this design phase?
  1. A
    A set of normalized relations
  2. B
    A reviewed entity-relationship (ER) model
  3. C
    An entity-relationship (ER) model with no redundant data
  4. D
    A set of denormalized relations

Correct Answer:
B

Question #5
In which phase of database design do you identify entities, attribute domains, and relationships?
  1. A
    Logical
  2. B
    Physical
  3. C
    Application
  4. D
    Conceptual

Correct Answer:
D

Next Questions

All Pages