The Updated Guide To 1D0-541 Practice Test

NEW QUESTION 1
In a relational database, which term describes a single table consisting of rows and
columns?

• A. Entity
• B. Matrix
• C. Relation
• D. Data dictionary

Answer: C

NEW QUESTION 2
The exhibit shows a table called Housing Relation. This table relates a unique student identification number with a dormitory building and a room fee for that building. The key for the Housing Relation is Student_ID. If each building charges only one fee and a student can live in only one building, then this table is in which normal form?

• A. 1NF
• B. 1NF and 2NF
• C. 1NF, 2NF, and 3NF
• D. 1NF, 2NF, 3NF, and BCNF

Answer: B

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

• A. m:m
• B. m:n
• C. 1:1
• D. 1:n

Answer: B

NEW QUESTION 4
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

Answer: B

NEW QUESTION 5
The exhibit shows a table called Activity Relation that relates a unique student identification number with a sports activity and a fee for participating in that activity. A student can participate in only one activity. The key for the relation is Student_ID. What consequence would occur if the tuple for Student_ID 1001 were removed?

• A. An update anomaly would occur.
• B. An insertion anomaly would occur.
• C. A deletion anomaly would occur.
• D. Both an insertion anomaly and a deletion anomaly would occur.

Answer: C

NEW QUESTION 6
Which pair of relational algebraic operations requires union compatibility?

• A. Projection and Cartesian product
• B. Selection and projection
• C. Intersection and difference
• D. Cartesian product and intersection

Answer: C

NEW QUESTION 7
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

Answer: A

NEW QUESTION 8
What is a domain?

• A. A normalized set of data applicable to a particular relation
• B. A combination of attributes for a relation
• C. A definition of permissible values for one or more attributes
• D. A set of permissible values for one or more relations

Answer: C

NEW QUESTION 9
Which characteristic is an advantage of a database management system?

• A. Data files are owned and maintained by the users.
• B. Database administration is simplified.
• C. A standard method can be used to access the database.
• D. Data is decentralized.

Answer: C

NEW QUESTION 10
Consider the Project relation shown in the exhibit as well as the following SQL statement:

DELETE FROM Project WHERE Cust_Name = Acme;
Which of the following tables shows the Project relation after execution of this SQL statement?

• A.
• B.
• C.
• D.

Answer: A

NEW QUESTION 11
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.

Answer: B

NEW QUESTION 12
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

Answer: D

NEW QUESTION 13
Using the Customer and Sales_Rep relations shown in the exhibit, you must datermine a relational algebraic expression that will result in the following relation:

Which of the following relational algebraic expressions would result in this relation?

• A. Customer X Sales_Rep
• B. (Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No (Sales_Rep X Customer))
• C. (Customer X Sales_Rep) ? Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No
• D. Customer.Sales_Rep_No = Sales.sales_Rep_No (Customer X Sales_Rep)

Answer: A

NEW QUESTION 14
Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create an intersection of the two relations with the widest variety of Structured Query Language dialects?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 15
Consider the relation shown in the exhibit. Which of the following SQL statements would
properly remove all tuples for New York customers?

• A. DELETE *FROM CustomersWHERE Sales_Office = New York;
• B. DELETEFROM CustomersWHERE Sales_Office = New York;
• C. DELETE *FROM CustomerWHERE Sales_Office <> New York;
• D. DELETEFROM CustomersWHERE Sales_Office NOT LIKE New York;

Answer: B

NEW QUESTION 16
Which three pieces of information did E.F. Codd describe as necessary to retrieve a data value from a relational database?

• A. Attribute, domain, and tuple
• B. Entity, relation name, and domain
• C. Table name, primary key, and entity
• D. Attribute, relation name, and primary key

Answer: D

NEW QUESTION 17
Consider the following relational algebraic expression as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit:


Which of the following relations would result from the given relational algebraic expression?

• A.
• B.
• C.
• D.

Answer: C

NEW QUESTION 18
Which area of database security involves maintaining access to enterprise data?

• A. Integrity
• B. Privacy
• C. Availability
• D. Confidentiality

Answer: C

NEW QUESTION 19
Which of the following best describes a composite key?

• A. A composite key is a primary key and foreign 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 key attributes.
• 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.

Answer: D

NEW QUESTION 20
......