[Q92-Q109] 最適な1z1-071試験準備問題集でOracle 1z1-071問題集PDFを試そう！[2024]

最適な1z1-071試験準備問題集でOracle 1z1-071問題集PDFを試そう！[2024]

Oracle 1z1-071試験受験生を確実にパスさせる1z1-071学習問題集

質問 # 92
* MANAGER is an existing role with no privileges or roles.
* EMP is an existing role containing the CREATE TABLEprivilege.
* EMPLOYEES is an existing table in the HR schema.
Which two commands execute successfully?

• A. GRANT CREATE SEQUENCE TO manager, emp;
• B. GRANT CREATE TABLE, emp TP manager;
• C. GRANT CREATE TABLE, SELECT ON hr.employees TO manager;
• D. GRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;
• E. GRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION;

正解：A、E

質問 # 93
You execute these commands:
SQL> DEFINE hiredate = '01-APR -2011';
SQL> SELECT employee_id, first_name, salary FROM employees WHERE hire date > &hiredate AND manager_id >&mgr_id; For which substitution variables will you be prompted?

• A. only &hiredate
• B. only &mgr_id
• C. &hiredate and &mgr_id
• D. none

正解：B

質問 # 94
You create a table by using this command:
CREATE TABLE rate_list (rate NUMBER(6,2));
Which two are true about executing statements?

• A. INSERT INTO rate_list VALUES (0.999) produces an error.
• B. INSERT INTO rate_list VALUES (-.9) inserts the value as -.9.
• C. INSERT INTO rate_list VALUES (87654. 556) inserts the value as 87654.6.
• D. INSERT INTO rate_list VALUES (-99.99) inserts the value as 99.99.
• E. INSERT INTO rate_list VALUES (-10) produces an error.
• F. INSERT INTO rate_list VALUES (0.551) inserts the value as .55.

正解：B、F

質問 # 95
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?

• A. DELETE order_id
  FROM orders
  WHERE order_total < 1000;
• B. DELETE
  FROM orders
  WHERE (SELECT order_id
  FROM order_items);
• C. DELETE orders
  WHERE order_total < 1000;
• D. DELETE orders o, order_items I
  WHERE o.order_id = i.order_id;

正解：B

質問 # 96
View the Exhibit and examine the structures of the employees and departments tables.

You must update the employees table according to these requirements::
-Update only those employees who work in Boston or Seattle (locations 2900 and 2700).
-Set department_id for these employees to the department id corresponding to London (locationid 2100).
-Set the employees' salary in iocation_id 2100 to 1.1 times the average salary of their department.
-Set the employees' commission In location_id 2100 to 1.5 times the average commission of their department.
You issue this command:

What is the result?

• A. It generates an error because a subquery cannot have a join condition in an update statement.
• B. It generates an error because multiple columns cannot be specified together in an UPDATE statement.
• C. It executes successfully but does not produce the desired update.
• D. It executes successfully and produces the desired update.

正解：C

質問 # 97
Which three statements are true regarding the usage of the WITH clause in complex correlated subqueries: (Choose three.)

• A. The query name in the WITH clause is visible to other query blocks in the WITH clause as well as to the main query block
• B. It can be used only with the SELECT clause.
• C. The WITH clause can hold more than one query.
• D. If the query block name and the table name are the same, then the table name takes precedence.

正解：A、B、C

質問 # 98
Examine the business rule:
Each student can work on multiple projects and each project can have multiple students.
You need to design an Entity Relationship Model (ERD) for optimal data storage and allow for generating reports in this format:
STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK
Which two statements are true in this scenario?

• A. PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.
• B. An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities.
• C. The ERD must have a M:M relationship between the STUDENTS and PROJECTS entities that must be resolved into 1:M relationships.
• D. The ERD must have a 1:M relationship between the STUDENTS and PROJECTS entities.
• E. STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.

正解：B、C

解説：
Explanation
References:
http://www.oracle.com/technetwork/issue-archive/2011/11-nov/o61sql-512018.html

質問 # 99
Examine the description of the EMPLOYEES table:

Which query requires explicit data type conversion?

• A. SELECT join_date + '20' FROM employees;
• B. SELECT salary + '120.50' FROM employees;
• C. SELECT SUBSTR(join_date, 1, 2) - 10 FROM employees;
• D. SELECT join_date || ' ' || salary FROM employees;
• E. SELECT join_date FROM employees WHERE join_date > '10-02-2018';

正解：E

質問 # 100
View the Exhibit and examine the details of PRODUCT_INFORMATIONtable.
PRODUCT_NAME CATEGORY_ID SUPPLIER_ID
Inkjet C/8/HQ 12 102094
Inkjet C/4 12 102090
LaserPro 600/6/BW 12 102087
LaserPro 1200/8/BW 12 102099
Inkjet B/6 12 102096
Industrial 700/ID 12 102086
Industrial 600/DQ 12 102088
Compact 400/LQ 12 102087
Compact 400/DQ 12 102088
HD 12GB /R 13 102090
HD 10GB /I 13 102071
HD 12GB @7200 /SE 13 102057
HD 18.2GB @10000 /E 13 102078
HD 18.2GB @10000 /I 13 102050
HD 18GB /SE 13 102083
HD 6GB /I 13 102072
HD 8.2GB@5400 13 102093
You have the requirement to display PRODUCT_NAMEfrom the table where the CATEGORY_IDcolumn has values 12or 13, and the SUPPLIER_IDcolumn has the value 102088. You executed the following SQL statement:
SELECT product_name
FROM product_information
WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088; Which statement is true regarding the execution of the query?

