試験問題と解答は1z1-071学習ガイド問題を試そう！ [Q81-Q97]

試験問題と解答は1z1-071学習ガイド問題を試そう！

Oracle Database SQL認証サンプル問題と練習試験合格させます

Oracle 1Z1-071認定試験は、Oracleデータベースを使用したSQLデータベース管理に関連する幅広いトピックをカバーしています。試験では、SQL構文、データ操作、データ定義、およびデータベースオブジェクトの作成に関する理解をテストします。また、選択されたステートメントを使用してデータを取得する機能、テーブルの結合、および集約関数についてもテストされます。さらに、この試験では、スキーマオブジェクトの管理、データの管理、データの整合性の確保に関するトピックをカバーしています。

 

質問 # 81
What is the primary difference between the relational database (RDB) and object-oriented database (OODB) models?

• A. OODB incorporates methods with data structure definition, whereas RDB does not allow this.
• B. RDB supports only E.F. Codd's rules, whereas OODB does not support them.
• C. RDB allows the definition of relationships between different tables, whereas OODB does not allow this.
• D. OODB supports multiple objects in the same database, whereas RDB supports only tables.

正解：A

解説：
Explanation/Reference:

質問 # 82
View the Exhibit and examine the structure of the ORDER_ITEMS table. (Choose the best answer.)

You must select the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_ITEMS table.
Which query would produce the desired result?

• A. SELECT order_idFROM order_itemsWHERE(unit_price*quantity)
  MAX(unit_price*quantity)GROUP BY order_id);
• B. SELECT order_idFROM order_itemsGROUP BY order_idHAVING
  SUM(unit_price*quantity) = (SELECT MAX (SUM(unit_price*quantity))FROM order_items GROUP BY order_id);
• C. SELECT order_idFROM order_itemsWHERE (unit_price*quantity) = (SELECT MAX(unit_price*quantity)FROM order_itemsGROUP BY order_id)
• D. SELECT order_idFROM order_itemsWHERE(unit_price*quantity) = (SELECT MAX (SUM(unit_price*quantity)FROM order_items) GROUP BY order_id);

正解：B

質問 # 83
Which two are true about granting object privileges on tables, views, and sequences?

• A. REFERENCES can be grantrd only on tables.
• B. INSERT can be granted only on tables and sequences.
• C. DELETE can be granted on tables, views, and sequences.
• D. ALTER can be granted only on tables and sequences.
• E. SELECT can be granted on tables, views, and sequences.

正解：A、E

解説：
Object privileges applicable to tables, views, and sequences in Oracle are:
B . REFERENCES can be granted only on tables. It allows the grantee to create a foreign key that refers to the table.
D . SELECT can be granted on tables and views. This allows the grantee to perform a SELECT on the table or view.
A, C, and E are incorrect. Specifically:
A is incorrect because DELETE cannot be granted on sequences; it is a privilege applicable to tables and views.
C is incorrect because INSERT cannot be granted on sequences; INSERT is applicable only to tables and views.
E is incorrect because ALTER is a privilege applicable to tables and indexes, not sequences.
Reference:
Oracle Database SQL Language Reference, 12c Release 1 (12.1): "GRANT"

質問 # 84
Which two statements are true regarding constraints?

• A. Only the primary key can be defined at the column and table levels.
• B. A table can have only one primary key and one foreign key.
• C. Both primary key and foreign key constraints can be defined at both column and table levels.
• D. The foreign key and parent table primary key must have the same name.
• E. A table can have only one primary key but multiple foreign keys.

正解：C、E

質問 # 85
View the exhibit and examine the structure of ORDERSand CUSTOMERStables.

Which INSERT statement should be used to add a row into the ORDERStable for the customer whose CUST_LAST_NAMEis Robertsand CREDIT_LIMITis 600? Assume there exists only one row with CUST_LAST_NAME as Roberts and CREDIT_LIMIT as 600.

• A. INSERT INTO orders
  VALUES (1,'10-mar-2007', 'direct',
  ( SELECT customer_id
  FROM customers
  WHERE cust_last_name='Roberts' AND credit_limit=600), 1000);
