Oracle 1z1-071リアルに2024年最新のブレーン問題集で模擬試験問題集 [Q167-Q186]

Oracle 1z1-071リアルに2024年最新のブレーン問題集で模擬試験問題集

1z1-071試験問題 リアルな1z1-071練習問題集

質問 # 167
Which two statements are true about Data Manipulation Language (DML) statements? (Choose two.)

• A. A DELETE FROM..... statement can remove rows based on only a single condition on a table.
• B. An INSERT INTO...VALUES.. statement can add multiple rows per execution to a table.
• C. A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.
• D. An UPDATE... SET... statement can modify multiple rows based on multiple conditions on a table.
• E. An UPDATE....SET.... statement can modify multiple rows based on only a single condition on a table.
• F. An INSERT INTO... VALUES..... statement can add a single row based on multiple conditions on a table.

正解：C、D

解説：
Explanation
References:
http://www.techonthenet.com/sql/and_or.php

質問 # 168
Examine the description of the CUSTONERS table:

CUSTNO is the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?

• A. LEFT OUTER JOIN with self join
• B. RIGHT OUTER JOIN with self join
• C. self Join
• D. PULL OUTER JOIN with self join
• E. subquery

正解：C、E

質問 # 169
Examine the data in the EMPLOYEES table:

Which statement will compute the total annual compensation for each employee?

• A. SELECT last _ name, (monthly_ salary * 12) + (monthly_ salary * 12 * NVL (monthly_ commission_pct, 0)) AS annual _comp
• B. SELECT last _ name, (monthly _ salary * 12) + (monthly_ commission _ pct * 12) AS FROM employees:
• C. SELECT last _ NAME (monthly_ salary + monthly _commission _ pct) * 12 AS annual_ comp FROM employees;
• D. select last _ name, (monthly_ salary * 12) + (monthly_ salary * 12 *monthly_ commission_ pct) AS annual_ camp FROM employees

正解：A

質問 # 170
View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTSand TIMEStables.

The PROD_IDcolumn is the foreign key in the SALEStable, which references the PRODUCTStable.
Similarly, the CUST_IDand TIME_IDcolumns are also foreign keys in the SALEStable referencing the CUSTOMERSand TIMEStables, respectively.
Evaluate the following CREATE TABLEcommand:
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_SALEStable would get created and all the NOTNULLconstraints defined on the specified columns would be passed to the new table.
• B. The NEW_SALEStable would get created and all the FOREIGNKEYconstraints defined on the specified columns would be passed to the new table.
• C. The NEW_SALEStable would not get created because the DEFAULTvalue cannot be specified in the column definition.
• D. The NEW_SALEStable would not get created because the column names in the CREATETABLE command and the SELECTclause do not match.

正解：A

質問 # 171
Examine the structure of the MARKS table:

Which two statements would execute successfully? (Choose two.)

• A. SELECT student_name subject1FROM marksWHERE subject1 > AVG(subject1);
• B. SELECT SUM(subject1+subject2+subject3)FROM marksWHERE student_name IS NULL;
• C. SELECT student_name,SUM(subject1)FROM marksWHERE student_name LIKE 'R%';
• D. SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1)FROM marksWHERE
  subject1 > subject2;

正解：B、D

質問 # 172
Examine the description of the PRODUCT_ DETAILS table:

Which two statements are true?

• A. EXPIRY_ DATE contains the SYSDATE by default if no date is assigned to it.
• B. EXPIRY_ DATE cannot be used in arithmetic expressions.
• C. PRODUCT_ NAME cannot contain duplicate values.
• D. PRODUCT_ ID can be assigned the PRIMARY KEY constraint.
• E. PRODUCT_ PRICE contains the value zero by default if no value is assigned to it.
• F. PRODUCT_ PRICE can be used in an arithmetic expression even if it has no value stored in it.

正解：B、D

解説：
In reference to the attributes of the PRODUCT_DETAILS table:
A). This statement is false. If PRODUCT_PRICE has no value (i.e., it is NULL), it cannot be used directly in arithmetic expressions because any operation with NULL results in NULL.
B). This statement is true. PRODUCT_ID has the NOT NULL constraint and is of type NUMBER, making it eligible to be a PRIMARY KEY. Primary keys require all values to be unique and not null.
C). This statement is true. EXPIRY_DATE is of type DATE, and it cannot be used in arithmetic expressions directly without a date function that operates on dates.
D). This statement is false. By default, columns of type DATE do not have a default value unless explicitly assigned using the DEFAULT keyword in the column definition.
E). This statement is false. By default, numeric columns do not have a default value unless specified with the DEFAULT keyword.
F). This statement is false. The statement about PRODUCT_NAME not containing duplicate values would be true if it were a UNIQUE or PRIMARY KEY, but there is no such constraint indicated in the provided table description.

