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

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 chained rows from other blocks.
• B.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.
• C.It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.
• D.It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.

SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?

• A.One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session
• B.One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully
• C.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users
• D.One audit record is created for every successful DROP TABLE command executed in the session of SCOTT
• E.One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT

Which two are true about undo tablespaces? (Choose two.)

• A.Single instance databases can have only one active undo tablespace
• B.They can be recovered only when an instance is in MOUNT state
• C.They must have only one data file
• D.They always retain undo for the time period defined by UNDO_RETENTION
• E.Tables can be created in undo tablespaces by SYS

Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)

• A.Allow the database to handle locks in default locking mode.
• B.Avoid coding unnecessary longrunning transactions.
• C.Allow escalation of row locks to block locks if too many row locks cause problem.
• D.Always explicitly code the locks as per the requirement of the application.

In your database:
SGA_TARGET = 270M
PGA_AGGREGATE_TARGET = 90M
The MEMORY_TARGET and MEMORY_MAX_TARGET parameters are currently not
configured.
You execute the command:
ALTER SYSTEM SET MEMORY_TARGET = 400M;
What is the outcome and why?

• A.The execution is successful and automatic memory management is enabled
• B.The execution fails because SGA_TARGET and PGA_AGGREGATE_TARGET are
  already configured
• C.The execution is successful but does not enable automatic memory management because the MEMORY_MAX_TARGET parameter must be configured to a value greater than MEMORY_TARGET
• D.The execution fails because the MEMORY_MAX_TARGET parameter must be
  configured to 400M before configuring the MEMORY_TARGET parameter