Oracle 1Z0-082 問題集

質問 1：
Examine these commands:

Which two statements are true about the sqiidr execution?
A. It generates a sqi script that it uses to load data from EMP.DAT TO EMP.
B. It overwrites the data for Alan and adds data for Curl and Bob
C. It generates a log that contains control file entries, which can be used with normal SQL'Loader operations.
D. It overwrites all data in emp with data from emp.dat.
E. It appends data from EMP.DAT TO EMP.
正解：A,E

質問 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：
In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)
A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
B. Add the AUTOEXTEND ON clause with NEXT set to 100M.
C. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
D. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
E. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
正解：C,D

質問 4：
Which three statements are true about using SQL*Plus?
A. It can run scripts passed to it by a shell script.
B. It can run scripts entered at the SQL prompt.
C. It has its own commands that are separate from any SQL statements.
D. It can run Recovery Manager (RMAN) commands.
E. It has both command-line and graphical user interfaces (GUI).
F. It must be downloaded from the Oracle Technology Network (OTN).
正解：B,C,F

質問 5：
Which three activities are recorded in the database alert log? (Choose three.)
A. Data Definition Language (DDL) statements
B. deadlock errors
C. block corruption errors
D. session logins and logouts
E. non-default database parameters
正解：B,C,E

質問 6：
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

質問 7：
Which three statements are true about Deferred Segment Creation in Oracle databases?
A. It Is the default behavior for tables and indexes.
B. It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
C. Sessions may dynamically switch back and forth from deferred to immediate segment creation.
D. Indexes inherit the deferred or immediate segment creation attribute from their parent table
E. It is supported for SYS-owned tables contained in locally managed tablespaces.
正解：A,C,D