1Z0-052 무료 덤프문제 온라인 액세스

Which three statements are correct about temporary tables? (Choose three.)

• A.Data Manipulation Language (DML) locks are never acquired on the data of temporary tables
• B.Temporary tables are always created in a user's temporary tablespace
• C.Indexes and views can be created on temporary tables
• D.Both the data and structure of temporary tables can be exported
• E.The data inserted into a temporary table in a session is available to other sessions

View the Exhibit and examine the setting for a table.

Which statement is true about the PCTFREE setting for the table?

• A.It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.
• B.It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.
• C.It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.
• D.It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.

You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?

• A.It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.
• B.It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
• C.It produces a warning for new failures before advising for CRITICAL and HIGH failures.
• D.It ignores new failures and considers the failures listed in the last LIST FAILURE command only.

You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?

• A.It records usernames and passwords of users when granted the DBA role
• B.It contains usernames and passwords of users for whom auditing is enabled
• C.It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups
• D.It is used by Oracle to authenticate users for remote database administrator

Examine these SQL statements and their output:

Which two are true? (Choose two.)

• A.Transactions will wait until free space becomes available in the UNDO tablespace when they have failed to allocate space
• B.The UNDO tablespace will grow automatically if there is not enough space to retain active UNDO
• C.Expired UNDO will be retained as long as possible within the limits of the current size of the UNDO tablespace
• D.Inactive UNDO will be retained for at least 15 minutes
• E.Active UNDO will be retained as long as needed by the transactions