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

1z1-071 Exam Question 66

Which two statements are true regarding the GROUP BYclause in a SQL statement? (Choose two.)

A.The GROUP BYclause is mandatory if you are using an aggregate function in the SELECTclause.

B.Using the WHEREclause before the GROUP BYclause excludes the rows before creating groups.

C.Using the WHEREclause after the GROUP BYclause excludes the rows after creating groups.

D.You can use column alias in the GROUP BYclause.

E.If the SELECTclause has an aggregate function, then those individual columns without an aggregate function in the SELECTclause should be included in the GROUP BYcause.

1z1-071 Exam Question 67

You must create a table for a banking application. (Choose the best answer.) One of the columns in the table has these requirements:
1: A column to store the duration of a short team loan
2: The data should be stored in a format supporting DATE arithmetic with DATE datatypes without using conversion functions.
3: The maximum loan period is 30 days.
4: Interest must be calculated based on the number of days for which the loan remains unpaid.
Which data type would you use?

A.Date

B.Interval day to second

C.Timestamp

D.Interval year to month

E.Number

1z1-071 Exam Question 68

Examine the structure of the MARKStable:

Which two statements would execute successfully? (Choose two.)
SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1)

A.FROM marks
WHERE subject1 > subject2;
SELECT student_name subject1

B.FROM marks
WHERE student_name LIKE 'R%';

C.FROM marks
WHERE student_name IS NULL;
SELECT student_name,SUM(subject1)

D.FROM marks
WHERE subject1 > AVG(subject1);
SELECT SUM(subject1+subject2+subject3)

1z1-071 Exam Question 69

Which two statements are true about Data Manipulation Language (DML) statements?

A.An INSERT INTO...VALUES.. statement can add multiple rows per execution to a table.

B.An UPDATE... SET... statement can modify multiple rows based on multiple conditions on a table.

C.A DELETE FROM..... statement can remove rows based on only a single condition on a table.

D.An INSERT INTO... VALUES..... statement can add a single row based on multiple conditions on a table.

E.A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.

F.An UPDATE....SET.... statement can modify multiple rows based on only a single condition on a table.

1z1-071 Exam Question 70

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.If the salary is more than 20000 and the employee is less than 125,insert EMPLOYEE_ID and SALARY into the SPECIAL_SAL table.

C.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.

D.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.

E.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.

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

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

Latest Upload: 102SAP.C_ABAPD_2507.v2025-09-12.q56; 102SAP.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; 138SAP.C-THR85-2505.v2025-09-09.q29; 167Adobe.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 66

1z1-071 Exam Question 67

1z1-071 Exam Question 68

1z1-071 Exam Question 69

1z1-071 Exam Question 70

Download PDF File