305試験解答は1z1-071最新版 テストエンジン [Q130-Q154]

305試験解答は1z1-071最新版 テストエンジン

合格確定1z1-071試験問最新の1z1-071試験問題集PDF2022年更新

質問 130
Examine the structure proposed for the TRANSACTIONS table:

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

• A. The CUST_CREDIT_VALUE column would allow storage of positive and negative integers.
• B. The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of
  4,000 characters.
• C. The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and seconds.
• D. The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.

正解: A,C

 

質問 131
Evaluate the following two queries:
SQL> SELECT cust_last_name, cust_city
FROM customers
WHERE cust_credit_limit IN (1000, 2000, 3000);
SQL> SELECT cust_last_name, cust_city
FROM customers
WHERE cust_credit_limit = 1000 or cust_credit_limit = 2000 or
cust_credit_limit = 3000
Which statement is true regarding the above two queries?

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

正解: D

解説:
References:
http://oraclexpert.com/restricting-and-sorting-data/

 

質問 132
View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index- organized table. (Choose two.)

Evaluate this SQL statement:
ALTER TABLE emp
DROP COLUMN first_name;
Which two statements are true?

• A. The FIRST_NAME column would be dropped provided it does not contain any data.
• B. The drop of the FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the SQL statement.
• C. The FIRST_NAME column would be dropped provided at least one column remains in the table.
• D. The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY provided the CASCADE option is added to the SQL statement.

正解: C

 

質問 133
Examine this query:
SELECT employee_id, first_name, salary
FROM employees
WHERE hiredate > 61*
Which two methods should yours to prevent prompting for hire date value when this queries executed?

• A. Execute the SET VERIFY ON command before executing the query.
• B. Use the DEFINE command before executing the query
• C. Execute the SET VERIFY OFF command before executing the query.
• D. Store the query in a script and pass the substitution value to the script when executing it.
• E. Replace 's1' with &1'in the query:
• F. Use the UNDEFINE command before executing the query.

正解: B,D

 

質問 134
View the exhibits and examine the structures of the COSTSand PROMOTIONStables.


Evaluate the following SQL statement:

What would be the outcome of the above SQL statement?

• A. It displays prod IDs in the promos with the highest cost in the same time interval.
• B. It displays prod IDs in the promos with the lowest cost in the same time interval.
• C. It displays prod IDs in the promos which cost less than the highest cost in the same time interval.
• D. It displays prod IDs in the promo with the lowest cost.

正解: C

 

質問 135
You execute this command:
ALTER TABLE employees SET UNUSED (department_id);
Which two are true?

• A. No updates can be made to the data in the DEPARTMENT_ID column.
• B. The DEPARTMENT_ID column can be recovered from the recycle bin
• C. The DEPARTMENT_ID column is set to null for all tows in the table
• D. A query can display data from the DEPARTMENT_ID column.
• E. A new column with the name DEPARTMENT_ID can be added to the EMPLOYEES table.
• F. The storage space occupied by the DEPARTMENT_ID column is released only after a COMMIT is issued.

正解: A,E

 

質問 136
View the Exhibit and examine PRODUCTS and ORDER_ITEMS tables.
You executed the following query to display PRODUCT_NAME and the number of times the product has been ordered:
SQL>SELECT p.product_name, i.item_cnt
FROM (SELECT product_id, COUNT (*) item_cnt
FROM order_items
GROUP BY product_id) i RIGHT OUTER JOIN products p
ON i.product_id = p.product_id;
What would happen when the above statement is executed?

• A. The statement would not execute because inline views and outer joins cannot be used together.
• B. The statement would not execute because the GROUP BY clause cannot be used in the inline.
• C. The statement would not execute because the ITEM_CNT alias cannot be displayed in the outer query.
• D. The statement would execute successfully to produce the required output.

正解: D

 

質問 137
Which statements are correct regarding indexes? (Choose all that apply.)

• A. For each DML operation performed, the corresponding indexes are automatically updated.
• B. When a table is dropped, the corresponding indexes are automatically dropped.
• C. A non-deferrable PRIMARY KEYor UNIQUE KEYconstraint in a table automatically creates a unique index.
• D. Indexes should be created on columns that are frequently referenced as part of any expression.

正解: A,B,C

解説:
Explanation/Reference:
References:
http://viralpatel.net/blogs/understanding-primary-keypk-constraint-in-oracle/

 

質問 138
Which two statements are true about Data Manipulation Language (DML) statements?

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

正解: E,F

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

 

