Black Friday Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Discussions
  1. Home
  2. CIW
  3. CIW Web Development Series
  4. 1D0-541
  5. CIW v5 Database Design Specialist Questions and Answers

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

Exam 1D0-541 All Questions
Exam 1D0-541 Premium Access

View all detail and faqs for the 1D0-541 exam

Go to Exam
Viewing page 1 out of 4 pages
Viewing questions 1-10 out of questions
Questions # 1:

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

Expert Solution
Questions # 2:

Which of the following occurs in a relation when records are added or removed?

Options:

A.

The number of domains changes.

B.

The attributes in the domain change.

C.

The cardinality of the relation is fixed but the degree varies.

D.

The degree of the relation is fixed but the cardinality varies.

Expert Solution
Questions # 3:

A theta-join can be viewed as:

Options:

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

Expert Solution
Questions # 4:

Consider the following relational algebraic expression as well as the Dept1_Parta and Dept2_Parts relations shown in the exhibit: Which of the following relations would result form the given relational algebraic expression?

Question # 4

Question # 4

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Expert Solution
Questions # 5:

Your database administrator has disallowed a group of users from making alterations to the Employees table in your corporate database. The users, known as Group_2, previously had full privileges with the Employees table. Which of the following SQL statements properly removes any alteration privileges from Group_2?

Options:

A.

REVOKE INSERT,

UPDATE, DELETE ON

Employees FROM Group_2;

B.

REVOKE

UPDATE FOR

Employees

FROM Group_2;

C.

REVOKE INSERT,

UPDATE, DELETE ON

Employees FOR Group_2;

D.

REVOKE

UPDATE, DELETE

FOR Employees

FROM Group_2;

Expert Solution
Questions # 6:

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:

A.

Repetition of data, application program flexibility, and data centralization

B.

Incompatibility of files, tabular data structures, and data dependence

C.

Separation of data, repetition of data, and data independence

D.

Application program inflexibility, data dependence, and separation of data

Expert Solution
Questions # 7:

Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

Options:

A.

SELECT * FROM

Registration WHERE

Course_Code = #

B.

SELECT * FROM

Registration WHERE

Course_Code LIKE _

C.

SELECT* FROM

Registration WHERE

Course_Code LIKE %

D.

SELECT * FROM

Registration WHERE

Course Code = %

Expert Solution
Questions # 8:

You enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS?

Options:

A.

Management of data redundancy, increased data integrity, increased data dependence, and increased application program flexibility.

B.

Consistency of data, adherence to standards, managed concurrency, and increased software complexity.

C.

Increased data access, increased data backup and recovery, data sharing, and consistency of data.

D.

Increased datasecurity, increased data integrity, increased data independence, and decreased data separation.

Expert Solution
Questions # 9:

Your enterprise is involved in planning a database project. The exhibit shows the result of one phase of the database design life cycle. Which term best describes the diagram shown in the exhibit?

Question # 9

Options:

A.

Information Engineering (IE) data model

B.

Corporate data model

C.

Database requirements model

D.

ERD model

Expert Solution
Questions # 10:

What is a virtual table?

Options:

A.

A virtual table is a relation created as the result of data manipulation; it exists only in computer memory, and is not a permanent part of the database.

B.

A virtual table is a relation stored in the database; it is used when multiple users access the same relation in a database.

C.

A virtual table is a relation derived from the database data dictionary; it contains metadata about a base relation.A virtual table is a relation derived from the database? data dictionary; it contains metadata about a base relation.

D.

A virtual table is a relation that consists of primary and foreign keys for a particular set of relations in a database.

Expert Solution
Viewing page 1 out of 4 pages
Viewing questions 1-10 out of questions