質問 # 173
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 table, 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 FOREIGN KEY constraints defined on the specified columns would be passed to the new table.
• B. The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
• C. The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.
• D. 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.

正解：D

質問 # 174
View the Exhibit and examine the structure of the ORDERS table.

You must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 101.
Which query would give you the desired result?

• A. SELECT order_id, order_date FROM orders
  WHERE order_date > ALL
  (SELECT MAX(order_date) FROM orders ) AND customer_id = 101;
• B. SELECT order_id, order_date FROM orders
  WHERE order_date > ALL
  (SELECT order_date FROM orders WHERE customer_id = 101);
• C. SELECT order_id, order_date FROM orders
  WHERE order_date >
  ANY
  (SELECT order_date FROM orders WHERE customer_id = 101);
• D. SELECT order_id, order_date FROM orders
  WHERE order_date > IN
  (SELECT order_date FROM orders WHERE customer_id = 101);

正解：B

質問 # 175
Evaluate the following SQL statement:
SELECT product_name || 'it's not available for order'
FROM product_information
WHERE product_status = 'obsolete';
You received the following error while executing the above query:
ERROR
ORA-01756: quoted string not properly terminated
What would you do to execute the query successfully?

• A. Use escape character to negate the single quotation mark inside the literal character string in the SELECTclause.
• B. Use Quote (q) operator and delimiter to allow the use of single quotation mark in the literal character string.
• C. Do not enclose the character literal string in the SELECTclause within the single quotation marks.
• D. Enclose the literal character string in the SELECTclause within the double quotation marks.

正解：B

解説：
Explanation/Reference:
References:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements003.htm

質問 # 176
Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?

• A. It produces an error because the ORDER BYclause should appear only at the end of a compound query-that is, with the last SELECTstatement.
• B. It executes successfully and displays rows in the descending order of PROMO_CATEGORY.
• C. It executes successfully but ignores the ORDER BYclause because it is not located at the end of the compound statement.
• D. It produces an error because positional notation cannot be used in the ORDER BYclause with SET operators.

正解：A

質問 # 177
Which three; statements are true about built-in data types?

• A. A blob stores unstructured binary data within the database.
• B. The default length for a char column Is always one character.
• C. A BFILE stores unstructured binary data In operating system files.
• D. A char column definition does not require the length to be specified.
• E. A varchar2 column definition does not require the length to be specified.
• F. A varchar2 blank pads column values only if the data stored Is non-numeric and contains no Special characters.

正解：A、B、C

質問 # 178
Which statement is true about TRUNCATE and DELETE?

• A. You can never tows from a table if foreign key constraints will be violated.
• B. For large tables TRUNCATE is faster than DELETE.
• C. For tables with multiple indexes and triggers is faster than TRUNCATE.
• D. You can never TRUNCATE a table if foreign key constraints will be violated.

正解：B

質問 # 179
View the Exhibit and examine the data in the PROMOTIONStable.

PROMO_BEGIN_DATEis stored in the default date format, dd-mon-rr.
You need to produce a report that provides the name, cost, and start date of all promos in the POST category that were launched before January 1, 2000.
Which SQL statement would you use?
SELECT promo_name, promo_cost, promo_begin_date

• A. FROM promotions
  WHERE promo_category = 'post' AND promo_begin_date < '01-01-00';
  SELECT promo_name, promo_cost, promo_begin_date
• B. FROM promotions
  WHERE promo_cost LIKE 'post%' AND promo_begin_date < '01-01-2000';
  SELECT promo_name, promo_cost, promo_begin_date
• C. FROM promotions
  WHERE promo_category LIKE '%post%' AND promo_begin_date < '1-JAN-00';
• D. FROM promotions
  WHERE promo_category LIKE 'P%' AND promo_begin_date < '1-JANUARY-00';
  SELECT promo_name, promo_cost, promo_begin_date

正解：C

質問 # 180
Examine the description of the BOOKS_TRANSACTIONS table:

Examine this partial SQL statement:
SELECT * FROM books_transactions
Which two WHERE conditions give the same result?

• A. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');
• B. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' OR member_id IN ('A101',
  'A102'));