質問 139
Which statement will execute successfully?

• A. SELECT 1 FROM DUAL
  UNION
  SELECT 2 FROM DUAL
  ORDER BY 1, 2;
• B. SELECT 1, 2 FROM DUAL
  UNION
  SELECT 3, 4 FROM DUAL
  ORDER BY 1, 2;
• C. SELECT 1, 2 FROM DUAL
  UNION
  SELECT 3, 4 FROM DUAL
  ORDER BY 3, 4;
• D. SELECT 3 FROM DUAL
  UNION
  SELECT 4 FROM DUAL
  ORDER BY 3 ;

正解: B

 

質問 140
Examine the contents of the EMP table:

What is the result?

• A. It will return the six employees earning the lowest salaries. In ascending order.
• B. It will return the six employees earning the highest salaries. In descending order.
• C. It will return the five employee's earning the lowest salaries. In ascending order.
• D. It will return the five employees earning the highest salaries. In descending order.

正解: C

 

質問 141
The ORDERS table has a primary key constraint on the ORDER_ID column.
The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the ORDERS table.
The constraint is defined with on DELETE CASCADE.
There are rows in the ORDERS table with an ORDER_TOTAL less than 1000.
Which three DELETE statements execute successfully?

• A. DELETE FROM orders;
• B. DELETE order_id FROM orders WHERE order_total<1000;
• C. DELETE orders WHERE order_total<1000;
• D. DELETE FROM orders WHERE order_total<1000;
• E. DELETE * FROM orders WHERE order_total<1000;

正解: A,C,D

 

質問 142
Examine the commands used to create DEPARTMENT_DETAILS and
COURSE_DETAILS:
SQL>CREATE TABLE DEPARTMENT_DETAILS
(DEPARTMENT_ID NUMBER PRIMARY KEY,
DEPARTMENT_NAMEVARCHAR2(50),
HODVARCHAR2(50));
SQL>CREATE TABLE COURSE_DETAILS
(COURSE_IDNUMBER PRIMARY KEY,
COURSE_NAMEVARCHAR2(50),
DEPARTMENT_IDVARCHAR2(50));
You want to generate a list of all department IDs along with any course IDs that may have been assigned to them.
Which SQL statement must you use?

• A. SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (d.department_id=c. department_id);
• B. SELECT d.department_id, c.course_id FROM course_details c LEFT OUTER JOIN department_details d ON (c.department_id=d. department_id);
• C. SELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN course_details c ON (d.department_id=c. department_id);
• D. SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (c.department_id=d. department_id);

正解: C

 

質問 143
View the Exhibit and examine the structure of the ORDERS table. The columns ORDER_MODE and ORDER_TOTAL have the default values 'direct' and 0 respectively.

Which two INSERT statements are valid? (Choose two.)

• A. INSERT INTO ordersVALUES (1,'09-mar-2007', DEFAULT, 101, DEFAULT);
• B. INSERT INTO(SELECT order_id,order_date,customer_id FROM orders)VALUES (1,'09-mar-2007',
  101);
• C. INSERT INTO orders(order_id,order_date,order_mode,(customer_id,order_total)VALUES (1,TO_DATE(NULL), 'online', 101, NULL);
• D. INSERT INTO ordersVALUES (1,'09-mar-2007', 'online','', 1000);
• E. INSERT INTO orders(order_id,order_date,order_mode,order_total)VALUES (1,'10-mar-2007','online',1000);

正解: A,B

 

質問 144
The BOOKS_TRANSACTIONStable exists in your database.
Examine the SQL statement:
SQL>SELECT * FROM books_transactionsORDER BY 3;
What is the outcome on execution?

• A. Rows are displayed in the order that they are stored in the table only for the first three rows.
• B. The execution tails unless the numeral 3 in the order by clause is replaced by a column name,
• C. Rows are displayed in the order that they are stored in the table only for the three rows with the lowest values in the key column.
• D. Rows are displayed sorted in ascending order of the values in the third column in the table.

正解: A

 

質問 145
View and Exhibit and examine the structure and data in the INVOICE table.

Which two statements are true regarding data type conversion in query expressions? (Choose two.)

• A. inv_date = '15-february-2008' :uses implicit conversion
• B. inv_amt = '0255982' : requires explicit conversion
• C. inv_date > '01-02-2008' : uses implicit conversion
• D. CONCAT(inv_amt, inv_date) : requires explicit conversion
• E. inv_no BETWEEN '101' AND '110' : uses implicit conversion

正解: A,E

 

質問 146
View the exhibit and examine the description of SALES and PROMOTIONS tables.

You want to delete rows from the SALES table, where the PROMO_NAME column in the PROMOTIONS table has either blowout sale or everyday low price as values.
Which three DELETE statements are valid? (Choose three.)

• A. DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'blowout sale')OR promo_name = 'everyday low price');
• B. DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'blowout sale')OR promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'everyday low price')
• C. DELETEFROM salesWHERE promo_id IN (SELECT promo_idFROM promotionsWHERE promo_name IN = 'blowout sale','everyday low price'));
• D. DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promo_name = 'blowout sale')AND promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'everyday low price')FROM promotionsWHERE promo_name = 'everyday low price');

