Free Access Oracle.1z0-071.v2022-02-20.q161 Practice Test (Page 24)

Question 111

Which task can be performed by using a single Data Manipulation Language (DML) statement?

A.adding a column with a default value while inserting a row into a table

B.adding a column constraint while inserting a row into a table

C.removing all data only from a single column on which a primary key constraint is defined

D.removing all data from a single column on which a unique constraint is defined

Question 112

Examine this statement which executes successfully:
Which three are true?

A.Regardless of salary,only if the employee id is less than 125,insert EMPLOYEE_ID,NANAGER_ID,SALARY into the MGR_HISTORY table.

B.Only if the salary is 20000 or less and the employee id is 125 or higher,insert EMPLOYEE_ID,MANAGER_ID,and SALARY into the MDR_HISTORY table.

C.If the salary is more than 20000 and the employee is less than 125,insert EMPLOYEE_ID and SALARY into the SPECIAL_SAL table.

D.If the salary is 20000 or less and the employee id is less than 125,insert EMPLOYEE_ID,HIRE_DATE,and SALARY into the SAL_HISTORY table.

E.Only if the salary is 20000 or less and the employee id is less than 125,insert EMPLOYEE_ID,MANAGER_ID,and SALARY into the MGR_HISTORY table.

F.Regardless of salary and employee id,insert EMPLOYEE_ID,MANAGER_ID,and SALARY into the MGR_HISTORY table.

Question 113

Examine the structure of the EMPLOYEES table. (Choose the best answer.) You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salaries greater than 10000.

A.SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALL SELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id
100)INETRSECTSELECT last_name, hire_date, salaryFROM employees WHERE
hire_date > SYSDATE- 180;

B.SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id
(SELECT employee_id FROM employees WHERE employee_id = '100')UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -
180INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE salary >
10000;

C.(SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALLSELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100))UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -180;

D.SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id
(SELECT employee_id FROM employees WHERE employee_id = 100)UNION
ALL(SELECT last_name, hire_date, salaryFROM employeesWHERE hire_date >
SYSDATE -180INTERSECTSELECT last_name, hire_date, salaryFROM
employeesWHERE salary > 10000);

Question 114

Examine the business rule:
Each student can work on multiple projects and each project can have multiple students.
You need to design an Entity Relationship Model (ERD) for optimal data storage and allow for generating reports in this format:
STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK
Which two statements are true in this scenario?

A.The ERD must have a 1:M relationship between the STUDENTSand PROJECTSentities.

B.The ERD must have a M:M relationship between the STUDENTSand PROJECTSentities that must be resolved into 1:M relationships.

C.STUDENT_IDmust be the primary key in the STUDENTSentity and foreign key in the PROJECTSentity.

D.PROJECT_IDmust be the primary key in the PROJECTSentity and foreign key in the STUDENTSentity.

E.An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities.

Question 115

Which two queries will result in an error?

A.SELECT FIRST_NAME LAST_NAME FROM EMPLOYEES;

B.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE ANNUAL_SALARY > 100000
ORDER BY ANNUAL_SALARY;

C.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE 12 * SALARY > 100000
ORDER BY 12 * SALARY;

D.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE ANNUAL_SALARY > 100000
ORDER BY 12 * SALARY ;

E.SELECT FIRST_NAME,LAST_NAME FROM EMPLOYEES;

F.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE 12 * SALARY > 100000
ORDER BY ANNUAL_SALARY;

Other Version: 3125Oracle.1z0-071.v2025-03-22.q314; 6663Oracle.1z0-071.v2024-10-24.q196; 3019Oracle.1z0-071.v2023-10-02.q276; 2622Oracle.1z0-071.v2023-05-08.q154; 6667Oracle.1z0-071.v2022-09-21.q298; 5492Oracle.1z0-071.v2022-08-30.q239; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 208PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 309Nokia.4A0-113.v2026-05-01.q69; 279EC-COUNCIL.312-49v11.v2026-04-30.q214; 231Microsoft.MB-820.v2026-04-30.q101; 214Salesforce.MC-202.v2026-04-30.q57; 212BICSI.INSTC_V8.v2026-04-29.q53; 341NMLS.MLO.v2026-04-28.q82; 246NCARB.Project-Management.v2026-04-28.q27; 466EMC.D-AV-DY-23.v2026-04-27.q184; 1129ServiceNow.CSA.v2026-04-27.q483

Question 111

Question 112

Question 113

Question 114

Question 115

Download PDF File