• A. It would execute and the output would display the desired result.
• B. It would not execute because the entire WHEREclause condition is not enclosed within the parentheses.
• C. It would not execute because the same column has been used in both sides of the ANDlogical operator to form the condition.
• D. It would execute but the output would return no rows.

正解：D

質問 # 101
Examine the command to create the BOOKS table.

The BOOK_ID value 101 does not exist in the table.
Examine the SQL statement:

Which statement is true?

• A. It executes successfully only if NULL is explicitly specified in the INSERT statement.
• B. It executes successfully only if the PUBLISHER_ID column name is added to the columns list in the INSERT statement.
• C. It executes successfully and the row is inserted with a rule PUBLISHER_ID.
• D. It executes successfully only if the PUBLISHER_ID column name is added to the columns list and NULL is explicitly specified in the INSERT statement.

正解：C

質問 # 102
You issued this command:

Which three statements are true?

• A. All indexes defined on HR.EMPLOYEES are dropped.
• B. Sequences used to populate columns in the HR.EMPLOYEES table are dropped.
• C. The HR.EMPLOYEES table may be moved to the recycle bin.
• D. Views referencing HR.EMPLOYEES are dropped.
• E. Synonyms for HR.EMPLOYEES are dropped.
• F. All constraints defined on HR.EMPLOYEES are dropped.

正解：A、D、F

質問 # 103
Examine the structure and data in the PRICE_LIST table:

You plan to give a discount of 25% on the product price and need to display the discount amount in the same format as the PROD_PRICE.
Which SQL statement would give the required result?

• A. SELECT TO_CHAR (TO_NUMBER(prod_price, '$99,999.99') * . 25, '$99,999.00')FROM PRICE_LIST
• B. SELECT TO_CHAR (prod_price* .25, '$99,999.99')FROM PRICE_LIST
• C. SELECT TO_NUMBER (TO_NUMBER(prod_price, '$99,999.99') * . 25, '$99,999.00')FROM PRICE_LIST
• D. SELECT TO_CHAR (TO_NUMBER(prod_price) * .25, '$99,999.00')FROM PRICE_LIST

正解：A

質問 # 104
Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

• A. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.
• B. The Oracle join syntax supports natural joins.
• C. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax.
• D. The Oracle join syntax supports creation of a Cartesian product of two tables.
• E. The SQL:1999 compliant ANSI join syntax supports natural joins.
• F. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
• G. The Oracle join syntax only supports right outer joins.

正解：A、B、E

解説：
Explanation/Reference: http://www.dba-oracle.com/oracle_tips_iso99_joins.htm

質問 # 105
In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'.
Evaluate the following query:

What would be the outcome?

• A. Abigail PA
• B. An error message
• C. Abigail Pa
• D. Abigail IS

正解：C

質問 # 106
Examine the structure of the EMPLOYEES table.

You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salaries greater than 10000.
Which query would retrieve the required result?

• A. SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id = (SELECT employee_id FROM employees WHERE employee_id = 100)UNION ALL(SELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE-180INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000);
• B. SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALLSELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100)INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE-180;
• C. (SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALLSELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100))UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE-180;
• D. SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id = (SELECT employee_id FROM employees WHERE employee_id = '100')UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE-180INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000;

正解：D

質問 # 107
View the Exhibit and examine the details of PRODUCT_INFORMATION table.
PRODUCT_NAME
CATEGORY_ID
SUPPLIER_ID
Inkjet C/8/HQ
12
102094
Inkjet C/4
12
102090
LaserPro 600/6/BW
12
102087
LaserPro 1200/8/BW
12
102099
Inkjet B/6
12
102096
Industrial 700/ID
12
102086
Industrial 600/DQ
12
102088
Compact 400/LQ
12
102087
Compact 400/DQ
12
102088
HD 12GB /R
13
102090
HD 10GB /I
13
102071
HD 12GB @7200 /SE
13
102057
HD 18.2GB @10000 /E
13
102078
HD 18.2GB @10000 /I
13
102050
HD 18GB /SE
13
102083
HD 6GB /I
13
102072
HD 8.2GB@5400
13
102093
You have the requirement to display PRODUCT_NAME from the table where the CATEGORY_ID column has values 12 or 13, and the SUPPLIER_ID column has the value 102088. You executed the following SQL statement:
SELECT product_name
FROM product_information
WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088; Which statement is true regarding the execution of the query?

• A. It would execute and the output would display the desired result.
• B. It would not execute because the same column has been used in both sides of the AND logical operator to form the condition.
• C. It would not execute because the entire WHERE clause condition is not enclosed within the parentheses.
• D. It would execute but the output would return no rows.

正解：D

質問 # 108
Examine the structure of the EMPLOYEES table. (Choose the best answer.) You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salaries greater than 10000.

• A. SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id
  (SELECT employee_id FROM employees WHERE employee_id = '100')UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -
  180INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE salary >
  10000;
• B. SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALL SELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id
  100)INETRSECTSELECT last_name, hire_date, salaryFROM employees WHERE
  hire_date > SYSDATE- 180;
• C. SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id
  (SELECT employee_id FROM employees WHERE employee_id = 100)UNION
  ALL(SELECT last_name, hire_date, salaryFROM employeesWHERE hire_date >
  SYSDATE -180INTERSECTSELECT last_name, hire_date, salaryFROM
  employeesWHERE salary > 10000);
• D. (SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALLSELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100))UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -180;

正解：A

質問 # 109
......

完全版1z1-071練習テスト問題集で308の別格な問題と解釈、今すぐゲットせよ：https://drive.google.com/open?id=1VWDR4-gMjgmEltJdUQ1_KLL1ZVV3FYLE

的確で最適なアンサー模擬試験はここにある：https://www.goshiken.com/Oracle/1z1-071-mondaishu.html