1z0-071問題集、Oracle実際の試験問題

質問 1

Which two are SQL features? (Choose two.)

A. providing update capabilities for data in external files

B. providing database transaction control

C. providing variable definition capabilities

D. providing graphical capabilities

E. processing sets of data

正解: B,E

解説: (PassTest メンバーにのみ表示されます)

質問 2

Which statement is true about TRUNCATE and DELETE?

A. For large tables, DELETE is faster than TRUNCATE.

B. You can never TRUNCATE a table if foreign key constraints will be violated.

C. For tables with multiple indexes and triggers, DELETE is faster than TRUNCATE.

D. You can DELETE rows from a table with referential integrity constraints.

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 3

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 of 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;

正解: B,C

質問 4

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 Quote (q) operator and delimiter to allow the use of single quotation mark in the literal character string.

B. Enclose the character literal string in the SELECT clause within the double quotation marks.

C. Do not enclose the character literal string in the SELECT clause within the single quotation marks.

D. Use escape character to negate the single quotation mark inside the literal character string in the SELECT clause.

正解: A

質問 5

You are designing the structure of a table in which two columns have the specifications:
COMPONENT_ID - must be able to contain a maximum of 12 alphanumeric
characters and uniquely identify the row
EXECUTION_DATETIME - contains Century, Year, Month, Day, Hour, Minute,
Second to the maximum precision and is used for calculations and
comparisons between components.
Which two options define the data types that satisfy these requirements most efficiently?

A. The COMPONENT_ID must be of VARCHAR2 data type.

B. The COMPONENT_ID column must be of CHAR data type.

C. The EXECUTION_DATATIME must be of DATE data type.

D. The EXECUTION _DATETIME must be of TIMESTAMP data type.

E. The EXECUTION_DATETIME must be of INTERVAL DAY TO SECOND data type.

F. The COMPONENT_ID must be of ROWID data type.

正解: A,C

質問 6

An Oracle database server session has an uncommitted transaction in progress which updated
5000 rows in a table.
In which three situations does the transactions complete thereby committing the updates?
(Choose three.)

A. when the session logs out successfully

B. when a CREATE INDEX statement is executed successfully in the same session

C. when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

D. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT

E. when a COMMIT statement is issued by the same user from another session in the same database instance

F. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT

正解: A,B,F

質問 7

You must display details of all users whose username contains the string 'ch_'.
Which query generates the required output? (Choose the best answer.)

A. SELECT * FROM users
Where user_name LIKE '%ch\_%' ESCAPE '\';

B. SELECT * FROM users
Where user_name LIKE 'ch\_%' ESCAPE '_';

C. SELECT * FROM users
Where user_name LIKE '%ch_';

D. SELECT * FROM users
Where user_name LIKE '%ch_%'ESCAPE'%';

正解: A

質問 8

You execute this query:

What is the result?

A. It generates an error.

B. It returns the date for the last Monday of the current month.

C. It executes successfully but does not return any result.

D. It returns the date for the first Monday of the next month.

正解: D

質問 9

Evaluate this query:
SQL> SELECT TRUNC(ROUND(156.00,-1),-1)
FROM DUAL;
What will be the result?

A. 100

B. 150

C. 160

D. 200

E. 16

正解: C

Oracle Database SQL - 1z0-071 模擬練習