← Back to exam page

Free 1D0-541 – CIW v5 Database Design Specialist Practice Test Question

Free demo downloads

Loading demo links...

Showing 7–9 of 10 questions

Question 7

In a relational database, which term describes a single table consisting of rows and columns?

Select an option, then click Submit answer.

  • ○

    Entity
  • ○

    Matrix
  • ○

    Relation
  • ○

    Data dictionary
Question 8

Consider the Recreation relation shown in the exhibit. You need to apply a SQL statement to the

Recreation relation that will return the following data:

Which SQL statement applied to the Recreation relation will return this data?

Select an option, then click Submit answer.

  • ○

    SELECT Activity FROM Recreation;
  • ○

    SELECT DISTINCT Activity FROM Recreation;
  • ○

    SELECT Activity FROM Recreation
    WHERE NOT LIKE Activity;
  • ○

    SELECT Activity FROM Recreation
    WHERE DISTINCT Activity;
Question 9

Which term describes the management of simultaneous transactions to prevent conflicts?

Select an option, then click Submit answer.

  • ○

    Parallelism
  • ○

    Serialization
  • ○

    Database control
  • ○

    Concurrency control