正解: A,B,C

 

質問 147
Examine the description of the PRODUCT_DETAILStable:

Which two statements are true?

• A. EXPIRY_DATEcontains the SYSDATEby default if no date is assigned to it.
• B. PRODUCT_NAMEcannot contain duplicate values.
• C. PRODUCT_PRICEcontains the value zero by default if no value is assigned to it.
• D. PRODUCT_IDcan be assigned the PRIMARY KEYconstraint.
• E. PRODUCT_PRICEcan be used in an arithmetic expression even if it has no value stored in it.
• F. EXPIRY_DATEcannot be used in arithmetic expressions.

正解: B,F

 

質問 148
Examine the structure of the ORDERS table:

You want to find the total value of all the orders for each year and issue this command:
SQL> SELECT TO_CHAR(order_date,'rr'), SUM(order_total) FROM orders
GROUP BY TO_CHAR(order_date, 'yyyy');
Which statement is true regarding the result? (Choose the best answer.)

• A. It executes successfully but does not give the correct output.
• B. It return an error because the datatype conversion in the SELECT list does not match the data type conversion in the GROUP BY clause.
• C. It returns an error because the TO_CHAR function is not valid.
• D. It executes successfully and gives the correct output.

正解: B

 

質問 149
You want to display the date for the first Monday of the next month and issue the following command:

What is the outcome?

• A. In generates an error because TO_CHARshould be replaced with TO_DATE.
• B. It executes successfully but does not return the correct result.
• C. In generates an error because fmand double quotation marks should not be used in the format string.
• D. In generates an error because rrrrshould be replaced by rrin the format string.
• E. It executes successfully and returns the correct result.

正解: E

 

質問 150
Which two are true about a SQL statement using SET operators such as UNION?

• A. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.
• B. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
• C. The names and number of columns must be identical for all SELECT statements in the query.
• D. The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query.
• E. The number, but not names, of columns must be identical for all SELECT statements in the query.

正解: B,D

 

質問 151
You must create a table for a banking application. (Choose the best answer.) One of the columns in the table has these requirements:
1: A column to store the duration of a short team loan
2: The data should be stored in a format supporting DATE arithmetic with DATE datatypes without using conversion functions.
3: The maximum loan period is 30 days.
4: Interest must be calculated based on the number of days for which the loan remains unpaid.
Which data type would you use?

• A. Date
• B. Interval year to month
• C. Number
• D. Timestamp
• E. Interval day to second

正解: E

 

質問 152
Which two statements are true regarding the EXISTS operator used in the correlated subqueries? (Choose two.)

• A. The outer query stops evaluating the result set of the inner query when the first value is found.
• B. It is used to test whether the values retrieved by the inner query exist in the result of the outer query.
• C. The outer query continues evaluating the result set of the inner query until all the values in the result set are processed.
• D. It is used to test whether the values retrieved by the outer query exist in the result set of the inner query.

正解: A,D

解説:
References:
http://www.techonthenet.com/oracle/exists.php

 

質問 153
Which two statements are true about dropping views?

• A. CASCADE constraints must be specified when referential integrity constraints on other objects refer to primary or unique keys In the view to be dropped.
• B. Read only views cannot be dropped.
• C. The creator of a view to be dropped must have the drop ANY_ VIEW privilege.
• D. Views referencing a dropped view become Invalid.
• E. Data selected by a view's defining query is deleted from Its underlying tables when the view is dropped.

正解: A,D

 

質問 154
......

1z1-071試験問題集無料サンプル365日更新：https://www.goshiken.com/Oracle/1z1-071-mondaishu.html

まもなく無料セール終了！- リアル1z1-071のPDF解答を試そう：https://drive.google.com/open?id=1VWDR4-gMjgmEltJdUQ1_KLL1ZVV3FYLE