Online Access Free Oracle.1z1-071.v2021-12-09.q323 Practice Test (Page 61)

1z1-071 Exam Question 296

Which three are true about system and object privileges

A.WITH GRANT OPTION cannot be used when granting an object privilege to PUBLIC

B.WITH GRANT OPTION can be used when granting an object privilege to both users and roles

C.Adding a primary key constraint to an existing table in another schema requires a system privilege

D.Revoking an object privilege that was granted with the WITH GRANT OPTION clause has a cascading effect

E.Revoking a system privilege that was granted with the WITH ADMIN OPTION has a cascading effect.

F.Adding a foreign key constraint pointing to a table in another schema requires the REFERENCEs object privilege

1z1-071 Exam Question 297

View the exhibit for the structure of the STUDENTand FACULTYtables.

You need to display the faculty name followed by the number of students handled by the faculty at the base location.
Examine the following two SQL statements:
Statement 1
SQL>SELECT faculty_name, COUNT(student_id)
FROM student JOIN faculty
USING (faculty_id, location_id)
GROUP BY faculty_name;
Statement 2
SQL>SELECT faculty_name, COUNT(student_id)
FROM student NATURAL JOIN faculty
GROUP BY faculty_name;
Which statement is true regarding the outcome?

A.Both statements 1 and 2 execute successfully and give the same required result.

B.Only statement 2 executes successfully and gives the required result.

C.Only statement 1 executes successfully and gives the required result.

D.Both statements 1 and 2 execute successfully and give different results.

1z1-071 Exam Question 298

View the Exhibit and examine the structure of the EMPLOYEES table.
You want to display all employees and their managers having 100 as the MANAGER_ID. You want the output in two columns: the first column would have the LAST_NAME of the managers and the second column would have LAST_NAME of the employees.

Which SQL statement would you execute?

A.SELECT m.last_name "Manager", e.last_name "Employee"
FROM employees m JOIN employees e
ON e.employee_id = m.manager_id
WHERE m.manager_id=100;

B.SELECT m.last_name "Manager", e.last_name "Employee"
FROM employees m JOIN employees e
ON m.employee_id = e.manager_id
WHERE e.managerjd=100;

C.SELECT m.last_name "Manager", e.last_name "Employee"
FROM employees m JOIN employees e
ON m.employee_id = e.manager_id
WHERE m.manager_id=100;

D.SELECT m.last_name "Manager", e.last_name "Employee"
FROM employees m JOIN employees e
WHERE m.employee_id = e.manager_id AND e.managerjd=100;

1z1-071 Exam Question 299

View the exhibit and examine the structure of the CUSTOMERS table.

Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)

A.listing of customers who do not have a credit limit and were born before 1980

B.finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers

C.listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'.

D.finding the number of customers, in each city, whose marital status is 'married'.

E.finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'

1z1-071 Exam Question 300

Which three are true about dropping columns from a table?

A.A column drop is implicitly committed

B.A primary key column cannot be dropped.

C.A column that is referenced by another column in any other table cannot be dropped.

D.Multiple columns can be dropped simultaneously using the ALTER TABLE command.

E.A column can be removed only if it contains no data.

F.A column must be set as unused before it is dropped from a table.

Other Version: 113Oracle.Latestcram.1z1-071.v2022-05-31.by.martina.239q.pdf; 10254Oracle.1z1-071.v2022-04-29.q239; 115Oracle.Lead2passed.1z1-071.v2021-09-02.by.nelly.334q.pdf

Latest Upload: 101SAP.C_ABAPD_2507.v2025-09-12.q56; 101SAP.C_TS452_2022.v2025-09-12.q83; 171ACSM.020-222.v2025-09-11.q48; 157VMware.5V0-31.23.v2025-09-10.q73; 131Oracle.1z0-915-1.v2025-09-10.q24; 160Citrix.1Y0-231.v2025-09-10.q87; 135SAP.C-THR85-2505.v2025-09-09.q29; 166Adobe.AD0-E727.v2025-09-09.q76; 130Oracle.1Z0-1123-25.v2025-09-09.q20; 136SAP.C_SIGPM_2403.v2025-09-08.q20

1z1-071 Exam Question 296

1z1-071 Exam Question 297

1z1-071 Exam Question 298

1z1-071 Exam Question 299

1z1-071 Exam Question 300

Download PDF File