Online Access Free 1D0-541 Practice Test

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

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

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 VIEWEmp_Dept AS SELECT * FROM Employee WHERE ID = 0001 AND ID = 0002 AND ID = 0003 AND ID = 0004;
• B.CREATE VIEWEmp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee;
• C.UPDATE VIEWEmp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee;
• D.UPDATE VIEWEmp_Dept AS SELECT * FROM Employee;

Which term describes one or more database operations that are executed as a single unit?

• A.Operational group
• B.Encapsulation
• C.Update
• D.Transaction

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.C
• B.B
• C.D
• D.A

Which of the following occurs in a relation when records are added or removed?

• A.The attributes in the domain change.
• B.The cardinality of the relation is fixed but the degree varies.
• C.The number of domains changes.
• D.The degree of the relation is fixed but the cardinality varies.