• C. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND (member_id = A101' OR member_id = 'A102'));
• D. WHERE (borrowed_date = SYSDATE AND transaction_type = 'RM') OR member_id IN ('A101',
  'A102');
• E. WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN ('A101',
  'A102');

正解：C、D

質問 # 181
View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statements:

What will be the result?
Exhibit 1.

Exhibit 2.

• A. It executes successfully but does not give the required result
• B. It executes successfully and gives the required result
• C. It gives an error because the GROUP BY clause is not valid
• D. It gives an error because the ALL keyword is not valid

正解：B

質問 # 182
The ORDERS table has a column ORDER_DATE of date type DATE The default display format for a date is DD-MON-RR Which two WHERE conditions demonstrate the correct usage of conversion functions?

• A. WHERE order_date IN (TO_DATE ('Oct 21 2018','MON DD YYYY'), TO_CHAR('Nov 21
  2018','MON DD YYYY'));
• B. WHERE ordet_date> TO_CHAR(ADD_MONTHS(SYSDATE, 6),'MON DD YYYY')
• C. WHERE order_date> TO_DATE(ADD_MONTHS(SYSDATE,6),'MON DD YYYY');
• D. WHERE order_date> TO_DATE('JUL 10 2018','MON DD YYYY');
• E. WHERE TO_CHAR(order_date,'MON DD YYYY') ='JAN 20 2019';

正解：D

解説：
In SQL, the correct usage of conversion functions is crucial when performing operations on dates. Oracle uses the TO_DATE function to convert a string to a date, and the TO_CHAR function to convert dates or numbers to strings.
* Statement C is correct: WHERE order_date > TO_DATE('JUL 10 2018','MON DD YYYY'); is a proper use of the TO_DATE function. It converts the string 'JUL 10 2018' to a date type, with the format 'MON DD YYYY', which is then used to compare with the order_date.
* Statements A, B, D, and E are incorrect or misuse conversion functions:
* A is incorrect because TO_CHAR is used to convert dates or numbers to strings, not the other way around, and therefore should not be compared with order_date.
* B is incorrect because order_date is of type DATE, and you should not compare a DATE with a string without converting it; the TO_CHAR here should be TO_DATE.
* D is incorrect because it mixes TO_DATE and TO_CHAR in the same IN list, which should contain date types only.
* E is incorrect because TO_DATE should take a string as an argument, not a date returned by ADD_MONTHS.

質問 # 183
You need to produce a report where each customer's credit limit has been incremented by $1000. In the output, the customer's last name should have the heading Name and the incremented credit limit should be labeled New Credit Limit. The column headings should have only the first letter of each word in uppercase.
Which statement would accomplish this requirement?

• A. SELECT INITCAP (cust_last_name) "Name", cust_credit_limit + 1000INITCAP ("NEW CREDIT LIMIT")FROM customers;
• B. SELECT cust_last_name AS Name, cust_credit_limit + 1000AS New Credit LimitFROM customers;
• C. SELECT cust_last_name AS Name, cust_credit_limit + 1000"New Credit Limit"FROM customers;
• D. SELECT cust_last_name AS "Name", cust_credit_limit + 1000AS "New Credit Limit"FROM customers;

正解：D

質問 # 184
Evaluate the following CREATE TABLEcommand:

Which statement is true regarding the above SQL statement?

• A. It would give an error because the USING INDEX clause is not permitted in the CREATE TABLE command.
• B. It would execute successfully and only ORD_ITM_IDX index would be created.
• C. It would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID_PK would be created.
• D. It would give an error because the USING INDEX clause cannot be used on a composite primary.

正解：B

質問 # 185
Which two statements are true about the ORDER BY clause?

• A. NULLS are not included in the sort operation.
• B. Numeric values are displayed in descending order if they have decimal positions.
• C. In a character sort, the values are case-sensitive.
• D. Column aliases can be used in the ORDER BY clause.
• E. Only columns that are specified in the SELECT list can be used in the ORDER BY clause.

正解：C、D

解説：
C: True. In Oracle Database 12c, character sorts are case-sensitive by default, meaning that it differentiates between uppercase and lowercase letters when sorting data. This behavior aligns with the binary collation rules typically used, unless explicitly overridden by using different collation settings.
D: True. Column aliases can indeed be used in the ORDER BY clause in Oracle SQL. This allows for more readable and maintainable code, as you can define a column alias in the SELECT list and refer to that alias in the ORDER BY clause. This usage promotes clarity, especially when dealing with complex calculations or function applications in the select list.

質問 # 186
......

Oracle 1z1-071認定試験は、Oracle Database SQLにおけるスキルと知識を証明したいデータベースプロフェッショナル向けの人気のある認定試験です。この試験は、データベースからデータを取得、挿入、更新、および削除するためのSQLクエリの作成能力を個人の能力を検証します。試験は、Oracle Database 12c以降のバージョンでの作業経験がある個人向けに設計されています。

 

厳密検証された1z1-071試験問題集と解答で無料提供の1z1-071問題と正解付き：https://www.passtest.jp/Oracle/1z1-071-shiken.html

あなたを合格させる1z1-071問題集無料で最新のOracle練習テスト：https://drive.google.com/open?id=1V9D5q-F2j55_oxhceu1lB8RBouvRTaad