Free Oracle 1z1-072 Exam Dumps Questions & Answers

The DATA tablespace uses Automatic Segment Space Management.
Examine this query and its output:

A block in EMP is 90% full.
At what percentage of free space will INSERT operations into the block again be possible?

• A.  10%
• B.  90%
• C.  25%
• D.  50%
• E.  75%

You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression.
Which compression option is best suited for this?

• A.  ROW STORE COMPRESS ADVANCED
• B.  COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• C.  COLUMN STORE COMPRESS FOR QUERY LOW
• D.  ROW STORE COMPRESS BASIC
• E.  COLUMN STORE COMPRESS FOR ARCHIVE LOW

Which two are prerequisites for shrinking a table online?

• A.  It must be in a tablespace that uses Automatic Segment Space Management (ASSM) .
• B.  It must have row movement enabled.
• C.  It must not have any DML triggers.
• D.  It must not have any referential integrity constraints.
• E.  It must have a unique key constraint.

A database is configured to use automatic undo management with temporary undo enabled. An update is executed on a heap-organized table stored in the TBS1 tablespace. Where is the undo stored?

• A.  in the SYSAUX tablespace
• B.  in the undo tablespace
• C.  in rollback segments
• D.  in the temporary tablespace
• E.  in the redo logs

Examine the command:
CREATE USER user1
IDENTIFIED BY user123
DEFAULT TEMPORARY TABLESPACE temp
QUOTA 5M ON system
PROFILE hr_user
PASSWORD EXPIRE;
Which two are true? (Choose two.)

• A.  A quota on the temporary tablespace must be specified to enable USER1 to perform queries and transactions.
• B.  USER1 will be prompted for a new passport at first login.
• C.  The PASSWORD EXPIRE clause is invalid because passwords are controlled by the HR_USER profile.
• D.  USER1's account is locked.
• E.  USER1 requires a quota to be able to store objects in the default permanent tablespace.