1Z0-082 試験問題を無料オンラインアクセス

Which two statements are true about the Oracle Data Dictionary?

• A.Data dictionary views are always created with queries that join two or more base tables.
• B.It is owned by the sys user.
• C.All data dictionary view joins base tables to dynamic performance views.
• D.Data dictionary base tables can be queried directly.
• E.It is owned by the system user.

Examine this command:

Which two statements are true? (Choose two.)

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

Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED ? (Choose two.) RETENTION

• A.UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
• B.UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
• C.Active UNDO is always retained.
• D.UNDO_RETENTION specifies how long all types of UNDO are retained.
• E.Unexpired UNDO is always retained.

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, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM
  employees;
• D.SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(`MONDAY') FROM employees;

Which two statements are true about substitution variables?

• A.A substitution variable can be used with any clause in a select statement.
• B.A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session
• C.A substitution variable can be used only in a select statement.
• D.A substitution variable used to prompt for a column name must be enclosed in single quotation marks.
• E.A substitution variable prefixed with & always prompts only once for a value in a session.
• F.A substitution variable used to prompt for a column name must be enclosed in double quotation marks.