A Review Of Pinpoint 1D0-541 Prep

NEW QUESTION 1
Consider the Employee relation shown in the exhibit. A database manager wants to set up a view called Emp_Dept that allows users to find employees and their department ID numbers. Which SQL statement will accomplish this?

• A. CREATE VIEW Emp_DeptAS SELECT Last_Name, First_Name, Dept_ID FROM Employee;
• B. UPDATE VIEW Emp_Dept AS SELECT *FROM Employee;
• C. UPDATE VIEW Emp_DeptAS SELECT Last_Name, First_Name, Dept_ID FROM Employee;
• D. CREATE VIEW Emp_Dept AS SELECT *FROM Employee WHERE ID = 0001 AND ID = 0002 AND ID = 0003 AND ID = 0004;

Answer: A

NEW QUESTION 2
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 3
Which relational algebraic operation is used to select specific columns (attributes) from a relation?

• A. Union
• B. Difference
• C. Projection
• D. Intersection

Answer: C

NEW QUESTION 4
Consider the Information Engineering diagram in the exhibit showing a conceptual data model of the relations BUILDING and RESIDENT. What is the next step in refining the data model?

• A. Create intermediate entities.
• B. Create a logical data model.
• C. Resolve many-to-many relationahips.
• D. Identify and resolve complex relationships.

Answer: B

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

Answer: A

NEW QUESTION 7
Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?

• A. Degree of a relation
• B. Cardinality of a relation
• C. Primary key of a relation
• D. Determinant of a relation

Answer: B

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

• A. Information Engineering (IE) data model
• B. Corporate data model
• C. Database requirements model
• D. Entity Relation Data (ERD) model

Answer: B

NEW QUESTION 9
Consider the following relation definitions:
STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 ) Primary Key Student_Number
HOUSING(
Housing_ID: integer NOT NULL Student_Number: integer NOT NULL
Building: variable length character string length 25 ) Primary Key Housing_ID
Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO ACTION
ON UPDATE CASCADE
What are the referential constraints for the relations defined in these relation definitions?

• A. There is no relationship between changes in STUDENT(Student_Number) and HOUSING(Student_Number).
• B. When STUDENT(Student_Number) is changed or deleted, this modification or deletion will automatically be reflected inHOUSING(Student_Number).
• C. Modifications to HOUSING(Student_Number) are automatically reflected in changes to STUDENT(Student_Number), but deletions are notpermitted.
• D. Modifications to STUDENT(Student_Number) are automatically reflected in changes to HOUSING(Student_Number). For a deletion to occurfrom STUDENT(Student_Number), it must first occur in HOUSING(Student_Number).

Answer: D

NEW QUESTION 10
Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

• A. SELECT *FROM CustomersWHERE Satisfaction_Rate <= 80 OR Satisfaction_Rate >= 90;
• B. SELECT *FROM CustomersWHERE Satisfaction_Rate IN (80 AND 90);
• C. SELECT *FROM CustomersWHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89;
• D. SELECT *FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);

Answer: C

NEW QUESTION 11
Which database security technique prevents invalid data from being entered into the database?

• A. File locking
• B. User authorization
• C. Parity checks
• D. Integrity controls

Answer: D

NEW QUESTION 12
Which term describes an attribute or combination of attributes that uniquely identifies a row in a relation?

• A. Entity
• B. Domain
• C. Primary key
• D. Attribute group

Answer: C

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

Answer: B

NEW QUESTION 14
Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

• A. SELECT *FROM CustomersWHERE Satisfaction_Rate <= 80 OR Satisfaction_Rate >= 90;
• B. SELECT *FROM CustomersWHERE Satisfaction_Rate IN (80 AND 90);
• C. SELECT *FROM CustomersWHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89;
• D. SELECT *FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);

Answer: C

NEW QUESTION 15
Consider the following relational algebraic expression:

Which of the following SQL statements is equivalent to this relational algebraic expression?

• A. SELECT Sales_Rep_No(108) FROM Orders;
• B. INSERT INTO OrdersVALUES(Sales_Rep_No = 108) WHERE Sales_Rep_No = NULL;
• C. SELECT *FROM OrdersWHERE Sales_Rep_No = 108;
• D. SELECT *FROM OrdersWHERE Sales_Rep_No = 108;

Answer: C

NEW QUESTION 16
What is the most important service provided by a database management system?

• A. Provides support for a data manipulation language
• B. Allows users to store data in a distributed data repository
• C. Provides support for data formatting language commands
• D. Translates procedural commands into non-procedural commands

Answer: A

NEW QUESTION 17
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 18
......