Free 1D0-541 Exam Dumps

Question 26

Your enterprise must decide whether to use a database management system. Which of the following best describes the overall functionality of a DBMS?

A. A DBMS provides the ability to control data access using Data Manipulation Language.
B. A DBMS provides the ability to maintain databases while providing increased security for the database.
C. A DBMS allows users to access the database while allowing only the database administrator to define user views.
D. A DBMS provides the ability to define, create and maintain databases while providing controlled access to databases.

Correct Answer:D

Question 27

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?
1D0-541 dumps exhibit

A. STUDENT(Student_Number: integer NOT NULLName: variable length character string length 20 NOT NULL) Primary Key Student_NumberCLASS(Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num
B. STUDENT(Student_Number: integer NOT NULLName: variable length character string length 20 NOT NULL) Primary Key Student_NumberCLASS(Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_NumForeign Key Class_Num References STUDENT
C. STUDENT(Student_Number: integer NOT NULLName: variable length character string length 20 NOT NULL) Primary Key Student_NumberSTU_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 NULLName: variable length character string length 20 NOT NULL) Primary Key Student_NumberSTU_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

Correct Answer:D

Question 28

For the Employee relation shown in the exhibit, which set of column values holds the complete tuple for the employee named James Smith?
1D0-541 dumps exhibit
A. 0002, James, Smith

A. 0002, James, Smith, 10-25-76
B. First_Name, James, Last_Name, Smith
C. Emp_ID, 0002, First_Name, James, Last_Name, Smith

Correct Answer:B

Question 29

Your enterprise has reached the conceptual design phase for a database project. What is the desired goal at the end of this design phase?

A. A set of normalized relations
B. A reviewed entity-relationship (ER) model
C. An entity-relationship (ER) model with no redundant data
D. A set of denormalized relations

Correct Answer:B

Question 30

A large enterprise uses a two-tier database architecture and runs complex database processing on the client. Which term best describes the client in this system?

A. Fat client
B. Thin client
C. Terminal client
D. Enterprise client

Correct Answer:A