• B. INSERT INTO (SELECT o.order_id, o.order_date, o.order_mode, c.customer_id, o.order_total FROM orders o, customers c
  WHERE o.customer_id = c.customer_id AND c.cust_last_name='Roberts' AND
  c.credit_limit=600)
  VALUES (1,'10-mar-2007', 'direct', (SELECT customer_id
  FROM customers
  WHERE cust_last_name='Roberts' AND credit_limit=600), 1000);
• C. INSERT INTO orders (order_id, order_date, order_mode,
  ( SELECT customer id
  FROM customers
  WHERE cust_last_name='Roberts' AND credit_limit=600), order_total);
  VALUES (1,'10-mar-2007', 'direct', &customer_id, 1000);
• D. INSERT INTO orders (order_id, order_date, order_mode,
  ( SELECT customer_id
  FROM customers
  WHERE cust_last_name='Roberts' AND credit_limit=600), order_total);
  VALUES (1,'10-mar-2007', 'direct', &customer_id, 1000);

正解：A

質問 # 86
Examine the description of the employees table:

Examine these requirements:
1- Display the last name, date of hire and the number of years of service for each employee.
2. If the employee has been employed 5 or more years but less than 10, display -5+ years of service".
3. If the employee has been employed 10 or more years but less than 15, display "10+ years of service".
4. If the employee has been employed 15 or more years, display "15-*- years of service".
5. If none of these conditions matches, display "<5 years of service".
6. Sort the results by the hire_date column.
Which statement satisfies all the requirements?

• A.
• B.
• C.
• D.

正解：C

質問 # 87
Which three privileges can be restricted to a subset of columns in a table? (Choose three.)

• A. DELETE
• B. SELECT
• C. INSERT
• D. UPDATE
• E. REFERENCES
• F. INDEX
• G. ALTER

正解：A、B、D

解説：
Explanation

質問 # 88
Which two statements are true about * _TABLES views?

• A. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in USER_TABLES.
• B. ALL TABLES displays all tables owned by the current user.
• C. All users can query DBA_TABLES successfully.
• D. You must have ANY TABLE system privileges, or be granted object privilges on the table, to viewa tabl e in DBA TABLES.
• E. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in ALL_TABLES.
• F. USER TABLES displays all tables owned by the current user.

正解：B、F

解説：
In Oracle, *_TABLES views provide information about tables.
B . USER_TABLES displays all tables owned by the current user, making this statement true. No additional privileges are required to see your own tables.
D . ALL_TABLES displays all tables that the current user has access to, either through direct ownership or through privileges, making this statement true.
A, C, E, and F are incorrect. Specifically:
A and E are incorrect because you do not need ANY TABLE system privileges to view tables in DBA_TABLES or ALL_TABLES; you need the SELECT_CATALOG_ROLE or equivalent privileges.
C is incorrect because as a user, you do not need additional privileges to see your own tables in USER_TABLES.
F is incorrect because not all users can query DBA_TABLES; this requires specific privileges or roles.
Reference:
Oracle Database Reference, 12c Release 1 (12.1): "Static Data Dictionary Views"

質問 # 89
View the Exhibit and examine the description of the ORDERS table. (Choose two.) Which two WHERE clause conditions demonstrate the correct usage of conversion functions?

