試験高合格率保証2023年05月04日 1z0-071試験問題と正確な回答！ [Q53-Q76]

試験高合格率保証2023年05月04日 1z0-071試験問題と正確な回答！

テストエンジン練習問題1z0-071有効最新の問題集

質問 # 53
Which two statements are true about sequences crated in a single instance Oracle database?

A. When the database instance shuts down abnormally, sequence numbers that have been cached but not used are available again when the instance is restarted.
B. DELETE <sequencename> would remove a sequence from the database.
C. The numbers generated by an explicitly defined sequence can only be used to insert data in one table.
D. CURRVAL is used to refer to the most recent sequence number that has been generated for a particular sequence.
E. When the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER SEQUENCE statement.

正解：D、E

質問 # 54
Examine these SQL statements which execute successfully:

Which two statements are true after execution?

A. The primary key constraint will be enabled and IMMEDIATE.
B. The foreign key constraint will be enabled and DEFERRED.
C. The foreign key constraint will be enabled and IMMEDIATE.
D. The primary key constraint will be enabled and DEFERRED.
E. The foreign key constraint will be disabled.

正解：C、D

質問 # 55
Which statement is true about Data Manipulation Language (DML)?

A. Each DML statement forms a transaction by default.
B. A transaction can consist of one or more DML statements.
C. DML automatically disables foreign ley constraints when modifying primary key values in the parent table.
D. DML disables foreign key constraints when deleting primary key values in the parent table, only when the ON DELETE CASCADE option is set for the foreign key constraint.

正解：B

質問 # 56
Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

A. Employees 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
B. Employees 100 and 200 will have the same SALARY as before the update command
C. Employee 200 will have SALARY set to the same value as the SALARY of employee 100
D. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
E. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
F. Employees 100 and 200 will have the same JOB_ID as before the update command

正解：A、E

質問 # 57
Which statement is true about the Oracle SQL, DELETEand TRUNCATEstatements?

A. DELETE but not TRUNCATEstatement can be used to remove data from selective columns and rows of a table.
B. DELTEand TRUNCATEstatements can have a rollback done to restore data into a table.
C. DELETEand TRUNCATEstatements remove all indexes for the tables on which they are performed.
D. DELETEbut not TRUNCATEstatement can be used to selectively remove rows from a table.

正解：D

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

There is a parent-child relationship between EMPLOYEE_ID and MANAGER_ID.
You want to display the last names and manager IDs of employees who work for the same manager as the employee whose EMPLOYEE_ID is 123.
Which query provides the correct output?

A. SELECT e.last_name, m.manager_idFROM employees e RIGHT OUTER JOIN employees mon (e.manager_id = m.employee_id)AND e.employee_id = 123;
B. SELECT e.last_name, e.manager_idFROM employees e RIGHT OUTER JOIN employees mon (e.employee_id = m.employee_id)WHERE e.employee_id = 123;
C. SELECT e.last_name, m.manager_idFROM employees e LEFT OUTER JOIN employees mon (e.employee_id = m.manager_id)WHERE e.employee_id = 123;
D. SELECT m.last_name, e.manager_idFROM employees e LEFT OUTER JOIN employees mon (e.manager_id = m.manager_id)WHERE e.employee_id = 123;

正解：D

質問 # 59
Examine the structure of the BOOKS_TRANSACTIONStable.

You want to update this table such that BOOK_IDis set to 'INVALID'for all rows where no MEMBER_ID has been entered.
Examine this partial SQL statement:

Which condition must be used in the WHEREclause to perform the required update?
MEMBER_ID = '';

A.
B. MEMBER_ID = NULL;
C. MEMBER_ID IS NULL;
D. MEMBER_ID = "";

正解：D

質問 # 60
You need to display the first names of all customers from the CUSTOMERStable that contain the character 'e' and have the character 'a' in the second last position.
Which query would give the required output?
SELECT cust_first_name

A. FROM customers
WHERE INSTR(cust_first_name, 'e')IS NOT NULL AND
SUBSTR(cust_first_name, 1, -2)='a';
SELECT cust_first_name
B. FROM customers
WHERE INSTR(cust_first_name, 'e')<>0 AND
SUBSTR(cust_first_name, -2, 1)='a';
SELECT cust_first_name
C. FROM customers
WHERE INSTR(cust_first_name, 'e')<>'' AND
SUBSTR(cust_first_name, -2, 1)='a';
SELECT cust_first_name
D. FROM customers
WHERE INSTR(cust_first_name, 'e')<>0 AND
SUBSTR(cust_first_name, LENGTH(cust_first_name), -2)='a';

正解：B

質問 # 61
Which two statements are true regarding a SAVEPOINT? (Choose two.)

A. A SAVEPOINTdoes not issue a COMMIT
B. Only one SAVEPOINTmay be issued in a transaction
C. Rolling back to a SAVEPOINT can undo a TRUNCATEstatement
D. Rolling back to a SAVEPOINTcan undo a DELETEstatement
E. Rolling back to a SAVEPOINTcan undo a CREATE INDEX statement

正解：A、D

質問 # 62
View the Exhibit and examine the structure of CUSTOMERStable.
Using the CUSTOMERStable, you need to generate a report that shows an increase in the credit limit by
15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.
Which SQL statement would produce the required result?

