Exclusive Black Friday Deal: 70% Off All Exam Bundles! Use coupon code below to unlock your savings! - Ends in 0d 00h 00m 00s - Coupon code: Friday70

Free CIW v5 Database Design Specialist Practice Questions

Question # 11

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?

Options:

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

Discussion 0
Question # 12

Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT. What is the relationship between BUILDING and RESIDENT?

Question # 12

Options:

A.  

1:1

B.  

1:N

C.  

N:1

D.  

M:N

Discussion 0
Question # 13

Which of the following best describes a composite key?

Options:

A.  

A composite key is a primary key that consists of the first two attributes of a relation.

B.  

A composite key is a primary or foreign key defined by its parent keys.

C.  

A composite key is a foreign key that consists of the same attributes as the primary key from a related table.

D.  

A composite key is a primary or foreign key that consists of two or more attributes of a relation.

Discussion 0
Question # 14

Consider the following database information:

domain s_id: integer domain grd: fixed length

character string length 1

STUDENT_GRADE(

Student_Number: s_id NOT NULL

Grade: grd ) Primary Key

Student_Number

During which phase of the database design process would this information be developed?

Options:

A.  

Logical

B.  

Physical

C.  

Conceptual

D.  

Implementation

Discussion 0
Question # 15

With regard to databases, what is normalization?

Options:

A.  

The process of reducing the cardinality of a relation

B.  

The process of organizing and refining relations

C.  

The process of duplicating data to reduce the number of tables

D.  

The process of limiting data stored in a table to a specific range of values

Discussion 0
Question # 16

Which subset of Structured Query Language (SQL) is used to perform operations such as data retrieval or deletion on the data contained in a database?

Options:

A.  

Data Control Language

B.  

Data Definition Language

C.  

Data Formatting Language

D.  

Data Manipulation Language

Discussion 0
Question # 17

The exhibit shows a table called Housing Relation that relates a unique student identification number with a dormitory building and a room fee for that building. Each building charges only one fee and a student can live in only one building. The key for the Housing Relation is Student_I

D.  

This table is in which normal form?

Question # 17

Options:

A.  

1NF

B.  

1NFand2NF

C.  

1NF,2NFand3NF

D.  

1NF,2NF,3NFandBCNF

Discussion 0
Question # 18

Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return the Registration2 relation from the Registration relation?

Question # 18

Options:

A.  

SELECT Course_Code

FROM Registration;

B.  

SELECT*FROM

Registration WHERE

Registration_ID = 1003 AND

Registration_ID = 1005;

C.  

SELECT*FROM Registration

WHERE Course_Code =‘A4343';

D.  

SELECT Registration_ID, Student_ID, First_Name, Last_Name

Discussion 0

1D0-541 PDF

1D0-541 PDF (Printable)
$46.5
$154.99

1D0-541 Testing Engine

1D0-541 PDF (Printable)
$51
$169.99

1D0-541 PDF + Testing Engine

1D0-541 PDF (Printable)
$63.9
$212.99

Free Exams Sample Questions