[2024-06-24更新,250問] 無料Oracle 1z0-071試験問題集、1z0-071予想試験(ページ 34)

1z0-071 試験問題 161

Examine the create table statements for the stores and sales tables.
SQL> CREATE TABLE stores(store_id NUMBER(4) CONSTRAINT store_id_pk PRIMARY KEY, store_name VARCHAR2(12), store_address VARCHAR2(20), start_date DATE);
SQL> CREATE TABLE sales(sales_id NUMBER(4) CONSTRAINT sales_id_pk PRIMARY KEY, item_id NUMBER(4), quantity NUMBER(10), sales_date DATE, store_id NUMBER(4), CONSTRAINT store_id_fk FOREIGN KEY(store_id) REFERENCES stores(store_id));
You executed the following statement:
SQL> DELETE from stores
WHERE store_id=900;
The statement fails due to the integrity constraint error:
ORA-02292: integrity constraint (HR.STORE_ID_FK) violated
Which three options ensure that the statement will execute successfully? (Choose three.)

A. Disable the FOREIGN KEY in SALES table and then delete the rows.

B. Disable the primary key in the STORES table.

C. DELETE the rows with STORE_ID = 900 from the SALES table and then delete rows from STORES table.

D. Create the foreign key in the SALES table on SALES_ID column with on DELETE CASCADE option.

E. Use CASCADE keyword with DELETE statement.

1z0-071 試験問題 162

Which two statements are true about sequences created in a single instance Oracle database? (Choose two.)

A. When the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER SEQUENCE statement.

B. DELETE <sequencename> would remove a sequence from the database.

C. The numbers generated by an explicitly defined sequence can only be used to insert data in one table.

D. CURRVAL is used to refer to the most recent sequence number that has been generated for a particular sequence.

E. When a database instance shuts down abnormally, sequence numbers that have been cached but not used are available again when the instance is restarted.

1z0-071 試験問題 163

コマンドを調べてください:

ON DELETE CASCADE とは何を意味しますか?

A. BOOKStable が削除されると、BOOK_TRANSACTIONStable 内のすべての行が削除されますが、テーブル構造は保持されます。

B. BOOKS.BOOK_ID 列の値が削除されると、BOOKS_TRANSACTIONS.BOOK_ID 列の対応する値が更新されます。

C. BOOKStable 内の行が削除されると、BOOK_ID が BOOKStable 内の削除された行と一致する BOOK_TRANSACTIONStable 内の行も削除されます。

D. BOOKStable が削除されると、BOOK_TRANSACTIONStable も削除されます。

1z0-071 試験問題 164

Examine the structure of the EMPLOYEEStable.

There is a parent/child relationship between EMPLOYEE_IDand MANAGER_ID.
You want to display the last names and manager IDs of employees who work for the same manager as the employee whose EMPLOYEE_IDis 123.
Which query provides the correct output?

A. SELECT e.last_name, m.manager_id
FROM employees e RIGHT OUTER JOIN employees m
on (e.manager_id = m.employee_id)
AND e.employee_id = 123;

B. SELECT e.last_name, e.manager_id
FROM employees e RIGHT OUTER JOIN employees m
on (e.employee_id = m.employee_id)
WHERE e.employee_id = 123;

C. SELECT e.last_name, m.manager_id
FROM employees e LEFT OUTER JOIN employees m
on (e.employee_id = m.manager_id)
WHERE e.employee_id = 123;

D. SELECT m.last_name, e.manager_id
FROM employees e LEFT OUTER JOIN employees m
on (e.manager_id = m.manager_id)
WHERE e.employee_id = 123;

1z0-071 試験問題 165

Which three are true about system and object privileges

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

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

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

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

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

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

他のバージョン: 342Oracle.1z0-071.v2026-02-09.q105; 1044Oracle.1z0-071.v2025-04-23.q282; 1339Oracle.1z0-071.v2024-01-24.q245; 1635Oracle.1z0-071.v2023-11-10.q292; 1514Oracle.1z0-071.v2023-06-29.q199; 3214Oracle.1z0-071.v2022-08-26.q318

最新アップロード: 164CrowdStrike.CCCS-203b.v2026-06-16.q114; 130WGU.Operations-Management.v2026-06-16.q23; 183EC-COUNCIL.312-49v11.v2026-06-16.q204; 198Microsoft.PL-300.v2026-06-16.q439; 143Fortinet.FCSS_LED_AR-7.6.v2026-06-16.q43; 174CheckPoint.156-215.82.v2026-06-15.q106; 125Salesforce.AP-215.v2026-06-15.q22; 139Nutanix.NCP-MCI-6.10.v2026-06-15.q88; 169CompTIA.CV0-004.v2026-06-15.q237; 186Microsoft.MS-102.v2026-06-15.q316

1z0-071 試験問題 161

1z0-071 試験問題 162

1z0-071 試験問題 163

1z0-071 試験問題 164

1z0-071 試験問題 165

PDFファイルをダウンロード