All About Downloadable 1D0-541 Free Demo

NEW QUESTION 1
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. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 2
Which subset of Structured Query Language (SQL) is used to create and name database entities?

• A. Data Control Language
• B. Database Entity Language
• C. Data Definition Language
• D. Data Manipulation Language

Answer: C

NEW QUESTION 3
Which type of entity must reference another entity for its data to be meaningful?

• A. Weak
• B. Strong
• C. Foreign
• D. Primary

Answer: A

NEW QUESTION 4
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 5
Which process is used to prevent the current database operation from reading or writing a data item while that data item is being accessed by another operation?

• A. Lock
• B. Deadlock
• C. Timestamp
• D. Batch

Answer: A

NEW QUESTION 6
What is a relational database domain?

• A. A group of attributes
• B. A set of permissible tuple values
• C. A collection of related data items
• D. A set of permissible attribute values

Answer: D

NEW QUESTION 7
Which statement accurately describes a characteristic of attributes?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 8
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 9
Which of the following best describes the information contained in the data dictionary (or system catalog)?

• A. Metadata
• B. Data model
• C. Table data
• D. Metafile

Answer: A

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

Answer: D

NEW QUESTION 11
Which component in the three-tier database architecture handles the data-processing and business logic?

• A. Thin client
• B. Fat client
• C. Database server
• D. Application server

Answer: D

NEW QUESTION 12
For the Employee relation shown in the exhibit, which set of column values holds the complete tuple for the employee named James Smith?

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

Answer: B

NEW QUESTION 13
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 sWHERE Sales_Office = Atlanta);
• B. INSERT INTO Atlanta_Customers SELECT *FROM CustomersWHERE Sales_Office = Atlanta;
• C. INSERT INTO Atlanta_CustomersSELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No FROM CustomersWHERE Sales_Office = Atlanta;
• D. INSERT INTO Atlanta_CustomersSELECT Cust_No, Cust_Name, Sales_Office, Sales_Rep_No FROM CustomersWHERE Sales_Office = Atlanta;

Answer: C

Explanation:

NEW QUESTION 14
Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit:

Which of the following relational algebraic expressions would result in the given table?

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

Answer: A

NEW QUESTION 15
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 16
Consider the symbols shown in the exhibit. Which of the following correctly identifies these symbols when used in an entity-relationship (ER) diagram?

• A. 1 = attribute, 2 = entity, 3 = relationship
• B. 1 = entity, 2 = relationship, 3 = attribute
• C. 1 = relationship, 2 = entity, 3 = attribute
• D. 1 = relationship, 2 = attribute, 3 = entity

Answer: C

NEW QUESTION 17
......