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

1z0-071 試験問題 231

EMPLOYEES テーブルの説明を調べます。

正常に実行される 2 つのステートメントはどれですか?

A. SELECT 'first_name は '' || 名 || 「従業員から」

B. SELECT '名前は \'' || 名 || 従業員からの「\」。

C. SELECT 'first_name は ''' ||first_name||''' FROM 従業員 ;

D. SELECT 'first_name は '|| 名|| 」従業員から。

E. SELECT 'first_name は '''||first_name ||'''' FROM 従業員 ;

1z0-071 試験問題 232

Which two are true about external tables that use the ORACLE _DATAPUMP access driver?

A. When creating an external table, data can be selected only from a table whose rows are stored in database blocks.

B. Creating an external table creates a directory object.

C. Creating an external table creates a dump file that can be used by an external table in the same or a different database.

D. Creating an external table creates a dump file that can be used only by an external table in the same database.

E. When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.

1z0-071 試験問題 233

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 eON m.employee_id = e.manager_idWHERE m.manager_id = 100;

B. SELECT m.last_name "Manager", e.last_name "Employee"FROM employees m JOIN employees eWHERE m.employee_id = e.manager_id and AND e.manager_id = 100

C. SELECT m.last_name "Manager", e.last_name "Employee"FROM employees m JOIN employees eON m.employee_id = e.manager_idWHERE e.manager_id = 100;

D. SELECT m.last_name "Manager", e.last_name "Employee"FROM employees m JOIN employees eON e.employee_id = m.manager_idWHERE m.manager_id = 100;

1z0-071 試験問題 234

View the Exhibit and examine the structure of ORDERSand ORDER_ITEMStables.
ORDER_IDis the primary key in the ORDERStable. It is also the foreign key in the ORDER_ITEMStable wherein it is created with the ON DELETE CASCADEoption.
Which DELETEstatement would execute successfully?