최신 1Z1-082 무료덤프 - Oracle Database Administration I

문제1

Examine the description of the BOOKS table:

The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.)

A. The second ROLLBACK command undoes the insert

B. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

C. The second ROLLBACK command does nothing

D. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

E. The second ROLLBACK command replays the delete

정답: A,D

문제2

You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

A. It is paused and can be resumed

B. It continues to run in the background

C. You can reattach to it and monitor it

D. It terminates

E. You can no longer monitor it

정답: A,C

문제3

Examine the description of the product_details table:

Which two statements are true?

A. EXPIRY_ DATE cannot be used in arithmetic expressions.

B. PRODUCT _price contains the value zero by default if no value is assigned to it.

C. PRODUCT_NAKE cannot contain duplicate values.

D. EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.

E. PRODUCT _ic can be assigned the PRIMARY KEY constraint.

F. PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.

정답: E,F

문제4

Examine the description of the BOOKS_TRANSACTIONS table:

A. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM* OR member_id IN ('A101', '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 (raeraber_id = 'A101' OR member_id = 'A102));

D. WHERE borrowed_date = SYSDATE AND (transaction_ype = 'RM' AND .-neraber_id = 'A101' OR member_id = 'A102');

정답: A,B

설명: (DumpTOP 회원만 볼 수 있음)

문제5

Which three statements are true about the DESCRIBE command? (Choose three.)

A. It displays the PRIMARY KEY constraint for any column or columns that have that constraint

B. It can be used to display the structure of an existing view

C. It displays the NOT NULL constraint for any columns that have that constraint

D. It can be used from SQL Developer

E. It displays all constraints that are defined for each column

F. It can be used only from SQL*Plus

정답: B,C,F

문제6

Examine the description of the PRODUCT_STATUS table:

The status column contains the values 'in stock' or 'out of stock' for each row.
Which two queries will execute successfully?

A. SELECT prod_id I I q' ('s not available) * 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK

B. SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';

C. SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;

D. SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';

E. SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK

F. SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK

정답: B,E

문제7

Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

A. receiving inbound requests from processes using shared server connections

B. sending each connection input request to the appropriate shared server input queue

C. broadcasting shared server session responses back to requesters on all connections

D. sending shared server session responses back to requesters on the appropriate connection

E. writing inbound request to the common request queue from all shared server connections

F. checking for outbound shared server responses on the common outbound response queue

정답: A,D,E

설명: (DumpTOP 회원만 볼 수 있음)

문제8

Examine this SQL statement:
SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

A. ORDER BY CUST_NO

B. ORDER BY "CUST_NO"

C. ORDER BY 2, 1

D. ORDER BY 2, cust_id

E. ORDER BY "Last Name"

정답: A,C,D

문제9

Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?

A. the first varchab2 column in the first select of the compound query

B. the first column in the first select of the compound query

C. the first column in the last select of the compound query

D. the first number or varchar2 column in the last select of the compound query

E. the first number column in the first select of the compound query

정답: B

문제10

While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened.
Which two statements are true?

A. DBA_DATA_FILES displays the new name for the data files.

B. DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.

C. V$DATAFILE displays the new names for the data files.

D. DBA_DATA _FILES displays both the new name and the old name for the data files.

E. DBA_DATA_FILES displays the original name for the data files.

정답: D,E

최신 1Z1-082 무료덤프 - Oracle Database Administration I

우리와 연락하기

유용한 링크

최신 업데이트