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

문제1

Which three statements are true about sequences in a single instance Oracle database?

A. A sequence can Issue duplicate values.

B. A sequence number that was allocated can be rolled back if a transaction fails.

C. Two or more tables cannot have keys generated from the same sequence.

D. Sequences can always have gaps.

E. A sequence's unallocated cached values are lost if the instance shuts down.

F. A sequence can only be dropped by a DBA.

정답: A,C,E

문제2

A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

A. in the temporary tablespace

B. in the SYSAUX tablespace

C. in the SGA

D. in the undo tablespace

E. in the PGA

정답: A

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

문제3

Which two statements are true about single row functions? (Choose two.)

A. CONCAT : can be used to combine any number of values

B. TRUNC : can be used with NUMBER and DATE values

C. FLOOR : returns the smallest integer greater than or equal to a specified number

D. MOD : returns the quotient of a division operation

E. CEIL : can be used for positive and negative numbers

정답: B,E

문제4

Which three are types of segments in an Oracle Database? (Choose three.)

A. stored procedures

B. sequences

C. index

D. tables

E. undo

F. clusters

정답: D,E,F

문제5

You start your database instance in NOMOUNT state. Which two actions are performed?

A. SYS can access the database.

B. The consistency of the database is checked.

C. The control files are opened.

D. All required background processes are started.

E. Memory is allocated for the SG1

정답: D,E

문제6

Examine this command:
CREATE UNDO TABLESPACE undotbs01
DATAFILE 'undotbs_01.dbf'
SIZE 100M
AUTOEXTEND ON;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

A. Add the SEGMENT SPACE MANAGEMENT AUTO clause

B. Add the ONLINE clause

C. Make certain that the database operates in automatic undo management mode

D. Set UNDO_TABLESPACE to UNDOTBS01

E. Add the NOLOGGING clause

정답: C,D

문제7

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which two statements are true?

A. Statement 2 may return multiple rows of output.

B. Both the statements give the same output.

C. Statement 2 returns only one row of output.

D. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

E. Statement 1 returns only one row of output.

정답: A,E

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

문제8

You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

A. SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;

B. SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;

C. SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;

D. SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;

E. SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;

정답: A,C

문제9

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

문제10

View the Exhibit and examine the description of the tables.
You execute this SQL statement:

Which three statements are true?

A. A product can have a different unit price at different times.

B. The statement will execute successfully and a new row will be inserted into the sales table.

C. The statement will fail because a subquery may not be contained in a values clause.

D. The sales table has five foreign keys.

E. A customer can exist in many countries.

F. The statement will fall if a row already exists in the sales table for product 23.

정답: A,B,D

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

우리와 연락하기

유용한 링크

최신 업데이트