A. SELECT NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"
FROM customers;
B. SELECT NVL(cust_credit_limit), 'Not Available') "NEW CREDIT"
FROM customers;
C. SELECT TO_CHAR (NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT" FROM customers;
D. SELECT NVL (TO CHAR(cust_credit_limit * .15), 'Not Available') "NEW CREDIT" FROM customers;

正解：D

質問 # 63
Which three statements are true reading subquenes?

A. Only one column or expression can be compared between the subquery and main query.
B. A Main query can have many subqueries.
C. The subquery and main query can retrieve data from different tables.
D. The subquery and main query must retrieve date from the same table.
E. A subquery can have more than one main query.
F. Multiple columns or expressions can be compared between the subquery and main query.

正解：B、C、F

質問 # 64
View the Exhibit and examine the structure of the CUSTOMERS table.

Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers.
Customers with no credit limit should have "Not Available" displayed.
Which SQL statement would produce the required result?

A. SELECT NVL(cust_credit_limit, 'Not Available')*.15 "NEW CREDIT" FROM customers;
B. SELECT NVL(TO_CHAR(cust_credit_limit*.15), 'Not Available') "NEW CREDIT" FROM customers;
C. SELECT TO_CHAR(NVL(cust_credit_limit*.15, 'Not Available')) "NEW CREDIT" FROM customers;
D. SELECT NVL(cust_credit_limit*.15, 'Not Available') "NEW CREDIT" FROM customers;

正解：D

質問 # 65
Which two tasks can be performed by using Oracle SQL statements?

A. connecting to a database instance
B. changing the password for an existing database user
C. querying data from tables across databases
D. starting up a database instance
E. executing operating system (OS) commands in a session

正解：B、C

解説：
References:
http://www.techonthenet.com/oracle/password.php
https://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_distdbs.htm

質問 # 66
You must write a query that prompts users for column names and conditions every time it is executed.
The user must be prompted only once for the table name.
Which statement achieves those objectives?

A. SELECT &col1, &col2
FROM "&table"
WHERE &condition = &cond;
B. SELECT &col1, '&col2'
FROM &table
WHERE &&condition = '&cond';
C. SELECT &col1, &col2
FROM &&table
WHERE &condition = &&cond
D. SELECT &col1, &col2
FROM &&table
WHERE &condition = &cond;

正解：D

質問 # 67
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 improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column.
B. Performance would degrade in query 2.
C. Performance would improve in query 2.
D. There would be no change in performance.

正解：D

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

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

PRODUCT_ID column is the primary key.
You create an index using this command:
SQL > CREATE INDEX upper_name_idx
ON product_information(UPPER(product_name));
No other indexes exist on the PRODUCT_INFORMATION table.
Which query would use the UPPER_NAME_IDX index?

A. SELECT UPPER(product_name)
FROM product_information;
B. SELECT product_id
FROM product_information
WHERE UPPER(product_name) IN ('LASERPRO', 'CABLE');
C. SELECT product_id, UPPER(product_name)
FROM product_information
WHERE UPPER(product_name) = 'LASERPRO' OR list_price > 1000;
D. SELECT UPPER(product_name)
FROM product_information
WHERE product_id = 2254;

正解：B

質問 # 69
Which two are SQL features?

A. providing graphical capabilities
B. providing variable definition capabilities.
C. processing sets of data
D. providing database transaction control
E. providing update capabilities for data in external files

正解：C、D

質問 # 70
You issued this command:

Which three statements are true? (Choose three.)

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

正解：A、E、F

解説：
Explanation/Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables010.htm#ADMIN01505

質問 # 71
The first DROP operation is performed on PRODUCTS table using this command:
DROP TABLE products PURGE;
Then a FLASHBACK operation is performed using this command:
FLASHBACK TABLE products TO BEFORE DROP;
Which is true about the result of the FLASHBACK command?

A. It recovers the table structure and data but not the related indexes.
B. It recovers only the table structure.
C. It is not possible to recover the table structure, data, or the related indexes.
D. It recovers the table structure, data, and the indexes.

正解：C

解説：
Explanation
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9003.htm

質問 # 72
View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables.

Examine this query which must select the employee IDs of all the employees who have held the job SA_MAN at any time during their employment.
SELECT employee_id
FROM employees
WHERE job_id = 'SA_MAN'
-------------------------------------
SELECT employee_id
FROM job_history
WHERE job_id='SA_MAN';
Choose two correct SET operators which would cause the query to return the desired result. (Choose two.)

A. INTERSECT
B. UNION ALL
C. UNION
D. MINUS

正解：B、C

質問 # 73
Evaluate the following CREATE TABLE command:

Which statement is true regarding the above SQL statement?

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

正解：C

質問 # 74
In the PROMOTIONS table, the PROMO_BEGIN_DATEcolumn is of data type DATEand the default date format is DD-MON-RR.
Which two statements are true about expressions using PROMO_BEGIN_DATEcontained a query? (Choose two.)

A. TO_NUMBER(PROMO_BEGIN_DATE)- 5 will return a number.
B. PROMO_BEGIN_DATE - SYSDATEwill return a number.
C. PROMO_BEGIN_DATE- 5 will return a date.
D. TO_DATE(PROMO_BEGIN_DATE * 5)will return a date.
E. PROMO_BEGIN_DATE - SYSDATEwill return an error.

正解：B、D

質問 # 75
View the exhibit and examine the ORDERStable.

The ORDERStable contains data and all orders have been assigned a customer ID. Which statement would add a NOTNULLconstraint to the CUSTOMER_IDcolumn?

A. ALTER TABLE orders
ADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
B. ALTER TABLE orders
ADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;
C. ALTER TABLE orders
MODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
D. ALTER TABLE orders
MODIFY customer_id CONSTRAINT orders_cust_nn NOT NULL (customer_id);

正解：D

質問 # 76
......

試験解答1z0-071最新版とテストエンジン：https://jp.fast2test.com/1z0-071-premium-file.html

合格させる1z0-071試験最新の1z0-071試験問題集PDF：https://drive.google.com/open?id=1MD7qtgGXb3TEby_dB_UNZXjH90DQG6NP