Oracle 1Z0-082 問題集

質問 1：
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
解説: (Topexam メンバーにのみ表示されます)

質問 2：
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 original name for the data files.
B. V$DATAFILE displays the new names for the data files.
C. DBA_DATA _FILES displays both the new name and the old name for the data files.
D. DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.
E. DBA_DATA_FILES displays the new name for the data files.
正解：A,C

質問 3：
Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)
A. Online index segment shrink
B. Online table segment shrink
C. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)
D. Oracle Managed Files (OMF)
E. Automatic data file extension (AUTOEXTEND)
正解：C,D,E

質問 4：
Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)
A. It uses the database buffer cache to load data
B. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
C. It generates a sql script that it uses to load data from EMP.DAT to EMP
D. It overwrites data in EMP with data in EMP.DAT
E. It appends data from EMP.DAT to EMP
正解：B,E

質問 5：
The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.
You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the week.
Which query can be used?
A. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;
B. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;
C. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY('MONDAY') FROM employees;
D. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
正解：B

質問 6：
Which two statements are true about Enterprise Manager (EM) Express?
A. You can shut down a database instance using EM Express.
B. You cannot start up a database instance using EM Express.
C. You can use a single instance of EM Express to manage multiple database running on the same server.
D. EM Express uses a separate repository database to store target database metadata.
E. By default, EM express is available for a database after database creation using DBCA.
正解：A,E

質問 7：
Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)
A. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.
B. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
C. The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.
D. The names and number of columns must be identical for all SELECT statements in the query.
E. The number, but not names, of columns must be identical for all SELECT statements in the query.
正解：A,B