If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Is it only at a segment level? Multiple segments belong to a single tablespace, so shouldn't it be both?

A. Block space utilization can be specified only at the segment level.
B. Block space utilization can be specified only in the data dictionary.
C. Block space utilization parameters can only be specified at the tablespace.
D. Block space utilization can be specified both at the tablespace level and segment level.

2. Which two parameters might affect the concurrency of transactions on a data block? (choose 2)

INITTRANS makes sense of course, but what is the other & why?

A. PCTUSED
B. PCTFREE
C. INITRANS
D. MAXEXTENTS
E. NEXTEXTENT

3. Which are DATABASE event triggers?

A. DROP USER
B. ALTER VIEW
C. CREATE DB
D. CALL TO A PROCEDURE

4. What are two effects of setting REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE? (choose 2)

C is correct, but I'm not sure if D or E is the other correct answer. SYSDBA is a granted priv, so are they trying to say by default, SYSDBA would not be allowed in until this is done?

A. Passwordfile can be stored remotely
B. Passwordfile access is restricted to local users
C. Only one instance on the database can use the passwordfile
D. Remote connection using the SYSDBA privileges are allowed
E. Remote connection using the SYSDBA privileges are prohibited

Good question. If you set a high value for PCTUSED, then you may decrease performance, because more migrated and
chained rows are present. Then low INITRANS on the other blocks may affect concurrency of the transaction.

With a low value for PCTUSED, the space usage is not efficient due to unused space in data blocks.

Good question. If you set a high value for PCTUSED, then you may decrease performance, because more migrated and
chained rows are present. Then low INITRANS on the other blocks may affect concurrency of the transaction.

With a low value for PCTUSED, the space usage is not efficient due to unused space in data blocks.

It really mess me. I found an some old threads answered BC and there is a guy got 63/64 stated the answer is BC too.