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

1z1-071 Exam Question 76

Examine the structure of the EMPLOYEES table. (Choose two.)

You must display the maximum and minimum salaries of employees hired 1 year ago.
Which two statements would provide the correct output?

A.SELECT minsal, maxsalFROM (SELECT MIN(salary) minsal, MAX(salary) maxsal FROM employeesWHERE hire_date < SYSDATE-365)GROUP BY maxsal, minsal;

B.SELECT MIN(Salary), MAX(salary)FROM (SELECT salary FROM employeesWHERE hire_date < SYSDATE-365);

C.SELECT minsal, maxsalFROM (SELECT MIN(salary) minsal, MAX(salary) maxsal FROM employeesWHERE hire_date < SYSDATE-365GROUP BY MIN(salary), MAX(salary);

D.SELECT MIN(Salary) minsal, MAX(salary) maxsalFROM employeesWHERE hire_date
< SYSDATE-365GROUP BY MIN(salary), MAX(salary);

1z1-071 Exam Question 77

View the Exhibit and examine the structure in the EMPLOYEES tables.

Evaluate the following SQL statement:
SELECT employee_id, department_id
FROM employees
WHERE department_id= 50 ORDER BY department_id
UNION
SELECT employee_id, department_id
FROM employees
WHERE department_id= 90
UNION
SELECT employee_id, department_id
FROM employees
WHERE department_id= 10;
What would be the outcome of the above SQL statement?

A.The statement would not execute because the positional notation instead of the column name should be used with the ORDER BY clause.

B.The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement.

C.The statement would execute successfully and display all the rows in the ascending order of DEPARTMENT_ID.

D.The statement would execute successfully but it will ignore the ORDER BY clause and display the rows in random order.

1z1-071 Exam Question 78

Which three statements are true? (Choose three.)

A.The data dictionary is created and maintained by the database administrator.

B.The data dictionary views consists of joins of dictionary base tables and user-defined tables.

C.The usernames of all the users including the database administrators are stored in the data dictionary.

D.The USER_CONS_COLUMNSview should be queried to find the names of the columns to which constraints apply.

E.Both USER_OBJECTSand CATviews provide the same information about all the objects that are owned by the user.

F.Views with the same name but different prefixes, such as DBA, ALLand USER, reference the same base tables from the data dictionary.

1z1-071 Exam Question 79

Examine the description of the CUSTOMERS table:
Which three statements will do an implicit conversion?

A.SELECT * FROM customers WHERE TO_DATE(insert_date)=DATE'2019-01-01';

B.SELECT * FROM customers WHERE insert_date'01-JAN-19';

C.SELECT * FROM customers WHERE customer_id=0001;

D.SELECT * FROM customers WHERE customer_id='0001';

E.SELECT * FROM customers WHERE insert_date=DATE'2019-01-01';

F.SELECT * FROM customers WHERE TO_CHAR(customer_id)='0001';

1z1-071 Exam Question 80

Which three are true about the MERGEstatement?

A.It can combine rows from multiple tables conditionally to insert into a single table.

B.It can merge rows only from tables.

C.It can use subqueries to produce source rows.

D.It can update, insert, or delete rows conditionally in multiple tables.

E.It can update the same row of the target table multiple times.

F.It can use views to produce source rows.

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 76

1z1-071 Exam Question 77

1z1-071 Exam Question 78

1z1-071 Exam Question 79

1z1-071 Exam Question 80

Download PDF File