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

 
Home > CIW > CIW Web Development Series > 1D0-541

1D0-541 CIW v5 Database Design Specialist Question and Answers

Question # 4

Consider the Project relation shown in the exhibit as well as the following SQL statement: Which of the following tables shows the Project relation after execution of this SQL statement?

A.

OptionA

B.

OptionB

C.

OptionC

D.

OptionD

Full Access
Question # 5

The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student with the ID 1311?

A.

Only an update anomaly would occur.

B.

An insertion anomaly would occur.

C.

A deletion anomaly would occur.

D.

An update anomaly and a deletion anomaly would occur.

Full Access
Question # 6

What is the most important service provided by a database management system?

A.

Provides support for a data manipulation language

B.

Allows users to store data in a distributed data repository

C.

Provides support for data formatting language commands

D.

Translates procedural commands into non-procedural commands

Full Access
Question # 7

Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit: Which of the following relational algebraic expressions would result in the given table?

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 8

Which statement accurately describes a characteristic of attributes?

A.

The ordering of attributes in a table is significant.

B.

An attribute contains values from multiple domains.

C.

An attribute name can be used only once per table.

D.

An attribute name can be used only once in a relational database system with multiple tables.

Full Access
Question # 9

What improvement can be made to file-based databases to overcome their limitations?

A.

Implement a tabular structure.

B.

Gather files in a distributed repository.

C.

Use a hierarchical database file system.

D.

Tightly couple database structure to database application programs.

Full Access
Question # 10

The exhibit shows a relation for a company projects. Which candidate key(s) would best serve as the primary key for this relation?

A.

S_Date and E_Date

B.

ProjJD

C.

ltem_Num and E_Date

D.

Proj_ID and Item_Num

Full Access
Question # 11

Which component in the three-tier database architecture handles the data-processing and business logic?

A.

Thin client

B.

Fat client

C.

Database server

D.

Application server

Full Access
Question # 12

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create a set difference of the two relations with the widest variety of Structured Query Language dialects?

A.

SELECT *FROM

Dept1_Parts

EXCEPT(SELECT

PartJD FROM

Dept2_Parts);

B.

SELECT * FROM

Dept1_Parts MINUS

(SELECT Part_ID

FROM Dept2_Parts);

C.

SELECT*FROM

Dept1_Parts

DIFFERENCE

(SELECT Part_ID

FROM Dept2_Parts);

D.

SELECT*FROM

Dept1_Parts WHERE

Part_ID NOT IN

(SELECT Part_ID FROM

Dept2_Parts);

Full Access
Question # 13

Consider the following four database design activities:

1 - Design user views.

2 - Select a DBMS.

3 - Apply normalization.

4 - Determine entities.

Which choice shows the correct ordering of these activities, from first to last, by assigned numbers?

A.

1,2,3,4

B.

3,4,1,2

C.

4,3,1,2

D.

4,2,3,1

Full Access
Question # 14

In which situation would the DBMS use a serial schedule to execute the transactions?

A.

Concurrent transactions read data from the same data structure.

B.

Concurrent transactions write data to different data structures.

C.

Concurrent transactions read or write the same data structure.

D.

Concurrent transactions read or write from different data structures.

Full Access
Question # 15

Consider the entity-relation (ER) diagram shown in the exhibit. When the logical database design phase is completed, which of the following is a valid DBDL description of the base relations for the ER diagram?

A.

STUDENT(

Student_Number: integer NOT NULL

Name: variable length character string length 20 NOT NULL)

Primary Key Student_Number

CLASS(

Class_Num: integer NOT NULL

Class_Name: integer NOT NULL)

Primary Key Class_Num

B.

STUDENT(

Student_Number: integer NOT NULL

Name: variable length character string length 20 NOT NULL)

Primary Key Student_Number

CLASS(

Class_Num: integer NOT NULL

Class_Name: integer NOT NULL)

Primary Key Class_Num

Foreign Key Class_Num References STUDENT

C.

STUDENT(

Student_Number: integer NOT NULL

Name: variable length character string length 20 NOT NULL)

Primary Key Student_Number

STU_CLASS(

Student_Number: integer NOT NULL

Class_Num: integer NOT NULL)

Primary Key Student_Number

CLASS(

Class_Num: integer NOT NULL

Class_Name: integer NOT NULL)

Primary Key Class_Num

D.

STUDENT(

Student_Number: integer NOT NULL

Name: variable length character string length 20 NOT NULL)

Primary Key Student_Number

STU_CLASS(

Student_Number: integer NOT NULL

Class_Num: integer NOT NULL)

Primary Key Student_Number, Class_Num

CLASS(

Class_Num: integer NOT NULL

Class_Name: integer NOT NULL)

Primary Key Class_Num

Full Access
Question # 16

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

A.

A recursive relationship

B.

A many-to-many relationship

C.

A one-to-one relationship

D.

A one-to-many relationship

Full Access
Question # 17

Which relational algebraic operation is used to select specific columns (attributes) from a relation?

A.

Union

B.

Difference

C.

Projection

D.

Intersection

Full Access
Question # 18

Which security technique limits access by unauthorized users to parts of an enterprise database?

A.

Views

B.

Concurrency

C.

Locking

D.

Integrity controls

Full Access
Copyright myexamcollection.com. All Right Reserved.