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

1z1-071 Exam Question 276

Which statement is true regarding external tables?

A.The CREATE TABLE AS SELECT statement can be used to upload data into a normal table in the database from an external table.

B.The data and metadata for an external table are stored outside the database.

C.The default REJECT LIMIT for external tables is UNLIMITED.

D.ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table.

1z1-071 Exam Question 277

View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. (Choose two.)

Evaluate this SQL statement:
ALTER TABLE emp
DROP COLUMN first_name;
Which two statements are true?

A.The FIRST_NAME column would be dropped provided at least one column remains in the table.

B.The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY provided the CASCADE option is added to the SQL statement.

C.The FIRST_NAME column would be dropped provided it does not contain any data.

D.The drop of the FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the SQL statement.

1z1-071 Exam Question 278

View the exhibit and examine the description of the PRODUCT_INFORMATION table.

Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

A.SELECT COUNT (DISTINCT list_price)FROM product_informationWHERE list_price is NULL

B.SELECT COUNT (list_price)FROM product_informationWHERE list_price i= NULL

C.SELECT COUNT (NVL(list_price, 0))FROM product_informationWHERE list_price is NULL

D.SELECT COUNT (list_price)FROM product_informationWHERE list_price is NULL

1z1-071 Exam Question 279

Examine the structure of the MEMBERStable.

Which query can be used to display the last names and city names only for members from the states MO and MI?

A.SELECT last_name, city FROM members WHERE state IN ('MO', 'MI');

B.SELECT DISTINCT last_name, city FROM members WHERE state ='MO' OR state
='MI';

C.SELECT last_name, city FROM members WHERE state LIKE 'M%';

D.SELECT last_name, city FROM members WHERE state ='MO' AND state ='MI';

1z1-071 Exam Question 280

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
WHERE m.employee_id = e.manager_id AND e.managerjd=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 e.employee_id = m.manager_id
WHERE m.manager_id=100;

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

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 276

1z1-071 Exam Question 277

1z1-071 Exam Question 278

1z1-071 Exam Question 279

1z1-071 Exam Question 280

Download PDF File