1Z0-082最も有効な質問と解答で勉強

Oracle Database Administration Iは業界で広く認知された資格であり、取得はキャリアの信頼性を高める確かな一歩となります。Tech4Examの1Z0-082問題集は165問を収録し、公式の出題範囲に沿って学習を組み立てられます。

Oracle 1Z0-082 試験概要:

Oracle 1Z0-082 試験シラバストピック:

Oracle Database Administration Iに関するよくあるご質問

Oracle Database Administration I 認定 1Z0-082 試験問題：

問題 #1

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. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
B. Employees 100 and 200 will have the same SALARY as before the update command
C. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
D. Employees 100 and 200 will have the same JOB_ID as before the update command
E. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
F. Employee 200 will have SALARY set to the same value as the SALARY of employee 100

問題 #2

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

A. Uncommitted transactions will be rolled back after complete recovery completes.
B. Only incremental backups can be used to roll forward the database while performing complete recovery.
C. Uncommitted transactions will be rolled back after incomplete recovery completes.
D. The database must have FLASHBACK enabled in order to perform incomplete recovery.
E. Incomplete recovery is possible only when the database is open.

問題 #3

The orders table has a column ORDER_DATE of data type date.
The default display format for a date Is DD-MON-RR.
Which two where conditions demonstrate the correct usage of conversion functions?

A. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
B. WHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018',
'Mon DD YYYY'))
C. WHERE order_date > TO_DATE<ADD_MONTHS(SYSDATE, c) , 'MON DD YYYY')
D. WHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')
E. WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'

問題 #4

You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression
Which compression option is best suited for this?

A. ROW STORE COMPRESS ADVANCED
B. COLUMN STORE COMPRESS FOR ARCHIVE LOW
C. COLUMN STORE COMPRESS FOR QUERY LOW
D. ROW STORE COMPRESS BASIC
E. COLUMN STORE COMPRESS FOR ARCHIVE HIGH

問題 #5

In the promotions table, the PROMO_BEGIN_DATE column is of data type date and the default date format Is DD-MON-RR.
h two statements are true about expressions using PROMO_BEGIN_DATE contained In a query?

A. to_numberipromo_begin_date) - s will return a number.
B. PROMO_ BEGIN_DATE - 5 will return a date.
C. PROMO_ BEGIN_DATE - sysdate will return a number.
D. TO_date(PROMO_ BEGIN_DATE * 5| will return a date.
E. PROMO_ BEGIN_DATE - sysdate will return an error.

解説：