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

문제1

Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

A. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

B. SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;

C. SELECT DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1;

D. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

E. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

정답: A,E

문제2

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)

A. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100
"DUES AMOUNT" FROM transactions;

B. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;

C. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;

D. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;

E. SELECT customer_id AS `CUSTOMER-ID', transaction_date AS DATE, amount + 100 `DUES AMOUNT' FROM transactions;

정답: C,D

문제3

The ORCL database has RESUMABLE__TIMEOUT = 7200 and
DEFERRED_SEGMENT_CREATION = FALSE
User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017-03-06T12:15:17.183438+05:30
statement in resumable session 'User U1(136), Session 1, Instance 1'
was suspended due to ORA-01536: space quota exceeded for tablespace
'DATA'
Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

A. Set DEFERRED_SEGMENT_CREATION to TRUE

B. Add a data file to DATA

C. Increase U1's quota sufficiently in DATA

D. Set AUTOEXTEND ON for data files in DATA

E. Grant UNLIMITED TABLESPACE to U1

F. Drop other U1 objects in DATA

정답: A,C,D

문제4

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

A. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

B. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables

C. The SQL:1999 compliant ANSI join syntax supports natural joins

D. The Oracle join syntax supports creation of a Cartesian product of two tables

E. The Oracle join syntax only supports right outer joins

F. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

G. The Oracle join syntax supports natural joins

정답: B,C,G

문제5

Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

A. The lsnrctl utility requires a listener.ora file to exist before it is started

B. Oracle Net Manager can be used to locally configure naming methods on a database server

C. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target

D. The Oracle Net Configuration Assistant is only used when running the Oracle installer

E. Oracle Net Manager can be used to centrally configure listeners on any database server target

F. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server

정답: B,E,F

문제6

Which two are true about complete and incomplete recovery? (Choose two.)

A. Incomplete recovery is possible only when the database is open.

B. Uncommitted transactions will be rolled back after complete recovery completes.

C. Only incremental backups can be used to roll forward the database while performing complete recovery.

D. Uncommitted transactions will be rolled back after incomplete recovery completes.

E. The database must have FLASHBACK enabled in order to perform incomplete recovery.

정답: B,C

문제7

Examine this command:
SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT
Which two statements are true?

A. Only queries are allowed on ORDERS while the shrink is executing.

B. The shrink operation causes rows to be moved to empty space starting from the beginning of the orders segment.

C. The high-water mark (HWM) of orders is adjusted.

D. Dependent indexes become UNUSABLE.

E. Queries and DML statements are allowed on ORDERS while the shrink is executing.

F. The shrink operation causes rows to be moved to empty space starting toward the end of the orders segment.

정답: B,E

문제8

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

A. The foreign key constraint will be disabled.

B. The foreign key constraint will be enabled and deferred.

C. The primary key constraint will be enabled and deferred.

D. The foreign key constraint will be enabled and immediate.

E. The primary key constraint will be enabled and immediate.

정답: A

문제9

Which two queries execute successfully?

A. SELECT COALESCE(100, NULL, 200) FROM DUAL;

B. SELECT 2TOLLIF(100, 'A') FROM DUAL;

C. SELECT NULLIF(100,100) FROM DUAL;

D. SELECT NULLIF(NULL, 100) FROM DUAL;

E. SELECT COALESCE (100, 'AM FROM DUAL;

정답: A

문제10

Which three instance situations are possible with the Oracle Database server without multi- tenant? (Choose three.)

A. one instance on one server associated with two or more databases on the same server

B. one instance on one server not associated with any database

C. two or more instances on separate servers all associated with one database

D. one instance on one server associated with two or more databases on separate servers

E. one instance on one server associated with one database

정답: A,B,D

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

우리와 연락하기

유용한 링크

최신 업데이트