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

View the Exhibit that sets the threshold for the Current Open Cursors Count metric.

Why is the Significance Level threshold type not available in the threshold setting?

• A.because AWR baseline is not enabled
• B.because Current Open Cursors Count is not a basic metric
• C.because the STATISTICS_LEVEL parameter is set to BASIC
• D.because the AWR baseline is a system-defined moving window baseline

View the Exhibit and examine the output.

You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE;
What is the outcome of this command?

• A.The table uses the default Flashback Archive.
• B.The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive-
• C.The Flashback Archive is created on the same tablespace where the tables are stored.
• D.The Flashback Archive is created on the SYSAUXtablespace.

You issued the following command:
CREATE GLOBAL TEMPORARY TABLE admin_work_area
(startdate DATE,
enddate DATE,
class CHAR(20))
ON COMMIT DELETE ROWS
TABLESPACE tbs_t1;
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.)

• A.It must be a nondefault temporary tablespace for the database.
• B.It must be the default temporary tablespace of the user who issues the command.
• C.It stores both the temporary table as well as its indexes.
• D.It can be a default or nondefault temporary tablespace for the database.
• E.It stores only the temporary table but not its indexes.

Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?

• A.only encryption and deduplication settings for only SecureFile CLOBs
• B.deduplication, encryption, and compression settings only for SecureFile CLOBs
• C.only encryption and compression settings for all SecureFile LOBs
• D.deduplication, encryption, and compression settings for all SecureFile LOBs

You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database? (Choose all that apply.)

• A.Auditing is disabled for all privileges.
• B.The audit trail is stored in an operating system file.
• C.Auditing is enabled for all privileges.
• D.Auditing is enabled for certain privileges related to database security.
• E.The audit trail is stored in the database