• A. WHERE Order_date_IN ( TO_DATE('OCT 21 2003', 'MON DD YYYY'), TO_CHAR('NOV
  21 2003', 'MON DD YYYY') )
• B. WHERE Order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
• C. WHERE TO_CHAR(Order_date, 'MON DD YYYY') = 'JAN 20 2003'
• D. WHERE Order_date > ( TO_DATE('JUL 10 2006', 'MON DD YYYY')

正解：C、D

質問 # 90
The stores table has a column start__date of data type date, containing the date the row was Inserted.
You only want to display details of rows where start date is within the last 25 months." Which where clause can be used?

• A. WHERE MONTHS_BETWEEN (SYSDATE, start-_date) <= 25
• B. WHERE MONTHS_UETWEEN (start_date, SYSDATE) <= 25
• C. WHERE ADD_MONTHS (3tart_datO, 25) <= SYSDATE
• D. WHERE TO_NUMBER (start_date - SYSDATE) <= 25

正解：A

質問 # 91

Which two queries only return CUBE?

• A. SELECT shape FROM bricks JOIN boxes ON weight < max_weight;
• B. SELECT shape FROM bricks JOIN boxes ON weight > min_weight;
• C. SELECT shape FROM bricks JOIN boxes ON NOT (weight > max_weight);
• D. SELECT shape FROM bricks JOIN boxes ON weight BETWEEN min_weight AND max_weight;
• E. SELECT shape FROM bricks JOIN boxes ON weight >= min_weight AND weight < max_weight;

正解：D、E

質問 # 92
View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables.

You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HAND for all the products wherein QUANTITY_ON_HAND is less than five.
Which two SQL statements can accomplish the task? (Choose two.)

• A. SELECT product_id, quantity_on_hand, supplier_idFROM product_informationNATURAL JOIN inventories AND quantity_on_hand < 5;
• B. SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iON (pi.product_id=i.product_id) AND quantity_on_hand < 5;
• C. SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iON (pi.product_id=i.product_id)WHERE quantity_on_hand < 5;
• D. SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iUSING (product_id) AND quantity_on_hand < 5;

正解：B、C

質問 # 93
Examine the data in the PRODUCTS table:

Examine these queries:
1. SELECT prod name, prod list
FROM products
WHERE prod 1ist NOT IN(1020) AND category _id=1;
2. SELECT prod name, | prod _ list
FROM products
WHERE prod list < > ANY (1020) AND category _id= 1;
SELECT prod name, prod _ list
FROM products
WHERE prod_ list <> ALL (10 20) AND category _ id= 1;
Which queries generate the same output?

• A. 2 and 3
• B. 1 and 3
• C. 1 and 2
• D. 1, 2 and 3

正解：B

質問 # 94
Which statements are true? (Choose all that apply.)

• A. The data dictionary views consists of joins of dictionary base tables and user-defined tables.
• B. The USER_CONS_COLUMNS view should be queried to find the names of the columns to which a constraint applies.
• C. The data dictionary is created and maintained by the database administrator.
• D. The usernames of all the users including the database administrators are stored in the data dictionary.
• E. Both USER_OBJECTS and CAT views 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, ALL and USER, use the same base tables from the data dictionary.

正解：B、D、F

解説：
Explanation
References:
https://docs.oracle.com/cd/B10501_01/server.920/a96524/c05dicti.htm

質問 # 95
Examine the structure of the SALES table. (Choose two.)

Examine this statement:

Which two statements are true about the SALES1 table? (Choose two.)

• A. It has PRIMARY KEY and UNIQUE constraints on the selected columns which had those constraints in the SALES table.
• B. It will not be created because the column-specified names in the SELECT and CREATE TABLE clauses do not match.
• C. It will have NOT NULL constraints on the selected columns which had those constraints in the SALES table.
• D. It is created with no rows.
• E. It will not be created because of the invalid WHERE clause.

正解：C、D

質問 # 96
View the exhibit for the structure of the STUDENTand FACULTYtables.

You need to display the faculty name followed by the number of students handled by the faculty at the base location.
Examine the following two SQL statements:
Statement 1
SQL>SELECT faculty_name, COUNT(student_id)
FROM student JOIN faculty
USING (faculty_id, location_id)
GROUP BY faculty_name;
Statement 2
SQL>SELECT faculty_name, COUNT(student_id)
FROM student NATURAL JOIN faculty
GROUP BY faculty_name;
Which statement is true regarding the outcome?

• A. Both statements 1 and 2 execute successfully and give the same required result.
• B. Both statements 1 and 2 execute successfully and give different results.
• C. Only statement 2 executes successfully and gives the required result.
• D. Only statement 1 executes successfully and gives the required result.

正解：D

質問 # 97
......

1z1-071認証問題集Oracle PL/SQL Developer Certified Associate 1z1-071ガイド 100%有効：https://jp.fast2test.com/1z1-071-premium-file.html