有効な1z1-071テスト解答Oracle 1z1-071試験PDF問題を試そう [Q69-Q86]

有効な1z1-071テスト解答Oracle 1z1-071試験PDF問題を試そう

Oracle 1z1-071認定リアル2022年最新の模擬試験合格させます

質問 69
View the Exhibit and examine the details of the PRODUCT_INFORMATION table.

You have the requirement to display PRODUCT_NAME and LIST_PRICE from the table where the CATEGORYJD column has values 12 or 13, and the SUPPLIER_ID column has the value 102088. You executed the following SQL statement:
SELECT product_name, list_price
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 not execute because the same column has been used in both sides of the AND logical operator to form the condition.
• B. It would execute but the output would return no rows.
• C. It would not execute because the entire WHERE clause condition is not enclosed within the parentheses.
• D. It would execute and the output would display the desired result.

正解: B

 

質問 70
Which two statements are true?

• A. CASE is a function and DECODE is not.
• B. AIl conditions evaluated using DECODE can also be evaluated using CASE.
• C. All conditions evaluated using CASE can also be evaluated using DECODE.
• D. DECODE is a function and CASE is not.
• E. Both CASE and DECODE are functions.
• F. Neither CASE nor DECODE is a function.

正解: B,D

 

質問 71
View the exhibit and examine the description of the PRODUCT_INFORMATIONtable.

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

• A. SELECT COUNT (list_price)
  FROM product_information
  WHERE list_price is NULL
• B. SELECT COUNT (NVL(list_price, 0))
  FROM product_information
  WHERE list_price is NULL
• C. SELECT COUNT (list_price)
  FROM product_information
  WHERE list_price i= NULL
• D. SELECT COUNT (DISTINCT list_price)
  FROM product_information
  WHERE list_price is NULL

正解: B

 

質問 72
In which normal form is a table, if it has no multi-valued attributes and no partial dependencies?

• A. second normal form
• B. third normal form
• C. fourth normal form
• D. first normal form

正解: A

解説:
References:
https://blog.udemy.com/database-normal-forms/

 

質問 73
View the exhibit and examine the description of the DEPARTMENTS and EMPLOYEES tables.

You wrote this SQL statement to retrieve EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, for all employees:
SELECT employee_id, first_name, department_name
FROM employees
NATURAL JOIN departments;
The desired output is not obtained after executing the above SQL statement. What could be the reason for this?

• A. The NATURAL JOIN clause is missing the USING clause.
• B. The EMPLOYEES and DEPARTMENTS tables have more than one column with the same column name and data type.
  Natural join needs only one column to be the same in each table. The EMPLOYEES and DEPARTMENTS tables have two columns that are the same (Department_ID and Manager_ID)
• C. The table prefix is missing for the column names in the SELECT clause.
• D. The DEPARTMENTS table is not used before the EMPLOYEES table in the FROM clause.

正解: B

 

質問 74
Examine the description of the EMPLOYEES table:

You write this failing statement:
SELECT dept_no AS department_id, MAX (salary) As max_sal
FROM employees
WHERE salary >10000
GROUP BY department_id
ORDER BY max_sal;
Which clause causes the error?

• A. SELECT
• B. GROUP BY
• C. ORDER BY
• D. WHERE

正解: B

 

質問 75
View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables.

The PROD_ID column is the foreign key in the SALES tables, which references the PRODUCTS table.
Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Evaluate the following CREATE TABLE command:
CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;
Which statement is true regarding the above command?

• A. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.
• B. The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.
• C. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table.
• D. The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.

正解: A

 

質問 76
You execute this command:
TRUNCATE TABLE depts;
Which two are true?

• A. It retains the integrity constraints defined on the table.
• B. It always retains the space used by the removed rows
• C. A Flashback TABLE statement can be used to retrieve the deleted data.
• D. A ROLLBACK statement can be used to retrieve the deleted data.
• E. It retains the indexes defined on the table.
• F. It drops any triggers defined on the table.

正解: A,E

 

質問 77
Evaluate the following CREATE TABLE commands:
CREATE_TABLE orders
( ord_no NUMBER (2) CONSTRAINT ord_pk PRIMARY KEY,
ord_date DATE,
cust_id NUMBER (4));
CREATE TABLE ord_items
( ord _no NUMBER (2),
item_no NUMBER(3),
qty NUMBER (3) CHECK (qty BETWEEEN 100 AND 200),
expiry_date date CHECK (expiry_date> SYSDATE),
CONSTRAINT it_pk PRIMARY KEY (ord_no, item_no),
CONSTARAINT ord_fk FOREIGN KEY (ord_no) REFERENCES orders (ord_no) );
Why would the ORD_ITEMStable not get created?

• A. The BETWEENclause cannot be used twice for the same table.
• B. ORD_NOand ITEM_NOcannot be used as a composite primary key because ORD_NOis also the FOREIGN KEY.
• C. The CHECKconstraint cannot be placed on columns having the DATEdata type.
• D. SYSDATEcannot be used with the CHECK constraint.

正解: D

 

質問 78
Examine this partial command:

Which two clauses are required for this command to execute successfully? (Choose two.)

• A. the REJECT LIMITclause
• B. the DEFAULT DIRECTORYclause
• C. the ACCESS PARAMETERSclause
• D. the LOCATIONclause
• E. the access driver TYPEclause

正解: B,D

 

