Free 1D0-541 Exam Dumps PDF Preview

Question 1

Single choice

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

A
Views
B
Concurrency
C
Locking
D
Integrity controls

Reveal answer details Close answer details

Correct answerA

Question 2

Single choice

Consider the table for an employee database shown in the exhibit.

What is the cardinality of the table?

A
5
B
20
C
4
D
25

Reveal answer details Close answer details

Correct answerC

Question 3

Single choice

A theta-join can be viewed as:

A
the intersection of two relations.
B
a Cartesian product of two relations.
C
a restricted Cartesian product of two relations.
D
the Cartesian product of two union-compatible relations.

Reveal answer details Close answer details

Correct answerC

Question 4

Single choice

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(
Class_Num: integer NOT NULL
Class_Name: integer NOT NULL)
Primary Key Class_Num

Reveal answer details Close answer details

Correct answerD

Question 5

Single choice

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

A
Union
B
Difference
C
Projection
D
Intersection

Reveal answer details Close answer details

Correct answerC

Question 6

Single choice

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?

A
Logical
B
Physical
C
Conceptual
D
Implementation

Reveal answer details Close answer details

Correct answerA

Question 7

Single choice

The exhibit shows a table called Recreation Relation that relates a unique student identification number and a sports activity with a fee for participating in that activity. The Student_ID and Activity columns in the table are used together as a composite key.

Which statement about the relation is correct?

A
Activity_Fee is a determinant of Activity.
B
Activity_Fee is partially dependent on the primary key.
C
The table contains a transitive dependency.
D
Activity_Fee is a determinant of Activity and Student_ID.

Reveal answer details Close answer details

Correct answerB

Question 8

Single choice

Consider the Orders relation shown in the exhibit.

Which of the following SQL statements would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No 108 is listed?

A
UPDATE Sales_Rep_No
IN Orders
SET(Sales_Rep_No = 110
WHERE Sales_Rep_No = 108);
B
UPDATE Orders
SET Sales_Rep_No = 110
WHERE Sales_Rep_No = 108;
C
UPDATE Orders
SET Sales_Rep_No = 110;
D
UPDATE Orders
WHERE Sales_Rep_No = 108
SET Sales_Rep_No = 110;

Reveal answer details Close answer details

Correct answerB

Question 9

Single choice

Which of the following is a characteristic of the three-tier database architecture?

A
A Web browser is used as the application server.
B
The application logic is centralized on a dedicated server.
C
A thick client is used to perform business application logic functions locally.
D
Database application logic and database functionality are integrated and reside on a common server.

Reveal answer details Close answer details

Correct answerB

Question 10

Single choice

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

Reveal answer details Close answer details

Correct answerA

Question 11

Single choice

Consider the following SQL statement and the Orders relation shown in the exhibit:

What is the output of this SQL statement?

A
B
C
D

Reveal answer details Close answer details

Correct answerC

Question 12

Single choice

Which of the following ACID properties requires that a transaction be executed in its entirety or not all?

A
Durability
B
Consistency
C
Isolation
D
Atomicity

Reveal answer details Close answer details

Correct answerD

Question 13

Single choice

Consider the relations shown in the exhibit. Due to restructuring, the sales department has been eliminated and the employees working in that department have been dismissed. All ID information is stored as integers.

Which SQL statement would be used to return a relation with all information for the employees who have been dismissed?

A
SELECT *
FROM Employee;
B
SELECT ID, Last_Name
FROM Employee;
WHERE ID = 0004;
C
SELECT *
FROM Employee
WHERE Dept_ID = 022;
D
SELECT *
FROM Employee
WHERE Dept_ID = 022;

Reveal answer details Close answer details

Correct answerC

Question 14

Single choice

A relation for a construction company is shown in the exhibit.

Which of the following best defines the relationship between Cust_ID and Cust_Name?

A
Cust_Name is the determinant.
B
Cust_Name is transitively dependent on Cust_ID.
C
Cust_ID is transitively dependent on Cust_Name.
D
Cust_Name is functionally dependent on Cust_ID.

Reveal answer details Close answer details

Correct answerD

Question 15

Single choice

Consider the relation shown in the exhibit.

Which of the following SQL statements would properly add information for a new employee?

A
INSERT INTO Employee
VALUES(0005, Tim, Bogart, 03-15-77);
B
INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0004, Tim, Bogart, 03-15-77);
C
INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);
D
INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

Reveal answer details Close answer details

Correct answerD

Question 16

Single choice

Which term describes the rejoining of relations that have been decomposed?

A
Normalization
B
Denormalization
C
Referential integrity
D
Domain constraints

Reveal answer details Close answer details

Correct answerB

Question 17

Single choice

The exhibit shows a relation for a companys projects.

Which candidate key(s) would best serve as the primary key for this relation?

A
S_Date and E_Date
B
Proj_ID
C
Item_Num and E_Date
D
Proj_ID and Item_Num

Reveal answer details Close answer details

Correct answerD

Question 18

Single choice

Consider the Recreation relation shown in the exhibit. You need to apply a SQL statement to the

Recreation relation that will return the following data:

Which SQL statement applied to the Recreation relation will return this data?

A
SELECT Activity FROM Recreation;
B
SELECT DISTINCT Activity FROM Recreation;
C
SELECT Activity FROM Recreation
WHERE NOT LIKE Activity;
D
SELECT Activity FROM Recreation
WHERE DISTINCT Activity;

Reveal answer details Close answer details

Correct answerB

Question 19

Single choice

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?

A
GRANT UPDATE ON Project TO Rubio, Doe;
GRANT SELECT ON Project TO Temp;
B
GRANT ALL PRIVILEGES ON Project TO Rubio, Doe;
GRANT UPDATE ON Project TO Temp;
C
GRANT SELECT ON Project
WHERE Manager = 'Rubio';
GRANT SELECT ON Project
WHERE Manager = 'Doe';
D
GRANT UPDATE ON Project
WHERE Manager = 'Rubio';
GRANT UPDATE ON Project
WHERE Manager = 'Doe';
GRANT SELECT ON Project TO Temp;

Reveal answer details Close answer details

Correct answerA

Question 20

Single choice

Consider the relations shown in the exhibit.

Which of the following SQL statements would enter data from the Customers relation into the Atlanta_Customers relation?

A
INSERT INTO Atlanta_Customers
VALUES(
SELECT *
FROM Customer s
WHERE Sales_Office = Atlanta);
B
INSERT INTO Atlanta_Customers
SELECT *
FROM Customers
WHERE Sales_Office = Atlanta;
C
INSERT INTO Atlanta_Customers
SELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No
FROM Customers
WHERE Sales_Office = Atlanta;
D
INSERT INTO Atlanta_Customers
SELECT Cust_No, Cust_Name, Sales_Office, Sales_Rep_No
FROM Customers
WHERE Sales_Office = Atlanta;

Reveal answer details Close answer details

Correct answerC

Free 1D0-541 Exam Dumps Preview

CIW v5 Database Design Specialist

PREVIEW CONTENTS · 1 VOLUME

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13

QUESTION 14

QUESTION 15

QUESTION 16

QUESTION 17

QUESTION 18

QUESTION 19

QUESTION 20