1z0-082 Free Practice Test

Examine this command:
<>

1. A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
2. B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
3. C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
4. D. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
5. E. The file is renamed and stored in the same location

Correct Answer: AB

Examine these commands:
<>

1. A. It overwrites data in EMP with data in EMP.DAT
2. B. It uses the database buffer cache to load data
3. C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
4. D. It generates a sql script that it uses to load data from EMP.DAT to EMP
5. E. It appends data from EMP.DAT to EMP

Correct Answer: BD

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

1. A. Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
2. B. The data dictionary is created and maintained by the database administrator
3. C. Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
4. D. Base tables can be queried directly
5. E. It is owned by the SYSTEM user
6. F. Usernames of all users including database administrators are stored in the data dictionary

Correct Answer: CDF

Which two statements are true about the SET VERIFY ON command? (Choose two.)

1. A. It can be used only in SQL*Plus
2. B. It displays values for variables used only in the WHERE clause of a query
3. C. It can be used in SQL Developer and SQL*Plus
4. D. It displays values for variables created by the DEFINE command
5. E. It displays values for variables prefixed with &&

Correct Answer: AD

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:
<>

1. A. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
2. B. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
3. C. Employee 200 will have SALARY set to the same value as the SALARY of employee 100
4. D. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
5. E. Employees 100 and 200 will have the same JOB_ID as before the update command
6. F. Employees 100 and 200 will have the same SALARY as before the update command

Correct Answer: AB