質問 79
Examine the structure of the EMPLOYEES table:

There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.
You want to display the name, joining date, and manager for all employees. Newly hired employees are yet to be assigned a department or a manager. For them, 'No Manager' should be displayed in the MANAGER column.
Which SQL query gets the required output?

• A. SELECT e.last_name, e.hire_date, NVL(m.last_name, 'No Manager') Manager FROM employees e NATURAL JOIN employees mON (e.manager_id = m.employee_id).
• B. SELECT e.last_name, e.hire_date, NVL(m.last_name, 'No Manager') Manager FROM employees e JOIN employees mON (e.manager_id = m.employee_id);
• C. SELECT e.last_name, e.hire_date, NVL(m.last_name, 'No Manager') Manager FROM employees e LEFT OUTER JOIN employees mON (e.manager_id = m.employee_id);
• D. SELECT e.last_name, e.hire_date, NVL(m.last_name, 'No Manager') Manager FROM employees e RIGHT OUTER JOIN employees mON (e.manager_id = m.employee_id);

正解: C

 

質問 80
View the Exhibit and examine the data in the PRODUCTS table.

You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure.
You issue this query:

Which statement is true?

• A. It executes successfully and returns the required result.
• B. It generates an error because the condition specified for the PROD_CATEGORY column is not valid.
• C. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.
• D. It executes successfully but returns no result.

正解: D

 

質問 81
Examine the structure proposed for the TRANSACTIONStable:

Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

• A. The CUST_STATUScolumn would allow storage of data up to the maximum VARCHAR2size of 4,000 characters.
• B. The TRANS_VALIDITYcolumn would allow storage of a time interval in days, hours, minutes, and seconds.
• C. The TRANS_DATEcolumn would allow storage of dates only in the dd-mon-yyyy format.
• D. The CUST_CREDIT_VALUEcolumn would allow storage of positive and negative integers.

正解: B,D

 

質問 82
Evaluate the following two queries:

Which statement is true regarding the above two queries?

• A. Performance would improve query 2 only if there are null values in the CUST__CREDIT__LIMIT column.
• B. There would be no change in performance.
• C. Performance would improve in query 2.
• D. Performance would degrade in query 2.

正解: B

 

質問 83
Which three statements are true? (Choose three.)

• A. The USER_CONS_COLUMNS view should be queried to find the names of columns to which constraints apply.
• B. Both USER_OBJECTS and CAT views provide the same information about all objects that are owned by the user.
• C. Views with the same name but different prefixes, such as DBA, ALL and USER, reference the same base tables from the data dictionary.
• D. The usernames of all users including database administrators are stored in the data dictionary.
• E. Data dictionary views consist of joins of dictionary base tables and user-defined tables.
• F. The data dictionary is created and maintained by the database administrator.

正解: A,C,D

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

 

質問 84
View the Exhibit and examine the data in the PRODUCT_INFORMATIONtable.

Which two tasks would require subqueries? (Choose two.)

• A. displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE
• B. displaying all supplier IDs whose average list price is more than 500
• C. displaying all the products whose minimum list prices are more than average list price of products having the status orderable
• D. displaying the number of products whose list prices are more than the average list price
• E. displaying the minimum list price for each product status

正解: C,D

 

質問 85
Examine the description of the EMP_DETAILS table given below:

Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL TABLE?

• A. An EMP_IMAGE column cannot be included in the ORDER BY clause.
• B. You cannot add a new column to the table with LONG as the data type.
• C. An EMP_IMAGE column can be included in the GROUP BY clause.
• D. You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column.

正解: A,B

 

質問 86
......

Oracle 1z1-071 認定試験の出題範囲：

トピック	出題範囲
トピック 1	同じ列に非表示のインデックスと複数のインデックスを含むインデックスを作成して維持します Drop co
トピック 2	SELECTステートメントを使用して、等結合と非等結合を使用して複数のテーブルのデータにアクセスします 自己結合を使用してテーブルをそれ自体に結合します
トピック 3	HAVING句を使用してグループ化された行を含めるか除外する サブクエリが解決できる問題の種類を説明する 相関サブクエリを使用して行を更新および削除する
トピック 4	lumns and set column UNUSED リレーショナルデータベースの理論的および物理的側面を説明する DDLを使用してテーブルとその関係を管理する
トピック 5	データ操作言語（DML）とトランザクション制御言語（TCL）の使用 DMLの目的を説明する
トピック 6	SELECTステートメントで一般関数と条件式を適用する 複数のテーブルからのデータを表示する
トピック 7	データディクショナリビューを使用したオブジェクトの管理 データディクショナリビューを使用してオブジェクトのデータを調査する さまざまなデータディクショナリビューをクエリする
トピック 8	クエリによって取得される行を制限およびソートする アンパサンド置換を使用して実行時に出力を制限およびソートする SQLで使用可能なさまざまなタイプの関数を使用する
トピック 9	EXISTSおよびNOTEXISTS演算子を使用する 単一行および複数行のサブクエリを使用する 表示 非表示の列を使用して単純および複雑なビューを作成する シーケンスを作成、維持、および使用する
トピック 10	変換関数と条件式の使用 TO_CHAR、TO_NUMBER、およびTO_DATE変換関数を使用する

 

1z1-071試験問題と有効な1z1-071問題集PDF：https://jp.fast2test.com/1z1-071-premium-file.html