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

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

• A.SYSDATE can be queried only from the DUAL table
• B.CURRENT_DATE returns the current date and time as per the session time zone
• C.CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
• D.SYSDATE can be used in expressions only if the default date format is DD-MON-RR
• E.CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
• F.SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

Which three statements are true about the Automatic Diagnostic Repository (ADR)?

• A.The ADR base is specified In the diagnostic_dest database parameter.
• B.It Is held Inside an Oracle database schema.
• C.It is a file-based repository held outside any database.
• D.It is only used for Oracle Database diagnostic information.
• E.It can be used for problem diagnosis of a database when that database's instance is down.

Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

• A.Tablespace free space can be viewed in V$TABLESPACE
• B.Tablespace free space can be viewed in DBA_TABLESPACES
• C.A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened
• D.V$TABLESPACE displays information about tablespaces contained in the data dictionary
• E.V$TABLESPACE displays information that is contained in the controlfile about tablespaces

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

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

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

• A.Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
• B.ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
• C.A block will always be eligible for inserts if the row is short enough to fit into the block
• D.Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
• E.PCTFREE defaults to 10% for all blocks in all segments for all compression methods