New Year Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

CIW 1D0-541 - CIW v5 Database Design Specialist

CIW 1D0-541 Premium Access     Download Demo    
Page: 2 / 4
Total 124 questions

Which of the following definitions best describes an entity?

A.

A relation

B.

Data about data

C.

Data stored in a table column

D.

An item about which information is stored

Which database security technique prevents invalid data from being entered into the database?

A.

File locking

B.

User authorization

C.

Parity checks

D.

Integrity controls

Consider the symbols shown in the exhibit. Which of the following correctly identifies these symbols when used in an entity-relationship (ER) diagram?

A.

1 = attribute, 2 = entity, 3 = relationship

B.

1 = entity, 2 = relationship, 3 = attribute

C.

1 = relationship, 2 = entity, 3 = attribute

D.

1 = relationship, 2 = attribute, 3 = entity

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

A.

SELECT * FROM Customers

WHERE Satisfaction_Rate <= 80

OR Satisfaction_Rate >= 90;

B.

SELECT * FROM Customers WHERE

Satisfaction_Rate IN (80 AND 90);

C.

SELECT *FROM Customers

WHERE Satisfaction_Rate >= 80

AND Satisfaction_Rate <= 89;

D.

SELECT * FROM

Customers WHERE

Satisfaction_Rate

BETWEEN (80, 90);

Your enterprise must decide whether to use a database management system. Which of the following best describes the functionality of a DBMS?

A.

A DBMS provides the ability to control data access and limit the number of users at one time.

B.

A DBMS provides the ability to maintain databases while providing increased security for the database.

C.

A DBMS allows users to access the database while allowing the database administrator to define views particular to individual sets of users.

D.

A DBMS provides the ability to define, create and maintain databases while providing controlled access to databases.

Which type of relational integrity is violated if a primary key in a database has a null value?

A.

Entity integrity

B.

Domain integrity

C.

Domain constraints

D.

Referential integrity

Consider the following relation definition:

STUDENT(

Student_Number: integer NOT NULL

Name: variable length character string length 20 NOT NULL)

Primary Key Student_Number

HOUSING(

Housing_ID: integer NOT NULL

Student_Number: integer NOT NULL

Building: variable length character string length 25 NOT NULL)

Primary Key Housing_ID

Foreign Key Student_Number References

STUDENT(Student_Number)

ON DELETE NO CHECK

ON UPDATE

Which integrity constraint is violated in this relation definition?

A.

Entity integrity

B.

Domain constraint

C.

Referential integrity

D.

Enterprise constraint

A theta-join can be viewed as:

A.

The intersection oftwo relations

B.

ACartesian product of two relations

C.

Arestricted Cartesian product of two relations

D.

The Cartesian product oftwo union-compatible relations

Which of the following definitions applies to all types of databases?

A.

Data that is stored as tables

B.

Software that manipulates data

C.

Data that is stored in a structured manner

D.

Data records that are stored sequentially in a file

Which mechanism provides database users with controlled access to the database through the use of virtual tables?

A.

View

B.

Data dictionary

C.

Database control language

D.

Database management system