Question 18 1. Click the Exhibit(s) button to examine the structures of the EMPL

Question

Question 18

1.       Click the Exhibit(s) button to examine the structures of the EMPLOYEE, PROJECT, and TASK tables.

You want to create a report of all employees, including employee name and project name, who are assigned to project tasks. You want to include all projects even if they currently have no tasks defined, and you want to include all tasks, even those not assigned to an employee.

Which joins should you use?

a self join on the EMPLOYEE table and a left outer join between the TASK and PROJECT tables

a natural join between the TASK and EMPLOYEE tables and a natural join between the TASK and PROJECT tables

a full outer join between the TASK and EMPLOYEE tables and a natural join between the TASK and PROJECT tables

a natural join between the TASK and EMPLOYEE tables and a left outer join between the TASK and PROJECT tables

a full outer join between the TASK and EMPLOYEE tables and a full outer join between the TASK and PROJECT tables

a left outer join between the TASK and EMPLOYEE tables and a right outer join between the TASK and PROJECT tables

Question 20

1.      

In dynamic SQL that performs DML operations, in which phase is the number of processed rows returned?

a.

bind

b.

fetch

c.

parse

d.

execute

Question 23

1.       To allow an authorized person to pass privileges on to others, the privileges must be given

A.

with RESTRICT

B.

to a role

C.

WITH GRANT OPTION

D.

with CASCADE

Question 25

1.       Deadlock can be spotted by looking for which of the following in the wait-for graph?

A.

a new node

B.

a cycle

C.

an edge

D.

a path of length 2

Question 29

1.       The level of the three-level database architecture that contains user views is the

A.

internal

B.

logical

C.

external

D.

physical

Question 32

1.       Which statement should you use to eliminate the need for all users to qualify Marilyn's INVENTORY table with her schema when querying the table?

CREATE SYNONYM inventory FOR inventory;

CREATE PUBLIC inventory SYNONYM FOR marilyn.inventory;

      

CREATE PUBLIC SYNONYM inventory FOR marilyn;

CREATE PUBLIC SYNONYM inventory FOR marilyn.inventory;

Question 39

1.       All of the following are set operations that can be performed on suitable relational tables EXCEPT

A.

SUM

B.

INTERSECTION

C.

DIFFERENCE

D.

UNION

a self join on the EMPLOYEE table and a left outer join between the TASK and PROJECT tables

a natural join between the TASK and EMPLOYEE tables and a natural join between the TASK and PROJECT tables

a full outer join between the TASK and EMPLOYEE tables and a natural join between the TASK and PROJECT tables

a natural join between the TASK and EMPLOYEE tables and a left outer join between the TASK and PROJECT tables

a full outer join between the TASK and EMPLOYEE tables and a full outer join between the TASK and PROJECT tables

a left outer join between the TASK and EMPLOYEE tables and a right outer join between the TASK and PROJECT tables

Explanation / Answer

Question 18 : Correct answer is LAST OPTION. You need to left outer join TASK with EMPLOYEE as you will also get task that are not assigned to any employee. And then you need to right outer join TASK with PROJECT as it will give those project which are not having task also.

Question 20 : The number of processed rows are returned in Fetch phase in which excueted query results are processed and returned.

Question 23 : You need to add clause WITH GRANT OPTION while granting privileges to allow it to transfer to some others

Question 25 : Graph cycle signifies the possibilty of deadlocks between processes for resources.

Question 29 : External level contains user views.

i m sorry i have no idea abt question 32. Apologize for that

Question 39 : Answer is A. Sum is not a set operations.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.