CIW 1D0-541 Exam Questions Free Practice Test

Viewing page 4 out of 4 pages

Viewing questions 31-40 out of questions

Questions # 31:

Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

Question # 31

Options:

m:m

m:n

1:1

1:n

Expert Solution

Questions # 32:

What is the highest normal form of the relation(s) shown in the exhibit?

Question # 32

Options:

No normal form

Second normal form

First normal form

Third normal form

Expert Solution

Questions # 33:

Which pair of relational algebraic operations requires union compatibility?

Options:

Union and join

Selection and projection

Intersection and difference

Cartesian product and intersection

Expert Solution

Questions # 34:

The database manager wants to give Rubio and Doe the ability to modify the Project Relation shown in the exhibit. A temporary employee named Temp needs to access the data in the database to generate reports. Which group of SQL statements will perform this task?

Options:

GRANT UPDATE ON Project TO Rubio, Doe;

GRANT SELECT ON Project TO Temp;

GRANT ALL PRIVILEGES ON Project TO Rubio, Doe;

GRANT UPDATE ON Project TO Temp;

GRANT SELECT ON Project

WHERE Manager = 'Rubio';

GRANT SELECT ON Project

WHERE Manager = 'Doe';

GRANT UPDATE ON Project

WHERE Manager = 'Rubio';

GRANT UPDATE ON Project

WHERE Manager = 'Doe';

GRANT SELECT ON Project TO Temp;

Expert Solution

Questions # 35:

Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

Question # 35

Options:

A recursive relationship

A many-to-many relationship

A one-to-one relationship

A one-to-many relationship

Expert Solution

Questions # 36:

Your company must choose which type of database to use for a new project. Which of the following lists three characteristics of file-based database systems?

Options:

Repetition of data, application program flexibility, and data centralization

Incompatibility of files, tabular data structures, and data dependence

Separation of data, repetition of data, and data independence

Application program inflexibility, data dependence, and separation of data

Expert Solution

Questions # 37:

Which type of dependency occurs when one attribute of a composite key is removed and the dependency still exists?

Options:

1:1

Transitive

Functional

Partial functional

Expert Solution

Viewing page 4 out of 4 pages

Viewing questions 31-40 out of questions

Pass the CIW CIW Web Development Series 1D0-541 Questions and answers with CertsForce